Can someone please help me with this. I have contacted the author of the program and he says it's a overwrite issue?




Database error in vBulletin 4.1.5:

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 : Saturday, August 13th 2011 @ 04:26:42 AM
Error Date : Saturday, August 13th 2011 @ 04:26:51 AM
Script : Log in - Extreme SMX - vBulletin Admin Control Panel
Referrer : Log in - Extreme SMX - vBulletin Admin Control Panel
IP Address :
Username :
Classname : vB_Database
MySQL Version : 5.1.52

can you go to your mysql database and run the following query

I will try and let you know. Thanks for the help.

http://i142.photobucket.com/albums/r...ee1006/php.jpg

Ran XML script afterwards....


Same error.

File I am trying to run on my vBulletin Forum: http://www.megaupload.com/?d=ORZYW9BU

Let me know if you need the files I have to upload to my db.

This is what I am trying to do: http://www.vbulletin.org/forum/showt...hlight=chatbox

i can't see any of the table's columns

the SHOW CREATE TABLE command will dump the entire table layout

i wanted to see the columns

don't take a screenshot of the phpmyadmin page, but instead, please copy/paste the entire CREATE TABLE statement

dbtech_vbshout_instance CREATE TABLE `dbtech_vbshout_instance` (
`instanceid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
`description` mediumtext COLLATE utf8_unicode_ci,
`active` tinyint(1) unsigned NOT NULL DEFAULT '0',
`autodisplay` tinyint(1) unsigned NOT NULL DEFAULT '0',
`permissions` mediumtext COLLATE utf8_unicode_ci,
`sticky` mediumtext COLLATE utf8_unicode_ci,
`shoutsound` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`invitesound` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`pmsound` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`bbcodepermissions` mediumtext COLLATE utf8_unicode_ci,
`notices` mediumtext COLLATE utf8_unicode_ci,
`sticky_raw` mediumtext COLLATE utf8_unicode_ci,
`varname` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`options` mediumtext COLLATE utf8_unicode_ci,
`forumids` mediumtext COLLATE utf8_unicode_ci,
PRIMARY KEY (`instanceid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci

did you notice anything while preparing that copy/paste?

your table does not contain a column called deployment

therefore you need to go back to wherever you got that INSERT statement from and correct it

Thank you for the help.

Where would I find the INSERT statement?

I didn't notice anything. What should look for? Do you want the entire upload files to look at?

225

#1064 - 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 '' at line 1


http://dev.mysql.com/doc/refman/5.1/en/insert.html

i have no idea, sorry

i would search your script source code for the first part of the insert statement...

INSERT INTO `dbtech_vbshout_instance`
(`name`, `description`, `active`, `autodisplay`, `deployment`, `templates`, `permissions`)
VALUES