Announcement

#1 2010-05-20 11:53:15

alexpreyer
Member
Hammelburg (Ger)
2009-11-27
179

[resolved] Piwigo fails after moving to MYSQL5

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

 

#2 2010-05-20 12:50:49

alexpreyer
Member
Hammelburg (Ger)
2009-11-27
179

Re: [resolved] Piwigo fails after moving to MYSQL5

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

 

#3 2010-05-20 13:54:06

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13791

Re: [resolved] Piwigo fails after moving to MYSQL5

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

 

#4 2010-05-20 18:46:22

alexpreyer
Member
Hammelburg (Ger)
2009-11-27
179

Re: [resolved] Piwigo fails after moving to MYSQL5

Thanks, that was it :-)

Offline

 

#5 2010-05-20 22:04:21

mathiasm
Former Piwigo Team
2006-02-06
2650

Re: [resolved] Piwigo fails after moving to MYSQL5

alexpreyer wrote:

Thanks, that was it :-)

Could you set the thread as resolved  (you have a link in your first post)

thanks
Mathias

Offline

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2024 · Contact