defender39 Posted October 21, 2003 Share Posted October 21, 2003 Not sure if anyone cares but in OSC-Affiliate 1.01 for MS1 there is a missing line in the /admin/includes/affiliate_configure.php define ('AFFILATE_INDIVIDUAL_PERCENTAGE' , 'true'); This allows for the admin to set individual rates. Quote Link to comment Share on other sites More sharing options...
k-sea Posted October 21, 2003 Share Posted October 21, 2003 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(); Quote Link to comment Share on other sites More sharing options...
Snowman Posted October 22, 2003 Share Posted October 22, 2003 // 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 Quote Link to comment Share on other sites More sharing options...
Guest Posted October 22, 2003 Share Posted October 22, 2003 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 Quote Link to comment Share on other sites More sharing options...
henri Posted October 22, 2003 Author Share Posted October 22, 2003 // 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'); Quote Link to comment Share on other sites More sharing options...
Guest Posted October 22, 2003 Share Posted October 22, 2003 This is what code is generated from the affiliate banner script <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> Quote Link to comment Share on other sites More sharing options...
fyrfyt Posted October 22, 2003 Share Posted October 22, 2003 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 Quote Link to comment Share on other sites More sharing options...
k-sea Posted October 22, 2003 Share Posted October 22, 2003 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. Quote Link to comment Share on other sites More sharing options...
Guest Posted October 23, 2003 Share Posted October 23, 2003 Hello, will somebody please help with the above banner problem, I have search everywhere and the fixes dont help me. :( Quote Link to comment Share on other sites More sharing options...
henri Posted October 23, 2003 Author Share Posted October 23, 2003 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? Quote Link to comment Share on other sites More sharing options...
k-sea Posted October 23, 2003 Share Posted October 23, 2003 (edited) 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 October 23, 2003 by k-sea Quote Link to comment Share on other sites More sharing options...
k-sea Posted October 23, 2003 Share Posted October 23, 2003 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. Quote Link to comment Share on other sites More sharing options...
manuva Posted October 24, 2003 Share Posted October 24, 2003 thanks to snowman for the help also. Quote Link to comment Share on other sites More sharing options...
Guest Posted October 24, 2003 Share Posted October 24, 2003 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 :( Quote Link to comment Share on other sites More sharing options...
aceclimber Posted October 25, 2003 Share Posted October 25, 2003 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 Quote Link to comment Share on other sites More sharing options...
Snowman Posted October 25, 2003 Share Posted October 25, 2003 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. Quote Link to comment Share on other sites More sharing options...
Snowman Posted October 25, 2003 Share Posted October 25, 2003 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. Quote Link to comment Share on other sites More sharing options...
Guest Posted October 25, 2003 Share Posted October 25, 2003 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 Quote Link to comment Share on other sites More sharing options...
aceclimber Posted October 25, 2003 Share Posted October 25, 2003 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 Quote Link to comment Share on other sites More sharing options...
CC Posted October 26, 2003 Share Posted October 26, 2003 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. Quote Link to comment Share on other sites More sharing options...
Snowman Posted October 26, 2003 Share Posted October 26, 2003 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 Quote Link to comment Share on other sites More sharing options...
Snowman Posted October 26, 2003 Share Posted October 26, 2003 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??? Quote Link to comment Share on other sites More sharing options...
Snowman Posted October 26, 2003 Share Posted October 26, 2003 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? Quote Link to comment Share on other sites More sharing options...
aceclimber Posted October 26, 2003 Share Posted October 26, 2003 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. Quote Link to comment Share on other sites More sharing options...
CC Posted October 26, 2003 Share Posted October 26, 2003 (edited) 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 October 26, 2003 by CC Quote 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.