Results 1 to 5 of 5
  1. #1
    Join Date
    Apr 2008
    Posts
    15
    Plugin Contributions
    0

    database error 1032 Can't find record in 'orders'

    Hello,

    It appears there have been no new orders to our store since January 31, 2013. This morning the following error appeared on the Admin page:

    1032 Can't find record in 'orders'
    in:
    [select o.orders_id as orders_id, o.customers_name as customers_name, o.customers_id, o.date_purchased as date_purchased, o.currency, o.currency_value, ot.class, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id and class = 'ot_total') order by orders_id DESC limit 5]
    If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

    There have been no new add-ons added recently. It doesn't appear that the site has been hacked, but I am not an expert. Could someone please help? I am using version 1.3.9h and the url is http://www.shotgunsportsmagazine.com/store

    I have put the site in maintenance mode. Hopefully this is a quick fix. Thank you.

  2. #2
    Join Date
    Jan 2007
    Location
    Australia
    Posts
    6,167
    Plugin Contributions
    7

    Default Re: 1032 Can't find record in 'orders'

    What version of MySQL are you using?
    Has your host done any updates lately?
    Have you tried to using a tool such as phpMyadmin to check/repair your database (it may have suffered a crash leaving one or more of the tables in an unreadable state).
    Are there any other functions that don't work?

    Cheers
    Rod

  3. #3
    Join Date
    Apr 2008
    Posts
    15
    Plugin Contributions
    0

    Default Re: 1032 Can't find record in 'orders'

    Thank you for the response Rod. We are running MySQL 5.5.29. I did as you suggested and repaired the table after checking it. The orders table was corrupt. Repairing resolved the issue. Thank you so much.

  4. #4
    Join Date
    Jan 2007
    Location
    Australia
    Posts
    6,167
    Plugin Contributions
    7

    Default Re: 1032 Can't find record in 'orders'

    Thanks for the feedback. It's always good to know how/when/if problems are solved. It often helps others with the same or similar problems.

    Cheers
    Rod

  5. #5
    Join Date
    Feb 2013
    Posts
    1
    Plugin Contributions
    0

    Default Re: 1032 Can't find record in 'orders'

    Hi Rod

    I suspect we have the same problem - corrupt table. Unfortunately our developer has done a runner, we paid him to do the work, he set up the whole e-commerce site and hosted it and still hosting it but he does not return my calls anymore. I have checked with Paypal, and everything is set up correctly. I have tried live orders myself and it worked, strangely orders that came in after that just do not get captured in the orders in admin and so we do not have a clue what items they ordered. I am at a breakdown what to do. I have the log-in details to the ftp if thats any help. Can you possibly help me? This is very urgent as some new orders have come in. Thanks.

 

 

Similar Threads

  1. v150 Standing Orders - can't find a definitive answer!
    By James Murray in forum General Questions
    Replies: 2
    Last Post: 18 Sep 2013, 12:20 AM
  2. How can we record where the orders come from?
    By anewstone in forum General Questions
    Replies: 1
    Last Post: 19 Feb 2009, 10:30 AM
  3. Paypal IPN in v1.3.8 - Could not find matched txn_id record in DB
    By babygekko in forum Upgrading from 1.3.x to 1.3.9
    Replies: 9
    Last Post: 27 Jun 2008, 04:46 PM
  4. IPN WARNING::Could not find matched txn_id record in DB
    By ottojan in forum Built-in Shipping and Payment Modules
    Replies: 0
    Last Post: 30 Jun 2007, 10:27 AM
  5. IPN WARNING::Could not find matched txn_id record in DB
    By rush_woman in forum Built-in Shipping and Payment Modules
    Replies: 7
    Last Post: 9 Feb 2007, 04:18 PM

Bookmarks

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
Zen-Cart, Internet Selling Services, Klamath Falls, OR