EasyPopulate 4.0 Support Thread

Glad you like it. :)

I need to modify products_ordered in the products table, I downloaded in Easy Populate 4: Complete Products (with Metatags) but that table column is not in the CSV file, is there another way for it to be download that I'm not seeing?

marcopolo:

I need to modify products_ordered in the products table, I downloaded in Easy Populate 4: Complete Products (with Metatags) but that table column is not in the CSV file, is there another way for it to be download that I'm not seeing?

While I won't leave you with the one liner that would answer this (read the instructions), but if you add the products table field(s) desired in the custom fields section of the admin-configuration then it will appear in the export and be modifiable on the import. Do not include v_ before the field name. Just the field name as it appears in the database for the (YOUR_PREFIX)products table.

That was easy, worked perfect! Thanks for quick reply and not giving me the one liner :smile:

Ok so I just tested a single line import worked fine, I figured I better try a couple lines to make sure that works and it gave me the following error:

UPDATED! - Model: 10 | 737 |
UPDATE PRODUCT FAILED! - Model: 20 - SQL error. Check Easy Populate error log in uploads directory
UPDATE PRODUCT FAILED! - Model: 30 - SQL error. Check Easy Populate error log in uploads directory

in the error log I have:

MySQLi error 1292: Incorrect datetime value: '-0001-11-30 00:00:00' for column 'products_date_available' at row 1
When executing:
UPDATE products SET
products_price = '15.1000',products_upc = '',products_ordered = '258',products_image = 'test.gif',
products_weight = '1.2',
products_discount_type = '0',
products_discount_type_from = '0',
product_is_call = '0',
products_sort_order = '0',
products_quantity_order_min = '1',
products_quantity_order_units = '1',
products_priced_by_attribute = '0',
product_is_always_free_shipping = '0',
products_tax_class_id = '2',
products_date_available = '-0001-11-30 00:00:00',
products_date_added = '2000-05-01 22:08:00',
products_last_modified = CURRENT_TIMESTAMP,
products_quantity = '786',
manufacturers_id = '1',
products_status = '1',
metatags_title_status = '0',
metatags_products_name_status = '0',
metatags_model_status = '0',
metatags_price_status = '0',
metatags_title_tagline_status = '0' WHERE (products_id = '4')

In the CSV I have the following only:

v_products_model,v_products_ordered
10,737
20,258
30,304

Ok nevermind, the error above was on my test site. I just tried it on my main site and it worked.

Glad to hear that it works, but I am curious about why it happened... What's different between the two? Does one have a differrent php version than the other? Are the versions of EP4 the same or different?

Recently corrected or tried to anyways an issue with those dates to make sure they work. I wonder if the sign is backwards for the more recent version(s) of php although I didn't test with as few columns as you did. (Not necessarily the intended use at the moment). Further since I'm working on publishing a new version I'd like to have ths addressed if it needs to be.

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

marcopolo:

and both sites have same version of EP4

Which is?

mc12345678:

Which is?

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

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.

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?

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.

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?

mc12345678:

Again need specificity, by latest, which version?

Easy Populate 4.0.30 - Beta 06-27-2015

marcopolo:

Easy Populate 4.0.30 - Beta 06-27-2015
Ahh, okay I think (and am still trying looking into it) that the salemaker issue was resolved in 4.0.31, but there is still a minor issue or two to post to that. Meanwhile I have 4.0.32 prepped, but I want to test it a little more before publishing. Have a few different things going on and don't want to negatively impact any users...