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

TOPIC: SQL DB Function Error in upgrading/install

SQL DB Function Error in upgrading/install 13 years 2 months ago #14621

  • soundtraxx
  • soundtraxx's Avatar Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 24
  • Karma: 1
  • Thank you received: 1
My problem has become more urgent as I tried a Fresh Fresh install of J1.6 and DTRegister and got the same error. I don't know how to fix this.

JInstaller::install: SQL Error. 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;
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;

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

Last Edit: by soundtraxx.

SQL DB Function Error in upgrading/install 13 years 2 months ago #14623

  • soundtraxx
  • soundtraxx's Avatar Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 24
  • Karma: 1
  • Thank you received: 1
Looks like it's not a DTRegister only problem, has something to do with my MYSQL, I'll research and try to fix. If you have any input feel free, it might save me some time.

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

SQL DB Function Error in upgrading/install 13 years 2 months ago #14624

  • soundtraxx
  • soundtraxx's Avatar Topic Author
  • Offline
  • Junior Boarder
  • Junior Boarder
  • Posts: 24
  • Karma: 1
  • Thank you received: 1
http://www.joomfish.net/forum/viewtopic.php?f=47&t=8462

I opened up the sql file in com_dtregister. Copied it all into excel, used find & replace for TYPE= to ENGINE=. Repackaged and everything works.

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

SQL DB Function Error in upgrading/install 13 years 2 months ago #14629

  • dthadmin
  • dthadmin's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 5470
  • Thank you received: 3
Hey, thanks for your input here. The new 2.7.9 package actually has this change implemented for the sql install file, so no worries when you go to upgrade.

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

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