Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

errors with affiliate module


Recommended Posts

I hope someone can help. My site is http://bgsoycandle.com/ecommerce/os/catalog/.

The very first page looks fine. The box with the affiliate info is there, just like it's supposed to be. But when I click on the links, I get errors.

 

Affiliate Information

Warning: main(includes/languages/english/affiliate_info.php): failed to open stream: No such file or directory in /home/bgsoycan/public_html/ecommerce/os/catalog/affiliate_info.php on line 18

 

Warning: main(includes/languages/english/affiliate_info.php): failed to open stream: No such file or directory in /home/bgsoycan/public_html/ecommerce/os/catalog/affiliate_info.php on line 18

 

Fatal error: main(): Failed opening required 'includes/languages/english/affiliate_info.php' (include_path='.:/usr/local/lib/php') in /home/bgsoycan/public_html/ecommerce/os/catalog/affiliate_info.php on line 18

Affiliate Program FAQ

Warning: main(includes/languages/english/affiliate_faq.php): failed to open stream: No such file or directory in /home/bgsoycan/public_html/ecommerce/os/catalog/affiliate_faq.php on line 19

 

Warning: main(includes/languages/english/affiliate_faq.php): failed to open stream: No such file or directory in /home/bgsoycan/public_html/ecommerce/os/catalog/affiliate_faq.php on line 19

 

Fatal error: main(): Failed opening required 'includes/languages/english/affiliate_faq.php' (include_path='.:/usr/local/lib/php') in /home/bgsoycan/public_html/ecommerce/os/catalog/affiliate_faq.php on line 19

 

Affiliate Log In actually goes to a page, but when I click on continue to sign up, I get this error

Warning: main(includes/languages/english/affiliate_signup.php): failed to open stream: No such file or directory in /home/bgsoycan/public_html/ecommerce/os/catalog/affiliate_signup.php on line 19

 

Warning: main(includes/languages/english/affiliate_signup.php): failed to open stream: No such file or directory in /home/bgsoycan/public_html/ecommerce/os/catalog/affiliate_signup.php on line 19

 

Fatal error: main(): Failed opening required 'includes/languages/english/affiliate_signup.php' (include_path='.:/usr/local/lib/php') in /home/bgsoycan/public_html/ecommerce/os/catalog/affiliate_signup.php on line 19

 

I have been over and over the files, have changed the permissions, etc. etc.

Any suggestions, please?

Joyce

Link to comment
Share on other sites

Also, I don't know how to add the tables in MYSQL. I now have errors in admin and I cannot see any of the tings I'm supposed to see in admin.

1146 - Table 'bgsoycan_p_os2.affiliate_sales' doesn't exist

 

select count(*) as count, sum(affiliate_value) as total, sum(affiliate_payment) as payment from affiliate_sales

 

[TEP STOP]

 

I'm thinking the above error is because of the mysql tables not being added? Please, how do I do this?

Joyce

Link to comment
Share on other sites

you must use phpmyadmin or mysql connector, depending upon what your host offers you. if you have a cpanel you can click on mysql and there is a link to phpmyadmin there.

Link to comment
Share on other sites

you must use phpmyadmin or mysql connector, depending upon what your host offers you.  if you have a cpanel you can click on mysql and there is a link to phpmyadmin there.

 

In the affiliate 2.5a intstall guide, it says this:

MySQL ALTERATIONS

 

Insert the new tables found in the affiliate.sql file into your osCommerce catalog database.

 

I'm not quite sure where or how to do this.

 

This is the affiliate.sql file:

# $Id: affiliate.sql,v 1.20 2003/07/12 13:13:38 simarilius Exp $

#

# OSC-Affiliate

#

# Contribution based on:

#

# osCommerce, Open Source E-Commerce Solutions

# http://www.oscommerce.com

#

# Copyright © 2002 - 2003 osCommerce

#

# Released under the GNU General Public License

#

# NOTE: * Please make any modifications to this file by hand!

#      * DO NOT use a mysqldump created file for new changes!

#      * Please take note of the table structure, and use this

#        structure as a standard for future modifications!

#      * Any tables you add here should be added in admin/backup.php

#        and in catalog/install/includes/functions/database.php

#      * To see the 'diff'erence between MySQL databases, use

#        the mysqldiff perl script located in the extras

#        directory of the 'catalog' module.

#      * Comments should be like these, full line comments.

#        (don't use inline comments)

 

DROP TABLE IF EXISTS affiliate_affiliate;

CREATE TABLE affiliate_affiliate (

  affiliate_id int(11) NOT NULL auto_increment,

  affiliate_gender char(1) NOT NULL default '',

  affiliate_firstname varchar(32) NOT NULL default '',

  affiliate_lastname varchar(32) NOT NULL default '',

  affiliate_dob datetime NOT NULL default '0000-00-00 00:00:00',

  affiliate_email_address varchar(96) NOT NULL default '',

  affiliate_telephone varchar(32) NOT NULL default '',

  affiliate_fax varchar(32) NOT NULL default '',

  affiliate_password varchar(40) NOT NULL default '',

  affiliate_homepage varchar(96) NOT NULL default '',

  affiliate_street_address varchar(64) NOT NULL default '',

  affiliate_suburb varchar(64) NOT NULL default '',

  affiliate_city varchar(32) NOT NULL default '',

  affiliate_postcode varchar(10) NOT NULL default '',

  affiliate_state varchar(32) NOT NULL default '',

  affiliate_country_id int(11) NOT NULL default '0',

  affiliate_zone_id int(11) NOT NULL default '0',

  affiliate_agb tinyint(4) NOT NULL default '0',

  affiliate_company varchar(60) NOT NULL default '',

  affiliate_company_taxid varchar(64) NOT NULL default '',

  affiliate_commission_percent DECIMAL(4,2) NOT NULL default '0.00',

  affiliate_payment_check varchar(100) NOT NULL default '',

  affiliate_payment_paypal varchar(64) NOT NULL default '',

  affiliate_payment_bank_name varchar(64) NOT NULL default '',

  affiliate_payment_bank_branch_number varchar(64) NOT NULL default '',

  affiliate_payment_bank_swift_code varchar(64) NOT NULL default '',

  affiliate_payment_bank_account_name varchar(64) NOT NULL default '',

  affiliate_payment_bank_account_number varchar(64) NOT NULL default '',

  affiliate_date_of_last_logon datetime NOT NULL default '0000-00-00 00:00:00',

  affiliate_number_of_logons int(11) NOT NULL default '0',

  affiliate_date_account_created datetime NOT NULL default '0000-00-00 00:00:00',

  affiliate_date_account_last_modified datetime NOT NULL default '0000-00-00 00:00:00',

  affiliate_lft int(11) NOT NULL,

  affiliate_rgt int(11) NOT NULL,

  affiliate_root int(11) NOT NULL,

  affiliate_newsletter char(1) NOT NULL default '1',

  PRIMARY KEY (affiliate_id)

);

 

DROP TABLE IF EXISTS affiliate_banners;

CREATE TABLE affiliate_banners (

  affiliate_banners_id int(11) NOT NULL auto_increment,

  affiliate_banners_title varchar(64) NOT NULL default '',

  affiliate_products_id int(11) NOT NULL default '0',

  affiliate_banners_image varchar(64) NOT NULL default '',

  affiliate_banners_group varchar(10) NOT NULL default '',

  affiliate_banners_html_text text,

  affiliate_expires_impressions int(7) default '0',

  affiliate_expires_date datetime default NULL,

  affiliate_date_scheduled datetime default NULL,

  affiliate_date_added datetime NOT NULL default '0000-00-00 00:00:00',

  affiliate_date_status_change datetime default NULL,

  affiliate_status int(1) NOT NULL default '1',

  PRIMARY KEY  (affiliate_banners_id)

);

 

DROP TABLE IF EXISTS affiliate_banners_history;

CREATE TABLE affiliate_banners_history (

  affiliate_banners_history_id int(11) NOT NULL auto_increment,

  affiliate_banners_products_id int(11) NOT NULL default '0',

  affiliate_banners_id int(11) NOT NULL default '0',

  affiliate_banners_affiliate_id int(11) NOT NULL default '0',

  affiliate_banners_shown int(11) NOT NULL default '0',

  affiliate_banners_clicks tinyint(4) NOT NULL default '0',

  affiliate_banners_history_date date NOT NULL default '0000-00-00',

  PRIMARY KEY  (affiliate_banners_history_id,affiliate_banners_products_id)

);

 

DROP TABLE IF EXISTS affiliate_clickthroughs;

CREATE TABLE affiliate_clickthroughs (

  affiliate_clickthrough_id int(11) NOT NULL auto_increment,

  affiliate_id int(11) NOT NULL default '0',

  affiliate_clientdate datetime NOT NULL default '0000-00-00 00:00:00',

  affiliate_clientbrowser varchar(200) default 'Could Not Find This Data',

  affiliate_clientip varchar(50) default 'Could Not Find This Data',

  affiliate_clientreferer varchar(200) default 'none detected (maybe a direct link)',

  affiliate_products_id int(11) default '0',

  affiliate_banner_id int(11) NOT NULL default '0',

  PRIMARY KEY  (affiliate_clickthrough_id),

  KEY refid (affiliate_id)

);

 

DROP TABLE IF EXISTS affiliate_news;

CREATE TABLE `affiliate_news` (

  `news_id` int(11) NOT NULL auto_increment,

  `headline` varchar(255) NOT NULL default '',

  `content` text NOT NULL,

  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',

  `STATUS` tinyint(1) NOT NULL default '0',

  PRIMARY KEY  (`news_id`)

) TYPE=MyISAM AUTO_INCREMENT=3 ;

 

DROP TABLE IF EXISTS affiliate_newsletters;

CREATE TABLE `affiliate_newsletters` (

  `affiliate_newsletters_id` int(11) NOT NULL auto_increment,

  `title` varchar(255) NOT NULL default '',

  `content` text NOT NULL,

  `module` varchar(255) NOT NULL default '',

  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',

  `date_sent` datetime default NULL,

  `status` int(1) default NULL,

  `locked` int(1) default '0',

  PRIMARY KEY  (`affiliate_newsletters_id`)

) TYPE=MyISAM AUTO_INCREMENT=1 ;

 

DROP TABLE IF EXISTS affiliate_payment;

CREATE TABLE affiliate_payment (

  affiliate_payment_id int(11) NOT NULL auto_increment,

  affiliate_id int(11) NOT NULL default '0',

  affiliate_payment decimal(15,2) NOT NULL default '0.00',

  affiliate_payment_tax decimal(15,2) NOT NULL default '0.00',

  affiliate_payment_total decimal(15,2) NOT NULL default '0.00',

  affiliate_payment_date datetime NOT NULL default '0000-00-00 00:00:00',

  affiliate_payment_last_modified datetime NOT NULL default '0000-00-00 00:00:00',

  affiliate_payment_status int(5) NOT NULL default '0',

  affiliate_firstname varchar(32) NOT NULL default '',

  affiliate_lastname varchar(32) NOT NULL default '',

  affiliate_street_address varchar(64) NOT NULL default '',

  affiliate_suburb varchar(64) NOT NULL default '',

  affiliate_city varchar(32) NOT NULL default '',

  affiliate_postcode varchar(10) NOT NULL default '',

  affiliate_country varchar(32) NOT NULL default '0',

  affiliate_company varchar(60) NOT NULL default '',

  affiliate_state varchar(32) NOT NULL default '0',

  affiliate_address_format_id int(5) NOT NULL default '0',

  affiliate_last_modified datetime NOT NULL default '0000-00-00 00:00:00',

  PRIMARY KEY  (affiliate_payment_id)

);

 

DROP TABLE IF EXISTS affiliate_payment_status;

CREATE TABLE affiliate_payment_status (

  affiliate_payment_status_id int(11) NOT NULL default '0',

  affiliate_language_id int(11) NOT NULL default '1',

  affiliate_payment_status_name varchar(32) NOT NULL default '',

  PRIMARY KEY  (affiliate_payment_status_id,affiliate_language_id),

  KEY idx_affiliate_payment_status_name (affiliate_payment_status_name)

);

 

DROP TABLE IF EXISTS affiliate_payment_status_history;

CREATE TABLE affiliate_payment_status_history (

  affiliate_status_history_id int(11) NOT NULL auto_increment,

  affiliate_payment_id int(11) NOT NULL default '0',

  affiliate_new_value int(5) NOT NULL default '0',

  affiliate_old_value int(5) default NULL,

  affiliate_date_added datetime NOT NULL default '0000-00-00 00:00:00',

  affiliate_notified int(1) default '0',

  PRIMARY KEY  (affiliate_status_history_id)

);

 

DROP TABLE IF EXISTS affiliate_sales;

CREATE TABLE affiliate_sales (

  affiliate_id int(11) NOT NULL default '0',

  affiliate_date datetime NOT NULL default '0000-00-00 00:00:00',

  affiliate_browser varchar(100) NOT NULL default '',

  affiliate_ipaddress varchar(20) NOT NULL default '',

  affiliate_orders_id int(11) NOT NULL default '0',

  affiliate_value decimal(15,2) NOT NULL default '0.00',

  affiliate_payment decimal(15,2) NOT NULL default '0.00',

  affiliate_clickthroughs_id int(11) NOT NULL default '0',

  affiliate_billing_status int(5) NOT NULL default '0',

  affiliate_payment_date datetime NOT NULL default '0000-00-00 00:00:00',

  affiliate_payment_id int(11) NOT NULL default '0',

  affiliate_percent  DECIMAL(4,2)  NOT NULL default '0.00',

  affiliate_salesman int(11) NOT NULL default '0',

  PRIMARY KEY  (affiliate_orders_id,affiliate_id)

);

 

INSERT INTO affiliate_payment_status VALUES (0, 1, 'Pending');

INSERT INTO affiliate_payment_status VALUES (1, 1, 'Paid');

 

 

INSERT INTO configuration_group VALUES (900, 'Affiliate Program', 'Options for the Affiliate Program', 50, 1);

INSERT INTO configuration VALUES ('','E-Mail Address', 'AFFILIATE_EMAIL_ADDRESS', '<[email protected]>', 'The E Mail Address for the Affiliate Program', 900, 1, NULL, now(), NULL, NULL);

INSERT INTO configuration VALUES ('','Affiliate Pay Per Sale Payment % Rate', 'AFFILIATE_PERCENT', '10.0000', 'Percentage Rate for the Affiliate Program', 900, 2, NULL, now(), NULL, NULL);

INSERT INTO configuration VALUES ('','Payment Threshold', 'AFFILIATE_THRESHOLD', '50.00', 'Payment Threshold for paying affiliates', 900, 3, NULL, now(), NULL, NULL);

INSERT INTO configuration VALUES ('','Cookie Lifetime', 'AFFILIATE_COOKIE_LIFETIME', '7200', 'How long does the click count (seconds) if customer comes back', 900, 4, NULL, now(), NULL, NULL);

INSERT INTO configuration VALUES ('','Billing Time', 'AFFILIATE_BILLING_TIME', '30', 'Orders billed must be at least "30" days old.<br>This is needed if a order is refunded', 900, 5, NULL, now(), NULL, NULL);

INSERT INTO configuration VALUES ('','Order Min Status', 'AFFILIATE_PAYMENT_ORDER_MIN_STATUS', '3', 'The status an order must have at least, to be billed', 900, 6, NULL, now(), NULL, NULL);

INSERT INTO configuration VALUES ('','Pay Affiliates with check', 'AFFILIATE_USE_CHECK', 'true', 'Pay Affiliates with check', 900, 7, NULL, now(), NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ');

INSERT INTO configuration VALUES ('','Pay Affiliates with PayPal', 'AFFILIATE_USE_PAYPAL', 'true', 'Pay Affiliates with PayPal', 900, 8, NULL, now(), NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ');

INSERT INTO configuration VALUES ('','Pay Affiliates by Bank', 'AFFILIATE_USE_BANK', 'true', 'Pay Affiliates by Bank', 900, 9, NULL, now(), NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ');

INSERT INTO configuration VALUES ('','Individual Affiliate Percentage', 'AFFILATE_INDIVIDUAL_PERCENTAGE', 'true', 'Allow per Affiliate provision', 900, 10, NULL, now(), NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ');

INSERT INTO configuration VALUES ('','Use Affiliate-tier' , 'AFFILATE_USE_TIER', 'false', 'Multilevel Affiliate provisions', 900, 11, NULL, now(), NULL,'tep_cfg_select_option(array(\'true\', \'false\'), ');

INSERT INTO configuration VALUES ('','Number of Tierlevels', 'AFFILIATE_TIER_LEVELS', '0', 'Number of Tierlevels', 900, 12, NULL, now(), NULL, NULL);

INSERT INTO configuration VALUES ('','Percentage Rate for the Tierlevels', 'AFFILIATE_TIER_PERCENTAGE', '8.00;5.00;1.00', 'Percent Rates for the tierlevels<br>Example: 8.00;5.00;1.00', 900, 13, NULL, now(), NULL, NULL);

INSERT INTO configuration VALUES ('','Affiliate News', 'MAX_DISPLAY_AFFILIATE_NEWS', '3', 'Maximum number of items to display on the Affiliate News page', 900, 14,  NULL, now(), NULL, NULL);

ALTER TABLE `affiliate_banners` ADD `affiliate_category_id` INT DEFAULT '0' NOT NULL AFTER `affiliate_products_id` ;

 

 

DROP TABLE IF EXISTS `affiliate_news`;

CREATE TABLE `affiliate_news` (

  `news_id` int(11) NOT NULL auto_increment,

  `date_added` datetime NOT NULL default '0000-00-00 00:00:00',

  `news_status` tinyint(1) NOT NULL default '0',

  PRIMARY KEY  (`news_id`)

) TYPE=MyISAM AUTO_INCREMENT=1 ;

 

 

# Tabellenstruktur f?r Tabelle `affiliate_news_contents`

#

 

DROP TABLE IF EXISTS `affiliate_news_contents`;

CREATE TABLE `affiliate_news_contents` (

  `affiliate_news_contents_id` int(11) NOT NULL auto_increment,

  `affiliate_news_id` int(11) NOT NULL default '0',

  `affiliate_news_languages_id` int(11) NOT NULL default '0',

  `affiliate_news_headlines` varchar(255) NOT NULL default '',

  `affiliate_news_contents` text NOT NULL,

  PRIMARY KEY  (`affiliate_news_contents_id`),

  KEY `affiliate_news_id` (`affiliate_news_id`),

  KEY `affiliate_news_languages_id` (`affiliate_news_languages_id`)

) TYPE=MyISAM AUTO_INCREMENT=1 ;

 

Do I create a new database in phpmyadmin? Or do I add to my existing one? Or do I add these tables to another file, then upload via ftp?

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...