FUDforum: Bug Reports » Several topics with sqlite

Home » FUDforum Development » Bug Reports » Several topics with sqlite

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

Re: Several topics with sqlite [message #159622 is a reply to message #159571]

Sat, 13 June 2009 07:47

naudefj

Messages: 3771
Registered: December 2004

Karma:

Senior Member
Administrator
Core Developer

I've asked for help on the sqlite mailing list. Pavel Ivanov replied with this alternate syntax that will work on sqlite:

UPDATE fud28_read
SET user_id=2, last_view=1244710953,
      msg_id=(SELECT last_post_id FROM fud28_thread
                    WHERE id = fud28_read.thread_id)
WHERE user_id=2
     AND thread_id in (SELECT id FROM fud28_thread
                                WHERE forum_id=4 AND last_post_date > 0)

The original query works on MySQL, PostgreSQL and Oracle - so, maybe they will support the original syntax in a future release.

Report message to a moderator

[Message index]

		Several topics with sqlite By: icarus on Thu, 11 June 2009 09:04
		Re: Several topics with sqlite By: naudefj on Thu, 11 June 2009 15:54
		Re: Several topics with sqlite By: naudefj on Sat, 13 June 2009 07:47
		Re: Several topics with sqlite By: icarus on Mon, 15 June 2009 11:26
		Re: Several topics with sqlite By: naudefj on Mon, 15 June 2009 17:13

Previous Topic:	Blank Page - Not Processing PHP pages
Next Topic:	Upgrading script corrupted when create_file_list's php binary is modified

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 28 08:54:17 GMT 2024

Total time taken to generate the page: 0.03955 seconds