Thread: Chat Modifications - MGC Chatbox Evo
View Single Post
  #627  
Old 02-26-2008, 10:40 AM
Saint_ago Saint_ago is offline
 
Join Date: Jan 2006
Location: S?o Paulo - Brasil
Posts: 64
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by VBDev View Post
This is based on usergroup permissions so I think you haven't set that usergroup permission
My bad! Now it's okay!

But i'm receiving this DB error by email:

Database error in vBulletin 3.6.8:

Invalid SQL:

SELECT c.*,fromu.userid AS fromuserid,fromu.username AS fromusername,fromu.usergroupid AS fromusergroupid,fromu.displaygroupid AS fromdisplaygroupid,
tou.userid AS touserid,tou.username AS tousername,tou.usergroupid AS tousergroupid,tou.displaygroupid AS todisplaygroupid

FROM vb_mgc_cb_evo_chat AS c
LEFT JOIN vb_user AS fromu ON (c.fromuid=fromu.userid)
LEFT JOIN vb_user AS tou ON (c.touid=tou.userid)
LEFT JOIN vb_mgc_cb_evo_command AS co ON (c.primcid=co.cid)

WHERE primcid='0'
ORDER BY sticky DESC,c.dateline DESC
LIMIT 25;

MySQL Error : Unknown column 'sticky' in 'order clause'
Error Number : 1054
Date : Monday, February 25th 2008 @ 10:18:18 PM
Script : http://bfcentral.oi.com.br/forum/mgc_cb_evo_ajax.php
Referrer : http://bfcentral.oi.com.br/forum/
IP Address : 189.43.64.69
Username : Trapo
Classname : vB_Database


Another issue, when a user doesn't have all required profile fields filled (for example, when a required field is created after his registration) the chatbox just shows empty, with no messages anda no options, and no indication of what is wrong. The user only knows that he have a problem with required fields when he tries to read a post/thread or do another action in forum. After that, when he fills the required fields, the chatbox shows correctly.
But i can't reproduce it. I've logged in as a regular user and tried to stick a message, but nothing happened, not even a db error..
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01204 seconds
  • Memory Usage 1,767KB
  • 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)bbcode_quote
  • (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