After trying upgrade to 2.1 I saw that I need Mysql 5. So I asked my provider and this night my site was moved to a server with mysql5. When I now try to start I get a lot of errors. The strange thing is, that Piwigo misses some tables. But I checked the Backup and the missed tables where not there before. Does anyone has an idea?
Here a short piece of the error messages:
Warning: [mysql error 1146] Table 'd00c82b9.piwigo_languages' doesn't exist
SELECT id, name
FROM piwigo_languages
ORDER BY name ASC
; in /www/htdocs/w005f3d5/bilder/piwigo/include/dblayer/functions_mysql.inc.php on line 642
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /www/htdocs/w005f3d5/bilder/piwigo/include/dblayer/functions_mysql.inc.php on line 155
Warning: [mysql error 1146] Table 'd00c82b9.piwigo_languages' doesn't exist
SELECT id, name
FROM piwigo_languages
ORDER BY name ASC
; in /www/htdocs/w005f3d5/bilder/piwigo/include/dblayer/functions_mysql.inc.php on line 642
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /www/htdocs/w005f3d5/bilder/piwigo/include/dblayer/functions_mysql.inc.php on line 155
Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /www/htdocs/w005f3d5/bilder/piwigo/include/dblayer/functions_mysql.inc.php:641) in /www/htdocs/w005f3d5/bilder/piwigo/include/user.inc.php on line 49
Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /www/htdocs/w005f3d5/bilder/piwigo/include/dblayer/functions_mysql.inc.php:641) in /www/htdocs/w005f3d5/bilder/piwigo/include/user.inc.php on line 49
Warning: [mysql error 1146] Table 'd00c82b9.piwigo_themes' doesn't exist
SELECT ui.*, uc.*, t.name AS theme_name
FROM piwigo_user_infos AS ui
LEFT JOIN piwigo_user_cache AS uc ON ui.user_id = uc.user_id
LEFT JOIN piwigo_themes AS t ON t.id = ui.theme
WHERE ui.user_id = '2' in /www/htdocs/w005f3d5/bilder/piwigo/include/dblayer/functions_mysql.inc.php on line 642
Warning: [mysql error 1062] Duplicate entry '2' for key 1
INSERT INTO piwigo_user_infos
(nb_image_line,nb_line_page,adviser,language,maxwidth,maxheight,expand,show_nb_comments,show_nb_hits,recent_period,template,enabled_high,level,user_id,status,registration_date)
VALUES('5','3','false','de_DE','1000','600','true','false','true','16','yoga/Sylvia','true','0','2','guest','2010-05-20 11:46:08') in /www/htdocs/w005f3d5/bilder/piwigo/include/dblayer/functions_mysql.inc.php on line 642
Warning: [mysql error 1146] Table 'd00c82b9.piwigo_themes' doesn't exist
SELECT ui.*, uc.*, t.name AS theme_name
FROM piwigo_user_infos AS ui
LEFT JOIN piwigo_user_cache AS uc ON ui.user_id = uc.user_id
LEFT JOIN piwigo_themes AS t ON t.id = ui.theme
WHERE ui.user_id = '2' in /www/htdocs/w005f3d5/bilder/piwigo/include/dblayer/functions_mysql.inc.php on line 642
Warning: [mysql error 1062] Duplicate entry '2' for key 1
INSERT INTO piwigo_user_infos
(nb_image_line,nb_line_page,adviser,language,maxwidth,maxheight,expand,show_nb_comments,show_nb_hits,recent_period,template,enabled_high,level,user_id,status,registration_date)
VALUES('5','3','false','de_DE','1000','600','true','false','true','16','yoga/Sylvia','true','0','2','guest','2010-05-20 11:46:08') in /www/htdocs/w005f3d5/bilder/piwigo/include/dblayer/functions_mysql.inc.php on line 642
Warning: [mysql error 1146] Table 'd00c82b9.piwigo_themes' doesn't exist
SELECT ui.*, uc.*, t.name AS theme_name
FROM piwigo_user_infos AS ui
LEFT JOIN piwigo_user_cache AS uc ON ui.user_id = uc.user_id
LEFT JOIN piwigo_themes AS t ON t.id = ui.theme
WHERE ui.user_id = '2' in /www/htdocs/w005f3d5/bilder/piwigo/include/dblayer/functions_mysql.inc.php on line 642
Offline
I found out, that it could be that not the transfer to the new server the reason could be. I changed the standart Sylvia Theme month ago, but when I have a look into the folders containing the Theme it looks like it's on standart. Could it be that the upgrade procedure, even it stopped with demanding Mysql 5, overwrote some things?
Offline
If the PHP considers the "languages" and "themes" tables are missing, it means that you're running Piwigo 2.1 code on a Piwigo 2.0 database.
Go to http://yourwebsite.com/yourgallery/upgrade.php
Offline
Thanks, that was it :-)
Offline
alexpreyer wrote:
Thanks, that was it :-)
Could you set the thread as resolved (you have a link in your first post)
thanks
Mathias
Offline