Just noticed that zen-cart 1.3.8 was released. i didn’t have time to look into the changes too deep, but I tried a *simple* upgrade of my local development system.

What I did in particular was:

1. Copy all files on top of my zen-cart installation, effectively deleting all mod changes
2. Ran the database upgrade
   This failed the first time with SQL error updating the query_builder table, since query_keys_list didn’t allow NULL.
3. Changed the database to allow NULL for column query_keys_list
4. Ran the database upgrade again (succeeded, but with two ignored statements that I didn’t check)
5. Logged in into admin
6. Reapplied all ZenMagick file patches
7. Done!

So far everything seems to work still fine. I’ll try to write more later once I had a chance to look into all the details of the changes