| SQL Error when upgrading : #1054 [message #16191] |
Tue, 20 January 2004 10:13  |
math_adm
Messages: 126
Registered: September 2003
Location: France
Karma: 0
|
Senior Member |
|
|
Hi
I was trying to upgrade from 2.3.8 to 2.6.0. I launched the upgrade.php and here's what I got:
Checking if SQL permissions to perform the upgrade are avaliable
Disable the forum
Forum is now disabled
Beginning the file upgrade process
Begining to decompress the archive
Finished decompressing the archive
File Upgrade Complete
Any changed files were backed up to: "/usr/local/apache/htdocs/FUDforum2_data/errors/.backup/"
Beginning SQL Upgrades
SQL Upgrades Complete
Creating Avatar Cache
Populating pdest field for private messages
MySQL Error: #1054 (Unknown column 'folder_id' in 'where clause'): SELECT to_list, id FROM fud23_pmsg WHERE folder_id='SENT' AND duser_id=ouser_id
Now the forum is no longer available. All I get are empty pages. I couldn't even run the consistency check. All I can do is rerun the upgrade.php which gives the same results !
What can I do ? Please help !
Thanks !
|
|
|
|
|
|
|
|
|
|
|
|
| Re: SQL Error when upgrading : #1054 [message #16307 is a reply to message #16293] |
Sun, 25 January 2004 18:40  |
jdarnold
Messages: 12
Registered: January 2003
Karma: 0
|
Junior Member |
|
|
Yes, I did. I got the exact same error as listed above...
| Quote: |
Beginning SQL Upgrades
SQL Upgrades Complete
Creating Avatar Cache
Populating pdest field for private messages
MySQL Error: #1054 (Unknown column 'folder_id' in 'where clause'): SELECT to_list, id FROM fud23_pmsg WHERE folder_id='SENT' AND duser_id=ouser_id
|
and now when I try and access my forums, I get:
| Quote: |
Fatal error: Cannot redeclare intnull() (previously declared in /home/virtual/site11/fst/var/www/html/forum/index.php:42) in/home/virtual/site11/fst/var/www/html/forum-data/include/core.inc on line 123
|
I used the 2.6 UPGRADE script everytime I tried.
[Updated on: Sun, 25 January 2004 18:50] Report message to a moderator |
|
|
|
| Re: SQL Error when upgrading : #1054 [message #16310 is a reply to message #16307] |
Sun, 25 January 2004 19:07 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
The first error is something that is fixed in the CVS.
If you download the attached upgrade script above, it should fix the problem.
FUDforum Core Developer
|
|
|
|
|
|
| Re: SQL Error when upgrading : #1054 [message #16318 is a reply to message #16313] |
Sun, 25 January 2004 19:49 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Try again in a few days, the IP of the server had changed and the new DNS entries need a few days to propogate.
FUDforum Core Developer
|
|
|
|
| Re: SQL Error when upgrading : #1054 [message #16362 is a reply to message #16318] |
Tue, 27 January 2004 01:49 |
jdarnold
Messages: 12
Registered: January 2003
Karma: 0
|
Junior Member |
|
|
OK, finally got the new upgrade script, uploaded it and changed the permissions to 666. now I get the following and it just stops:
| Quote: |
Beginning SQL Upgrades
SQL Upgrades Complete
Adding GLOBAL Variables
Compiling theme default
DUPE: SECTION -> approved_avatar_title found in /var/www/html/5th-imperium.net/forum-data/thm/Fifth/tmpl/users_adm.tmpl (now parsing /var/www/html/5th-imperium.net/forum-data/thm/Fifth/tmpl/avatar_msg.tmpl)
|
Trying to access the forums yields:
| Quote: |
Warning: fud_use(/var/www/html/5th-imperium.net/forum-data/include/theme/default/err msg.inc): failed to open stream: No such file or directory in/home/virtual/site11/fst/var/www/html/forum-data/include/core.inc on line 67
Warning: fud_use(): Failed opening '/var/www/html/5th-imperium.net/forum-data/include/theme/default/errmsg.inc ' for inclusion (include_path='.:/php/includes:/usr/share/php:/usr/share/pear') in /home/virtual/site11/fst/var/www/html/forum-data/include/core.inc on line 67
Temporarily offline; please come back soon!__fud_ecore_adm_login_msg
|
Where do I go from here??
Edit: For some reason the upgrade script file size is only 58k after running the script, where it was 1.2MB before. Is this right??
[Updated on: Tue, 27 January 2004 01:53] Report message to a moderator |
|
|
|
| Re: SQL Error when upgrading : #1054 [message #16375 is a reply to message #16362] |
Tue, 27 January 2004 18:08 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
The size difference is correct, because the archive has been moved to a separate file to prevent safe_mode problems.
The problem occurred because you had some duplicate section names in the theme you've created. So the process stopped prematurely and was unable to complete rebuilding of all the themes. Hence the problem you are seeing.
You can fix the problem by running the following query and then re-running the upgrade script
UPDATE fud23_themes SET theme_opt=0 WHERE theme='Fifth';
replace fud23_ with whatever you database prefix is.
FUDforum Core Developer
|
|
|
|
| Re: SQL Error when upgrading : #1054 [message #16384 is a reply to message #16375] |
Wed, 28 January 2004 01:41 |
jdarnold
Messages: 12
Registered: January 2003
Karma: 0
|
Junior Member |
|
|
| Quote: |
The problem occurred because you had some duplicate section names in the theme you've created. So the process stopped prematurely and was unable to complete rebuilding of all the themes. Hence the problem you are seeing.
|
Only change I made for my theme was the addition of a link in the header - that's it.
Ilia, I'm sorry for all the trouble this has been, but I'm still not there. Now I get the following:
| Quote: |
Checking if SQL permissions to perform the upgrade are avaliable
Disable the forum
Forum is now disabled
Beginning the file upgrade process
Begining to decompress the archive
Finished decompressing the archive
File Upgrade Complete
Any changed files were backed up to: "/var/www/html/5th-imperium.net/forum-data/errors/.backup/"
Beginning SQL Upgrades
SQL Upgrades Complete
Setting default theme
Notice: Undefined index: LANGUAGE in /home/virtual/site11/fst/var/www/html/forum/upgrade.php on line 1277
Notice: Undefined index: LOCALE in /home/virtual/site11/fst/var/www/html/forum/upgrade.php on line 1277
Adding GLOBAL Variables
Compiling theme default
Warning: file_get_contents(/var/www/html/5th-imperium.net/forum-data/thm/default/i18 n//charset): failed to open stream: No such file or directory in/home/virtual/site11/fst/var/www/html/forum-data/include/compiler.inc on line 509
Missing Message entry postcheck_subj_needed inside i18n//msg
|
I swear that this was an unmodified forum install (except for the addition of the above mentioned link in the header).
EDIT: I can see where the firs Notice above results in teh incorrect directory page in the Warning. It should probably be ...i18n/english/charset. Where does the language come from?? Is there supposed to be a LANGUAGE variable in the GLOBALS.php file?? If so, there is not in my GLOBALS.php file. NOTE: I've never modified this file except through the Control Panel interface.
[Updated on: Wed, 28 January 2004 02:04] Report message to a moderator |
|
|
|
|
|
|
|
|
|
|
|
| Re: SQL Error when upgrading : #1054 [message #16393 is a reply to message #16391] |
Wed, 28 January 2004 04:16 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
The 1st step would be for you to take the non-original (small one) upgrade script and modify it as per my suggestion. This will not cause problems even if \r are added to it.
FUDforum Core Developer
|
|
|
|
|
|
|
|
| Re: SQL Error when upgrading : #1054 [message #16448 is a reply to message #16427] |
Fri, 30 January 2004 16:12 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Based on the error you are seeing it seems like some variable is still not defined or incorrect. Send me your modified upgrade script and I'll take a look.
FUDforum Core Developer
|
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]