EasyPopulate 4.0 Support Thread

To be honest I have no idea the reason the test site does not work, I also on the test site can not save when I edit a product I get the following error:
05-Dec-2015 20:37:10 America/New_York] PHP Fatal error: 1366:Incorrect integer value: '' for column 'nestable' at row 1
/functions/database.php on line 53 <== in /var/www/zencart/includes/classes/db/mysql/query_factory.php on line 155

PHP version on test site is: 5.6.12-1 and Database: MySQL 5.6.26

PHP version on main site is: 5.6.11-1 and Database: MySQL 5.6.25

Hope that helps, if I figure it out I will post back more info.

and both sites have same version of EP4

Quote:

---

Originally Posted by marcopolo

and both sites have same version of EP4

---

Which is?

Quote:

---

Originally Posted by mc12345678

Which is?

---

Sorry :frusty: EasyPopulate-4.0-master - in changlog last entry is: 4.0.28 01-03-2015

Quote:

---

Originally Posted by marcopolo

Sorry :frusty: EasyPopulate-4.0-master - in changlog last entry is: 4.0.28 01-03-2015

---

Saw'right. I would say that a few things are likely now discovered. PHP 5.6.26 is the cutoff for the change in how dates are processed/stored, and that it is advisable to update EP4 to take advantage of the improved code/compatibility. It's not entirely difficult: note the settings in the admin->configuration section, from the tools area select the remove link, upload the new files, select the install at the top, repopulate the settings (and new ones otherwise would just upload and keep on going).

Otherwise, the other error doesn't appear to be related to EP4, but I say that because of the "odd" column referenced... It could be something else... Suggest trrying to reproduce the error but with lat9's mydebug backtrace installed...

I figured out why the test site failed! I had to edit my MYSQL my.cnf and comment out the following line:

#sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

restart mysql

then the import worked just fine.

Quote:

---

Originally Posted by marcopolo

I figured out why the test site failed! I had to edit my MYSQL my.cnf and comment out the following line:

#sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

restart mysql

then the import worked just fine.

---

Two questions to confirm/understand, which issue(s) were corrected by the mysql change, and was EP4 upgraded as part of the process?

Quote:

---

Originally Posted by mc12345678

Two questions to confirm/understand, which issue(s) were corrected by the mysql change, and was EP4 upgraded as part of the process?

---

I upgraded to latest version of EP4 first, which did NOT solve the issue. I then applied the fix mentioned above and that fixed both issues.

Quote:

---

Originally Posted by marcopolo

I upgraded to latest version of EP4 first, which did NOT solve the issue. I then applied the fix mentioned above and that fixed both issues.

---

Again need specificity, by latest, which version?