Recover Cart [Support Thread]

[KADesign]

Is this compatible with the new 1.3.6? I just added this to my site and get this error when I attempt to recover carts:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/kellysco/public_html/shop/admin/recover_cart_sales.php on line 429

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/kellysco/public_html/shop/admin/recover_cart_sales.php on line 429

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/kellysco/public_html/shop/admin/recover_cart_sales.php on line 429

Do you need globals on? Or does it simply not work with the latest version? Anyone know?

Thanks,
Kelly

[heavenlynights]

Is this compatible with the new 1.3.6? I just added this to my site and get this error when I attempt to recover carts:



Do you need globals on? Or does it simply not work with the latest version? Anyone know?

Thanks,
Kelly

Hi sleepless

I am running the latest recover cart mod straight out of the box from a_berezin sig. with globals off. I upgraded my cart to 1.3.6 with recover cart already installed and everything works fine. Did not have to do any modifications with files. Oh html emails work as well

Not sure how to fix your problem as I am no wizz at code but I think I had similar problem and still do, see earlier post on previous page!!

good luck and hope that you are able to sort through it!!

[heavenlynights]

Hi sleepless

and everything works fine.

I had similar problem and still do, see earlier post on previous page!!

sorry for the slight contradiction!!

[Danielle]

When I try and upload the SQL file, I get this error:

1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '; CREATE TABLE scart ( scartid int(11) NOT NULL auto_increment, customers_id' at line 1

and it doesn't install successfully. How do I fix this error? I've been playing with this for quite awhile now with no luck. It worked fine before I upgraded. I am now using Zen 1.3.5 with the latest version of Recover Carts.

Thank you!

[firehorse]

Hi,

So noone else is having this problem? I am using the latest version of Recover Carts and my Zen is v.1.3.5. Does anyone who uses a db prefix have this working???

Thank you!

I have a prefix and I have exactly the same problem as you.

Looks like the mod isn't putting the prefix in front of the database. Will have to wait for Andrew to fix it.

Alan

[Danielle]

Hi,I have a prefix and I have exactly the same problem as you.

Looks like the mod isn't putting the prefix in front of the database. Will have to wait for Andrew to fix it.

Alan

Thank you so much for replying and letting me know you have the same problem! I was starting to think I was just going nuts and everybody was ignoring me lol This is really frustrating because before I upgraded the old version of recover carts worked just fine

[Danielle]

Shouldn't it be pretty easy to add the prefix in ourselves? I tried but I just can't get it to work. I've successfully done it with other mods, but this one I'm just not having any luck I would think we could just add zen_ to the table names but it's not working for me...

[firehorse]

Hi,

Shouldn't it be pretty easy to add the prefix in ourselves? I tried but I just can't get it to work. I've successfully done it with other mods, but this one I'm just not having any luck I would think we could just add zen_ to the table names but it's not working for me...

I think somewhere in zencart, there must be a routine to add the prefix. And for some reason, it wasn't used for scart to make it prefix_scart.

But looking for where that is waaaaay beyond me!

Best regards
Alan

[DrByte]

/admin/includes/extra_datafiles/recover_cart_database_tables.php (or maybe recover_cart_filenames.php ):

define('TABLE_SCART', 'scart');

vs

define('TABLE_SCART', DB_PREFIX . 'scart');

[firehorse]

Hi,

/admin/includes/extra_datafiles/recover_cart_database_tables.php (or maybe recover_cart_filenames.php ):

define('TABLE_SCART', 'scart');

vs

define('TABLE_SCART', DB_PREFIX . 'scart');

It was /admin/includes/extra_datafiles/recover_cart_filenames.php

Worked a treat

Best regards
Alan