bkiani Posted November 26, 2019 Share Posted November 26, 2019 Hello I'm using OSC version 2.3.4 I see this error when I want to add a feature to the product 1136 - Column count doesn't match value count at row 1 insert into products_attributes values (null, '52', '3', '3', '0', '+') Of course, everything was fine before I moved my site to another server Before transitioning the host, product editing tools were available when additional product options were available, but this tool is not available on the product editing page anymore. please help Thanks Link to comment Share on other sites More sharing options...
bkiani Posted November 26, 2019 Author Share Posted November 26, 2019 I'm using OSC version 2.3.4 Link to comment Share on other sites More sharing options...
♥ecartz Posted November 26, 2019 Share Posted November 26, 2019 6 minutes ago, bkiani said: 1136 - Column count doesn't match value count at row 1 insert into products_attributes values (null, '52', '3', '3', '0', '+') This is saying that the table products_attributes has a different number of columns than six. The two main fixes you could attempt would be to either change the table in the database to have six columns that match those values or to change the query to include the column names. INSERT INTO products_attributes (products_attributes_id, products_id, options_id, options_values_id, options_values_price, price_prefix) VALUES (NULL, '52', '3', '3', '0', '+') Definitely back up your files and database before trying either. You might also consider how you migrated. Did you migrate the files and database yourself? Did you use a tool? Perhaps you need to reinstall the App (tool) that allowed you to edit the product options. Or it may be that you are using a different version of PHP and the tool doesn't work there. Always back up before making changes. Link to comment Share on other sites More sharing options...
bkiani Posted November 26, 2019 Author Share Posted November 26, 2019 Thanks for the quick response Unfortunately, I forgot which one I had installed the ajax plugin Link to comment Share on other sites More sharing options...
bkiani Posted November 26, 2019 Author Share Posted November 26, 2019 When I open the product edit page I see this error Request URL: >http://admin url removed/admin folder removed/attributeManager/attributeManager.php?products_id=165&pageAction=new_product&osCAdminID=86371baf562ec1ee70e57edd2ce96ea8 Request Method: GET Status Code: 500 Internal Server Error please help me Thanks Link to comment Share on other sites More sharing options...
♥JcMagpie Posted November 26, 2019 Share Posted November 26, 2019 You should not post your admin path on the forum. If that is your real path then you need to change the admin foulder name to somthing else. Link to comment Share on other sites More sharing options...
bkiani Posted November 26, 2019 Author Share Posted November 26, 2019 11 minutes ago, JcMagpie said: You should not post your admin path on the forum. If that is your real path then you need to change the admin foulder name to somthing else. ok Link to comment Share on other sites More sharing options...
♥ecartz Posted November 26, 2019 Share Posted November 26, 2019 12 hours ago, bkiani said: 500 Internal Server Error This just says that there was a problem on the server. To get help, you'd need to get the error message from the log file. Unfortunately, the method for getting the log file varies from host to host, so you'd need to either read their documentation or ask them for help getting the error message. With the actual error message, we might be able to give you more help. You also might want to look in the file attributeManager.php and see if it tells you any more about the App that you have installed. That's not a core file, so the App provided it. Always back up before making changes. Link to comment Share on other sites More sharing options...
bkiani Posted December 17, 2019 Author Share Posted December 17, 2019 On 11/27/2019 at 3:11 AM, ecartz said: This just says that there was a problem on the server. To get help, you'd need to get the error message from the log file. Unfortunately, the method for getting the log file varies from host to host, so you'd need to either read their documentation or ask them for help getting the error message. With the actual error message, we might be able to give you more help. You also might want to look in the file attributeManager.php and see if it tells you any more about the App that you have installed. That's not a core file, so the App provided it. Thank You Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.