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 #159671 is a reply to message #159670]

Mon, 15 June 2009 17:13

naudefj

Messages: 3771
Registered: December 2004

Karma:

Senior Member
Administrator
Core Developer

Try this and let me know if it helps:

Index: users.inc.t
===================================================================
RCS file: /forum21/install/forum_data/src/users.inc.t,v
retrieving revision 1.171
diff -u -r1.171 users.inc.t
--- users.inc.t	3 May 2009 18:57:06 -0000	1.171
+++ users.inc.t	15 Jun 2009 17:12:27 -0000
@@ -781,7 +781,7 @@
 
 function user_mark_forum_read($id, $fid, $last_view)
 {
-	if (__dbtype__ == 'mysql') {
+	if (__dbtype__ == 'mysql' || __dbtype__ == 'sqlite') {
 		if ($GLOBALS['FUD_OPT_3'] & 1024) {
 			q('INSERT INTO {SQL_TABLE_PREFIX}read (user_id, thread_id, msg_id, last_view) SELECT '.$id.', id, last_post_id, '.__request_timestamp__.' FROM {SQL_TABLE_PREFIX}thread WHERE forum_id='.$fid.' AND last_post_date > '.$last_view.' ON DUPLICATE KEY UPDATE last_view=VALUES(last_view), msg_id=VALUES(msg_id)');
 		} else {

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: Mon Oct 07 23:51:33 GMT 2024

Total time taken to generate the page: 0.03536 seconds