FUDforum: FUDforum Installation Issues » mysql select problem just after installation

Home » FUDforum » FUDforum Installation Issues » mysql select problem just after installation

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

Re: mysql select problem just after installation [message #750 is a reply to message #749]

Tue, 26 February 2002 18:23

Ilia

Messages: 13241
Registered: January 2002

Karma:

Senior Member
Administrator
Core Developer

aetius wrote on Tue, 26 February 2002 12:15 PM

I just installed FUD, but when i recall the main page, i receive the following error:
-----
Query Failed: SELECT fud_cat.description, fud_cat.name AS cat_name, fud_cat.default_view, fud_cat.allow_collapse, fud_forum.*, fud_msg.id AS msg_id, fud_msg.post_stamp AS msg_post_stamp, fud_users.id AS user_id, fud_users.login AS user_login FROM fud_cat INNER JOIN fud_forum ON fud_cat.id=fud_forum.cat_id AND fud_cat.hidden='N' LEFT JOIN fud_msg ON fud_forum.last_post_id=fud_msg.id LEFT JOIN fud_users ON fud_msg.poster_id=fud_users.id WHERE fud_forum.hidden='N' ORDER BY fud_cat.view_order, fud_forum.view_order
Reason: You have an error in your SQL syntax near 'ON fud_cat.id=fud_forum.cat_id AND fud_cat.hidden='N' LEFT JOIN fud_msg ' at line 5
-----
the file is index.php

any help?

thanks in advance.

2 questions:

1) What is the version of your MySQL that you are running
2) Could you please give me a URL to your forum

FUDforum Core Developer

Report message to a moderator

[Message index]

		mysql select problem just after installation By: aetius on Tue, 26 February 2002 17:15
		Re: mysql select problem just after installation By: Ilia on Tue, 26 February 2002 18:23
		Re: mysql select problem just after installation By: aetius on Wed, 27 February 2002 16:50
		Re: mysql select problem just after installation By: Ilia on Wed, 27 February 2002 16:53

Previous Topic:	Aproving posts
Next Topic:	Problem Creating Threads

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 16:08:47 GMT 2024

Total time taken to generate the page: 0.04299 seconds