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

TOPIC: [S]DTRegister 2.7.3a install errors mysql server 5.5.8

[S]DTRegister 2.7.3a install errors mysql server 5.5.8 13 years 10 months ago #12139

  • Trinners
  • Trinners's Avatar Topic Author
  • Offline
  • Fresh Boarder
  • Fresh Boarder
  • Posts: 13
  • Thank you received: 0
I thought I would pass this along hopefully it will help someone else with this issue: installing DTRegister 2.7.3a on a MySQL Server version: 5.5.8 with Joomla version 1.5.22: after uninstalling the existing 2.7.2h DTRegister component and attempting to install the latest 2.7.3a version of the component, I ran into this SQL errors:

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;

This error seems to be due to the TYPE=MyISAM as TYPE is not supported in MySQL server version 5.5.8 instead the ENGINE=MyISAM is used instead.
I unzipped the .\Joomla15x\com_dtregister2_7_3aJ15.zip file
Then using a text editor opened Joomla15x\com_dtregister2_7_3a_J15\admin\sql\install.mysql.dtregister.sql version i just unzipped
did a find/replace for TYPE=MyISAM and replaced it with ENGINE=MyISAM
then saved the file and then rezipped the files in to
com_dtregister2_7_3aJ15.zip and used the new version to install. The install errors did not occur after this change. I hope this helps some one else with this error.

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

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