[VBDev]

Originally Posted by angeljs

Here is the error I received in the emails:

Database error in vBulletin 4.0.2:

Invalid SQL:

SELECT  administrator.*, 
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_cphome AS phrasegroup_cphome,
language.phrasegroup_cpglobal AS phrasegroup_cpglobal,
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 administrator AS administrator ON (administrator.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 = 2;

MySQL Error   : Unknown column 'mgcugp.mgc_cb_evo_default_color' in 'field list'
Error Number  : 1054
Request Date  : Tuesday, May 25th 2010 @ 07:18:01 AM
Error Date    : Tuesday, May 25th 2010 @ 07:18:01 AM
Script        : http://simfansuk.com/forums/admincp/index.php?loc=plugin.php%3Fdo%3Dproduct
Referrer      : http://simfansuk.com/forums/admincp/plugin.php?do=productenable&productid=mgc_cb_evo&s=
IP Address    : 90.200.25.157
Username      : 
Classname     : vB_Database
MySQL Version :

Really appreciate you taking the time with this

Seems like the usergroup table wasn't modified to add the mgc_cb_evo_default_color field.
Did you get any error when installing the chatbox ?

I would recommand you to uninstall the product and import it again.

Originally Posted by tafreeh

It may sound stupid.. but how do you banned someone other than use commands ?

and how do u use those commands anyways.. Sorry ppl I never use IRC before...

Thanks

You have the possibility to ban someone from a link in the menu near the chats or use the /ban command.

Its syntax is explained in the chatbox help (? icon in the chatbox).

Originally Posted by Halfhidden

@ VBDev.
I've closed down the test account you asked me to set up. I can see you are very busy with database errors and such like.. so I'll try and figure it out myself.
Thanks anyway.

Well you only activated it during 24H, so don't expect me to be that fast.
I do vB as hobby and I have a life

Originally Posted by Bano Host

I like it but it hard to install ,

why not all files need to upload in one directory to make it easy to removed?

and , we hope the install only to upload files and product so langauge

not to edit any template

please fix this and important one to let all files in one directory

thanks any way

There is multiples locations for files upload because some are using the vB standards :

• cpnav and permissions xml files goes in includes/xml so that vB automatically recognize it
• Data manager class goes in includes because this is where vB searches them when you instantiate one
• Admin files goes in admincp directory for structure keeping
• Cron php file could indeed be moved to another directory, I'll perhaps consider that
• Perhaps mgc_cb_evo.php and mgc_cb_evo_ajax.php could also be moved to mgc_cb_evo directory, I'll consider that

Regarding the language, this is for personnal reasons, I am french so I decided to make it default in french and to provide an english language file. I am sure that can be understood

Originally Posted by Saphyrus

what should i add in mgc_cb_evo.css ?

Well you should add something like :

#mgc_cb_evo_input {
   background-color : #123456;
}

Not sure if this is a '#' or a '.', I am not a master in CSS and don't have a code beyond my eyes but that should be something like that.