Go Back   vb.org Archive > vBulletin Modifications > Archive > vB.org Archives > General > Member Archives
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools
Chris Bowyer's "Shoutbox" Problem! Details »»
Chris Bowyer's "Shoutbox" Problem!
Version: , by Logikos Logikos is offline
Developer Last Online: Sep 2023 Show Printable Version Email this Page

Version: Unknown Rating:
Released: 01-17-2003 Last Update: Never Installs: 0
 
No support by the author.

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.

Quote:
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"
Quote:
eval("dooutput(\"".gettemplate('forumhome')."\");" );
and replace with
Quote:
$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

Show Your Support

  • This modification may not be copied, reproduced or published elsewhere without author's permission.

Comments
  #2  
Old 01-18-2003, 06:14 AM
Shpookdefied Shpookdefied is offline
 
Join Date: Jan 2003
Location: South Florida
Posts: 58
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yes, it would be nice to get this working. Any help?
Reply With Quote
  #3  
Old 01-18-2003, 06:28 AM
EchoHype.com's Avatar
EchoHype.com EchoHype.com is offline
 
Join Date: Mar 2002
Location: Harrisburg, PA
Posts: 174
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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

gnight
Reply With Quote
  #4  
Old 01-19-2003, 09:32 PM
Logikos Logikos is offline
 
Join Date: Jan 2003
Posts: 2,924
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

*Bump* still need help
Reply With Quote
  #5  
Old 01-22-2003, 03:56 AM
TECK's Avatar
TECK TECK is offline
 
Join Date: Nov 2001
Location: Canada
Posts: 4,182
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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:
Code:
$shout = $DB_site->query_first("
  SELECT shoutbox.*,user.username
  FROM shoutbox
  LEFT JOIN user USING( userid )
  ORDER BY shoutbox.timestamp DESC LIMIT 1
");
Reply With Quote
  #6  
Old 01-22-2003, 03:00 PM
Logikos Logikos is offline
 
Join Date: Jan 2003
Posts: 2,924
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Yes i did run the query, and i still run into this peoblem
Reply With Quote
  #7  
Old 01-22-2003, 07:08 PM
TECK's Avatar
TECK TECK is offline
 
Join Date: Nov 2001
Location: Canada
Posts: 4,182
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 12:54 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04283 seconds
  • Memory Usage 2,255KB
  • Queries Executed 22 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)bbcode_code
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)modsystem_post
  • (1)navbar
  • (6)navbar_link
  • (120)option
  • (7)post_thanks_box
  • (7)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (7)post_thanks_postbit_info
  • (6)postbit
  • (7)postbit_onlinestatus
  • (7)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete