Good Afternoon,

I can't seem to ever get the updatestore.php to work for me when I have tried switching over to the css version. I have tried updating https://steinbrink.com to the css/js version and it won't finish the updater. None of the products are displayed. Both lines of script (below) have been added to my header.php file in the themes folder. After running the updater it finishes with the following errors. You helped me with this on another site, and you mentioned "It seems that column, pDateAdded had NULL values and that combined with mySQL database settings which don't allow NULL date values caused an error, so I just added defaults for the NULL values."

I have sent you ftp credentials to vince AT ecommercetemplates DOT com, if it's not too much trouble will you take a look at this for me?

Checking for pCustomCSS in table products

Adding pMinQuant column to products table.
Adding pPopularity column to products table.
Adding pNumSales column to products table.
Adding pUpload column to products table.
Adding pCustomCSS column to products table.
Terminated but with errors
Incorrect date value: '0000-00-00' for column 'pDateAdded' at row 1
Unknown column 'pMinQuant' in 'field list'
Incorrect date value: '0000-00-00' for column 'pDateAdded' at row 1
Unknown column 'pPopularity' in 'field list'
Incorrect date value: '0000-00-00' for column 'pDateAdded' at row 1
Unknown column 'pNumSales' in 'field list'
Incorrect date value: '0000-00-00' for column 'pDateAdded' at row 1
Incorrect date value: '0000-00-00' for column 'pDateAdded' at row 1
Unknown column 'pUpload' in 'field list'
Incorrect date value: '0000-00-00' for column 'pDateAdded' at row 1
Unknown column 'pCustomCSS' in 'field list'
Unknown column 'pCustomCSS' in 'products'
Incorrect date value: '0000-00-00' for column 'pDateAdded' at row 1
Key column 'pNumSales' doesn't exist in table
Key column 'pPopularity' doesn't exist in table
Incorrect date value: '0000-00-00' for column 'pDateAdded' at row 1
Incorrect date value: '0000-00-00' for column 'pDateAdded' at row 1

re:
<link rel="stylesheet" type="text/css" href="/css/ectcart.css"/>
<script type="text/javascript" src="/js/ectcart.js"></script>

Scott McLaughlin
President
Heartland Hosting, LLC


Scott McLaughlin
President
Heartland Hosting, LLC

Hi Scott
Sorry for the problems there but it seems that there were invalid date values in the database which stopped the new columns being added. I've added a check to replace these invalid values with valid ones so the updater has run ok now and I've added the check to the updaters here so you won't get the same problem in the future. Your site should be ok now.

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater

Thank you so much, Vince. I cringe a bit when I need to update.

Scott McLaughlin
President
Heartland Hosting, LLC

quote:

---

I cringe a bit when I need to update.

---

Sorry to hear that Scott, and it shouldn't be the case. Normally running an updater is a case of copying the files and running the script but if you like in the future, send me an email beforehand and we can arrange a time that I'm around just in case anything should go wrong. But I'm pretty sure it will all go smoothly from now on anyway.

Vince

Click Here for Shopping Cart Software
Click Here to sign up for our newsletter
Click Here for the latest updater