Dan,
I am losing my mind! Heh. I have installed your hack and there were no problems during installation. I then installed the Yabba hack "last 10" and have got it working, unless you decide to log out and try to access the page. Then you get a message:
Quote:
There seems to have been a slight problem with the Ashkins' Family Web Site database.
Please try again by pressing the refresh button in your browser.
An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.
We apologise for any inconvenience.
|
The error message I get is this:
Quote:
<!--
Database error in vBulletin 3.0.3:
Invalid SQL: SELECT
post.postid, post.nowplaying AS post_nowplaying,
thread.threadid, thread.title AS thread_title,
user.userid, user.username
FROM
post AS post,
thread AS thread,
user AS user
LEFT JOIN deletionlog AS dlog_t ON (dlog_t.primaryid = thread.threadid AND dlog_t.type = 'thread')
LEFT JOIN deletionlog AS dlog_p ON (dlog_p.primaryid = post.postid AND dlog_p.type = 'post')
WHERE
thread.threadid = post.threadid AND
thread.forumid IN() AND
thread.visible = 1 AND
dlog_t.primaryid IS NULL AND
dlog_p.primaryid IS NULL AND
post.visible = 1 AND
thread.open <> 10 AND
user.userid = post.userid AND
post.nowplaying != ''
ORDER BY post.postid DESC LIMIT 10
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND
thread.visible = 1
mysql error number: 1064
Date: Sunday 19th of September 2004 07:52:28 PM
Script: http://ashkins.net/forum/index.php
Referer: http://www.ashkins.net/forum/login.php?do=logout
Username: Unregistered
IP Address: xx.xx.xx.xx
-->
|
My site uses "Vbindex" and I am using Vbulletin 3.03. It does this on my forum index page as well when I try it. I have been working on this for a while now and can't seem to get it to work. Whenever I insert the code into my index.php and save it, I am able to see the last ten displayed properly, but if I log out of the page, it will not let me back in. Web page is
http://ashkins.net/forum