SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast
    Join Date
    Dec 2006
    Posts
    88
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    MySQL new version error

    Everything was fine until the hosting company upgraded MySQL to 5.5.21 version.

    I don't wat's wrong with this query in 5.5.21 version?
    Code MySQL:
    Code MySQL:
    CREATE TABLE #__hp_temp (
     id INT(11) NOT NULL, 
    type MEDIUMTEXT NOT NULL, 
    suburb MEDIUMTEXT NOT NULL, 
    price MEDIUMTEXT NOT NULL, 
    pov MEDIUMTEXT NOT NULL, 
    sead MEDIUMTEXT NOT NULL, 
    more SET('more') NOT NULL, 
    PRIMARY KEY  (id)
    ) TYPE=MyISAM ;


    I'm getting error
    Code MySQL:
    Code MySQL:
    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 \'TYPE=MyISAM\' at line 10 SQL=CREATE TABLE jos_hp_temp (\n id INT(11) NOT NULL, \ntype MEDIUMTEXT NOT NULL, \nsuburb MEDIUMTEXT NOT NULL, \nprice MEDIUMTEXT NOT NULL, \npov MEDIUMTEXT NOT NULL, \nsead MEDIUMTEXT NOT NULL, \nmore SET(\'more\') NOT NULL, \nPRIMARY KEY (id)\n) TYPE=MyISAM ;

    Any idea?

    Thanks.

  2. #2
    SitePoint Wizard bronze trophy chris.upjohn's Avatar
    Join Date
    Apr 2010
    Location
    Melbourne, AU
    Posts
    2,196
    Mentioned
    17 Post(s)
    Tagged
    1 Thread(s)
    The reason your getting an error is because TYPE is now deprecated, instead you need to ENGINE which is now the default standard for creating tables and works all the way back to MySQL 4.


Tags for this Thread

Bookmarks

Posting Permissions

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