FUDforum: FUDforum Installation Issues » Will not show Category

Home » FUDforum » FUDforum Installation Issues » Will not show Category

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

Re: Will not show Category [message #5341 is a reply to message #5336]

Wed, 28 August 2002 11:57

esm2002

Messages: 339
Registered: May 2002
Location: Atlanta Georgia

Karma:

Senior Member

As a follow-up, when I am not logged in as a registered user, I cannot see any of the forums. If I go to the members listing screen and click on a member, I get the following error.

Quote:

Query Failed: SELECT count(*) FROM fud2_poll INNER JOIN fud2_msg ON fud2_poll.id=fud2_msg.poll_id INNER JOIN fud2_thread ON fud2_thread.id=fud2_msg.thread_id INNER JOIN fud2_forum ON fud2_thread.forum_id=fud2_forum.id WHERE fud2_poll.owner=111 AND fud2_thread.forum_id IN () AND fud2_thread.locked='N' AND fud2_msg.approved='Y' AND fud2_forum.cat_id!=0
Reason: You have an error in your SQL syntax near ') AND fud2_thread.locked='N' AND fud2_msg.approved='Y' AND fud2_forum.cat_id!=0' at line 8
From: /home/acct351/public_html/fudforum/br/index.php
Server Version: 3.23.22-beta

Maybe looking back at the sequence of things will help. If I sign in and go to the members listing screen and click on a member, I can click on any member without error. On August 2 a member named deshka registerd and made a post to the message board. That post can be read without error from the members board. On August 2, since I was scheduled to be home for the coming week, I decided to upgrade from 1.98 to 2.2.4RC3. there was a problem and we got things working by Aug 6, as I recollect. I registered as Wilbur Post just to test but did not post a message. A couple of other new members resgisted that day. On Aug 7 barbee registered as a new member and posted two messages. When I am in the members listing and click on the link to her last post, I get the following error

Quote:

Query Failed: SELECT fud2_msg.id AS msg_id, fud2_thread_view.pos, fud2_thread.id, fud2_msg.subject FROM fud2_thread_view INNER JOIN fud2_thread ON fud2_thread_view.thread_id=fud2_thread.id INNER JOIN fud2_msg ON fud2_thread.root_msg_id=fud2_msg.id WHERE fud2_thread_view.forum_id=3 AND fud2_thread_view.page= AND fud2_thread_view.pos IN (-1, 1) ORDER BY pos
Reason: You have an error in your SQL syntax near 'AND fud2_thread_view.pos IN (-1, 1) ORDER BY pos' at line 15
From: /home/acct351/public_html/fudforum/br/index.php
Server Version: 3.23.22-beta

One last thing. When I sign in as the Admin, I can see the message boards. When I sign in as a regular member, Wilbur Post, I cannot see any of the forums. But I can go to the members board and view any msgs before August 3 ( see above ). I can also view the unread posts - see attached. Strangely, I see one of barbee's msg but cannot see her other message ( see wp01.jpg and wp01a.jpg ). I tried clicking on the [more unread messages] link but nothing showed up ( see wp02.jpg ).

Could it be that one of barbee's msg has become "corrupted" and thus causing the problems? Since I can view msgs before her just fine, but not after, and including, her msg, it would seem the program is OK. Maybe not all of the problem but mabye a start.

Gene
"The older I get, the more I admire competence, just simple competence in any field from adultery to zoology."

Report message to a moderator

[Message index]

		Will not show Category By: esm2002 on Mon, 12 August 2002 23:30
		Re: Will not show Category By: Ilia on Tue, 13 August 2002 13:37
		Re: Will not show Category By: esm2002 on Tue, 13 August 2002 19:23
		Re: Will not show Category By: Ilia on Tue, 13 August 2002 19:46
		Re: Will not show Category By: esm2002 on Thu, 15 August 2002 21:11
		Re: Will not show Category By: Ilia on Thu, 15 August 2002 21:42
		Re: Will not show Category By: esm2002 on Thu, 15 August 2002 22:57
		Re: Will not show Category By: Ilia on Thu, 15 August 2002 23:57
		Re: Will not show Category By: esm2002 on Fri, 16 August 2002 00:16
		Re: Will not show Category By: Ilia on Mon, 19 August 2002 02:53
		Re: Will not show Category By: esm2002 on Mon, 19 August 2002 11:32
		Re: Will not show Category By: Ilia on Mon, 19 August 2002 16:21
		Re: Will not show Category By: esm2002 on Tue, 20 August 2002 04:00
		Re: Will not show Category By: Ilia on Tue, 20 August 2002 12:23
		Re: Will not show Category By: esm2002 on Tue, 20 August 2002 21:41
		Re: Will not show Category By: esm2002 on Thu, 22 August 2002 16:01
		Re: Will not show Category By: Ilia on Thu, 22 August 2002 16:16
		Re: Will not show Category By: esm2002 on Thu, 22 August 2002 17:26
		Re: Will not show Category By: esm2002 on Mon, 26 August 2002 15:23
		Re: Will not show Category By: Ilia on Mon, 26 August 2002 15:46
		Re: Will not show Category By: esm2002 on Mon, 26 August 2002 17:03
		Re: Will not show Category By: Ilia on Tue, 27 August 2002 12:43
		Re: Will not show Category By: esm2002 on Tue, 27 August 2002 12:56
		Re: Will not show Category By: Ilia on Tue, 27 August 2002 13:13
		Re: Will not show Category By: esm2002 on Tue, 27 August 2002 13:39
		Re: Will not show Category By: Ilia on Tue, 27 August 2002 13:48
		Re: Will not show Category By: esm2002 on Tue, 27 August 2002 17:00
		Re: Will not show Category By: esm2002 on Wed, 28 August 2002 01:16
		Re: Will not show Category By: Ilia on Wed, 28 August 2002 03:21
		Re: Will not show Category By: esm2002 on Wed, 28 August 2002 11:57
		Re: Will not show Category By: Ilia on Wed, 28 August 2002 12:49
		Re: Will not show Category By: Ilia on Wed, 28 August 2002 14:49
		Re: Will not show Category By: esm2002 on Wed, 28 August 2002 16:07
		Re: Will not show Category By: Ilia on Wed, 28 August 2002 16:49
		Re: Will not show Category By: esm2002 on Wed, 28 August 2002 21:54
		Re: Will not show Category By: esm2002 on Wed, 16 October 2002 22:24
		Re: Will not show Category By: Ilia on Thu, 17 October 2002 21:31
		Re: Will not show Category By: esm2002 on Wed, 16 October 2002 02:07

Previous Topic:	Error msg
Next Topic:	Registering new users is very slow

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 22:37:31 GMT 2024

Total time taken to generate the page: 0.04472 seconds