Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: 2.7.4b Won't Install - SQL Error

2.7.4b Won't Install - SQL Error 13 years 8 months ago #13212

  • wbaccus
  • wbaccus's Avatar Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 20
  • Thank you received: 0
Fortunately, I was trying this on a localhost version of my site:

Uninstalled 2.7.4 and tried to install 2.7.4b under MAMP.

Got this error:

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 6 SQL=CREATE TABLE IF NOT EXISTS `jos_dtregister` ( `id` INT (7) NOT NULL AUTO_INCREMENT, `property` VARCHAR(255) DEFAULT NULL, `value` text DEFAULT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM;
SQL =
CREATE TABLE IF NOT EXISTS `jos_dtregister` (
`id` INT (7) NOT NULL AUTO_INCREMENT,
`property` VARCHAR(255) DEFAULT NULL,
`value` text DEFAULT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
Component Install: SQL error or missing or unreadable SQL file. DB function failed with error number 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 'TYPE=MyISAM' at line 6 SQL=CREATE TABLE IF NOT EXISTS `jos_dtregister` ( `id` INT (7) NOT NULL AUTO_INCREMENT, `property` VARCHAR(255) DEFAULT NULL, `value` text DEFAULT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM;
SQL =
CREATE TABLE IF NOT EXISTS `jos_dtregister` (
`id` INT (7) NOT NULL AUTO_INCREMENT,
`property` VARCHAR(255) DEFAULT NULL,
`value` text DEFAULT NULL,
PRIMARY KEY (`id`)
) TYPE=MyISAM;
Install Component Error

Please Log in or Create an account to join the conversation.

2.7.4b Won't Install - SQL Error 13 years 8 months ago #13244

  • wbaccus
  • wbaccus's Avatar Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 20
  • Thank you received: 0
Same problem on the upgrade to 2.75 on my localhost installation. SQL error.

Please advise.

Please Log in or Create an account to join the conversation.

2.7.4b Won't Install - SQL Error 13 years 8 months ago #13247

  • dthadmin
  • dthadmin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 5470
  • Thank you received: 3
No one else has reported any such issue. It has to be specific to your site / server. Need to log a support ticket.

Please Log in or Create an account to join the conversation.

  • Page:
  • 1
Time to create page: 0.106 seconds