Messages

UGH!! I totally skipped over that one! That was my problem! Thank you so much!

I have... no luck!

no errors. Added this line and it works, thank you so much. I now have one other issue I cannot seem to figure out... I have slowly been getting this wire code displaying on the home page and then on the products pages it gets worse. I have tried playing with extensions and tried to find places to later code but have not been successful, can you possibly assist with this?

I am getting the following error when I updated to 1.2.12

There has been a critical error processing your request

SQL Error: Unknown column 'stock_checkout' in 'field list'
Error No: 1054
SQL: SELECT DISTINCT *, pd.name AS name, m.name AS manufacturer, ss.name AS stock_status, stock_checkout, lcd.unit as length_class_name, ( SELECT AVG(r.rating) FROM abpc_reviews r WHERE p.product_id = r.product_id AND status = 1 GROUP BY r.product_id ) AS rating , COALESCE( ( SELECT p2sp.price FROM abpc_product_specials p2sp WHERE p2sp.product_id = p.product_id AND p2sp.customer_group_id = '1' AND ((p2sp.date_start = '0000-00-00' OR p2sp.date_start < NOW()) AND (p2sp.date_end = '0000-00-00' OR p2sp.date_end > NOW())) ORDER BY p2sp.priority ASC, p2sp.price ASC LIMIT 1 ) , p.price) as final_price FROM abpc_products p LEFT JOIN abpc_product_descriptions pd ON (p.product_id = pd.product_id AND pd.language_id = '1') LEFT JOIN abpc_products_to_stores p2s ON (p.product_id = p2s.product_id) LEFT JOIN abpc_manufacturers m ON (p.manufacturer_id = m.manufacturer_id) LEFT JOIN abpc_stock_statuses ss ON (p.stock_status_id = ss.stock_status_id AND ss.language_id = '1') LEFT JOIN abpc_length_class_descriptions lcd ON (p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') WHERE p.product_id = '125' AND p2s.store_id = '0' AND p.date_available <= NOW() AND p.status

I don't think I modified anything... huh

How would I restore it?

When you enter the site it displays fine. Whenever you go to any of my products there are some strange characters at the top. I have looked an a few places but it only shows up on a product. Can someone please advise on this? The image is of the upper left corner of the page by the logo.

I have searched quite extensively and cannot find anywhere that I can edit the content of the email that is sent to a new customer to validate their account. Can someone please advise. Thanks.