SQL sintax error at local lamp...

Hi!

Im having problems when accesing a document (at the frontend) that is using a MaxiGallery call... and it happens only at local, it works great when I use it in my hosting (Im ussing the same db prefix, usernames, passwords, for both sides)

I have found this at the readme fisrt post:
http://modxcms.com/forums/index.php/topic,33063.0.html

But I have not that kind of hyppen, (but a _)

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 `farbedsg_modxfd`.modxfd_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 ;

Any idea how to solve this issue?
Why is happening this?


modx evo 1.0.5
MaxiGallery 0.5.2
php 5.3.5
mysql 5.0.7

No idea?

I have this error too:

PHP error debug
Error: Function split() is deprecated
Error type/ Nr.: - 8192
File: /home/username/http/farbedesign/html/assets/snippets/maxigallery/maxigallery.class.inc.php
Line: 242
Line 242 source: $sizes = split(’x’, $max_thumb_size);

Probably the database doesn’t like the "TYPE=MyISAM" directive; the new directive is "ENGINE=MyISAM".

Newer versions of PHP have deprecated the split() function; explode() should be used instead.
http://modxcms.com/forums/index.php/topic,42308.msg253968.html#msg253968

That solved my problem... i was not able to install maxigallery! Thanks!

I am having the same problem. Where/how can I change the "TYPE=MyISAM" directive to "ENGINE=MyISAM" ? Thanks!


Ah, silly me. Got it! It's in that same php file. Changed it and all working now [ed. note: intandem last edited this post 11 years ago.]