I had to rebuild a site that got hacked badly. I deleted everything on the server and installed a brand new copy of Evo 1.0.15. All good, put back in all my TV, Templates, Chunks and the site is running great. I then installed MaxiGallery as directed using FTP. Everything is in the right place and the folders have the correct permissions. When I put the original Maxigallery call on the page, I get the error. When I put the most simple Maxigallery on the page, same thing.
Here is the call:
[!MaxiGallery? &display=`embedded` &embedtype=`slimbox` &pics_per_row=`4` &max_thumb_size=`220` &max_pic_size=`0` &thumb_use_dropshadow=`0`!]
Here is the full Error I get in Safari. Any help would be appreciated.
« 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 `ballyspring_site`.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 ;
Basic info
REQUEST_URI :
http://ballyspringinn.com/gallery
Resource : [5]Gallery
Current Snippet : MaxiGallery
Referer :
http://ballyspringinn.com/
User Agent : Mozilla/5.0 (Macintosh; Intel Mac OS X 10_10) AppleWebKit/600.1.25 (KHTML, like Gecko) Version/8.0 Safari/600.1.25
IP : 64.121.25.16
Benchmarks
MySQL : 0.0032 s (3 Requests)
PHP : 1.6846 s
Total : 1.6877 s
Memory : 2.6761093139648 mb
Backtrace
1 DocumentParser->executeParser()
index.php on line 144
2 DocumentParser->prepareResponse()
manager/includes/document.parser.class.inc.php on line 1576
3 DocumentParser->outputContent()
manager/includes/document.parser.class.inc.php on line 1678
4 DocumentParser->parseDocumentSource()
manager/includes/document.parser.class.inc.php on line 583
5 DocumentParser->evalSnippets()
manager/includes/document.parser.class.inc.php on line 1458
6 DocumentParser->_get_snip_result()
manager/includes/document.parser.class.inc.php on line 1047
7 DocumentParser->evalSnippet()
manager/includes/document.parser.class.inc.php on line 1134
8 eval()
manager/includes/document.parser.class.inc.php on line 996
9 include()
manager/includes/document.parser.class.inc.php(996) : eval()'d code on line 75
10 maxiGallery->createTable()
assets/snippets/maxigallery/maxigallery.php on line 243
11 DBAPI->query()
assets/snippets/maxigallery/maxigallery.class.inc.php on line 55