Acajoom Installation Error Fix
Was upgrading Acajoom GPL 3.2.7 to Acajoom 5.2.0 and encountered the following errors.
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.
---
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.
JInstaller::install: SQL Error. DB function failed with error number 1064After checking the SQL codes, I realize theres syntax error when running the TYPE=MyISAM against the database.
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;
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.
- Extract the installer (acajoomnews5.2.0.zip).
- Open "1.5.acajoom.xml" and "acajoom.xml".
- Remove all occurrences of "TYPE=MyISAM".
- Re-zip the files.
- 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.
- Just reset the mentioned files/folders ownership and chmod to 777.
- Then run the installers provided in the documentation, again.
- (Repeat step 1 again is theres error meesage.)
Hope that helps those who are new to this. :)
It has to do with the MySQL version. The newer version now uses the syntax ENGINE=MyISAM instead.
ReplyDeletehttp://dev.mysql.com/doc/refman/5.0/en/myisam-storage-engine.html
https://archive.storycorps.org/interviews/get-success-with-real-oracle-1z0-1080-20-exam-dumps-2020/
ReplyDeletehttps://dumpsexpert.lighthouseapp.com/projects/144771-actual-hp-hpe6-a77-dumps-pdf-2020/tickets/1-verified-hpe6-a77-exam-questions
http://groupspaces.com/exambraindumps/pages/new-updated-citrix-1y0-312-dumps-pdf-citrix-1y0-312-exam-questions
https://www.musicglue.com/dumpsexpert/posts/real-huawei-h13-321-2020-pdf-dumps-samples-for-free
https://www.musicglue.com/dumpsexpert/posts/amazon-web-services-saa-c02-real-pdf-dumps-2020
https://www.musicglue.com/dumpsexpert/posts/get-2020-exam-questions-for-ncp-510-exam
https://padlet.com/QuestionsPDF/AMAZON
https://works.bepress.com/examdumps/1/
http://jurnal.unswagati.ac.id/index.php/Perspective/comment/view/1561/972/98890
http://icalshare.com/calendars/16270