FUDforum: FUDforum Installation Issues

Home » FUDforum » FUDforum Installation Issues » 2.5.2 upgrade problem

Show: Today's Messages :: Polls :: Message Navigator

2.5.2 upgrade problem [message #12364]

Wed, 06 August 2003 10:45

brewer13210

Messages: 9
Registered: December 2002
Location: Central NY

Karma: 0

Junior Member

Hi,

I just run the upgrade script for version 2.5.2, and everything seemed to go okay during the upgrade.

However, when accessing the forum, you now get the following error:
"Fatal error: SQL Error has occurred, please contact the administrator of the forum and have them review the forum's SQL query log in /home/apache/web_pages/Forum/index.php on line 52"

What should I be checking to fix this?

Thanks...

Todd

If you spend all your time arguing with fools, you'll just end up tired and they'll still be fools.

Report message to a moderator

Re: 2.5.2 upgrade problem [message #12369 is a reply to message #12364]

Wed, 06 August 2003 13:23

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

if you can login as the admin via the admin control panel check the error log control panel. Otherwise send me sql_errors files from your errors/ directory.

FUDforum Core Developer

Report message to a moderator

Re: 2.5.2 upgrade problem [message #12380 is a reply to message #12369]

Wed, 06 August 2003 16:20

brewer13210

Messages: 9
Registered: December 2002
Location: Central NY

Karma: 0

Junior Member

I can't log in to the forum as either a user or administrator.

The sql error file is attached.

Thanks...

Todd

Attachment: sql_errors.zip
(Size: 3.16KB, Downloaded 745 times)

If you spend all your time arguing with fools, you'll just end up tired and they'll still be fools.

Report message to a moderator

Re: 2.5.2 upgrade problem [message #12387 is a reply to message #12380]

Wed, 06 August 2003 18:25

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Based on the errors that I see you need to repair the forum's SQL tables as they have become corrupt. This is quite simple to do, just run:

REPAIR [table_name];

FUDforum Core Developer

Report message to a moderator

Re: 2.5.2 upgrade problem [message #12388 is a reply to message #12387]

Wed, 06 August 2003 19:18

brewer13210

Messages: 9
Registered: December 2002
Location: Central NY

Karma: 0

Junior Member

Thanks for the help.

I went through and repaired each table, but I'm still getting the same error.

You can see it here:

http://24.58.232.45/Forum/index.php

Is there any way to see what the MySQL error was? That would probably help narrow things down.

Todd

If you spend all your time arguing with fools, you'll just end up tired and they'll still be fools.

[Updated on: Wed, 06 August 2003 19:20]

Report message to a moderator

Re: 2.5.2 upgrade problem [message #12396 is a reply to message #12388]

Wed, 06 August 2003 20:29

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Take the last line from sql_errors and pass the long string of characters to php's base64_decode() function. If you print the output you'll see the error.

FUDforum Core Developer

Report message to a moderator

Re: 2.5.2 upgrade problem [message #12402 is a reply to message #12396]

Wed, 06 August 2003 22:31

brewer13210

Messages: 9
Registered: December 2002
Location: Central NY

Karma: 0

Junior Member

The error is:

(index.php) 1064: You have an error in your SQL syntax near '' at line 1
Query: SELECT u.id, u.alias, u.is_mod, u.custom_color FROM fud23_ses s INNER JOIN fud23_users u ON u.id=s.user_id WHERE s.time_sec>1060199685 AND u.invisible_mode='N' ORDER BY s.time_sec DESC LIMIT
Server Version: 3.23.56-Max
[Referring Page] http://fud.prohost.org/forum/index.php?t=selmsg&unread=1&rid=876&am p;frm_id=

Todd

If you spend all your time arguing with fools, you'll just end up tired and they'll still be fools.

Report message to a moderator

Re: 2.5.2 upgrade problem [message #12430 is a reply to message #12402]

Thu, 07 August 2003 16:00

Ilia

Messages: 13241
Registered: January 2002

Karma: 0

Senior Member
Administrator
Core Developer

Can you try running this query manually from MySQL and see if you get any errors?

FUDforum Core Developer

Report message to a moderator

Previous Topic:	Upgrade from 2.5.0 to 2.5.2 does not work
Next Topic:	IP address change problems

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 07 06:31:39 GMT 2024

Total time taken to generate the page: 0.02543 seconds