We launched new forums in March 2019—join us there. In a hurry for help with your website? Get Help Now!
    • 18961 ☆ A M B ☆
    • 237 Posts
    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
      Michael Smull
      http://www.bigpixelstudio.com
      twitter: @mdsdesign