Guest bmxboy Posted April 10, 2007 Share Posted April 10, 2007 This morning I attempted to go into our Orders via the Admin area and I keep getting a MySql 1142 Error. We desperately need to get this corrected so we can process and ship orders. No admins are able to access the orders. We are getting the following message when we click on ORDERS: ---------------------------------------------------------------------------------------------------------------------- 1142: SELECT command denied to user 'cycles_rmontalv'@'localhost' for table 'mobile' QUERY = SELECT b.mobile, d.name as prodname, b.customer_id, a.status, a.cart_order_id, a.time, b.title, b.firstName, b.lastName, a.ip, a.prod_total, b.email FROM CubeCart_order_inv c, CubeCart_customer.mobile, CubeCart_order_sum a, CubeCart_customer b, CubeCart_inventory d WHERE 1 AND d.productId = c.productId AND c.cart_order_id = a.cart_order_id AND a.customer_id = b.customer_id GROUP BY a.cart_order_id ORDER BY time DESC ----------------------------------------------------------------------------------------------------------------------- Someone PLEASE HELP!!! Thanks in advance Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.