Topic: Global Topic
Is there any chance this plugin can be upgraded for SQLite?
Or can anyone help me figure out how to do it?
Re: Global Topic
In the future, please just post these inside the topic for the plugin 
What's wrong with the plugin, because it doesn't look to me like it has any MySQL specific code?
Re: Global Topic
apologies, I'll try and remember...
I get the error: Error: Unable to get topics.
Which I assume relates to
$result = $db->query('SELECT t.id, t.poster, t.subject, t.posted, t.last_post, t.last_post_id, t.last_poster, t.num_views, t.num_replies, t.closed, t.sticky, t.moved_to, t.forum_id, f.forum_name FROM '.$db->prefix.'topics as t LEFT JOIN '.$db->prefix.'forums as f ON t.forum_id=f.id WHERE subject=\''.$db->escape($cur_global['subject']).'\' AND posted='.$db->escape($cur_global['posted']).' ORDER BY sticky DESC, '.(($cur_forum['sort_by'] == '1') ? 'posted' : 'last_post').' DESC LIMIT 0, 50') or error('Unable to get topics', __FILE__, __LINE__, $db->error());The error occurs as soon as I go to the page. Running punBB 1.2.14
Re: Global Topic
Enable debug mode, paste the full error
Re: Global Topic
ok, enabled debug, and show queries while I was there just in case and got the following:
File: .../forum/plugins/AMP_Global_topic.php
Line: 265
PunBB reported: Unable to get topics
Database reported: SQL logic error or missing database (Errno: 1)
Failed query: SELECT t.id, t.poster, t.subject, t.posted, t.last_post, t.last_post_id, t.last_poster, t.num_views, t.num_replies, t.closed, t.sticky, t.moved_to, t.forum_id, f.forum_name FROM topics as t LEFT JOIN forums as f ON t.forum_id=f.id WHERE subject='Test' AND posted=1167187313 ORDER BY sticky DESC, last_post DESC LIMIT 0, 506 2007-02-01 13:30 (edited by Rich Pedley 2007-02-01 13:31)
Re: Global Topic
digging a little deeper the following appears in the table:
5073 poster Test 1167187313 1167601133 37887 last_poster 4 15 0 0 NULL 14
5075 poster Test 1167187313 1167601133 0 NULL 0 0 0 0 5073 10(poster, and last_poster names amended)