cinolas Posted February 6, 2020 Share Posted February 6, 2020 I'm using osC 2.3.4 BS I recently moved to a new host and with that came a change in the active PHP version to 5.4.45 from a previous 5.x version. (I believe the PHP version is what's causing my problems, I could be wrong). After the move I started getting errors about incorrect integer values in the SQL insert when creating new products, which I fixed by adding the correct (float) and (int) in front of my tep_db_prepare_input calls. I believe that prevents the values from being inserted as ''. This wasn't a problem with the previous PHP version. Another problem I'm having is when checking out with a product that has an attribute option value that is longer than 32 characters. First it generated an error in the browser that said: Data too long for column 'products_options_values' at row 1 This also wasn't a problem before the move, the data in the field simply got truncated at 32 chars. So I changed the length of the fields products_options and products_options_values in orders_products_attributes from 32 to 64 and that fixed that error message, HOWEVER users with products that have attribute values longer than 32 chars still cannot checkout. The Confirm Order button presses but nothing happens. This is not a problem when only products with short attribute values are being purchased. So obviously I need to expand the character limit for my attribute values somewhere else as well for this to work, but where? Any help is greatly appreciated! Link to comment Share on other sites More sharing options...
cinolas Posted February 7, 2020 Author Share Posted February 7, 2020 In an emergency measure, to make sure my customers could check out, I shortened all my long attribute values to less than 32 chars. But checkout still doesn't work. Even if I delete the product from my cart and re-add it with the short attribute value, the Confirm Order button just doesn't do anything (my CC isn't getting charged either). So that may not my problem. Why would some products allow Checking Out and not others. How do I debug the Confirm Order button behaviour to see what the problem is? Link to comment Share on other sites More sharing options...
mfleeson Posted February 8, 2020 Share Posted February 8, 2020 It sounds like although you increased the length of the product_attributes you didn't change the matching order_product_attributes. Can you supply the create table sql's for your product and order tables? Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.