FUDforum: Bug Reports » Error trying to mark messages read

Home » FUDforum Development » Bug Reports » Error trying to mark messages read

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

Re: Error trying to mark messages read [message #18559 is a reply to message #18558]

Thu, 27 May 2004 16:10

darkness

Messages: 7
Registered: May 2004

Karma:

Junior Member

I've got a whole bunch of these, and the time stamp indicates they're mostly from me testing:

(/srv/www/forums.caliginous.net/root/index.php:141
/srv/www/forums.caliginous.net/root/index.php:1103
/srv/www/forums.caliginous.net/root/theme/default/markread.php:47
/srv/www/forums.caliginous.net/root/index.php:1183
) : ERROR: parser: parse error at or near "SELECT" at character 108
Query: UPDATE fud26_1_read SET user_id=4, thread_id=id, msg_id=last_post_id, last_view=1085666536 WHERE user_id=4 SELECT id, last_post_id FROM fud26_1_thread WHERE forum_id=4
Server Version:
[Referring Page] http://forums.caliginous.net/

Then I've got some other SQL errors that I'm guessing are unrelated, but here's a selection of them anyway:

(/srv/www/forums.caliginous.net/root/index.php:141
/srv/www/forums.caliginous.net/root/index.php:208
/srv/www/forums.caliginous.net/root/theme/default/usrinfo.php:287
/srv/www/forums.caliginous.net/root/index.php:1183
) : ERROR: parser: parse error at or near ")" at character 128
Query: SELECT count(*) FROM fud26_1_poll p INNER JOIN fud26_1_forum f ON p.forum_id=f.id WHERE p.owner=17 AND f.cat_id>0 AND f.id IN()
Server Version:
[Referring Page] http://forums.caliginous.net/index.php?t=finduser&btn_submit=Find&rid=17&S=11b2f5b29cf9dcbeb055c7b02943393b

(/srv/www/forums.caliginous.net/root/index.php:141
/srv/www/forums.caliginous.net/root/index.php:134
/srv/www/forums.caliginous.net/root/theme/default/usrinfo.php:209
/srv/www/forums.caliginous.net/root/index.php:1183
) : ERROR: parser: parse error at or near ")" at character 144
Query: SELECT f.id, f.name FROM fud26_1_mod mm INNER JOIN fud26_1_forum f ON mm.forum_id=f.id INNER JOIN fud26_1_cat c ON f.cat_id=c.id WHERE f.id IN() AND mm.user_id=4
Server Version:
[Referring Page] http://forums.caliginous.net/index.php?t=online_today&rid=17&S=11b2f5b29cf9dcbeb055c7b02943393b

Those are the three queries that seem to be in the SQL error log. I'm running PostgreSQL 7.3.4 (Fedora Core 1 Linux, postgresql-server-7.3.4-11).

darky
--

Report message to a moderator

[Message index]

		Error trying to mark messages read By: darkness on Thu, 27 May 2004 15:22
		Re: Error trying to mark messages read By: Ilia on Thu, 27 May 2004 15:52
		Re: Error trying to mark messages read By: darkness on Thu, 27 May 2004 16:10
		Re: Error trying to mark messages read By: Ilia on Thu, 27 May 2004 16:53
		Re: Error trying to mark messages read By: darkness on Thu, 27 May 2004 17:19
		Re: Error trying to mark messages read By: Ilia on Thu, 27 May 2004 17:29
		Re: Error trying to mark messages read By: darkness on Thu, 27 May 2004 17:35
		Re: Error trying to mark messages read By: Ilia on Thu, 27 May 2004 17:37
		Re: Error trying to mark messages read By: darkness on Thu, 27 May 2004 17:44
		Re: Error trying to mark messages read By: darkness on Thu, 27 May 2004 16:39
		Re: Error trying to mark messages read By: darkness on Thu, 27 May 2004 16:53

Previous Topic:	2.6.2 Find User link broken
Next Topic:	3 phantom visitors

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Oct 05 05:19:14 GMT 2024

Total time taken to generate the page: 0.03774 seconds