error message on upgrade [message #10242] |
Sun, 25 May 2003 21:15  |
|
I got this message after running the latest upgrade script
<Fetch SQL archive
SQL archive is now avaliable
Beginning SQL Upgrades
MySQL Error: #1062 (Duplicate entry '8-200' for key 2): ALTER TABLE fud_forum_read ADD UNIQUE(forum_id,user_id)>
I would be greatful for any help.
Got Torque?
|
|
|
|
|
Re: error message on upgrade [message #10317 is a reply to message #10258] |
Tue, 27 May 2003 22:51   |
|
I ran the latest upgrade and get this Warning during the upgrade
Warning: getimagesize(/usr/home/web/users/a0003196/html/fforum/www/images/custom_avatars/30) [function.getimagesize]: failed to create stream: No such file or directory in /usr/home/web/users/a0003196/html/fforum/www/upgrade.php on line 1138
after the upgrade completed, went to log on and got this:
(index.php) 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 '' at line 1
Query: SELECT u.id, u.alias, u.is_mod, u.custom_color FROM fud_ses s INNER JOIN fud_users u ON u.id=s.user_id WHERE s.time_sec>1054075504 AND u.invisible_mode='N' ORDER BY s.time_sec DESC LIMIT
Server Version: 4.0.12-log
Thanks for the great support.
Got Torque?
[Updated on: Tue, 27 May 2003 22:53] Report message to a moderator
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: error message on upgrade [message #10360 is a reply to message #10358] |
Wed, 28 May 2003 18:51   |
|
You must mean the $MAX_LOGGEDIN_USERS variable.
I do not see that variable in my www_server_root GLOBALS.php but do see it in my include GLOBALS.php
soooo are you saying to ad "$MAX_LOGGEDIN_USERS" to the GLOBALS.php file in my www_server_root?
or delete all the GLOBALS.php files (except the on in include) then rebuild the theme? create syslinks to the include_GLOBALS.php file. (not that I know how to do that)
chmod (www_server_root) GLOBALS.php and index are 644, if that helps.
sorry to be such a pain.
Got Torque?
[Updated on: Wed, 28 May 2003 20:08] Report message to a moderator
|
|
|
|