FUDforum: FUDforum Installation Issues » SQL Post-Installation Problems

Home » FUDforum » FUDforum Installation Issues » SQL Post-Installation Problems

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

SQL Post-Installation Problems [message #1407]

Fri, 12 April 2002 15:17

henry

Messages: 2
Registered: April 2002
Location: Bedford, UK

Karma:

Junior Member

Hey there,

I've just installed FUDforum-1.2.4 on my standard RedHat box.

Versions are as follows:

mysql-3.22.32
php-4-something

This is what I get at the top of most queries!

Query Failed: SELECT fud_cat.description, fud_cat.name AS cat_name, fud_cat.default_view, fud_cat.allow_collapse, fud_forum.*, fud_forum_read.last_view, 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 LEFT JOIN fud_forum_read ON fud_forum.id=fud_forum_read.forum_id AND fud_forum_read.user_id=1 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
From: /usr/local/apache/htdocs/forum/www_root/index.php
Server Version: 3.22.32

Any ideas? I did have to edit GLOBALS.php and take out a load of '/''s in order to get it to work at all.

Thanks in advance,

Henry Rolling Eyes

Report message to a moderator

[Message index]

		SQL Post-Installation Problems By: henry on Fri, 12 April 2002 15:17
		Re: SQL Post-Installation Problems By: Ilia on Fri, 12 April 2002 15:20
		Re: SQL Post-Installation Problems By: henry on Fri, 12 April 2002 16:02

Previous Topic:	Removing links from login.php
Next Topic:	Java error when i try too use Formatting tools

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 10:46:29 GMT 2024

Total time taken to generate the page: 0.04464 seconds