EasyPopulate 4.0 Support Thread

[mc12345678]

How do I uninstall Easy Populate?

I got an error when trying to run the install.sql in Admin

'WARNING: An Error occurred, please refresh the page and try again.'

In phpMyAdmin the error says

SQL query:

INSERT INTO admin_pages
VALUES (
'easyPopulate', 'BOX_TOOLS_EASY_POPULATE', 'FILENAME_EASYPOPULATE', '', 'tools', 'Y', @configuration_group_id
);

MySQL said: Documentation
#1062 - Duplicate entry 'easyPopulate' for key 'page_key'

and thus I have no Admin->Configuration->Easy Populate menu item.

The Admin->Tools->Easy Populate required me changing all the php [<? ] tags in the tempEP/fileList.php, since I cannot for some reasons get shortcodes enabled on my localhost.

When I upload a file with two sample items, I get an error 1054

MySQL error 1054: Unknown column 'EASYPOPULATE_CONFIG_CUSTOM_FIELDS' in 'field list'
When executing:
INSERT INTO products SET
						products_model					=	'P1010669' ,
						products_price					=	'15.9' ,
						products_image					=	'P1010669.jpg' ,
						products_weight					=	'0' ,
						products_tax_class_id			=	'' ,
						products_date_available			=	'' ,
						products_date_added				=	CURRENT_TIMESTAMP ,
						products_last_modified			=	CURRENT_TIMESTAMP ,
						products_quantity				=	'3' ,
						master_categories_id			=	'9' ,
						manufacturers_id				=	'1',
						products_status					=	'1',
						metatags_title_status			=	'',
						metatags_products_name_status	=	'',
						metatags_model_status			=	'',
						metatags_price_status			=	'',
						metatags_title_tagline_status	=	'' , EASYPOPULATE_CONFIG_CUSTOM_FIELDS='' 
MySQL error 1054: Unknown column 'EASYPOPULATE_CONFIG_CUSTOM_FIELDS' in 'field list'
When executing:
INSERT INTO products SET
						products_model					=	'J17960B' ,
						products_price					=	'15' ,
						products_image					=	'P1010328.jpg' ,
						products_weight					=	'0.5' ,
						products_tax_class_id			=	'' ,
						products_date_available			=	'' ,
						products_date_added				=	CURRENT_TIMESTAMP ,
						products_last_modified			=	CURRENT_TIMESTAMP ,
						products_quantity				=	'2' ,
						master_categories_id			=	'9' ,
						manufacturers_id				=	'1',
						products_status					=	'1',
						metatags_title_status			=	'',
						metatags_products_name_status	=	'',
						metatags_model_status			=	'',
						metatags_price_status			=	'',
						metatags_title_tagline_status	=	'' , EASYPOPULATE_CONFIG_CUSTOM_FIELDS=''

I can only gather this is stemming from whatever options should be showing in Admin->Configuration->Easy Populate.

So...how do I a)get the configuration menu item to show OR b)uninstall this thing and try again?

So, I've reread your original statement above. I don't currently have access to a computer to review the code and identify which value is supposed to be the pagekey, but if you identify which of the values of the errant SQL is the page key, then, go into mySQLadmin and identify the duplicate entry to possibly delete it and rerun the SQL statement(s) that provide the menu option(s) that you are missing possibly to rename/renumber the page key so that you are then able to successfully use EP4.

As to short tags, that would be in your php.ini and may require resetting cache/sessions after change, or waiting if your host/the version of PHP allows.

[k1ra]

So, I've reread your original statement above. I don't currently have access to a computer to review the code and identify which value is supposed to be the pagekey, but if you identify which of the values of the errant SQL is the page key, then, go into mySQLadmin and identify the duplicate entry to possibly delete it and rerun the SQL statement(s) that provide the menu option(s) that you are missing possibly to rename/renumber the page key so that you are then able to successfully use EP4.

As to short tags, that would be in your php.ini and may require resetting cache/sessions after change, or waiting if your host/the version of PHP allows.

Finally got around to this again...and THANK YOU for giving me an idea of where to go..

I ended up going into phpMyAdmin, navigating to the admin_pages table, and deleting the BOX_TOOLS_EASY_POPULATE value. I re-ran the install.sql, which ran correctly this time and viola! Menu item for Easy Populate now appears under Admin->Configuration.

[k1ra]

One step forward...still another to figure out I am still getting the MySQL error 1054: Unknown column 'EASYPOPULATE_CONFIG_CUSTOM_FIELDS' in 'field list'...when trying to import 2 test products.

It has got me stumped.

I should add that exporting a csv of the two products [different from the 2 being imported] that already exist on my site, EP does not download any data.