Guest besimtari Posted April 8, 2005 Share Posted April 8, 2005 After I add an option for a product, just for testing, I got this error MySQL Error Occured 1054: Unknown column 'value' in 'field list' QUERY = SELECT cubecartstoreCubeCart_options_bot.option_id, cubecartstoreCubeCart_options_bot.value_id, option_price, option_symbol, value cubecartstoreCubeCart_ion_name, assign_id FROM `cubecartstoreCubeCart_options_bot` INNER JOIN `cubecartstoreCubeCart_options_mid` ON cubecartstoreCubeCart_options_mid.value_id = cubecartstoreCubeCart_options_bot.value_id INNER JOIN `cubecartstoreCubeCart_options_top` ON cubecartstoreCubeCart_options_bot.option_id = cubecartstorecubecartstoreCubeCart_options_top.option_id WHERE assign_id = 84 I removed the option again but this error still showing. Can some one help me on this. Quote Link to comment Share on other sites More sharing options...
Guest billmc Posted April 8, 2005 Share Posted April 8, 2005 hi besimtari, It looks like the new options fields were not added to the data base check in phpMyAdmin. if not then you can add them manually hth billmc Quote Link to comment Share on other sites More sharing options...
Guest Joker Posted April 9, 2005 Share Posted April 9, 2005 Find line 236 in install.php. Change line: PRIMARY KEY (`cat_id`,`cat_id`) with this: PRIMARY KEY (`cat_id`) Quote Link to comment Share on other sites More sharing options...
Guest besimtari Posted April 9, 2005 Share Posted April 9, 2005 Find line 236 in install.php. Change line: PRIMARY KEY Â (`cat_id`,`cat_id`) with this: PRIMARY KEY Â (`cat_id`) Do you mean to instal the db again? Quote Link to comment Share on other sites More sharing options...
Guest mstgokcen Posted April 10, 2005 Share Posted April 10, 2005 But we did delete the install.php so what will happen? upload all these files again? Quote Link to comment Share on other sites More sharing options...
Guest Posted April 10, 2005 Share Posted April 10, 2005 But we did delete the install.php so what will happen? upload all these files again? Just edit a local copy of install.php and upload that. Quote Link to comment Share on other sites More sharing options...
Guest mstgokcen Posted April 10, 2005 Share Posted April 10, 2005 Just edit a local copy of install.php and upload that. but after re-upload instal.php then site says you must delete the install directory WARNING - Your store will not function until the install directory is deleted from the server. Quote Link to comment Share on other sites More sharing options...
Guest Posted April 10, 2005 Share Posted April 10, 2005 but after re-upload instal.php then site says you must delete the install directory WARNING - Your store will not function until the install directory is deleted from the server. After uploading it, the idea is then to re-run the install script. (i'm just taking jokers advice,i dont have my own answer to the original problem) Quote Link to comment Share on other sites More sharing options...
Guest mstgokcen Posted April 10, 2005 Share Posted April 10, 2005 Find line 236 in install.php. Change line: PRIMARY KEY Â (`cat_id`,`cat_id`) with this: PRIMARY KEY Â (`cat_id`) I changed the line in install.php and then re-install the cc3 but again when I add a product option and try to buy it gives error... MySQL Error Occured 1054: Unknown column 'value' in 'field list' QUERY = SELECT CubeCart_options_bot.option_id, CubeCart_options_bot.value_id, option_price, option_symbol, value CubeCart_ion_name, assign_id FROM `CubeCart_options_bot` INNER JOIN `CubeCart_options_mid` ON CubeCart_options_mid.value_id = CubeCart_options_bot.value_id INNER JOIN `CubeCart_options_top` ON CubeCart_options_bot.option_id = CubeCart_options_top.option_id WHERE assign_id = 85 Quote Link to comment Share on other sites More sharing options...
Guest besimtari Posted April 10, 2005 Share Posted April 10, 2005 Find line 236 in install.php. Change line: PRIMARY KEY Â (`cat_id`,`cat_id`) with this: PRIMARY KEY Â (`cat_id`) Hi Joker, Thank you for your instraction, it works now. I had a copy of the install.php file. Quote Link to comment Share on other sites More sharing options...
Guest besimtari Posted April 10, 2005 Share Posted April 10, 2005 oooppsssss, again MySQL Error Occured 1054: Unknown column 'value' in 'field list' QUERY = SELECT cubecartstoreCubeCart_options_bot.option_id, cubecartstoreCubeCart_options_bot.value_id, option_price, option_symbol, value cubecartstoreCubeCart_ion_name, assign_id FROM `cubecartstoreCubeCart_options_bot` INNER JOIN `cubecartstoreCubeCart_options_mid` ON cubecartstoreCubeCart_options_mid.value_id = cubecartstoreCubeCart_options_bot.value_id INNER JOIN `cubecartstoreCubeCart_options_top` ON cubecartstoreCubeCart_options_bot.option_id = cubecartstorecubecartstoreCubeCart_options_top.option_id WHERE assign_id = 84 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.