Chris Bowyer's "Shoutbox" Problem!

[Logikos]

After installing this hack on my PC (Computer) Vbb
it worked great!

I then uploaded all files necessary to my real board, i ran into this problem. When i try to load my Forums Home.
Ii get this error.


Database error in vBulletin 2.2.9:

Invalid SQL: SELECT u.username, s.userid, s.shout_text, s.timestamp FROM user u, shoutbox s WHERE u.userid = s.userid ORDER BY s.timestamp DESC LIMIT 1
mysql error: Unknown column 's.userid' in 'field list'

mysql error number: 1054

Date: Friday 17th of January 2003 04:55:30 PM
Script: http://www.TheNemesis.net/Forums/Forums/
Referer:




In the Instructions (index.php)(forums home)
i "find"
eval("dooutput(\"".gettemplate('forumhome')."\");");

and replace with

$shout = $DB_site->query_first("SELECT u.username, s.userid, s.shout_text, s.timestamp FROM user u, shoutbox s WHERE u.userid = s.userid ORDER BY s.timestamp DESC LIMIT 1");
$shout[timestamp] = vbdate('n-j-y, g:i:s a', $shout[timestamp]);
$shout[shout_text] = bbcodeparse($shout[shout_text]);
eval("\$the_shoutbox .= \"".gettemplate("forumhome_shoutbox")."\";");
eval("dooutput(\"".gettemplate('forumhome')."\");");


i can see where the error is coming from.
But cant tell if the codeing is wrong

Help needed quick :(
Thanks!
-Nem

[Shpookdefied]

Yes, it would be nice to get this working. Any help?

[EchoHype.com]

I'll look at the code more thoroughly when I wake up and give ya a solution

gnight

[Logikos]

*Bump* still need help

[TECK]

Please, always post a link to the actual hack, if you want help faster. You are lucky that I knew the coder's hack.
Did you ran the query to create the needed table?

Use this code:$shout = $DB_site->query_first("
SELECT shoutbox.*,user.username
FROM shoutbox
LEFT JOIN user USING( userid )
ORDER BY shoutbox.timestamp DESC LIMIT 1
");

[Logikos]

Yes i did run the query, and i still run into this peoblem

[TECK]

Did you edited the code with my query? What's the error you get now?