Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

OSC-Affiliate


henri

Recommended Posts

Yeah I'm still receiving the duplicate entry error durring checkout_process.php.

Sales data doesn't make it to affiliate sales table. Everything else works fine.

 

Just to be sure on this - the order ID being inserted should be the same as the customer order id right?

 

The install document say to place the affiliate_checkout_process like this.

 

 

// Include OSC-AFFILIATE

require(DIR_WS_INCLUDES . 'affiliate_checkout_process.php');

 

// load the before_process function from the payment modules

$payment_modules->before_process();

Link to comment
Share on other sites

// Include OSC-AFFILIATE

require(DIR_WS_INCLUDES . 'affiliate_checkout_process.php');

 

yes you need to add this before

 

// load the before_process function from the payment modules

$payment_modules->before_process();

 

in checkout_process.php

 

and no the order ID is not the customer ID its the $insert_id

Link to comment
Share on other sites

i hate to be a problem, but i have seen this addressed in the following posts and the fix was to redo everything. I cannot do this. The banners do not show up for me. I changed the value to 1 like the faq file says and it shows me where it is getting the image file from and it is correct( went to the image where it says it is getting it from and its there.http://cheapscript.net/os/images/banner1.gif

 

But no image. I tried to insert the sql that fixed for someone a couple pages back but get an error saying duplicate entry. So i must have the right set up but my banners do not show up.

 

Is it the size of the banner maybe?

 

Please take a look at http://cheapscript.net/os/affiliate_banners_banners.php

 

I also have the problem when you click on the banner it takes to a page not found error.

 

Please help with this.

 

Thanks

Link to comment
Share on other sites

// Include OSC-AFFILIATE

require(DIR_WS_INCLUDES . 'affiliate_checkout_process.php');

 

// load the before_process function from the payment modules

$payment_modules->before_process();

It says:

 

In checkout_process.php in the catalog directory find line

// load the after_process function from the payment modules

$payment_modules->after_process();

 

and insert before it

 

// Include OSC-AFFILIATE

require(DIR_WS_INCLUDES . 'affiliate_checkout_process.php');

Link to comment
Share on other sites

Does any one know why I am getting this on my Admin page. I have applied the update to 2.02 and it cleared up some of them but some still remain. Any ideas?

 

osCommerce 

BOX_ENTRY_SUPPORT_SITE

BOX_ENTRY_SUPPORT_FORUMS

BOX_ENTRY_MAILING_LISTS

BOX_ENTRY_BUG_REPORTS

BOX_ENTRY_FAQ

BOX_ENTRY_LIVE_DISCUSSIONS

BOX_ENTRY_CVS_REPOSITORY

BOX_ENTRY_INFORMATION_PORTAL

 

Reports

REPORTS_PRODUCTS, REPORTS_ORDERS

 

Thanks

Link to comment
Share on other sites

and no the order ID is not the customer ID its the $insert_id

 

So the order id is not the customer "order id" I gues that's where I'm getting confused. The only way I can get this to work is if I change the structure of the affiliate_order_id to "AUTO_INCREMENT"

 

If I do this it works like a charm but I was figuring it was connected to the customers order number.

Link to comment
Share on other sites

So the order id is not the customer "order id" I gues that's where I'm getting confused. The only way I can get this to work is if I change the structure of the affiliate_order_id to "AUTO_INCREMENT"

Then the affiliate should not work.

Have you read my reply?

Link to comment
Share on other sites

Then the affiliate should not work.

Have you read my reply?

Henery,

 

Correct, I read your post on where the // Include OSC-AFFILIATE should be placed.

 

In checkout_process.php in the catalog directory find line

// load the after_process function from the payment modules

$payment_modules->after_process();

 

load it before that line...

 

Sorry My mistake for posting the wrong location. Too much coffee or something I've changed that and yet it still proceeds to give me the insert error.

 

Before testing I removed all data in the sales table.

 

ON my second order I received the insert error ...

Edited by k-sea
Link to comment
Share on other sites

Then the affiliate should not work.

Have you read my reply?

Henery,

 

Correct, I read your post on where the // Include OSC-AFFILIATE should be placed.

 

In checkout_process.php in the catalog directory find line

// load the after_process function from the payment modules

$payment_modules->after_process();

 

load it before that line...

 

Sorry My mistake for posting the wrong location. Too much coffee or something I've changed that and yet it still proceeds to give me the insert error.

 

Before testing I removed all data in the sales table.

 

ON my second order I received the insert error ...

Never mind... It's working... With this first snow fall in vermont my brain was focused on snowboarding and not code modifcations...

 

I had oscommerce in two directories on my computer and when I changed the checkout_process.php file it was the wrong one.

 

OSCAffiliate is now working 100%! Even worked with 2checkout so I'm happy.

 

Thank you "henri" and "snowman" for your assistance.

Link to comment
Share on other sites

HI, did a full re install of osc affiliate and still same problem banners do not show. and when you click the broken image link it takes you to a page not found.

 

Help pleeeeeeeeeeeeaaaaaaaaaaaaasssssssssssseeeeeeeeeeee :(

Link to comment
Share on other sites

1044 - Access denied for user: 'xxxx_xxxxx@localhost' to database 'xxxxx_xxxxx'

 

I have gotten this message trying to install this script. I have read where it says to remove to lock/unlock params in the script, but which script, what file and where?

 

 

Any help would be great.

 

Thanks,

 

Jeff

Link to comment
Share on other sites

HI, did a full re install of osc affiliate and still same problem banners do not show. and when you click the broken image link it takes you to a page not found.

 

Help pleeeeeeeeeeeeaaaaaaaaaaaaasssssssssssseeeeeeeeeeee :(

Dont know why youre not seeing them, your script is displaying the banners fine and linking to your website.

Link to comment
Share on other sites

Does any one know why I am getting this on my Admin page. I have applied the update to 2.02 and it cleared up some of them but some still remain. Any ideas?

 

osCommerce?

BOX_ENTRY_SUPPORT_SITE

BOX_ENTRY_SUPPORT_FORUMS

BOX_ENTRY_MAILING_LISTS

BOX_ENTRY_BUG_REPORTS

BOX_ENTRY_FAQ

BOX_ENTRY_LIVE_DISCUSSIONS

BOX_ENTRY_CVS_REPOSITORY

BOX_ENTRY_INFORMATION_PORTAL

 

Reports

REPORTS_PRODUCTS, REPORTS_ORDERS

 

Thanks

You havent applied all the language changes. double check the readme and the files that you have uploaded.

Link to comment
Share on other sites

HI, Snowman and thanks for responding.

 

You are saying that you see the affiliate banners on my site? This is very wierd i see a broken image when i try to go to banner links in my affiliate test account. it displays a broken image and when i click the broken image it goes to a page not found.

 

PLease sign for a affiliate test account and go to banner links and see if it displays a banner that you can use and see if it works. This would help out allot.

 

 

Thanks for your help

Link to comment
Share on other sites

1044 - Access denied for user: 'xxxx_xxxxx@localhost' to database 'xxxxx_xxxxx'

 

I have gotten this message trying to install this script. I have read where it says to remove to lock/unlock params in the script, but which script, what file and where?

 

Any update on this?

 

Thanks,

 

Jeff

Link to comment
Share on other sites

Just a quick question about this mod.

Cos it goes on for 70+ pages now, it makes it kinda hard to find things...

 

Anyway, has there been an issue in regards to the password forgotten section not working?

 

When testing it, if someone forgot their password and went thru the Forgotten your password link, then it DID issue and email with the new password, but the password it sent out on email doesnt work when you try to login with it.

 

I have tried this a dozen times to see if it is just me, but whenever I try there is definately a problem.

The new password is not recognised and the user can not get in.

 

Anyone else heard of this, and was there a fix anywhere in this thread if it is a known bug?

 

ta.

Link to comment
Share on other sites

HI, Snowman and thanks for responding.

 

You are saying that you see the affiliate banners on my site? This is very wierd i see a broken image when i try to go to banner links in my affiliate test account. it displays a broken image and when i click the broken image it goes to a page not found.

 

PLease sign for a affiliate test account and go to banner links and see if it displays a banner that you can use and see if it works. This would help out allot.

 

 

Thanks for your help

<a href="http://cheapscript.net/os/index.php?ref=1&affiliate_banner_id=2" target="_blank"><img src="http://cheapscript.net/os/images/banner1.gif" border="0" alt="1"></a>

 

is the code you displayed and that code is working fine, however that is not the code that the generator builds in the configuration you have.

 

<a href="http://cheapscript.net/os/index.php?ref=2&affiliate_banner_id=2" target="_blank"><img src="http://cheapscript.net/os/affiliate_show_banner.php?ref=2&affiliate_banner_id=2" border="0" alt="banner4"></a>

 

is for the banner that you have setup and if you load the mage portion of that code you will see its loading fine.

 

So therefore the error is probably in your stores configuration files. Make sure you have the latest bugfix of the module loaded, and that you edited the paths to the images correctly.

 

Try setting the image debug in the affiliate_configure.php file to tru and see what the result is. This should give you the answer you need to fix that issue

Link to comment
Share on other sites

1044 - Access denied for user: 'xxxx_xxxxx@localhost' to database 'xxxxx_xxxxx'

 

I have gotten this message trying to install this script. I have read where it says to remove to lock/unlock params in the script, but which script, what file and where?

 

Any update on this?

 

Thanks,

 

Jeff

You have the files affiliate files loaded? yes?

 

Have you logged into your databse using phpMyadmin or similar and loaded the sql data into your stores dataase???

Link to comment
Share on other sites

Just a quick question about this mod.

Cos it goes on for 70+ pages now, it makes it kinda hard to find things...

 

Anyway, has there been an issue in regards to the password forgotten section not working?

 

When testing it, if someone forgot their password and went thru the Forgotten your password link, then it DID issue and email with the new password, but the password it sent out on email doesnt work when you try to login with it.

 

I have tried this a dozen times to see if it is just me, but whenever I try there is definately a problem.

The new password is not recognised and the user can not get in.

 

Anyone else heard of this, and was there a fix anywhere in this thread if it is a known bug?

 

ta.

This bug is fixed in the v2.0 release.

 

what version are you running?

Link to comment
Share on other sites

1044 - Access denied for user: 'xxxx_xxxxx@localhost' to database 'xxxxx_xxxxx'

 

I have gotten this message trying to install this script. I have read where it says to remove to lock/unlock params in the script, but which script, what file and where?

 

Any update on this?

 

Thanks,

 

Jeff

You have the files affiliate files loaded? yes?

 

Have you logged into your databse using phpMyadmin or similar and loaded the sql data into your stores dataase???

Yes I have. and it still isnt working.

Link to comment
Share on other sites

This bug is fixed in the v2.0 release.

 

what version are you running?

I am trying out version 1.9 I think it is.

 

Our site is built on CVS from Nov 2002, so I am a little uncertain whether or not vs 2.0 of OSC-Affiliate would work or not...

 

Bit of a pain really, cos I need to get the password issue working or it will cause problems in the future.

 

I see you recommend not using vs 2.0 with older snapshots.

Is this still the case?

 

Or do you know what is the cause of the problem?

I can then maybe look to fix it.

Edited by CC
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...