Recover Cart [Support Thread]

[Woodymon]

I have not observed your issue.

Some things to look at:

Within /admin/recover_cart_sales.php is $SHOW_ATTRIBUTES = FALSE (appx line 49)?


Is it possible the db did not get patched correctly? You may want to repatch and/or compare the SQL file bundled with RCS the mod with your database.

Have you re-uploaded ALL files for the mod?

Which version of Zen Cart?
Which version of MySQL?

BTW you should rename your admin directory. From the error message you posted, you have not done so. (Or maybe you edited the error message before posting to the forum... which is a good idea). Please see the security docs bundled with Zen Cart.

Sorry I can't be of further assist. Maybe someone else with more intimate knowlege of the SQL error message will chime in.

Woody

[Woodymon]

Another thing to check is your table prefix. Is it the default "zen_" or something else or nothing at all?

[jayson.gurney]

Hi folks many thanks for the help. I have installed the module with success on a new fresh local server install. Will keep my fingers crossed that when its implemented on the live store it works there too

Someone mentioned about the renaming of the admin folder - I am aware of this but many thanks for the reminder :)

[landshark]

Hi folks many thanks for the help. I have installed the module with success on a new fresh local server install. Will keep my fingers crossed that when its implemented on the live store it works there too

Someone mentioned about the renaming of the admin folder - I am aware of this but many thanks for the reminder :)

So how did you fix the line 410 error, I am having the same trouble on my testing server?

[ladysaat]

I got this error after successfully installing the SQL patch and then clicking on RecoverCart in the tools area:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /hsphere/local/home/hodllc/houseofdiva.com/zencart/admin/recover_cart_sales.php on line 410

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /hsphere/local/home/hodllc/houseofdiva.com/zencart/admin/recover_cart_sales.php on line 410


Line 410 reads: $inrec2 = mysql_fetch_array($query2);


I am using zencart v1.3.0.1 and I just got this mod from the downloads sec. here.

So what does it mean? I looked at the file and I do not know what is "supposed" to be there versus what is.

[Woodymon]

I got this error after successfully installing the SQL patch and then clicking on RecoverCart in the tools area.

It's a common error. Merlin has posted in the old forum that the workaround solution is to:

-> set the Register Globals value in htaccess to ON.

And melin stated if you still observe the error to not worry about it as the mod still works.

I have the links to the old IPB site but they do not work for the new support forum site. If you would rather like to receive a copy of the related posts in a text file PM me your email

Or search the archived contributions forum for the following topic titles:

"Recover Cart Not Working, error mesage" Jan 12 2006

(spelling incorrect on purpose)

And search on:

"Recover Cart Module Problem"

-Woody

[ladysaat]

ahh okay, I have sent my host a trouble ticket to make sure those are set to "On" I thought they'd done it already. When I searched I searched under Recover Cart errors and such. I will do the suggestion and search harder next time. Thanks for the help!!

[silvito]

Hello Zinners,

I have installed recover cart and i uploaded everything to it relative path but when i go to the tool and on the dropdown i click recover cart i see some carts recovered but above the carts i get this message three times.

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\inetpub\foxmar\FoxCart\admin\recover_cart_sales.php on line 395

Any thought as to what this means? Is there a solution to it?

[silvito]

Also i forgot to metion that when i go to reports tab and click the recover cart link i get this message at the top


Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in D:\inetpub\foxmar\FoxCart\admin\stats_recover_cart_sales.php on line 134

[twi]

can anyone tell me how to do the patch in admin>patch mysql?

the readme instructions tells me to patch but did not specify how to patch. specific and detailed instructions would be greatly appreciated. I do not know

p.s. how to use MySQL.