🌍
English
I tried to go from 2.3.5 to 2.4.6. I started the upgrade from the admin page on my site. It seemed to complete normally, gave me an info screen about extensions that had been turned off. But clicking on the orange "Home" button at the bottom led to a screen full of mysql errors and an access error. My hosting service does have versions of mysql, php, etc., that meet the requirements.
Samples of error messages below. You can see the lot by going to http://molvray.com/photos/index.php The very last line about "You are not authorized to access the requested page" looks serious.
first few lines:
Warning: [mysql error 1146] Table 'mmolvray_phpwebgallery.users' doesn't exist
SELECT id AS id
, username AS username
, password AS password
, mail_address AS email
FROM users
WHERE id = '1' in /usr/home/quixote/public_html/galleryphp/include/dblayer/functions_mysql.inc.php on line 770
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /usr/home/quixote/public_html/galleryphp/include/dblayer/functions_mysql.inc.php on line 153last few lines:
Warning: [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''false',1358300525,'185,195',6330,'NOT IN','0')' at line 5
INSERT IGNORE INTO phpwebgallery_user_cache
(user_id, need_update, cache_update_time, forbidden_categories, nb_total_images,
image_access_type, image_access_list)
VALUES
(,'false',1358300525,'185,195',6330,'NOT IN','0') in /usr/home/quixote/public_html/galleryphp/include/dblayer/functions_mysql.inc.php on line 770
Notice: Undefined index: language in /usr/home/quixote/public_html/galleryphp/include/common.inc.php on line 151
Notice: Undefined index: language in /usr/home/quixote/public_html/galleryphp/include/common.inc.php on line 155
Notice: Undefined index: nb_image_page in /usr/home/quixote/public_html/galleryphp/include/section_init.inc.php on line 178
Warning: Cannot modify header information - headers already sent by (output started at /usr/home/quixote/public_html/galleryphp/include/dblayer/functions_mysql.inc.php:769) in /usr/home/quixote/public_html/galleryphp/include/functions_html.inc.php on line 506
You are not authorized to access the requested page
Identification HomeI hope someone can help! Reinstalling and recustomizing from zero will take me days. :(
Last edited by quixote (2013-01-16 04:50:56)
Offline
the solution is given here [Forum, post 131179 by laurent.duretz in topic 19683] After upgrade to 2.4 sql failure: Table 'piwigo.users' doesn't exist
ps : did you copy the whole default configuration into your local configuration ? if so you should clean it up (remove all code you didn't change) to avoid such problems in the future
Offline
Yes! Thank you, thank you! That works. Whew. What a relief!
I need to re-do some of my customizations because I think I cheated and put them in the main files rather than local/ directory.
Config.inc.php: yes, I must have copied the whole thing. I saw, when I was searching for an answer to this, that it was a problem to do that so I checked mine. But it seemed to be mainly stuff I'd changed so I stopped after a couple of screens. Stupid. Another thing I need to do is reduce that file to only the changed lines.
Thanks again!
Offline