vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Chat Modifications - MGC Chatbox Evo (https://vborg.vbsupport.ru/showthread.php?t=168992)

ninjamaster 09-14-2013 03:45 PM

1 Attachment(s)
hi can anybody help me i have received an email with this error on it does anyone know how to fix it and also im getting a BBCODES error shown on the attachment

Database error in vBulletin 4.2.1:

Invalid SQL:

SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_global AS phrasegroup_global,
language.phrasegroupinfo AS lang_phrasegroupinfo,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep
,mgcugp.mgc_cb_evo_default_color,mgcugp.mgc_cb_evo _chanid
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))
LEFT JOIN usergroup AS mgcugp ON (user.usergroupid=mgcugp.usergroupid)
WHERE user.userid = 1 LIMIT 1;

MySQL Error : Unknown column 'mgcugp.mgc_cb_evo_chanid' in 'field list'
Error Number : 1054
Request Date : Saturday, September 14th 2013 @ 11:43:34 AM
Error Date : Saturday, September 14th 2013 @ 11:43:34 AM


T:mad:hanks you

VBDev 09-14-2013 03:50 PM

Quote:

Originally Posted by fookaa (Post 2444205)
Ah i dont have links in bot chat but i did disable the bot and that did fix it :D

Quote:

Originally Posted by Cusski (Post 2444202)
remove bot entries that have a link, this fixed for me

Please guys post a screenshot of what you had set so that I can investigate (bot page)

Quote:

Originally Posted by Virtex-II (Post 2445540)
Hi guys I have just installed version 3.4.0 but I can't find the option to enlarge the text box where the user can write their messages. Actually this text box is a little bit larger that the OK button. Can someone please help? Thanks!!!

In chat formating options.

VBDev 09-14-2013 03:52 PM

Quote:

Originally Posted by ninjamaster (Post 2445599)
hi can anybody help me i have received an email with this error on it does anyone know how to fix it and also im getting a BBCODES error shown on the attachment

Database error in vBulletin 4.2.1:

Invalid SQL:

SELECT
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate, user.languageid AS saved_languageid,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_global AS phrasegroup_global,
language.phrasegroupinfo AS lang_phrasegroupinfo,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep
,mgcugp.mgc_cb_evo_default_color,mgcugp.mgc_cb_evo _chanid
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))
LEFT JOIN usergroup AS mgcugp ON (user.usergroupid=mgcugp.usergroupid)
WHERE user.userid = 1 LIMIT 1;

MySQL Error : Unknown column 'mgcugp.mgc_cb_evo_chanid' in 'field list'
Error Number : 1054
Request Date : Saturday, September 14th 2013 @ 11:43:34 AM
Error Date : Saturday, September 14th 2013 @ 11:43:34 AM


T:mad:hanks you

Seems like you had an error in chatbox install. Would recommand you to uninstall and install it again.

Regarding bbcodes, have you uploaded the images directory to your style misc image directoy ?

ninjamaster 09-14-2013 04:43 PM

Quote:

Originally Posted by VBDev (Post 2445602)
Seems like you had an error in chatbox install. Would recommand you to uninstall and install it again.

Regarding bbcodes, have you uploaded the images directory to your style misc image directoy ?

i have not uploaded anything all i did was install everything

DAMINK 09-23-2013 04:31 AM

I am wanting to use image names in replacement of the current names or html markup.
I can do this forum wide using the replacement variable.
Only problem is the chatroom does not display them correctly.
Its able to show them in the online bit breifly until it refreshes then it just picks up the original name again and not the replacement variable like below.

http://www.ftw.net.au/fileuploads4/1...able-issue.png

Also when you look through the Archives of the chatroom the image names appear ok. It seems its only in the actual live chat area its not appearing?

http://www.ftw.net.au/fileuploads4/1...n-archives.png

I would really like to be able to have this work.

Pladimir 09-28-2013 02:54 PM

How can i change the color of the text input box on my vb3.8. Actually, it is white and i would change it to black.

greez

hawk11220 10-04-2013 01:33 AM

nevermind, figured it out

dailyyeah 10-04-2013 05:27 AM

Hi,

I am getting the security token issue. I did a lot of research, but I can't find any answers. Essentially, I changed my cookie domain to be /, and now I can't view any chat logs on Firefox, or send any messages. But IE works perfectly.

What could it be?

Thanks,

tbworld 10-04-2013 05:59 AM

A general thing you can try is to clear your browser's cache and cookies, if you have not done so already.

dailyyeah 10-04-2013 12:50 PM

Quote:

Originally Posted by tbworld (Post 2449871)
Clear your browser's cache and cookies, if you have not done so already.

Yeah, that is not the issue. I tested this with three different computers.


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

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.16561 seconds
  • Memory Usage 1,756KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (5)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete