import_db.php error

[bhappel]

Hi,

The squirrelcart installation went fine until I tried to import the database tables. I got this error:

Importing database records.....
MySQL Error 1064 encountered on line #20: You have an error in your SQL syntax near '; ' 6
Query was: CREATE TABLE `Address_Form_Settings` ( `record_number` int(11) NOT NULL auto_increment, `Billing_Fields` text NOT NULL, `Required_Billing_Fields` text NOT NULL, `Shipping_Fields` text NOT NULL, `Required_Shipping_Fields` text NOT NULL, `Default_for_Address_Is` tinyint(4) NOT NULL default '0', `Account_Fields` text NOT NULL, `Required_Account_Fields` text NOT NULL, `Countries` text NOT NULL, `First_Country` int(11) NOT NULL default '0', `Default_Country` int(11) NOT NULL default '0', PRIMARY KEY (`record_number`) ) TYPE=MyISAM AUTO_INCREMENT=2 ;
Database import failed.

Can you tell me what the problem is and howto fix it? Can I just run the SQL statements through phpMyAdmin and skip using import_db.php?

Thanks for your help!

[pbxcom]

The way it looks is you are installing a new squirrelcart. Seeing as several people have successfully installed SquirrelCart the only two explanation I can come up with are occationally information isn't parsed incorrectly by the server and can cause those errors or the sever is configured wrong and has a problem running the import script in which case you would have to contact your web host. You could try completly restarting the SquirrelCart installation, just delete everything the files and database. This will elimnate any possibility of a file having not been uploaded properly. If it still doesn't work try downloading a new copy of squirrelcart, just in case something got messed up in the first download, and then reinstall if it still doesn't work I would definately contact your web host.

Also to answer the second part or your question, yes, just take the squirrelcart.sql file and use phpmyadmin to import that file.

[bhappel]

Thanks for your reply. I imported the squirrelcart.sql file into phpmyadmin and it worked great. The database structure is set up and the store seems to be working fine. Thanks again.