Results 1 to 10 of 10
  1. #1
    Join Date
    Aug 2011
    Posts
    6

    Unanswered: MySQL Error 1054 Vbulletin 4.1.5

    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

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    can you go to your mysql database and run the following query
    Code:
    SHOW CREATE TABLE dbtech_vbshout_instance
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Aug 2011
    Posts
    6
    I will try and let you know. Thanks for the help.

  4. #4
    Join Date
    Aug 2011
    Posts
    6
    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
    Last edited by 225; 08-14-11 at 02:31.

  5. #5
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    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
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  6. #6
    Join Date
    Aug 2011
    Posts
    6
    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

  7. #7
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    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
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  8. #8
    Join Date
    Aug 2011
    Posts
    6
    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

  9. #9
    Join Date
    Aug 2011
    Posts
    6
    #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

  10. #10
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Quote Originally Posted by 225 View Post
    Where would I find the INSERT statement?
    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
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •