wilma2 Posted November 27, 2008 Share Posted November 27, 2008 #1136 - Column count doesn't match value count at row 1 HI there the last 2 contribuitions i have tried to add I have encountered this error. I have followed some ideas here on the forum by changing products_attributes but no luck. The last contribution I tried to add was the free gift module. Does anyone have any ideas? thanks in advance I can not add anything with this error. Trish Link to comment Share on other sites More sharing options...
wilma2 Posted November 27, 2008 Author Share Posted November 27, 2008 #1136 - Column count doesn't match value count at row 1 HI there the last 2 contribuitions i have tried to add I have encountered this error. I have followed some ideas here on the forum by changing products_attributes but no luck. The last contribution I tried to add was the free gift module. Does anyone have any ideas? thanks in advance I can not add anything with this error. Trish Hi there again the title of this has nothing to do with the issue above but i got copy/paste happy lol :rolleyes: Link to comment Share on other sites More sharing options...
Guest Posted November 27, 2008 Share Posted November 27, 2008 #1136 - Column count doesn't match value count at row 1 HI there the last 2 contribuitions i have tried to add I have encountered this error. I have followed some ideas here on the forum by changing products_attributes but no luck. The last contribution I tried to add was the free gift module. Does anyone have any ideas? thanks in advance I can not add anything with this error. Trish I don't have the answer to your question, just wanted to comment Great Site! I've bookmarked it. Link to comment Share on other sites More sharing options...
spooks Posted November 27, 2008 Share Posted November 27, 2008 You havent given enough info to tell anything put site:http://www.oscommerce.com/forums Column count doesn't match value count in google to see other fixes that might apply Sam Remember, What you think I ment may not be what I thought I ment when I said it. Contributions: Auto Backup your Database, Easy way Multi Images with Fancy Pop-ups, Easy way Products in columns with multi buy etc etc Disable any Category or Product, Easy way Secure & Improve your account pages et al. Link to comment Share on other sites More sharing options...
wilma2 Posted November 27, 2008 Author Share Posted November 27, 2008 I don't have the answer to your question, just wanted to comment Great Site! I've bookmarked it. lol not my site i just have a sick dog to. But it is a great site! I have nothing to do with it though. And i was checking it out at hte same time when i got copy paste happy lol. In regards to my issue I was installing free gift module at the time and in the instructions i was told to Database Modifications: Add Configuration Group: INSERT INTO `configuration_group` VALUES ('', 'Free Gift', 'Free Gift Configuration', '17', '1'); Please get the groups id that the db has generated, as it will be required for the next step! Add Configuration Items: Please replace 'ID' with the id generated from stage 1 INSERT INTO `configuration` VALUES ('ID', 'Minimum Spend', 'FREE_GIFT_MINIMUM_SPEND', '30.00', 'Minimum Spend to Qualify For The Free Gift', '17', '1', '2007-08-08 15:24:50', '2007-08-07 19:16:00', null, null); INSERT INTO `configuration` VALUES ('ID', 'Free Gift Category', 'FREE_GIFT_CATEGORY', '96', 'The category that contains all of the potentially free items', '17', '2', '2007-08-11 11:02:05', '2007-08-07 19:16:00', 'tep_cfg_get_cat_name', 'tep_cfg_pull_down_cat_list('); Add Free Gift Orders Table CREATE TABLE `orders_freegift` ( `orders_freegift_id` int(11) NOT NULL auto_increment, `orders_id` int(11) default NULL, `products_id` int(11) default NULL, `products_model` varchar(12) default NULL, `products_name` varchar(64) default NULL, PRIMARY KEY (`orders_freegift_id`) ) TYPE=MyISAM; but when trying the first step adding configuration group is when i got the error. I have also had it when trying to add competition v1.2 Link to comment Share on other sites More sharing options...
spooks Posted November 27, 2008 Share Posted November 27, 2008 Check you dbase with phpMyAdmin Configuration Group should have 5 columns: configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible It would appear you have less than that!! Sam Remember, What you think I ment may not be what I thought I ment when I said it. Contributions: Auto Backup your Database, Easy way Multi Images with Fancy Pop-ups, Easy way Products in columns with multi buy etc etc Disable any Category or Product, Easy way Secure & Improve your account pages et al. Link to comment Share on other sites More sharing options...
wilma2 Posted November 27, 2008 Author Share Posted November 27, 2008 Check you dbase with phpMyAdmin Configuration Group should have 5 columns: configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible It would appear you have less than that!! #1136 - Column count doesn't match value count at row 1 I want to thank you for your help Sam. I appreciate it. But I have 7 the 5 you mention plus hiddentouser and hiddentoall Link to comment Share on other sites More sharing options...
spooks Posted November 27, 2008 Share Posted November 27, 2008 OH, WELL THATS JUST THE SAME. You must allow for all the columns so use: INSERT INTO `configuration_group` VALUES ('', 'Free Gift', 'Free Gift Configuration', '17', '1','',''); Sam Remember, What you think I ment may not be what I thought I ment when I said it. Contributions: Auto Backup your Database, Easy way Multi Images with Fancy Pop-ups, Easy way Products in columns with multi buy etc etc Disable any Category or Product, Easy way Secure & Improve your account pages et al. Link to comment Share on other sites More sharing options...
wilma2 Posted November 27, 2008 Author Share Posted November 27, 2008 OH, WELL THATS JUST THE SAME. You must allow for all the columns so use: INSERT INTO `configuration_group` VALUES ('', 'Free Gift', 'Free Gift Configuration', '17', '1','',''); That worked great Sam thank you. I see the difference is the "," at the end so I tried it with these 2 lines INSERT INTO `configuration` VALUES ('ID', 'Minimum Spend', 'FREE_GIFT_MINIMUM_SPEND', '30.00', 'Minimum Spend to Qualify For The Free Gift', '17', '1', '2007-08-08 15:24:50', '2007-08-07 19:16:00', null, null); INSERT INTO `configuration` VALUES ('ID', 'Free Gift Category', 'FREE_GIFT_CATEGORY', '96', 'The category that contains all of the potentially free items', '17', '2', '2007-08-11 11:02:05', '2007-08-07 19:16:00', 'tep_cfg_get_cat_name', 'tep_cfg_pull_down_cat_list('); but it did not work I got the same error msg. Link to comment Share on other sites More sharing options...
spooks Posted November 27, 2008 Share Posted November 27, 2008 Don't make stabs in the dark, you could mess your dbase Those have the correct number, so don't need the extra bits, BUT did you follow the instructions about the ID? Sam Remember, What you think I ment may not be what I thought I ment when I said it. Contributions: Auto Backup your Database, Easy way Multi Images with Fancy Pop-ups, Easy way Products in columns with multi buy etc etc Disable any Category or Product, Easy way Secure & Improve your account pages et al. Link to comment Share on other sites More sharing options...
wilma2 Posted November 27, 2008 Author Share Posted November 27, 2008 Don't make stabs in the dark, you could mess your dbase Those have the correct number, so don't need the extra bits, BUT did you follow the instructions about the ID? I did. Even wrote the number down everywere so i did not forget it But sadly got the same error Link to comment Share on other sites More sharing options...
spooks Posted November 28, 2008 Share Posted November 28, 2008 Check you dbase with phpMyAdmin Configuration has how many columns?, you must match that as per before. Sam Remember, What you think I ment may not be what I thought I ment when I said it. Contributions: Auto Backup your Database, Easy way Multi Images with Fancy Pop-ups, Easy way Products in columns with multi buy etc etc Disable any Category or Product, Easy way Secure & Improve your account pages et al. Link to comment Share on other sites More sharing options...
wilma2 Posted November 28, 2008 Author Share Posted November 28, 2008 Check you dbase with phpMyAdmin Configuration has how many columns?, you must match that as per before. Configuration has 14 but i looked and as an update to the contribution i found Please get the configuration_id that the db has generated, as it will be required for the next step! AND CHECK THE LASTconfiguration_id IN configuration AND add in LAST1 and LAST2 below. example your last number is 143, you add in 144 and 145. Please replace 'ID' with the id generated from stage 1 Add Configuration Items: INSERT INTO `configuration` VALUES ('LAST1', 'Minimum Spend', 'FREE_GIFT_MINIMUM_SPEND', '30.00', 'Minimum Spend to Qualify For The Free Gift', 'ID', '1', '2007-08-08 15:24:50', '2007-08-07 19:16:00', null, null); So does that mean for last1 i put 15 and in id I put the number from before? As that still kicked back the same error. Once again Sam thank you for your help it is appreciated. One day I hope to give back to the community and with your help I am getting there Link to comment Share on other sites More sharing options...
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.