[Done 2.0.0] ALTER IGNORE TABLE not handled in executeSQL function in sqlpatch.php

[hem]

ZenCart Version 1.3.8. The following line fails:

ALTER IGNORE TABLE `test_table` ADD `test_field` INT( 11) NOT NULL DEFAULT '0';

sqlpatch.php responds:

1146 Table 'zencart.test_table' doesn't exist
in:
[ALTER IGNORE TABLE test_table ADD test_field INT(11) NOT NULL DEFAULT '0';]

This is because I use a prefix for my tables which is not added by the executeSQL function because ALTER IGNORE TABLE is not handled.

[yellow1912]

In the mean time, I suggest taking a look at this:

http://code.google.com/p/zencart-mod.../source/browse

sql_patch is put into a class here:
http://code.google.com/p/zencart-mod...atch_class.php
You can improve it by adding your own code to handle this situation.

[hem]

Interesting- Is that an official ZenCart development enviroment???

[yellow1912]

No.
http://www.zen-cart.com/forum/showth...ight=installer