Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2008
    Location
    Memphis, USA
    Posts
    299
    Plugin Contributions
    0

    Default 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

  2. #2
    Join Date
    Jan 2008
    Location
    Memphis, USA
    Posts
    299
    Plugin Contributions
    0

    Default 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.

  3. #3
    Join Date
    Jan 2012
    Posts
    488
    Plugin Contributions
    0

    Default Re: Recover cart sales plugin problem.

    Quote Originally Posted by coucho View Post
    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.

  4. #4
    Join Date
    Oct 2007
    Location
    MA, USA
    Posts
    385
    Plugin Contributions
    0

    Default 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.

 

 

Similar Threads

  1. v151 recover cart sales su zc 151
    By favjola in forum Customization from the Admin
    Replies: 13
    Last Post: 15 Feb 2016, 07:13 PM
  2. Recover Cart Sales
    By kevinc66 in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 21 Aug 2008, 12:46 AM
  3. Recover Cart Sales
    By silvito in forum General Questions
    Replies: 3
    Last Post: 19 Apr 2007, 03:16 PM
  4. Recover Abandoned Cart Sales
    By gardengate in forum Customization from the Admin
    Replies: 11
    Last Post: 6 Nov 2006, 04:34 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg