hobbzilla Posted August 11, 2004 Author Share Posted August 11, 2004 David: That would be fairly easy.. my only question would be "Why" ?? Do you really want the customer changing their mind about where they found out about the site after they already registered??? This script IMHO could be much better served for a "referral" program as asked about previously in this thread upon each and every checkout. Tied with an affiliate program to give commissioned sales. (That is what we do here at work.. only I don't use this -- I use my vendor distance locator contrib). Quote Link to comment Share on other sites More sharing options...
dasaro Posted August 11, 2004 Share Posted August 11, 2004 That is a drawback I had not considered. My only reasoning for such a change is so customers who registered before I added this can still enter their referral source. Granted, it's only 25 customers, but I'd still like to know what advertising has worked best so far. Quote Link to comment Share on other sites More sharing options...
hobbzilla Posted August 11, 2004 Author Share Posted August 11, 2004 Easy enough to fix... would be great for the next release.. Â only show if customers referral id is = 0. Quote Link to comment Share on other sites More sharing options...
Guest Posted August 13, 2004 Share Posted August 13, 2004 Hi all! Â I just installed this contribution bu I've a little problem. It's running ok at the admin side. But I encounter the error msg below at my create_account.php. Can anyone help or tell me whats wrong? thanks! :D Â ENTRY_SOURCE Fatal error: Call to undefined function: tep_get_source_list() in /home/estrella/public_html/create_account2.php on line 519 Quote Link to comment Share on other sites More sharing options...
hobbzilla Posted August 13, 2004 Author Share Posted August 13, 2004 You need to update your html_output.php in catalog/includes/functions  function tep_get_source_list() specifically. Quote Link to comment Share on other sites More sharing options...
Guest Posted August 13, 2004 Share Posted August 13, 2004 yay!! its working now. Thanks alot! :) Quote Link to comment Share on other sites More sharing options...
JoeyT Posted August 17, 2004 Share Posted August 17, 2004 In along with Davids idea of allowing the customer to change the referral. Â I would think it would be best to be able to change the referral in Admin area. I was going to try to add a drop down box so that an admin can Correct or add a referral to the customer record from there. Â This would be helpful say if a referral was selected wrong when they signed up, or if you have previous customers like David that you need to now assign referrals to. Â I took like this contribution and thanks to you's who worked hard on creating and modifying it. Â JoeyT Quote Link to comment Share on other sites More sharing options...
Dhananjaya Posted August 21, 2004 Share Posted August 21, 2004 Hey, I started with the new version (1.2) just yesterday. After the install I get on the catalog index page: Â Warning: session_start() [function.session-start]: Cannot send session cookie - headers already sent by (output started at /home/www/regalgift/catalog/includes/functions/general.php:1276) in /home/www/regalgift/catalog/includes/functions/sessions.php on line 67 Â Warning: session_start() [function.session-start]: Cannot send session cache limiter - headers already sent (output started at /home/www/regalgift/catalog/includes/functions/general.php:1276) in /home/www/regalgift/catalog/includes/functions/sessions.php on line 67 Â Warning: Cannot modify header information - headers already sent by (output started at /home/www/regalgift/catalog/includes/functions/general.php:1276) in /home/www/regalgift/catalog/includes/functions/general.php on line 29 Â Upon inspection of the the two lines mentioned I see no cause for concern. So then I started going back and commenting out all the mode code one page at a time and testing to see where I starts working and where the problem may be. After getting all through the cat changes and it was still buggered I hit the forum and found this thread and read it from the top. Â The error I'm seeing is remarkably similar the the post in the beginning of this thread regarding some sql code error that were since corrected. But before I realized I was looking at issues related to an earlier release I tried to reinstall the corrected sql update from 6/9. Anyway I've tried all three versions of the sql and neither work and I'm all mucked up here and need help. Thanks Quote I have moved on from oscommerce to magento and no longer monitoring this site. Link to comment Share on other sites More sharing options...
hobbzilla Posted August 24, 2004 Author Share Posted August 24, 2004 You need to double check your integration. Sometimes a single carriage return after the php closing tag can create the errors you are submitting. I and others have installed this contribution directly on top of stock 2.2MS2 and are not experiencing these errors. Did you do the changes by hand or overwrite? Quote Link to comment Share on other sites More sharing options...
Dhananjaya Posted September 2, 2004 Share Posted September 2, 2004 Thanks for replying Zilla  I know it works cause I can get it to work on a fresh install. My problem is that I I have a ton of mods and it would take to long to start over. To make things worse I can't seem to successfully backtrack so I am a deadman. Do you have any clues where to find the solution to these specific errors? I don't even know if it is the database or the code. Quote I have moved on from oscommerce to magento and no longer monitoring this site. Link to comment Share on other sites More sharing options...
hobbzilla Posted September 2, 2004 Author Share Posted September 2, 2004 unfortunately, that error is can be tedious to track down. I would start with general.php my guess is that line 1276 is the eof. The error that you are receiving "Cannot send session cookie - headers already sent by..." is definately in the code and not the DB. Â You did make a backup, yes?? Â If not, I'll bet you will next time! Â Good luck Quote Link to comment Share on other sites More sharing options...
osGirl21 Posted October 4, 2004 Share Posted October 4, 2004 hi, I am getting the following error  1062 - Duplicate entry '174' for key 1 insert into customers_info (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created) values ('174', '0', now())  [TEP STOP]  why is that??? some one please help... Urgent. thanks in advance Quote Link to comment Share on other sites More sharing options...
Druide Posted October 4, 2004 Share Posted October 4, 2004 hi, I am getting the following errorwhy is that??? some one please help... Urgent. thanks in advance <{POST_SNAPBACK}>   change it to:  insert into customers_info (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created) values ('', '0', now())  good luck Sabrina Quote Robert  We all need to learn it once, how hard it may seem when you look at it, also you will master it someday ;) Link to comment Share on other sites More sharing options...
hobbzilla Posted October 4, 2004 Author Share Posted October 4, 2004 (edited) Actually, if you are getting the duplicate entry error, you need to double check your installation and make sure you don't have any other contributions that will muck with this one. Changing the code to that suggested will not create the 1-to-1 relationship needed between customers & customers_info. I.e. customer 176 would be 177 in customer_info.. which would not be good. Â It has been my experience that this error comes about from another contribution that adds another "INSERT INTO TABLE_CUSTOMERS_INFO...." statement. When their code get's executed, it is the second insert statment get's run and mysql returns that primary key already exists so it won't let it continue with the duplicate Insert. Â You need to read the first page of this thread and see if you can't find the offending contribution. Â -Ryan Edited October 4, 2004 by hobbzilla Quote Link to comment Share on other sites More sharing options...
Dhananjaya Posted October 14, 2004 Share Posted October 14, 2004 Hey Ryan, By the way I did eventually get this contribution to work. The error turned out to be in the cutting and pasting and not putting in a Carriage return where it ought to be. Anyway all is well. Thanks! Â Steel, You were in the midst of a upgrade that I really really want. I am in the middle of adding in your code and I get the impression that it is unfinished and you had more to do on it. Are you going to do anymore on it? Are you going to tidy it up and post it as a contribution? Quote I have moved on from oscommerce to magento and no longer monitoring this site. Link to comment Share on other sites More sharing options...
Dhananjaya Posted October 14, 2004 Share Posted October 14, 2004 Noel, I meant Noel when I said Steel in the last post. So I installed your contribution to this contribution and it basically works and I think it will really add value to an already essential contribution once it is all tweaked. Â I have some questions and concerns for you if you would please... (Anyone else feel free to respond - especially Ryan if you are available) Â 1. I don't understand what to do with this: CODE if ($info['customers_info_source_id'] ==4) { Â Refers to my Friend / CoWorker select box. And it will not taint your "other" category, it would just be some info the customer put down when signing up. Â 2. When I add new souces now I get source codes starting at 10000 and I remember reading Ryan's instructions not to go over 999. Â 3. I want to edit the source and source other in admin/customer.php edit customer mode so that I can tidy up my database by cleaning up their entries and changing their "others" to newly created sources. Â 4. In the customer listing on customers.php where the referrals are listed I am only getting the info from sources_other and not from sources. Is that the way you intended it or did I muck it up? Quote I have moved on from oscommerce to magento and no longer monitoring this site. Link to comment Share on other sites More sharing options...
spannerman Posted October 30, 2004 Share Posted October 30, 2004 Hi all! I just installed this contribution bu I've a little problem. It's running ok at the admin side. But I encounter the error msg below at my create_account.php. Can anyone help or tell me whats wrong? thanks! :D  ENTRY_SOURCE Fatal error: Call to undefined function: tep_get_source_list() in /home/estrella/public_html/create_account2.php on line 519 <{POST_SNAPBACK}>  Hi folks,  Have just installed this mod on a test site but have his error in admin/customers.php at line 749  In the Admin panel, when going to view existing customers after installing the mod (eg. Customers who haven't supplied this info yet) I get:  Call to undefined function tep_get_source_name() in ... error. I have looked through all the pages of the site and the mod for the function name and cannot find it, though the function tep_get_source_list() does exist and I have successfully created a list of sources under "Referral" in Admin.  Can someone post the code for this please, I assume it needs to go in functions.php Quote Link to comment Share on other sites More sharing options...
spannerman Posted October 30, 2004 Share Posted October 30, 2004 I meant to add that it's quite a heavily modded shop and I did the mod using Beyond Compare to add the lines to my exiting files. I have checked the original download (v1.2) as well and can't find it in there either!. Â Many thanks! Quote Link to comment Share on other sites More sharing options...
Guest Posted November 5, 2004 Share Posted November 5, 2004 Hey  I am having a wee problem with the report section in admin...  When I reg'd a test customer i selected "Other" and in the report it showed a total of '71'instead of '1'.  I then reg'd a second customer, selected "Other" and the report showed '72' instead of '2'.  Where can I reset this counter?  Cheers  Paul Quote Link to comment Share on other sites More sharing options...
Guest Posted November 5, 2004 Share Posted November 5, 2004 Hey I am having a wee problem with the report section in admin...  When I reg'd a test customer i selected "Other" and in the report it showed a total of '71'instead of '1'.  I then reg'd a second customer, selected "Other" and the report showed '72' instead of '2'.  Where can I reset this counter?  Cheers  Paul <{POST_SNAPBACK}>  Doh!!!!  I take it that it is adding up all the 'nones' for the existing customers that reg'd b4 contribution install...  How can I change this?  Cheers  Paul Quote Link to comment Share on other sites More sharing options...
ptholt Posted December 11, 2004 Share Posted December 11, 2004 I feel a bit of a fool as my question is nowhere near as complex as some of the others, but i rather foolishly downloaded and updated all the necessary php files (only been using oscommerce seriously for the last week! - NEWBIE ALERT!).  and all was going swimmingly till i got the line in the instructions that said -  'In the temporary unzipped directory you will find a .sql file. This contains the mysql configuration data for the manufacturers_info table. Please update your database accordingly via however method you are most comfortable (phpmyadmin, etc.).'  can someone please translate this into something that makes sense :) I downloaded phpmyadmin and have not got a clue what im doing there or how i add the sql from update.sql into my tables, can someone point me in the direction of a rather basic walkthough  thanks. Quote Link to comment Share on other sites More sharing options...
hobbzilla Posted December 14, 2004 Author Share Posted December 14, 2004 Peter, Â Welcome to the osCommerce community. Everybody starts out as a newbie one time or another! Â Anyway, phpmyadmin is a mysql web-based utility. Documentation for it can be found here: http://www.phpmyadmin.net/documentation/ Â Also, you could try a search on google for more help. Unfortunately this isn't the place for a phpmyadmin tutorial (as there are many out there). Â Did you try to search Google for 'phpmyadmin tutorial' ?? Quote Link to comment Share on other sites More sharing options...
joma Posted December 16, 2004 Share Posted December 16, 2004 can anyone help me, i want to try and add new information frield to my create account, so i can ask other relevents of my customers then standard. I want to request from them a text area box to tell me what product they are looking for. I sell caravans so it will be for a description of what they want. So it will be like the other sources box in this mod. Possibly this will just add to to customers information page in the admin as another info box. Quote Link to comment Share on other sites More sharing options...
hobbzilla Posted December 16, 2004 Author Share Posted December 16, 2004 How did you hear about us? ver 1.3 released! Â Get it here: http://www.oscommerce.com/community/contributions,2159 Quote Link to comment Share on other sites More sharing options...
edtiger Posted December 22, 2004 Share Posted December 22, 2004 Doh!!!! I take it that it is adding up all the 'nones' for the existing customers that reg'd b4 contribution install...  How can I change this?  Cheers  Paul <{POST_SNAPBACK}>  Hopefully this is still useful to you. I have changed this line in admin/stats_referral_sources.php (about line 19)   $referrals_query_raw = "select count(ci.customers_info_source_id) as no_referrals, s.sources_name, s.sources_id from " . TABLE_CUSTOMERS_INFO . " ci LEFT JOIN " . TABLE_SOURCES . " s ON s.sources_id = ci.customers_info_source_id group by s.sources_id order by ci.customers_info_source_id DESC";   to this   $referrals_query_raw = "select count(ci.customers_info_source_id) as no_referrals, s.sources_name, s.sources_id from " . TABLE_CUSTOMERS_INFO . " ci LEFT JOIN " . TABLE_SOURCES . " s ON s.sources_id = ci.customers_info_source_id where ci.customers_info_source_id != '0' group by s.sources_id order by ci.customers_info_source_id DESC";  this will prevent anyone with the default of 0 being displayed in the count. ie if you installed the contrib and already have 70 customers, it will ignore the customers with blank referral values. 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.