Thread: Chat Modifications - Dion Dev Shoutbox v2.1 (AJAX)
View Single Post
  #163  
Old 02-04-2012, 03:54 AM
VIP Hawaii VIP Hawaii is offline
 
Join Date: Aug 2008
Location: Maine
Posts: 17
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I liked your shoutbox a lot until I realised that it does not use VBulletin's permissions system, so I uninstalled it. Then I started getting these errors. I have removed the entire /shoutbox directory and reverted the template edits yet I keep getting the database errors! :

"Database error in vBulletin 3.8.4:

Invalid SQL:

select s.*, g.opentag, g.closetag
from shoutbox as s, user as u, usergroup as g
where u.userid = s.user_id and g.usergroupid = u.usergroupid
order by id desc
limit;

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 '' at line 5
Error Number : 1064
Request Date : Saturday, February 4th 2012 @ 03:23:31 AM
Error Date : Saturday, February 4th 2012 @ 03:23:32 AM
Script : http://paradisefoundation.net/shoutbox/shoutshow.php
Referrer : http://paradisefoundation.net/shoutbox/shoutdiv.php
IP Address : xxxxxxxx
Username : xxxxxxx
Classname : vB_Database
MySQL Version : 5.1.52
"

If you try clicking on the links to the two "scripts" above, you will see that they do not even exist on our server anymore ... yet the errors persist.

Please help! :erm:
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01143 seconds
  • Memory Usage 1,764KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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
  • showpost_complete