| 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 #10249 is a reply to message #10242] |
Mon, 26 May 2003 14:22  |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
You need to run the following query:
DELETE FROM fud_forum_read WHERE forum_id=8 AND user_id=200 LIMIT 1;
FUDforum Core Developer
|
|
|
|
|
|
| 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 #10323 is a reply to message #10317] |
Wed, 28 May 2003 12:40 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Somehow your GLOBALS.php is missing the $MAX_LOGGEDIN_USERS variable.
To solve the problem to the following:
1) Go to the admin control panel directorly (your_forum_url/adm/)
2) On the settings panel find settings called 'Maximum number of logged in users to show' and set it's value to a number (suggested 25).
FUDforum Core Developer
|
|
|
|
|
|
| Re: error message on upgrade [message #10331 is a reply to message #10330] |
Wed, 28 May 2003 13:32 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Make sure that your GLOBALS.php are not compiles of each other but rather symlinks to the 'real' GLOBALS.php inside the include directory.
FUDforum Core Developer
|
|
|
|
|
|
| Re: error message on upgrade [message #10333 is a reply to message #10332] |
Wed, 28 May 2003 13:39 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Download the files and see if they are identical, if they are not, you are not using symlinks.
FUDforum Core Developer
|
|
|
|
| Re: error message on upgrade [message #10335 is a reply to message #10333] |
Wed, 28 May 2003 13:58 |
|
|
checked the 'real' globals.php vs one in my www dir. It is not identical to the 'real' globals.php
example:
'real' $PRIVATE_TAGS = "NONE"; /* toggle N:ML:HTML */
'www_dir' $PRIVATE_TAGS = "ML"; /* toggle N:ML:HTML */
will keep checking.
Got Torque?
|
|
|
|
| Re: error message on upgrade [message #10336 is a reply to message #10335] |
Wed, 28 May 2003 14:10 |
|
|
Victor_M and I use the same hosting service. We both started to have problems when they "upgraded". I'm thinking my symlinks should look like:
<?php
include_once "/path/to/include/GLOBALS.php";
?>
Per your advice to Victor_M pasted below
Re: Question about GLOBALS.php
Mon, 26 May 2003 07:41
Normally on *nix systems there is 1 GLOBALS.php inside the incldue/ directory and 2 symlinks to this file. One of those symlinks
is inside the forum's web root directory and the other inside the adm/ directory.
On Win32, since symlinks are not supported there are 3 GLOBALS.php, the ones that are symlinks on *nix are basically
<?php
include_once "/path/to/include/GLOBALS.php";
?>
what do you think??
Got Torque?
|
|
|
|
| Re: error message on upgrade [message #10338 is a reply to message #10336] |
Wed, 28 May 2003 14:23 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
<?php
include_once "/path/to/include/GLOBALS.php";
?>
Will work, but I am not sure if that'll work once you start changing settings via the settings control panel. Since this solution was only intended for win32 systems.
FUDforum Core Developer
|
|
|
|
| Re: error message on upgrade [message #10339 is a reply to message #10338] |
Wed, 28 May 2003 14:41 |
|
|
Ahh
my hosting info:
Web Server: Apache/2.0.45 (Unix) FrontPage/5.0.2.2626
so would this apply to me?
Normally on *nix systems there is 1 GLOBALS.php inside the incldue/ directory and 2 symlinks to this file. One of those symlinks is inside the forum's web root directory and the other inside the adm/ directory.
How do I create these symlinks to my 'real' globals.php? Just put copies where they should be?? It can't be that easy.
sorry for all the questions, thanks for all the help.
Got Torque?
|
|
|
|
| Re: error message on upgrade [message #10340 is a reply to message #10339] |
Wed, 28 May 2003 15:12 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
You are not using Win32 that much is clear.
Run the following script:
<?php
$real_path = "/path/to/include/GLOBALS.php"
include($real_path);
@unlink($WWW_ROOT_DISK . 'GLOBALS.php');
@unlink($WWW_ROOT_DISK . 'adm/GLOBALS.php');
symlink($real_path, $WWW_ROOT_DISK . 'GLOBALS.php');
symlink($real_path, $WWW_ROOT_DISK . 'adm/GLOBALS.php');
?>
FUDforum Core Developer
|
|
|
|
|
|
|
|
|
|
| Re: error message on upgrade [message #10346 is a reply to message #10343] |
Wed, 28 May 2003 16:49 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
So the error you are seeing only appears when you try to access the forum's from page?
Try rebuilding the theme and see if the problem goes away, if it does not make the 'default' theme the default theme (if you had not done so already).
FUDforum Core Developer
|
|
|
|
| Re: error message on upgrade [message #10347 is a reply to message #10346] |
Wed, 28 May 2003 16:54 |
|
|
| Quote: |
So the error you are seeing only appears when you try to access the forum's from page?
|
correct.
On the Theme Mgmt Page I see this warning...
Warning: file_get_contents(/usr/home/web/users/a0003196/html/fforum/data/thm/default/i18n/_vti_cnf/locale) [function.file-get-contents]: failed to create stream: No such file or directory in /usr/home/web/users/a0003196/html/fforum/www/adm/admthemes.php on line 239
is/was set to default
Go ahead with the rebuild??
Got Torque?
|
|
|
|
|
|
| Re: error message on upgrade [message #10349 is a reply to message #10348] |
Wed, 28 May 2003 17:04 |
|
|
Ok I did this is what popped up
Warning: copy(/usr/home/web/users/a0003196/html/fforum/datasql/mysql/db.inc) [function.copy]: failed to create stream: No such file or directory in /usr/home/web/users/a0003196/html/fforum/data/include/compiler.inc on line 439
unable to make directory (/usr/home/web/users/a0003196/html/fforum/datainclude/theme)
hmmmm looks like I am missing a "/"
(....datainclude/theme)...)
Got Torque?
|
|
|
|
|
|
| Re: error message on upgrade [message #10351 is a reply to message #10349] |
Wed, 28 May 2003 17:31 |
|
|
Info:
I noticed on the global config panel, my DATA ROOT dir info was not there, added in (this was earlier), went back just now and it WAS missing a / at the end.
Downloaded and checked the GLOBALS.php, all paths have the "/" at the end.
Went to Theme Mgmt, ran "rebuild" get this:
Warning: file_get_contents(/usr/home/web/users/a0003196/html/fforum/data//thm/default/i18n/_vti_cnf/locale) [function.file-get-contents]: failed to create stream: No such file or directory in /usr/home/web/users/a0003196/html/fforum/www/adm/admthemes.php on line 239
Got Torque?
|
|
|
|
|
|
|
|
| Re: error message on upgrade [message #10356 is a reply to message #10355] |
Wed, 28 May 2003 18:17 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
I see a message about an sql error, go to the error log viewer and see what the error is.
FUDforum Core Developer
|
|
|
|
| Re: error message on upgrade [message #10357 is a reply to message #10356] |
Wed, 28 May 2003 18:20 |
|
|
this is the last error in the error log
Wed May 28 18:22:32 GMT 2003 (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>1054145852 AND u.invisible_mode='N' ORDER BY s.time_sec DESC LIMIT
Server Version: 4.0.12-log
[Referring Page] http://fud.prohost.org/forum/index.php?t=selmsg&unread=1&rid=876&frm_id=
Got Torque?
|
|
|
|
| Re: error message on upgrade [message #10358 is a reply to message #10357] |
Wed, 28 May 2003 18:27 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Ok, you need to make sure that the GLOBALS.php that is being included has the variable I mentioned in my prior messages.
FUDforum Core Developer
|
|
|
|
| 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 |
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]