sunny123 Posted September 27, 2008 Share Posted September 27, 2008 Hi I ran contrib_tracker.sql and it had the following errors 14th line contrib_support VARCHAR( 55 ) NULL ; The semi Colon needed to be changed to comma. Easy fixed but the following doesn't make sense: INSERT INTO contrib_tracker( contr_id, contrib_osc_id, contrib_name, contrib_link, config_comments, STATUS , date_status_change, note_created, contr_last_modified, last_update, contrib_vers ) VALUES ( '', '4815', 'Contribution Tracker Now Installed', 'http://addons.oscommerce.com/info/4815', 'Congratulations! Contribution Tracker now installed! You may now delete this Contribution or use it to play around with and get the feel of your new osC contribution.', 1, '0000-00-00 00:00:00', '2005-04-15 12:55:45', '2005-04-15 12:55:45', '2005-04-15', '1.6.6e' ); MySQL said: #1054 - Unknown column 'date_status_change' in 'field list' date_status_change is not a field in contrib_tracker table and date_status_change table has not been created. I ran Contrib Tracker v1.7.3d. Help in solving my issue would be much appreciated as I plan to load many contrib's and this contrib will make managing updates alot easier. Regards Sunny123 Quote Link to comment Share on other sites More sharing options...
♥geoffreywalton Posted September 27, 2008 Share Posted September 27, 2008 Check that column date_status_change is in the sql and is now in the table. Should STATUS be capitalised? Might be an idea to post all the sql. DROP TABLE IF EXISTS contrib_tracker; CREATE TABLE contrib_tracker ( contr_id int(11) NOT NULL auto_increment, contrib_name varchar(255) NOT NULL default '', contrib_link varchar(255) default '', config_comments longtext, status tinyint(1) NOT NULL default '2', [b]date_status_change[/b] datetime NOT NULL default '0000-00-00 00:00:00', note_created datetime NOT NULL default '0000-00-00 00:00:00', contr_last_modified datetime NOT NULL default '0000-00-00 00:00:00', last_update datetime NOT NULL default '0000-00-00 00:00:00', contrib_vers varchar(5) default '', KEY config_id (contr_id) ) TYPE=MyISAM; INSERT INTO contrib_tracker (contr_id, contrib_name,contrib_link, config_comments, status, date_status_change, note_created, contr_last_modified, last_update,contrib_vers) VALUES ('','Contribution Tracker Now Installed','http://addons.oscommerce.com/info/4815', 'Congratulations! Contribution Tracker now installed! You may now delete this Contribution or use it to play around with and get the feel of your new osC contribution.', 1, '0000-00-00 00:00:00', '2005-04-15 12:55:45', '2005-04-15 12:55:45', '2005-04-15','1.4'); INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added) values ('', 'Last Contrib Check', 'LAST_CONFIG_CHECK', '', 'Last time checked the OSCommerce official contribution site. ', '0', '50', '2006-03-19 10:57:09', now()); Quote Need help installing add ons/contributions, cleaning a hacked site or a bespoke development, check my profile Virus Threat Scanner My Contributions Basic install answers. Click here for Contributions / Add Ons. UK your site. Site Move. Basic design info. For links mentioned in old answers that are no longer here follow this link Useful Threads. If this post was useful, click the Like This button over there ======>>>>>. 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.