FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » FUDforum Installation Issues » Installation OK error when logging in as Admin
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
Installation OK error when logging in as Admin [message #8075] Fri, 10 January 2003 21:27 Go to next message
djtom34 is currently offline  djtom34   Canada
Messages: 10
Registered: January 2003
Karma: 0
Junior Member
I get the following message when i try to log in as Admin:

Query Failed: SELECT count(*) FROM fud_msg_report INNER JOIN fud_msg ON fud_msg_report.msg_id=fud_msg.id INNER JOIN fud_thread ON fud_msg.thread_id=fud_thread.id INNER JOIN fud_mod ON fud_thread.forum_id=fud_mod.forum_id AND fud_mod.user_id=1
Reason: You have an error in your SQL syntax near 'ON fud_msg_report.msg_id=fud_msg.id INNER JOIN fud_thread ON fud_msg.thread_id=f' at line 1
From: /usr/web/www.tom33.com/forum5/index.php

Please help

Thanks

Tom
Re: Installation OK error when logging in as Admin [message #8076 is a reply to message #8075] Fri, 10 January 2003 22:12 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Hmm that query appears to be perfectly valid.
What database system are you using and what is it's version?
Also what version of FUDforum are you using?


FUDforum Core Developer
Re: Installation OK error when logging in as Admin [message #8077 is a reply to message #8075] Fri, 10 January 2003 22:16 Go to previous messageGo to next message
djtom34 is currently offline  djtom34   Canada
Messages: 10
Registered: January 2003
Karma: 0
Junior Member
Thanks for helping out.

the database is Mysql ver 3.2.2
the fud version is 1.1.1

Best regards

Tom
Re: Installation OK error when logging in as Admin [message #8078 is a reply to message #8077] Fri, 10 January 2003 22:24 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
Hmm... your MySQL version is too old and likely does not support the query syntax needed. You need MySQL 3.23 or higher, plus where did you get sources for FUDforum 1.1.1, that is an ancient version of the forum.

FUDforum Core Developer
Re: Installation OK error when logging in as Admin [message #8084 is a reply to message #8077] Fri, 10 January 2003 23:42 Go to previous message
djtom34 is currently offline  djtom34   Canada
Messages: 10
Registered: January 2003
Karma: 0
Junior Member
SUCCESS!!!!!!!!!!

I spoke with my ISP and they upgraded to 3.2.3 and now all the errors are gone.

Thank you very much.
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Is it possible to show the Number of active Users on another page?
Next Topic: Install went fine, posting gives SQL error
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Nov 22 06:38:35 GMT 2024

Total time taken to generate the page: 0.02343 seconds