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)

OblivionMage 02-25-2009 08:34 PM

I reinstalled the chatbox (I'll try doing that again) and its not a specific style (doesn't work on default with all other hooks disabled).

NEway, thanks for the fast help ^^

((Yeah I know the errors aren't chatbox issues, sorry if that was misleading. I just posted them b.c I think you asked if there were any console errors from FF earlier))

Celebutopia 02-25-2009 10:02 PM

I tried installing this and all I kept getting where db errors that stated the following:

Code:

Database error in vBulletin 3.8.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.phrasegroup_posting AS phrasegroup_posting,
                        language.phrasegroup_postbit AS phrasegroup_postbit,
                        language.phrasegroup_showthread AS phrasegroup_showthread,
                        language.phrasegroup_inlinemod AS phrasegroup_inlinemod,
                        language.phrasegroup_reputationlevel AS phrasegroup_reputationlevel,
                        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 = 13061;

MySQL Error  : Unknown column 'mgcugp.mgc_cb_evo_default_color' in 'field list'

Can someone please help. Thanks!

VBDev 02-25-2009 11:00 PM

Quote:

Originally Posted by ispots (Post 1754624)
Damnit...didn't know there was a 2.2.1....I just updated like 3 days ago!

I'll let you know after I update again.

Ah ah the 2.2.1 was released 1 day after the 2.2.0.

Quote:

Originally Posted by OblivionMage (Post 1754626)
I reinstalled the chatbox (I'll try doing that again) and its not a specific style (doesn't work on default with all other hooks disabled).

NEway, thanks for the fast help ^^


((Yeah I know the errors aren't chatbox issues, sorry if that was misleading. I just posted them b.c I think you asked if there were any console errors from FF earlier))

Oh yes my bad :) Anyway do you still get that error with default style ?

Quote:

Originally Posted by Celebutopia (Post 1754703)
I tried installing this and all I kept getting where db errors that stated the following:

Code:

Database error in vBulletin 3.8.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.phrasegroup_posting AS phrasegroup_posting,
            language.phrasegroup_postbit AS phrasegroup_postbit,
            language.phrasegroup_showthread AS phrasegroup_showthread,
            language.phrasegroup_inlinemod AS phrasegroup_inlinemod,
            language.phrasegroup_reputationlevel AS phrasegroup_reputationlevel,
            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 = 13061;

MySQL Error  : Unknown column 'mgcugp.mgc_cb_evo_default_color' in 'field list'

Can someone please help. Thanks!

Where you having a previous version of the chatbox ?

Mr. Baws 02-26-2009 03:47 PM

I get this error when i try to move threads/posts (2.2.1)

Code:

Database error in vBulletin 3.8.1:

Invalid SQL:

            INSERT INTO mgc_cb_evo_chat
                (dateline,fromuid,ctext,sticky,chanid,coidentifier,iswarning,warningtype,tpforumid)
            VALUES
                (1235667822,,'11491,test',0,0,0,1,'thread',119);

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 ''11491,test',0,0,0,1,'thread',119)' at line 4
Error Number  : 1064
Request Date  : Thursday, February 26th 2009 @ 05:03:42 PM
Error Date    : Thursday, February 26th 2009 @ 05:03:42 PM
Script        : http://www.myboard.com/inlinemod.php?do=domoveposts&t=2129&postids=202414
Referrer      : http://www.myboard.com/inlinemod.php?threadid=2129&p=
IP Address    : 78.2.XXX.XX
Username      : XXXXXXXX
Classname    : vB_Database
MySQL Version : 5.0.67-community


VBDev 02-26-2009 07:02 PM

How are you moving threads/post ?

Coz I tried and didn't experienced it.

desirulez 02-26-2009 08:48 PM

im getting a database error because of this hack whenever i try to save something in usergroup i get this error i been uninsalled MGC CHATBOX

Database error in vBulletin 3.8.1:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'dR Girls',
`description` = '',
`usertitle` = 'dR Girls',
`opentag` = '<span style=\"color:#FF00FF\" title=\"dR Girls\"><b><dark>',
`closetag` = '</span>',
`passwordexpires` = '0',
`passwordhistory` = '0',
`ispublicgroup` = '0',
`canoverride` = '0',
`hhroptions` = '0',
`trgpermissions` = '0',
`forumpermissions` = '12316919',
`genericpermissions` = '1544034179',
`attachlimit` = '1000000',
`pmquota` = '100',
`pmpermissions` = '1',
`pmsendmax` = '5',
`pmthrottlequantity` = '0',
`calendarpermissions` = '17',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions2` = '1',
`genericoptions` = '41',
`profilepicmaxwidth` = '150',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '25000',
`avatarmaxwidth` = '50',
`avatarmaxheight` = '50',
`avatarmaxsize` = '20000',
`signaturepermissions` = '245759',
`sigpicmaxwidth` = '0',
`sigpicmaxheight` = '0',
`sigpicmaxsize` = '0',
`sigmaxrawchars` = '0',
`sigmaxchars` = '0',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '5',
`albumpermissions` = '0',
`albumpicmaxwidth` = '0',
`albumpicmaxheight` = '0',
`albumpicmaxsize` = '0',
`albummaxpics` = '0',
`albummaxsize` = '0',
`usercsspermissions` = '63',
`visitormessagepermissions` = '23',
`socialgrouppermissions` = '50903',
`maximumsocialgroups` = '5',
`groupiconmaxsize` = '25000',
`mgc_cb_evo_permissions` = '0',
`mgc_cb_evo_nbmsg_show` = '',
`mgc_cb_evo_nbmsg_perday_show` = ''
WHERE usergroupid=14;

MySQL Error : Unknown column 'mgc_cb_evo_permissions' in 'field list'
Error Number : 1054

VBDev 02-26-2009 09:09 PM

Well as I have said many times : read the uninstall instructions !!

RedGTiVR6 02-26-2009 11:24 PM

I'm sure this has been covered before, but with 293 pages, it's a little hard to keep up!

I've got this installed with no problems currently other than the fact that a number of the settings are still showing up in French. Any ideas how I can fix this?

I made sure to upload the English language.xml

Any help would be greatly appreciated!

Also, I've noticed that the time isn't showing up correctly.

For instance, right now it's 7:33 PM, but the time is showing up as 7:1 PM on the Chat box. One other minor bug, the version still states 2.2.0 in the bottom of the chat box, even though it's listed as 2.2.1 in the products in the AdminCP.

fukdawrld 02-27-2009 02:59 AM

I have 2 issues:

Ok i have a very strange problem. It seems whatever display order I have my chats on is opposite for registered users. If i have it set to "newest first" my admins, mods, supermod, all see it as newest first...but my registered users see it as oldest first???? Any Ideas?


The other has been asked in this thread a few times but with no clear answers:

Quote:

Originally Posted by Trek (Post 1709823)
UPDATE #2:
-----------

So the problem is actually that the variable $stylevar['imgdir_misc'] is getting URLencoded before vB does whatever replacements it needs to do. Or at least whatever string is including that variable for the image output is getting URLENCODED too soon. Again, I don't know where this is happening, but I'm trying to figure it out.

UPDATE
-------

Ok, I found the exact cause now, it's my custom theme. It has a custom variable called {IF} (Images Folder) which translates to "%7BIF%7D" when it's URLDECODED. So somewhere within this mod I'd guess that it needs to check/process the replacement variables when building the images folder variable ($stylevar['imgdir_misc']). I have no idea where that might be or how to do it though.

------------
Ok, I found what the problem is, just not a solution yet.

I searched this thread and found one other person with the problem, although no solution was posted.

The problem is, somewhere the text "%7BIF%7D" is getting inserted into the image URL paths. I've done some searches and cannot find this text anywhere.




I"m having this exact same issue..how would i go about fixing this.

Ranger187 02-27-2009 04:44 AM

Me of all people should know, but VBDev or whomever, is there a resizer so if images are posted, it restricts them to a certain size (settable by usergroup) or whatever?


All times are GMT. The time now is 12:32 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.09156 seconds
  • Memory Usage 1,794KB
  • 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
  • (3)bbcode_code_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (6)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