• Welcome to the Chevereto user community!

    Here users from all over the world gather around to learn the latest about Chevereto and contribute with ideas to improve the software.

    Please keep in mind:

    • This community is user driven. Be polite with other users.
    • We recommend purchasing a Chevereto license to participate in this community.
    • Purchase a Community Subscription to get even faster ticket response times.
  • Chevereto Support CLST

    Support response

    Support checklist

    • Got a Something went wrong message? Read this guide and provide the actual error. Do not skip this.
    • Confirm that the server meets the System Requirements
    • Check for any available Hotfix - your issue could be already reported/fixed
    • Read documentation - It will be required to Debug and understand Errors for a faster support response

Upgrade table prefix issue

Status
Not open for further replies.

crystyv

Chevereto Member
hello

I don't know why update script it's say this:

PDOException thrown in /home//public_html/app/src/Legacy/G/DB.php:151

# Message [Code #42S02]
SQLSTATE[42S02]: Base table or view not found: 1146 Table 'tst.chv_albums' doesn't exist

# Incident ID:6336a507b5984

but my is db_table_prefix'] = 'chi5_';
 
Hi,

There's a bug at app/legacy/install/installer.php when you use a different table prefix. This will be patched in the next revision.

You need to replace in the above file all the occurrences of:

PHP:
chv_albums

With this:

PHP:
chi5_albums
 
Last edited:
Hello

is not working,:




[lokomotiv@h1 public_html]$ /usr/bin/php81 app/bin/legacy -C update
Chevere\Throwable\Exceptions\LogicException thrown in /home/lokomotiv/domains/tst.lokomotiv.ro/public_html/app/legacy/install/installer.php:1936

# Message
Problems executing the update query, must run the following statements directly in your SQL console. <pre style="overflow:auto;"><code>ALTER TABLE chi5_requests MODIFY request_type enum('upload','signup','account-edit','account-password-forgot','account-password-reset','account-resend-activation','account-email-needed','account-change-email','account-activate','login','content-password', 'account-two-factor') NOT NULL;
INSERT IGNORE INTO chi5_login_passwords (login_password_user_id, login_password_date_gmt, login_password_hash)
SELECT login_user_id, max(login_date_gmt), login_secret
FROM chi5_logins
WHERE login_type = "password"
GROUP BY login_user_id;
INSERT IGNORE INTO chi5_login_cookies (login_cookie_user_id, login_cookie_connection_id, login_cookie_date_gmt,
login_cookie_ip, login_cookie_user_agent, login_cookie_hash)
SELECT login_user_id, 0, login_date_gmt, login_ip, login_hostname, login_secret
FROM chi5_logins
WHERE login_type = "cookie"
GROUP BY login_date_gmt
ORDER BY login_date_gmt DESC;
INSERT IGNORE INTO chi5_login_connections (login_connection_user_id, login_connection_provider_id, login_connection_date_gmt,
login_connection_resource_id, login_connection_resource_name,
login_connection_token)
SELECT login_user_id, login_provider_id, max(login_date_gmt), login_resource_id, login_resource_name, '' token
FROM chi5_logins
JOIN chi5_login_providers ON login_provider_name = login_type
WHERE login_type IN ('facebook', 'twitter', 'google', 'vk')
GROUP BY login_user_id, login_provider_id;
UPDATE chi5_login_providers
SET login_provider_key_id = '', login_provider_key_secret = '', login_provider_is_enabled = '0'
WHERE login_provider_name = 'facebook';UPDATE chi5_login_providers
SET login_provider_key_id = '', login_provider_key_secret = '', login_provider_is_enabled = '0'
WHERE login_provider_name = 'twitter';UPDATE chi5_login_providers
SET login_provider_key_id = '', login_provider_key_secret = '', login_provider_is_enabled = '0'
WHERE login_provider_name = 'google';UPDATE chi5_login_providers
SET login_provider_key_id = '', login_provider_key_secret = '', login_provider_is_enabled = '0'
WHERE login_provider_name = 'Vkontakte';

ALTER TABLE chi5_users ADD KEY user_palette_id (user_palette_id);
INSERT INTO chi5_settings (setting_name, setting_value, setting_default, setting_typeset) VALUES ('logo_type', 'vector', 'vector', 'string');
INSERT INTO chi5_settings (setting_name, setting_value, setting_default, setting_typeset) VALUES ('theme_palette', '0', '0', 'string');

INSERT INTO chi5_settings (setting_name, setting_value, setting_default, setting_typeset) VALUES ('enable_xr', '0', '0', 'bool');
INSERT INTO chi5_settings (setting_name, setting_value, setting_default, setting_typeset) VALUES ('xr_host', 'localhost', 'localhost', 'string');
INSERT INTO chi5_settings (setting_name, setting_value, setting_default, setting_typeset) VALUES ('xr_port', '27420', '27420', 'string');
INSERT INTO chi5_settings (setting_name, setting_value, setting_default, setting_typeset) VALUES ('xr_key', '', '', 'string');

INSERT INTO chi5_settings (setting_name, setting_value, setting_default, setting_typeset) VALUES ('route_user', 'user', 'user', 'string');
INSERT INTO chi5_settings (setting_name, setting_value, setting_default, setting_typeset) VALUES ('root_route', 'user', 'user', 'string');

INSERT INTO chi5_settings (setting_name, setting_value, setting_default, setting_typeset) VALUES ('arachnid', '0', '0', 'bool');
INSERT INTO chi5_settings (setting_name, setting_value, setting_default, setting_typeset) VALUES ('arachnid_key', '', '', 'string');
INSERT INTO chi5_settings (setting_name, setting_value, setting_default, setting_typeset) VALUES ('image_first_tab', 'info', 'info', 'string');

INSERT INTO chi5_settings (setting_name, setting_value, setting_default, setting_typeset) VALUES ('website_random_guest', '1', '1', 'bool');
INSERT INTO chi5_settings (setting_name, setting_value, setting_default, setting_typeset) VALUES ('website_search_guest', '1', '1', 'bool');
INSERT INTO chi5_settings (setting_name, setting_value, setting_default, setting_typeset) VALUES ('debug_errors', '0', '0', 'bool');
INSERT INTO chi5_settings (setting_name, setting_value, setting_default, setting_typeset) VALUES ('news_check_datetimegmt', '', '', 'string');

DELETE FROM chi5_settings WHERE setting_name = 'theme_main_color';
DELETE FROM chi5_settings WHERE setting_name = 'theme_top_bar_button_color';
UPDATE chi5_settings SET setting_value = "4.0.0" WHERE setting_name = "chevereto_version_installed";</code></pre>

# Incident ID:6336f0176e3e9

# Time
2022-09-30T13:33:11+00:00 [1664544791]

# Stack trace
------------------------------------------------------------
#0 /home/lokomotiv/domains/tst.lokomotiv.ro/public_html/app/legacy/install/installer.php:1936
{main}()
------------------------------------------------------------
#1 /home/lokomotiv/domains/tst.lokomotiv.ro/public_html/app/legacy/commands/update.php:18
require_once()
------------------------------------------------------------
#2 /home/lokomotiv/domains/tst.lokomotiv.ro/public_html/app/legacy/entrypoints/cli.php:53
require_once(string(length=83))
------------------------------------------------------------
#3 /home/lokomotiv/domains/tst.lokomotiv.ro/public_html/app/bin/legacy:13
require_once(string(length=83))
------------------------------------------------------------
 
Follow the instructions of the error message.

Problems executing the update query, must run the following statements directly in your SQL console.
 
Revision 4.0.1 improves on this error message. At this point I will consider this bug as "pending release" (for the chv_ prefix issue). Feel free to open another ticket for the later issue.
 
Status
Not open for further replies.
Back
Top