Msql folder can't locate

New Member Joined: Jul 11, 2016 Posts: 14

Trying to add, Nuke Treasury v1.1.

I cant find the Msql Folder

MySQL Version 5.5.36-cll

Operating System linux

Site Admin Joined: Jun 04, 2004 Posts: 6433

Hello,

There is a separate config for the database in the module folder. The idea is that you might wish to keep the treasury tables in a separate database.

Check the config settings in modules/Donations/config.php and / or modules/Donations/config.inc.php to see if they are correct.

Posted: Wed Jul 20, 2016 12:22 pm

when unzipping the zip file, inside have an html folder and sql folder. Where do I place nuke treasury.sgl?. Because the install instruction says to drop it into the msql folder.

Please help

Posted: Wed Jul 20, 2016 12:29 pm

The treasury.SQL is a text file with commands to load the tables necessary for nuke Treasury.

Open your site's control panel
Then open phpMyAdmin
Select your nuke DB.
Click the SQL tab or the Import tab.
If you use SQL, open the SQL file and copy and paste the commands into a SQL window in phpMyAdmin and click Go.
If you use Import, choose the SQL file and click Go.

After that, make sure the config file in your modules/Donations folder has the same database configuration as your root/config.php file.

Posted: Thu Jul 21, 2016 4:12 am

Did as you said get this error:#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'TYPE=MyISAM' at line 23

Posted: Thu Jul 21, 2016 7:37 am

Change all instances of TYPE=MyISAM to ENGINE=MyISAM

Posted: Thu Jul 21, 2016 12:23 pm

thx work 100%.