[SOLVED]Unable to Add Product after Upgrade (1.0.0.8 - 1.1)[SOLVED]

[Dirty Bill]

The message received is:

There is 1 error :

1. you already have the maximum quantity available for this product



Quantity is set to 9999 on each product, no attributes or features at all, nothing to override the in-stock quantity. Every product throws this error. Unsure where to look, or what do to here. Any ideas?

Thx.

[Dirty Bill]

"customizationFields is not defined"...

[Dirty Bill]

I'm surprised that more people don't know something about this cart. Many questions, few answers, closed wiki...Opensource, or Commercial, software has to work, particularly if you intend to foster the kind of trust you need to be the leader. My 2 francs worth.

I solved this problem:

1) Restore the database to the pre-upgrade version (1.0.0.8)
2) Open a MySQL Client with Admin rights to the DB, open the update sql files here for execution.
3) 1 at a time, open the files in the following folder: ...\Desktop\prestashop\install\sql\upgrade (the 1.1zip file was opened to the desktop)
- open the files in order beginning with the one just after your install (1.0.0.8 in my case).
4) my first file was 1.1.0.1.sql.
5) add "use ;" at the top of the file.
6) search and replace "PREFIX" with whatever you used for a table prefix; the default is "ps".
7) execute the file.
8) repeat with 1.1.0.2.sql, 1.1.0.3.sql, 1.1.0.4.sql and finally 1.1.0.5.sql. Your files will vary based on which version you are upgrading from.
9) Go into the BackOffice and then open and save each configuration page on the Preferences Tab. I had to reselect the language for the site, re-assign a default carrier, and re-save the main preferences page before it worked.

I'm sure there is probably a better way to handle this, but this is what I did. It also managed to solve several other odd problems and slowdowns.

Now if I could get some help solving the dumbass PDF conversion problem; for the png files that are (forced to be) saved as jpgs in the system.

[zusu]

Hi.

I had this same problem with adding products to cart (msg: you already have the maximum quantity available for this product ).
Check your table cart_product. I hadn't field date_add. I missing add this as datetime format. Should help. Helped in my case.

zusu