I'm trying to install the MaxiGallery and I get this error:
« MODx Parse Error »
MODx encountered the following error while attempting to parse the requested resource:
« Execution of a query to the database failed - 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 AUTO_INCREMENT=1' at line 12 »
SQL: CREATE TABLE `modxevo`.modx_maxigallery ( `id` int(10) unsigned NOT NULL auto_increment, `gal_id` int(10) unsigned NOT NULL, `filename` tinytext NOT NULL, `title` text NOT NULL, `date` datetime NOT NULL, `descr` text default NULL, `pos` int(10) default NULL, `own_id` int(10) default NULL, `hide` int(1) default 0, PRIMARY KEY (`id`) ) TYPE=MyISAM AUTO_INCREMENT=1 ;
looks like you'l have to modify the assets/snippets/maxigallery/maxigallery.class.inc.php
modify line 54, from this:
) TYPE=MyISAM AUTO_INCREMENT=1 ;";
to this:
) ENGINE=MyISAM AUTO_INCREMENT=1 ;";
Thank you breezer! That works!! I am very much a newbie when it comes to this so I appreciate it so much!
