SQL error on install 1.5.0.15

[tdr170]

I downloaded the svn version of Prestashop 1.5.0.15 to make sure I had the latest files for testing and can not install, I get the following error at 13% if demo products installed and at 15% in not.

 

SQL error on query 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 'KEY `id_feature_value` (`id_product`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8' at line 7

 

I had 1.5.0.13 installed in this same location and deleted all files and droped all database tables all checks are green and database connects without issues.

 

Anyone else with this issue.

[tdr170]

This was reported to the forge and this morning I received a message from Damien that there was an issue (missing comma) and that the issue has been resolved.

 

http://forge.prestashop.com/browse/PSCFV-3649

 

Damien METZGER added a comment - 17/Aug/12 9:07 AM

 

Sorry, there was a missing comma in the installer. Fixed!

[tdr170]

OK so they fixed the issue above but there are new ones, now the install won't even start do to a syntax error. (see below)

However I was able to get the install to go forward and install by changing the line in question.

I make no guarantee that this is 100% correct way to fix I only know that it worked.

 

 

 

Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING in /hermes/bosweb/web066/b667/ipg.mydomain/shop15/install/models/database.php on line 64

 

(changed this)

64 -------- $dbtype = ' ('.Db::getClass()')';

(to this)

64 ------- $dbtype = ' ('.Db::getClass().')';

 

 

The next issue I have found is under Tax rules, when you click edit a state to add a tax rule you can pick a country but not the state, I don't remember tis in the prvious 1.5 version. (see pick)

 

 

 

Edited August 18, 2012 by tdr170 (see edit history)