Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

contrib_tracker.sql failed


sunny123

Recommended Posts

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

Link to comment
Share on other sites

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());

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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...