Thread: Chat Modifications - MGC Chatbox Evo
View Single Post
  #4782  
Old 04-01-2009, 07:34 AM
VBDev's Avatar
VBDev VBDev is offline
 
Join Date: Jan 2004
Location: France
Posts: 2,570
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Quote:
Originally Posted by Raug View Post
Not sure if I'm understanding this. I looked at the mgc_cb_evo_chat table and the closest thing I see to chat text is ctext. Right now its type is "mediumtext" so is this what should be changed to utf8? I'm also not very savvy with mysql so I'm not entirely sure how to change it if that's the case.
Nope, you have the table encoding type for this field which is something containing "latin" in it and which need to be changed to utf8.

Quote:
Originally Posted by The Realist View Post
I've a section open so none members can post but when a post is created a DB error shows up. When I disable the notifications the error goes away.

I have updated the files to the latest versions.

Any ideas?

The DB error is:

Code:
Invalid SQL:
 
            INSERT INTO mgc_cb_evo_chat
                (
                  dateline,fromuid,name,ctext,sticky,chanid,coidentifier,iswarning,warningtype,tpforumid,
                  hascustomavatar,avatarid,avatarrevision,usergroupid,displaygroupid
                  
                )
            VALUES
                (
                    1238499283,0,'','823,Test',0,0,0,1,'thread',38,
                 ,,,
                 ,
                 
                );
 
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 10
Error Number  : 1064
Request Date  : Tuesday, March 31st 2009 @ 11:34:43 AM
Error Date    : Tuesday, March 31st 2009 @ 11:34:43 AM
Script        : http://www.xxxxx.co.uk/newthread.php?do=postthread&f=38
Referrer      : http://www.xxxxx.co.uk/newthread.php?do=newthread&f=38
IP Address    : 
Username      : Unregistered
Classname     : vB_Database
MySQL Version :
PS,

If I disable the "Activate the display of an automatic message upon creation of a new thread by an user" the error goes away but the other option works great.
So you only have problems with thread notification but not post ?

Quote:
Originally Posted by Se?or Ramos View Post
My apologies. I'm still fairly new to the adminstrative and technical end of vB, so knowing what information you need would be awesome. I'm using CuteFTP professional. I have 3 of the same image for each channel in there, with the _sel, _nosel and _new suffixes. Is this not what I'm supposed to do?
Yes with .gif extension, but don't input the _sel, _nosel or _new in the field (neither do input the .gif).

Quote:
Originally Posted by Mr. Baws View Post
upgraded and now i cant see msgs in default channel, idk how to fix that, i tried everything
Any errors in your firefox console ?

Quote:
Originally Posted by kronnos View Post
Anyone use this along with VBSEO? Does it work fine?
We do on forumcoding and it works. Why ?
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01116 seconds
  • Memory Usage 1,782KB
  • 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_code
  • (5)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