Zen Cart Logo
Forums / General Questions / Recover cart sales plugin problem.

Recover cart sales plugin problem.

Views: 912

Results 1 to 4 of 4
12 Dec 2012, 4:27 AM
#1
coucho avatar

coucho

Zen Follower

Join Date:
Jan 2008
Location:
Memphis, USA
Posts:
298
Plugin Contributions:
0

Recover cart sales plugin problem.

I installed this plugin and I get a blank page when accessing this from the admin. I am running v150. This is what my host says that happened. Any ideas as to fix this?

This appears to be related to the recover cart sale plugin. We recommend you contact the developer of this plugin and let them know that the script appears to be attempting to access a table that hasn't been created yet.

The error message I got when I ran a strace on the script says "Table 'coucho_zncr1.zen_scart' doesn't exist."

21:50:47 write(3, "\352\2\0\0\3SELECT cb.customers_id,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t cb.products_id,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t cb.customers_basket_quantity,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t cb.customers_basket_date_added,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t cus.customers_firstname,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t cus.customers_lastname,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t cus.customers_telephone,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t cus.customers_email_address,\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t sc.datemodified\n\t\t\t\t\t\t\t\t\t\t\t\t\tFROM zen_customers_basket cb\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN zen_customers cus ON (cb.customers_id = cus.customers_id)\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tLEFT JOIN zen_scart sc ON (cb.customers_id = sc.customers_id)\n\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE cb.customers_basket_date_added >= '20121111'\n\t\t\t\t\t\t\t\t\t\t\t\t\t\tAND cb.customers_id NOT IN ('')\n\t\t\t\t\t\t\t\t\t\t\t\t\tORDER BY cb.customers_id A SC, cb.customers_basket_date_added DESC", 750) = 750
21:50:47 read(3, "5\0\0\1\377z\4#42S02Table 'coucho_zncr1.zen_scart' doesn't exist", 16384) = 57
21:50:47 write(1, "<div class="systemError">", 25) = 25
21:50:47 write(1, "WARNING: An Error occurred, please refresh the page and try again.", 66) = 66

12 Dec 2012, 4:45 AM
#2
coucho avatar

coucho

Zen Follower

Join Date:
Jan 2008
Location:
Memphis, USA
Posts:
298
Plugin Contributions:
0

Re: Recover cart sales plugin problem.

I reinstalled the php files but maybe I think I may not have the SQL files correctly installed. Can someone give me and uninstall SQL query? Then I can install the query again and see if that works.

12 Dec 2012, 6:10 AM
#3
limitless avatar

limitless

Inactive

Join Date:
Jan 2012
Posts:
496
Plugin Contributions:
0

Re: Recover cart sales plugin problem.

coucho:

I reinstalled the php files but maybe I think I may not have the SQL files correctly installed. Can someone give me and uninstall SQL query? Then I can install the query again and see if that works.

You shouldnt start multiple threads on the same issue.

In your other post I gave you the fix to the mysql query.

23 Jan 2014, 6:50 PM
#4
magicman avatar

magicman

Zen Follower

Join Date:
Oct 2007
Location:
MA, USA
Posts:
385
Plugin Contributions:
0

Re: Recover cart sales plugin problem.

Having the same issue. I was able to install the script ok but the Admin is blank and I cannot edit anything.