easy populate 1.2.5.5.csv - fetch_array error on .csv generation

Hi,

I've scoured the forum for this error that I receive when creating a Complete .csv file:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in ...blah blah/easypopulate.php on line 811
 File Full-EP2009Aug08-1907.csv     successfully exported! The file is ready for download in your /temp/ directory.
 An SQL error has occured. Please check your input data for tabs within fields and delete these. If this error continues, please forward your error log to the Easy Populate maintainer

I'm just trying out this CSV version (new install - did not have the older EP software installed). I did, however, install the SQL patch as I was initially getting errors re the configuration.

This is on a godaddy shared virtual server Linux/PHP 5.2.5/ZC 1.3.8a. I have the same EP CSV installation on my local system w/o a hitch - with the same sql patch (Windows XP).

Anyone have an idea of what might be happening on my production server? Thanks a million for any ideas!

In case anyone else runs into this problem - it originated from the EASYPOPULATE_CONFIG_CUSTOM_FIELDS column that was not defined (I have no custom fields - that I know of!).

Looking into this a bit further, in the log file I'm was getting a:

EASYPOPULATE_CONFIG_CUSTOM_FIELDS unknown column error in the sql statement. I commented out the custom field array load in admin/easypopulate.php ~ line 134:

$custom_fields == FALSE;
/*
if(strlen(EASYPOPULATE_CONFIG_CUSTOM_FIELDS) > 0)
{
	$custom_fields = explode(',',EASYPOPULATE_CONFIG_CUSTOM_FIELDS);
}
*/

Hope this helps save some headaches....

Love the app - it's saving me a ton of time!

WOW! Thank you for posting this one, it was thoroughly stumping me. :D

Fixed for me too. Good spot. Cheers!:clap:

emmtqg:

In case anyone else runs into this problem - it originated from the EASYPOPULATE_CONFIG_CUSTOM_FIELDS column that was not defined (I have no custom fields - that I know of!).

Looking into this a bit further, in the log file I'm was getting a:

EASYPOPULATE_CONFIG_CUSTOM_FIELDS unknown column error in the sql statement. I commented out the custom field array load in admin/easypopulate.php ~ line 134:

$custom_fields == FALSE;
/*
if(strlen(EASYPOPULATE_CONFIG_CUSTOM_FIELDS) > 0)
{
$custom_fields = explode(',',EASYPOPULATE_CONFIG_CUSTOM_FIELDS);
}
*/

> 
> Love the app - it's saving me a ton of time!


Amazing, Saved me loads of time. Thanks!

Sorry to have to post .. but just not finding anything.

I have 2 questions. I have loaded the latest version. followed all the instructions. I am running v 1.3.8.

1. installed everything in appropriate folders. I had to run install the SQL for anything to show up in my ADMIN panel. Easy Populate shows up under the Configuration tab. But when I go to Tool, Easy Populate. Nothing happens .. this is launching the easypopulate.php program but I get a blank screen and done message. Help!:blink:

2. Where is the xls template. it is not in the download folders.

thanks

MstrYoda:

Sorry to have to post .. but just not finding anything.

I have 2 questions. I have loaded the latest version. followed all the instructions. I am running v 1.3.8.

1. installed everything in appropriate folders. I had to run install the SQL for anything to show up in my ADMIN panel. Easy Populate shows up under the Configuration tab. But when I go to Tool, Easy Populate. Nothing happens .. this is launching the easypopulate.php program but I get a blank screen and done message. Help!:blink:

2. Where is the xls template. it is not in the download folders.

thanks

1. Manually check that each file actually uploaded.

2. Create a few of your categories, then enter a few products manually. Then download a complete CSV file. This will give you your template.