OSaffiliate Mysql error ...pls help

gmfaizuddin · June 20, 2009

Hi, I had been trying to install OSaffiliate on OScommers 2.2.rc2a without any luck.

My problem is when i try to load the SQL file into my database i get this error..

==== Error===

SQL query:

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

);

MySQL said:

#1366 - Incorrect integer value: '' for column 'configuration_id' at row 1

-------------------------------------------------------------end------------------------

can some body educate me on this and help me solve this problem...pls

below is the data base im trying to load in mysql (this file came with the pack from the community....)

# $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_category_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 ;

My server details

windows vista x86...apache 2.2.11....php5+,....Mysql 5+,...ffmpeg,...flvtool2,....ioncube,....mencoder...imagemagic...phpmyadmin 2.2xx..."using no-ip service"

Pc...doual core...4gb ram...250gm hdd.

On this server I have tested all packages installation / working perfectly normal... (joomla latest, oscommerce latest, Gallary latest, phpnuke+oscnuke latest, phbb latest,Social Engine latest)

Except OSaffiliate....????????

This dame pack was tryed 2 years ago was working very good but now it is weiard.....doesnot work....(on apache 1.3, Php4, mysql 4, windows xp)

CAN SOME BODY PLS HELP ME.... Im not able to digest the fact it doesnot work.

I m not that good with codes...pls try and explain in detail...

Jan Zonjee · June 20, 2009

Hi, I had been trying to install OSaffiliate on OScommers 2.2.rc2a without any luck.

Of course this belongs more in a support thread of osCaffiliate (if there is one) or in the General contribution support forum for v2.2 but OK.

Try changing the '' to null in the statements that insert values in the table configuration (there are a number of them starting with this one):

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

to:

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

Since you get the error almost at the end of the installation the parts above that are likely done to the database. You better check that otherwise you get new errors :)

gmfaizuddin · June 20, 2009

Thank you for your responce it was very nice of you...i had been breaking my head off with this issue.....

Well any ways I took your advaise and did as you said.... This time i did not have that old problem but i have a new problem now. Mysql says

Error
SQL query:

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

MySQL said:

#1060 - Duplicate column name 'affiliate_category_id'

any advaice on this pls......

If you need to chat with me

Im on ... [email protected] or gmfaizuddin@hotmail or ( http://www.vipcoffeehut.com --and go for Customer Service- 24/7 help.) or offcource here too.

Thanx for all your help.

Jan Zonjee · June 20, 2009

This time i did not have that old problem but i have a new problem now. Mysql says

MySQL is right. This line should have been left out of the sql file:

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

because in the sql to create this table affiliate_category_id is already there.

You can ignore this error. You now only need to run the part that starts with:

DROP TABLE IF EXISTS `affiliate_news`;
CREATE TABLE `affiliate_news` (

Note that ff you run this sql file several times the same values that are inserted in the table configuration will be inserted again, and again, and again. Just that you know.

P.S. Do you like receiving spam by posting your email addresses here?

gmfaizuddin · June 20, 2009

ok...the next option phpmyadmin gives me is to go back.

how do i proceed further....can you pls give me more detail on it.

or can i remove that line and do a clean install of the sql file.....

ok Let me do the fresh install of sql file on a clean fresh OSC...

The site is still not live so i can delete and reinstall 100 time if it is needed.

I will be back in 10 mints

Thxs for yur help...

Lol...I cant edit my last post to remove the emails or links....hmmm????ok

Okkkkk much fater then i thought...i will get back...

it worked and all tables install good clean .....thx god...no no no...thank you....for the help...

i will come back after i try the other fils editing and let you know...

once again thx you very much for your support.

gmfaizuddin · June 21, 2009

Ok... Here I am.... I install the OSaffiliate core pack after the SQL install.

went to the admin area checked out the affiliates area every thing looked fine did some affeliates setup and logged out.

went to the main site ...on front end... clicked on every link ...they all worked fine

Finaly went in to register myself as an affiliate with a different ID...fill in all details then submit the form...the result is

1364 - Field 'affiliate_root' doesn't have a default value

insert into affiliate_affiliate (affiliate_firstname, affiliate_lastname, affiliate_email_address, affiliate_payment_check, affiliate_payment_paypal, affiliate_payment_bank_name, affiliate_payment_bank_branch_number, affiliate_payment_bank_swift_code, affiliate_payment_bank_account_name, affiliate_payment_bank_account_number, affiliate_street_address, affiliate_postcode, affiliate_city, affiliate_country_id, affiliate_telephone, affiliate_fax, affiliate_homepage, affiliate_password, affiliate_agb, affiliate_newsletter, affiliate_gender, affiliate_dob, affiliate_company, affiliate_company_taxid, affiliate_suburb, affiliate_zone_id, affiliate_state, affiliate_date_account_created, affiliate_lft, affiliate_rgt) values ('Gulam', 'Faizuddin', '[email protected]', '', '[email protected]', 'none', 'none', 'none', 'none', 'none', '123, 1st street', 't2y3y5', 'saanichton', '38', '1234567', '1234567', 'http://www.exelshare.com', 'fd4418c1fbffd82ec72ffcc70d801526:07', '1', '', 'm', '19581101', 'ABC', '123456789', 'non', '67', '', now(), '1', '2')

[TEP STOP]

1100 - Table 'sessions' was not locked with LOCK TABLES

select count(*) as total from sessions where sesskey = 'vno5iibj6rgi6d97o8eammfpc2'

[TEP STOP]

looks like mysql DB problem...what is it....can you throw some light on this issue pls.

Thanks for all your efforts to help me out.

gmfaizuddin · June 21, 2009

OK ....Boss

I have setup a temp site for your inspection.... you can check it...

Im sending you a PM with the details.... it is setup with OSCommerce + OSaffiliate. go and try it out if you want.

Thx

Jan Zonjee · June 21, 2009

looks like mysql DB problem...what is it....

In the table affiliate_affiliate there are a very large number of fields and in the insert query only part of the fields are mentioned. For the fields that are in the table but are not found in the query MySQL still needs to enter a value. If there is a default value then MySQL will use that. If there is no default value and the field is not in the query MySQL will complain like it does here.

So you can either change the query to include the field affiliate_root (one of the last fields in the table) or give it a default value of zero using phpMyAdmin. I'm not familiar with this contribution so don't know if that would be a problem causing unexpected consequences later if you use zero for a default value. Probably not but I can't know that.

Is this perhaps the support thread for this contribution?

gmfaizuddin · June 21, 2009

Thx Boss... I will try your suggetion and then see what happens and post it here.... i will also go through the section you suggested and if i can find a fix.... just peeped throught ..seem lot of em are stuck not only me....oooooo....let me see and get back to you

Thx for your help and support.

I will leave the test site on for now if you feel like playing arround go ahead and play...it is only loaded for you to plau if ever you need to play on...

Thx for now be back soon.

gmfaizuddin · June 21, 2009

Ok... Boss.. I am Back... Good News...

I follower Your advaice and changed the defatul values to "0"

I changed in 3 areas

affileat_affileat lft

affileat_affileat rht

affileat_affileat root

and gave it a try it just worked fine.....like it use to work with the old server pack about 1 and half year ago.

I just gave a quicl test run on the signup and lodin, then tested the admin area.... every thing looked as it was suppose to be...

Now i will give a try for 8 tiesrs like before and see what are the implications and let you know....

This 8 taier thingy is going to take long as i have to 8 X 3 and then slowly test it....so if im going to be late in reporting u have to excuse me.....

By the way i will leave the sample TEST site for you to have a feel if you want to....as i said you have the details in your mail box.

you can even get in touch with me from there.

Thank you very much for all your efferts in getting this going....we shall be in touch... and get to know each other more.

I will check back again to see if you have left any message for me.

bye for now

gmfaizuddin · June 21, 2009

Ok Boss noe there is a new problem, when i went to make banners it allowed me one banner and when i go for new banner again it give me this proble

1062 - Duplicate entry '2' for key 1

insert into affiliate_banners (affiliate_banners_title, affiliate_products_id, affiliate_category_id, affiliate_banners_image, affiliate_banners_group, affiliate_date_added, affiliate_status) values ('vip coffe hut 2', '29', '0', '2', '', now(), '1')

[TEP STOP]

any sugestions on this pls....

I cannot proceed further to test the module with out banners.

Thank you

Jan Zonjee · June 21, 2009

1062 - Duplicate entry '2' for key 1

This doesn't make sense. As you can see from the sql that builds the table for affiliate_banners the primary key is an auto-increment field. No clue.

gmfaizuddin · June 21, 2009

may be im doing some thing wrong....the fact is i have used this pack very succesfully in Jan 2008 after which i contributed to the community too....

The same pack is giveing me problem...i can belive it.... the problem is i dont remember how i did it..... let me see....i will give it a try and get back to you..

I want to contribute this pack to the comunity.... i have prepaired it....it came to over 3 MB so i decided to load the pack in Media fire and ask the comunity to download it from there.....

The pack contains...OSC2.2rc2a...+ OSCaffiliate full named it 2.8a " all done up ready to upload and login and try...+ detailed instruction with thanking you and Faaliyet + others. + a link to testshop for people to try it before they even install..+ my personel Live chat. I want to keep this module alive as i see no much of activity on it.

By the way the contributions after my contribution Jan 2008 do not work so i had to eleminate them from this pack. I will upload it and give it to people to try and come up with solution and keep checking it and fixing it.

Be back soon with good results, wish me luck and success.

gmfaizuddin · June 22, 2009

Ok...I did not do any thing wrong... i think there is some issue in the pack...

But i went inside the db and changed the ID 1 and preesed go...it accepted the change without any problem...

went back to the admin and started makeing banners and thing went on good....smooth....

But for some reason the banner pics when uploading it goes up the server and i get success result...

when i go and look for the pics which uploaded are not there...???????????????

in the db the location of the pic is stored correctly....

when i go into the affiliate area and go for links it gives me the links but no picture shown

so i guess it is PHP coeding problem.... do you want to take a look in the php coding and give me feed back?

let me know i will copy and past the affiliate_banner_banner.php file code.

Thank you for your help.

OSaffiliate Mysql error ...pls help

Recommended Posts

gmfaizuddin

Jan Zonjee

gmfaizuddin

Jan Zonjee

gmfaizuddin

gmfaizuddin

gmfaizuddin

Jan Zonjee

gmfaizuddin

gmfaizuddin

gmfaizuddin

Jan Zonjee

gmfaizuddin

gmfaizuddin

Archived

Browse

Activity