credenscel,
It looks like a typo in the code somewhere. I suggest using the Developers Tool Kit in Admin/Tools search for "p.browse_by_make p.products_price_sorter" in "all files-Admin"
If not found, it might be on 2 lines, in which case you would need to search for "p.browse_by_make" and look at each program where it's found until you find one missing the comma.
If you find it, add a comma and try the same steps.
Also, if it's only happening on EP loaded products, there is probably some field that the mod needs that EP is not populating.
Jeff
Jeff,
THANK YOU!!!!!!
There was a comma missing in "collect_info.php" file. I added the comma and things worked marvelously!!!
Although I am still not sure how that error happened because "browse by make" is a sidebox which i edited via "banner manger" and did not touch the PHP files. Either way... THANK YOU!!![]()
well i'm back with more questions
after geting the EP work i realized that it's setting all my product types as General Product. The products that i'm adding are done using Music Product. Is there a way to have EP upload things as a Music Product?
Jeff,
It's me again!
I did the update as instructed. It didn't override the description again.
// already in the description, let's just update it
//$sql =
//"UPDATE ".TABLE_PRODUCTS_DESCRIPTION." SET
//products_name='" . zen_db_input($name) . "',
//products_description='" . zen_db_input($v_products_description[$key]) . "',
";
//if ($ep_supported_mods['psd'] == true) {
//$sql .= "
//products_short_desc='" . zen_db_input($v_products_short_desc[$key]) . "',
";
}
//$sql .= "
//products_url='" . zen_db_input($v_products_url[$key]) . "'
//WHERE
//products_id = '$v_products_id' AND
//language_id = '$key'";
But this error message still appears.
Warning 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
Will this cause problem later?
Again thanks for all the help!
Johnny
Jeff,
Thanks for the help. It worked like a charm!
Sorry about dragging it out, I am not an experienced programmer like yourself, so this has been a learning process.
Thanks again,
Johnny
![]()
No problem. Glad I could help.
Jeff
anyone knows if EP (free or the advanced) will work for product type music? Right now everything is uploaded is general product![]()
EP has no option for anything other than general type = 1
You have at least 3 choices here.
1. Add a products_type column in your file and mod EP to update or insert the new column as required.
2. If ALL your products are music you could use the Tools/Install SQL patches and enter
after each EP upload.PHP Code:
UPDATE products SET products_type = 2;
3. I noticed that products_type has a default of 1. Using myPHP admin, change the default for products_type to 2.
As always, TEST TEST TEST!!!
Jeff
Bookmarks