Bug DB error on install

[Robp57]

I am setting up the shout on a brand new forum and when I go to upload the xml, Im getting a DB error before it finishes...

Database error in vBulletin 4.2.0:

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, February 15th 2013 @ 09:07:13 AM
Error Date : Friday, February 15th 2013 @ 09:07:22 AM
Script : http://www.URL/admincp/plugin.php?do=productimport
Referrer : http://www.URL/admincp/plugin.php?do=productadd
IP Address :

 

[Fillip H.]

Please re-download and re-upload the files for the mod, I've hotfixed the installer files to no longer attempt to use that field.

This only happens on installations that were aborted for some other reason

 

[Robp57]

Nope...still stops at the same place.....


Updating Version Number To: 4.5.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 Database error

 

[Fillip H.]

Please open /dbtech/vbshout/install/450.php and change lines 97-108 to the following:

self::$db->query_write("
INSERT INTO `" . TABLE_PREFIX . "dbtech_vbshout_instance`
	(`name`, `description`, `active`, `autodisplay`, `templates`, `permissions`)
VALUES (
	'Shoutbox',
	'This is the default Shoutbox.\r\nYou can change this description by clicking [Edit].',
	1,
	" . (isset($vbulletin->options['dbtech_vbshout_autoadd']) ? $vbulletin->options['dbtech_vbshout_autoadd'] : 1) . ",
	'" . (isset($vbulletin->options['dbtech_vbshout_includetemplates']) ? $vbulletin->options['dbtech_vbshout_includetemplates'] : '') . "',
	'" . self::$db->escape_string(trim(serialize($permarray))) . "'
)");
self::report('Updated Instance', '1');

Then run the installation again

 

[Robp57]

Same issue......

 

[Fillip H.]

It's quite impossible that you get the same database error as reported in the OP if you edited that file on your server. Can you please double-check your edits?

 

[Robp57]

self::$db->query_write("
INSERT INTO `" . TABLE_PREFIX . "dbtech_vbshout_instance`
(`name`, `description`, `active`, `autodisplay`, `templates`, `permissions`)
VALUES (
'Shoutbox',
'This is the default Shoutbox.\r\nYou can change this description by clicking [Edit].',
1,
" . (isset($vbulletin->options['dbtech_vbshout_autoadd']) ? $vbulletin->options['dbtech_vbshout_autoadd'] : 1) . ",
'" . (isset($vbulletin->options['dbtech_vbshout_includetemplates']) ? $vbulletin->options['dbtech_vbshout_includetemplates'] : '') . "',
'" . self::$db->escape_string(trim(serialize($permarray))) . "'
)");
self::report('Updated Instance', '1');

 

[Fillip H.]

If you provide me with an FTP account I'll upload the fixed file on your server

 

[Robp57]

PM sent

 

[Fillip H.]

I've uploaded the new installation files.

If the issue persists, please also PM me with an AdminCP account so that I can investigate this myself.

 

[Fillip H.]

Update: The issue was not the same issue - the error message had changed. I added a fix for the new error message and the product now imported successfully

 

[Robp57]

You are the man.....Thanx for all your help...........:RpS_thumbsup: