[ic] Troubleshooting MySQL table import errors

[Peter]

On 03/09/05 13:37, Peter N. wrote:
> - - - [25/February/2005:10:40:13 -0500] - - table 'products' failed: 
> products import failed: 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 ' '', '', '', '', 'F1015-210-small-1.jpg', 
> 'F1015-210-large-1.jp

> | price         | decimal(12,2) |      | MUL | 0.00    |       |

You have price set as type decimal.  This is just a guess, but I think 
that mysql doesn't have an implicit conversion for a number type 
(decimal, float, integer, etc) from an empty string ('').  The easiest 
fix would be to just change that to type varchar(20) or something.

Peter