Easy Popluate and Stocks By Attribute Error

[HGrubb]

I am using a fresh install of Zen Cart 1.3.8. I installed Easy Populate and Stocks By Attribute and both worked fine. I then downloaded and installed the Easy Populate and Stocks by Attribute contribution which is only a new easypopulate.php file for the admin folder. When I go to Tools -> Easy Populate and click on "Download Model/Price/Qty/Pwas .csv file to edit" I get the following error:


Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/content/h/s/s/***/html/admin/easypopulate.php on line 803

Warning: Cannot modify header information - headers already sent by (output started at /home/content/h/s/s/***/html/admin/easypopulate.php:803) in /home/content/h/s/s/***/html/admin/easypopulate.php on line 1149

Warning: Cannot modify header information - headers already sent by (output started at /home/content/h/s/s/***/html/admin/easypopulate.php:803) in /home/content/h/s/s/***/html/admin/easypopulate.php on line 1150

Warning: Cannot modify header information - headers already sent by (output started at /home/content/h/s/s/***/html/admin/easypopulate.php:803) in /home/content/h/s/s/***/html/admin/easypopulate.php on line 1154

Warning: Cannot modify header information - headers already sent by (output started at /home/content/h/s/s/***/html/admin/easypopulate.php:803) in /home/content/h/s/s/***/html/admin/easypopulate.php on line 1158
v_products_model,v_specials_price,v_specials_date_avail,v_specials_expires_date, v_products_price,v_products_quantity,pwas_attrib_id,pwas_products_quantity,v_opt ions_name

Please help!

[HGrubb]

Line 803

while ($row = mysql_fetch_array($result, MYSQL_ASSOC)){

[HGrubb]

Anyone?

[redheads]

Still no ideas, or did someone figure this out and forget to post about it ;-)

??

I have been reading and searching... I have the same error, same experience as the others here - EP works, Stock by attributes works, EP w/ stock by attributes... error. I did not get the 'header errors' - just this is in my csv file:

<br />
<b>Warning</b>: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in <b>/home/xxxxxx/...admin/easypopulate.php</b> on line <b>803</b><br />
v_products_model v_specials_price v_specials_date_avail v_specials_expires_date v_products_price v_products_quantity pwas_attrib_id pwas_products_quantity v_options_name

Only on that one download option (the one added by EP w/stock by attributes)

[redheads]

Ok, in the error log I find this:

MySQL error 1146: Table 'XXXXX.products_with_attributes_stock' doesn't exist
When executing:
SELECT
			p.products_id as v_products_id,
			p.products_model as v_products_model,
			p.products_price as v_products_price,
			p.products_tax_class_id as v_tax_class_id,
			p.products_quantity as v_products_quantity,
			pa.products_attributes_id as pwas_attrib_id,
			pwas.quantity as pwas_products_quantity,
			pov.products_options_values_name as v_options_name
			FROM
			XXXX_products as p
			JOIN
			XXXX_products_attributes as pa
            on  p.products_id = pa.products_id
            JOIN
            aami_products_options_values as pov
            on      pa.options_values_id = pov.products_options_values_id
            join    products_with_attributes_stock PWAS
            on      PWAS.stock_attributes = pa.products_attributes_id

and the table prefix is NOT listed correctly - it should have the database name and the PREFIX on it... like:

XXXXX.<prefix>_products_with_attributes_stock

a hint as to the problem??? mayhaps??? Maybe it is not going to find the table it is looking for, since there is no prefix??

And if that is the problem, how to fix it???

I tried the same install on another shop, same error. Shop is 1.3.8p3

[balihr]

Hey guys, did anyone solve this issue?
I believe i found a solution, but would like to hear from someone who's having this issue to verify.