Hello,
While installing the JA Methys 1.7 Quickstart file to localhost, I’m receiving the following error during the database configuration step of the Joomla installer:
Some errors occurred while populating the database: 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 ‘ DROP TABLE IF EXISTS `prefix_assets`’ at line 1 SQL= DROP TABLE IF EXISTS `prefix_assets`
As a side note, I previously replaced “TYPE=MYISAM” WITH “ENGINE=MYISAM” according to another posting…..this took care of that particular problem. But now I can’t seem to get passed this syntax problem. Any thoughts?
Joomla 1.7
XAMPP 1.7.4
MySql 5.5.8
Thanks!
Manos
Moderator
Hi,
I couldn’t reproduce this issue on localhost with XAMPP 1.7.1. Can you please download again a fresh copy of JA Methys quickstart and try once more?
Regards
Manos
1 user says Thank You to Manos for this useful post
Hello Manos,
I downloaded a fresh copy but still receiving the same error message. I looked at the joomla.sql and sample_data.sql files, but I don’t know enough about MyPHP syntax to know if there is a problem.
Also, the ‘prefix_assets’ table appears to be created and populated in MyPHPAdmin, but with the error message I can’t proceed with the installation.
Any other thoughts? Thank you! …Brian
Problem solved…..I uninstalled xampp 1.7.4 and installed xampp 1.7.3. No problems with the older version.
Manos
Moderator
Hi,
I am glad your problem is sorted out! We will be glad to see your site when it’s done, you can show it here -> SOTM Competition & Member Showcase
Regards
Manos
This topic contains 5 replies, has 2 voices, and was last updated by Manos 13 years, 3 months ago.
We moved to new unified forum. Please post all new support queries in our New Forum
