After trying to update from 6.6.5 to current version I am receiving the following errors after running updatestore.php. I do have the /js and /css folders and

<link rel="stylesheet" type="text/css" href="/css/ectcart.css"/>
<script type="text/javascript" src="/js/ectcart.js"></script>
in my .php store files.

Incorrect date value: '0000-00-00' for column 'pDateAdded' at row 54
Unknown column 'pMinQuant' in 'field list'
Incorrect date value: '0000-00-00' for column 'pDateAdded' at row 54
Unknown column 'pPopularity' in 'field list'
Incorrect date value: '0000-00-00' for column 'pDateAdded' at row 54
Unknown column 'pNumSales' in 'field list'
Incorrect date value: '0000-00-00' for column 'pDateAdded' at row 54
Incorrect date value: '0000-00-00' for column 'pDateAdded' at row 54
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 54
Incorrect date value: '0000-00-00' for column 'pDateAdded' at row 54

Scott McLaughlin
President
Heartland Hosting, LLC

Hi Scott, can you try uploading updatestore.php from the updater package again to the server and browse to the file and click the button. It might be a good idea to delete any updatestore that is already on the server prior to uploading the new one.

The error indicates that the scripts are looking for these fields but they are not there in the database.

quote:

---

Unknown column 'pMinQuant' in 'field list'

---

Winners never quit, quitters never win
CSS and Responsive Designs
User Manual for Ecommerce Templates

Hi Scott,
I've seen this error with the date added error message before when I attempted to update a clients site some time ago.

What I ended up doing was downloading the product inventory as a csv from the product admin, do a sort on the Pdateadded column and adding dates in the correct format where there were no dates entered. Uploaded the csv file and then ran the updatestore.php file once more.

Doing that will sort out the problem but I'm sure Vince may step in here and send you an updated updatestore.php file that will sort out your problem.



* Database Migrations and Conversions*
* ASP to PHP Cart Conversions*
*Contact Us*
*Buy The PHP Capture Card Plugin*
*Rate Our Services/View Our Feedback*

I downloaded a new package from the php updatee, v 7.0.8_2 and uploaded it to the server. I ran the http://express-distributing.com/updatestore.php and still have a problem. This is the current error message.



Checking for devicenotifications upgrade

Adding pMinQuant column to products table.
Adding pPopularity column to products table.
Adding pNumSales column to products table.
Terminated but with errors
Incorrect date value: '0000-00-00' for column 'pDateAdded' at row 54
Unknown column 'pMinQuant' in 'field list'
Incorrect date value: '0000-00-00' for column 'pDateAdded' at row 54
Unknown column 'pPopularity' in 'field list'
Incorrect date value: '0000-00-00' for column 'pDateAdded' at row 54
Unknown column 'pNumSales' in 'field list'
Incorrect date value: '0000-00-00' for column 'pDateAdded' at row 54
Incorrect date value: '0000-00-00' for column 'pDateAdded' at row 54
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 54
Incorrect date value: '0000-00-00' for column 'pDateAdded' at row 54

Currently when I login into the /vsadmin and click on product admin >> List products

Unknown column 'pMinQuant' in 'field list'
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/expressd/public_html/vsadmin/inc/incfunctions.php on line 1806

Warning: mysql_free_result() expects parameter 1 to be resource, boolean given in /home/expressd/public_html/vsadmin/inc/incfunctions.php on line 1812

Products.php is displaying the following error

Unknown column 'pPopularity' in 'field list'
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/expressd/public_html/vsadmin/inc/incfunctions.php on line 1806

Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/expressd/public_html/vsadmin/inc/incfunctions.php on line 1806

Scott McLaughlin
President
Heartland Hosting, LLC

Hi Scott
Can you send the site FTP login to my email (vince AT ecommercetemplates DOT com) and I'll get this sorted out for you.

Vince

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

Hi Scott
I've made a couple of changes to the updatestore.php script so that has run successfully now. Can you make sure all the files are copied for the updater and all should be good.

Vince

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

THANK YOU VINCE!!

Everything looks good. What did you do differently in the updatestore.php file to get it to run? I've never had so much trouble. I've been using this cart for almost as long as it has been available.

Scott McLaughlin
President
Heartland Hosting, LLC

Hi Scott
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.

Vince

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