mysql error

  • Do the errors below indicate corruption of DB? Problem began today on my ecommerce website https://www.rentmothernature.com.

    MySQL error: Unknown column ‘order_id’ in ‘field list’
    Query: SELECT DISTINCT(order_id) FROM rmn_orders WHERE datetime >=”2015-05-01 00:00:00″ AND datetime <= “2015-05-02 00:00:00” AND order_status = “Paid” OR order_status = “Printed”

    MySQL error: Unknown column ‘order_id’ in ‘field list’
    Query: SELECT id, datetime, order_id, order_status, lease_id, cart_item_id, delivery_id, user_id_billing FROM rmn_orders WHERE cart_item_id=”NwEBcMl8ktMyCfvEetq4hl0kqE9TqUe4Hj”

Viewing 3 replies - 1 through 3 (of 3 total)

  • Have you tried repairing the database?

    Thread Starter angstrom

    (@angstrom)

    I am not knowledgeable enough to do so. The item ‘order_id’ is a legitimate field. I see that similar problems have appeared with others using v4.1.4. Am wondering if that is the cause?
    My website is today displaying the mysql error when orders are placed (at checkout page) which is a related problem.

    Ask your hosting company for help in repairing or troubleshooting your database.

    You may want to post at jobs.wordpress.net or elsewhere for a freelancer to assist you with repairs.

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘mysql error’ is closed to new replies.