Acajoom Installation Error Fix

Was upgrading Acajoom GPL 3.2.7 to Acajoom 5.2.0 and encountered the following 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 35 SQL=CREATE TABLE IF NOT EXISTS `z1ck_acajoom_lists` ( `id` int(10) NOT NULL auto_increment, `list_name` varchar(101) NOT NULL default '', `list_desc` text NOT NULL, `list_type` tinyint(2) NOT NULL default '0', `sendername` varchar(64) NOT NULL default '', `senderemail` varchar(64) NOT NULL default '', `bounceadres` varchar(64) NOT NULL default '', `layout` text NOT NULL, `template` int(9) NOT NULL default '0', `subscribemessage` text NOT NULL, `unsubscribemessage` text NOT NULL, `unsubscribesend` tinyint(1) NOT NULL default '1', `auto_add` tinyint(1) NOT NULL default '0', `user_choose` tinyint(1) NOT NULL default '0', `cat_id` int(10) NOT NULL default '0', `delay_min` int(2) NOT NULL default '0', `delay_max` int(2) NOT NULL default '7', `follow_up` int(10) NOT NULL default '0', `html` tinyint(1) NOT NULL default '1', `hidden` tinyint(1) NOT NULL default '0', `published` tinyint(1) NOT NULL default '0', `createdate` datetime NOT NULL default '0000-00-00 00:00:00', `acc_level` int(2) NOT NULL default '0', `acc_id` int(11) NOT NULL default '29', `notification` tinyint(1) NOT NULL default '0', `owner` int(11) NOT NULL default '0', `footer` tinyint(1) NOT NULL default '1', `notify_id` int(10) NOT NULL default '0', `next_date` int(11) NOT NULL default 0, `start_date` DATE NOT NULL, `params` text , PRIMARY KEY (`id`), UNIQUE KEY `list_name` (`list_name`) ) TYPE=MyISAM;
After checking the SQL codes, I realize theres syntax error when running the TYPE=MyISAM against the database.

A quick-fix to this of course is to remove all the lines that contains that code fragment.

Heres a simple step-by-step on how and where to remove.
  1. Extract the installer (acajoomnews5.2.0.zip).
  2. Open "1.5.acajoom.xml" and "acajoom.xml".
  3. Remove all occurrences of "TYPE=MyISAM".
  4. Re-zip the files.
  5. Install as per normal in Joomla 1.5.
For those lazy bumps out there, heres the fixed installer


---

Side-note: After installing the extension, I got these error messages.


Of course, if you look care fully (and read the documentation link provided). Its actually just folder permission issues.

  1. Just reset the mentioned files/folders ownership and chmod to 777.
  2. Then run the installers provided in the documentation, again.
  3. (Repeat step 1 again is theres error meesage.)

Hope that helps those who are new to this. :)



Comments

  1. It has to do with the MySQL version. The newer version now uses the syntax ENGINE=MyISAM instead.
    http://dev.mysql.com/doc/refman/5.0/en/myisam-storage-engine.html

    ReplyDelete

Post a Comment

Popular posts from this blog

225019099301.apps.googleusercontent.com

Backup MySQL to Azure Storage in 30 Seconds

Generate GoDaddy SSL Certificate (.crt) for Azure Websites (.pfx)