Status
Not open for further replies.

Mofo Jacx

New member
Hi there, Im am trying to install your chat. I chose to install the lite version so i can evaluate before purchase.

However during install im getting a fail.

This is what i see

[:]

Created Table: dbtech_vbshout_ignorelist
Created Table: dbtech_vbshout_log
Created Table: dbtech_vbshout_shout
Altered Table: administrator
Altered Table: forum
Altered Table: user
Altered Table: usergroup
Populated Table: datastore
Populated Table: dbtech_vbshout_shout

Updating Version Number To: 4.0.0

Created Table: dbtech_vbshout_command
Created Table: dbtech_vbshout_deeplog
Altered Table: user
Created Table: dbtech_vbshout_chatroom
Created Table: dbtech_vbshout_chatroommember
Created Table: dbtech_vbshout_instance
Altered Table: dbtech_vbshout_shout

Database error in vBulletin 4.1.7:

Invalid SQL:

INSERT INTO `dbtech_vbshout_instance`
(`name`, `description`, `active`, `autodisplay`, `deployment`, `templates`, `permissions`)
VALUES (
'Shoutbox',
'This is the default Shoutbox.
You can change this description by clicking [Edit].',
1,
1,
'index',
'',
'a:8:{i:2;i:2108;i:6;i:4092;i:4;i:12;i:8;i:0;i:7;i:3964;i:5;i:4092;i:1;i:4;i:3;i:12;}'
);

MySQL Error : Unknown column 'deployment' in 'field list'
Error Number : 1054
Request Date : Friday, October 7th 2011 @ 08:02:42 PM
Error Date : Friday, October 7th 2011 @ 08:02:54 PM
Script : Log in - Clipwire Games Forum - vBulletin Admin Control Panel
Referrer : Log in - Clipwire Games Forum - vBulletin Admin Control Panel
IP Address : 216.139.102.249
Username : Jacx
Classname : vB_Database
MySQL Version : 5.0.45


any suggestions?
 
Try the install script again, it looks like your MySQL failed to create a column.
 
Run this
Code:
DROP TABLE dbtech_vbshout_instance

Then try it again. If it still fails, keep it on the page then run the above and also this:
Code:
    CREATE TABLE `dbtech_vbshout_instance` (
      `instanceid` INT( 10 ) UNSIGNED NOT NULL AUTO_INCREMENT ,
      `name` VARCHAR( 50 ) NOT NULL ,
      `description` MEDIUMTEXT NULL DEFAULT NULL ,
      `active` TINYINT( 1 ) UNSIGNED NOT NULL ,
      `autodisplay` TINYINT( 1 ) UNSIGNED NOT NULL ,
      `deployment` MEDIUMTEXT NULL DEFAULT NULL ,
      `templates` MEDIUMTEXT NULL DEFAULT NULL ,
      `permissions` MEDIUMTEXT NULL DEFAULT NULL ,
      PRIMARY KEY (`instanceid`)
    )
 
I have database error

I did install , then tried to fix usergroups permissions > then update

I got database error as following:
=========
Database error in vBulletin 4.1.11:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'أرافيلى جديد',
`description` = 'مباشرة بعد التسجيل',
`usertitle` = 'أرافيلى جديد',
`opentag` = '',
`closetag` = '',
`passwordexpires` = '0',
`passwordhistory` = '0',
`idealchatpermissions` = '0',
`forumpermissions` = '1782015',
`genericpermissions` = '1378628291',
`attachlimit` = '0',
`pmquota` = '20',
`pmpermissions` = '1',
`pmsendmax` = '2',
`pmthrottlequantity` = '0',
`calendarpermissions` = '1',
`wolpermissions` = '1',
`adminpermissions` = '0',
`genericpermissions2` = '1',
`genericoptions` = '54',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '80',
`avatarmaxheight` = '80',
`avatarmaxsize` = '20000',
`signaturepermissions` = '400383',
`sigpicmaxwidth` = '300',
`sigpicmaxheight` = '80',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '1000',
`sigmaxchars` = '500',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '6',
`sigmaximages` = '4',
`sigmaxvideos` = '1',
`albumpermissions` = '207',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '159',
`visitormessagepermissions` = '55',
`socialgrouppermissions` = '251765',
`maximumsocialgroups` = '1',
`groupiconmaxsize` = '65535',
`mgc_cb_evo_permissions` = '0',
`mgc_cb_evo_refreshrate` = '30',
`mgc_cb_evo_nbmsg_show` = '',
`mgc_cb_evo_nbmsg_perday_show` = '',
`mgc_cb_evo_nbthreads_perday_show` = '0',
`mgc_cb_evo_max_chats_perday` = '0',
`ms_vopt_permissions` = '0'
WHERE usergroupid=2;

MySQL Error : Unknown column 'mgc_cb_evo_nbmsg_show' in 'field list'
Error Number : 1054
Request Date : Monday, April 2nd 2012 @ 09:14:52 AM
Error Date : Monday, April 2nd 2012 @ 09:14:52 AM
Script : Log in - ARAPHIL - vBulletin Admin Control Panel
Referrer : Log in - ARAPHIL - vBulletin Admin Control Panel
IP Address : 180.190.31.192
Username : dr.helal
Classname : vB_Database
MySQL Version : 5.5.19-55


============
I uninstalled (removed) the product , still getting the same message when trying to update any user group

Thank you in advance for your help

 
Last edited:
That is caused by a broken MGC Chatbox Evo install. Please request help from the author of that mod :)
 
Status
Not open for further replies.

Legacy vBShout

vBulletin 3.8.x vBulletin 4.x.x
Seller
DragonByte Technologies
Release date
Last update
Total downloads
3,167
Customer rating
5.00 star(s) 1 ratings
Back
Top