315 replies to this topic

[p51mustang]

OK, I deleted all the mods for this contribution and restored my backup database, so everything now works as it was before installing this contribution.

This contribution is a great idea, but I think I will wait for a new, consolidated release (ie, with the count fix and adding source to customer info, plus any new enhancements) before trying to install again.

I really like this mod

[cyberphool]

Hi there, hope you're still reading this thread Ryan

Could you let me know how to change these fields from mandatory to optional please?


thanks,


David

[cyberphool]

I AM A DOLT


I just read through your installation notes again -

"Admin can also make this required or not (Admin->Configuration->Customer Details)"


cheers for that, solved

[dasaro]

I, too, am thankful for effort put forth on this wonderful contribution. I'm fairly new to all of this stuff and am working through as best I can. I finished all of the admin side additions just fine. Works great!! I was sure that all of the catalog changes were flawless too, until I tried to create a fake account just to try it out. I get the following error on the next page:

Quote

1062 - Duplicate entry '76' for key 1

insert into customers_info (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created, customers_info_source_id) values ('76', '0', now(), '4')

[TEP STOP]

I understand from the previous posts that this results from a duplicate entry. I have found the problem in create_account.php as follows:

// Guest Account Start
      if (!$guest_account) {
        tep_db_query("insert into " . TABLE_CUSTOMERS_INFO . " (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created) values ('" . tep_db_input($customer_id) . "', '0', now())");
      } else {
        tep_db_query("insert into " . TABLE_CUSTOMERS_INFO . " (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created) values ('" . tep_db_input($customer_id) . "', '-1', now())");
      }
// Guest Account End

//Referral start ===========================
      tep_db_query("insert into " . TABLE_CUSTOMERS_INFO . " (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created, customers_info_source_id) values ('" . (int)$customer_id . "', '0', now(), '". (int)$source . "')");

      if ($source == '9999') {
        tep_db_query("insert into " . TABLE_SOURCES_OTHER . " (customers_id, sources_other_name) values ('" . (int)$customer_id . "', '". $source_other . "')");
      }
//Referral end ============================

It is painfully obvious that the two queries at the beginning of 'Guest Account' and 'Referral' are nearly identical and cannot peacefully co-exist. However, I am not sure at all on how to fix this. Will it have anything to do with the '0' ?

This error prevents any new customers from seemingly creating a new account. Their information is successfully stored in the table and they may log into their new account afterwards, but this error message is terribly unaesthetic, at best.

Any help would be more than greatly appreciated. The sooner the better!!!

-David

[PM5K]

When I browse "sources_other" and go to export I see the following error:

Error

SQL-query :

SHOW TABLE STATUS LIKE 'sources_other' FROM 'sources_other'

MySQL said:


You have an error in your SQL syntax near 'FROM 'sources_other'' at line 1
Back

Thanks for the assistance....

[hobbzilla]

How Did you Hear About Us v1.2 released!

Get it here:
http://www.oscommerce.com/community/contributions,2159

v1.2 - 08/10/04
Referral Report Bug fixes
Display Referrer for customer
Create Account SQL Bug fixes

[hobbzilla]

PM5K, on Aug 9 2004, 08:33 AM, said:

When I browse "sources_other" and go to export I see the following error:

Error

SQL-query :

SHOW TABLE STATUS LIKE 'sources_other' FROM 'sources_other'

MySQL said:


You have an error in your SQL syntax near 'FROM 'sources_other'' at line 1
Back

Thanks for the assistance....

where is this exactly? Sounds like phpmyadmin ??? Shouldn't be an export from the oscommerce admin side of things.

[hobbzilla]

dasaro, on Aug 7 2004, 12:21 AM, said:

It is painfully obvious that the two queries at the beginning of 'Guest Account' and 'Referral' are nearly identical and cannot peacefully co-exist. However, I am not sure at all on how to fix this. Will it have anything to do with the '0' ?

This error prevents any new customers from seemingly creating a new account. Their information is successfully stored in the table and they may log into their new account afterwards, but this error message is terribly unaesthetic, at best.

Any help would be more than greatly appreciated. The sooner the better!!!

-David

Simply remove the insert from my code and append the portion to Guest Account:

// Guest Account Start
      if (!$guest_account) {
        tep_db_query("insert into " . TABLE_CUSTOMERS_INFO . " (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created, customers_info_source_id) values ('" . tep_db_input($customer_id) . "', '0', now(), '". (int)$source . "')");
      } else {
        tep_db_query("insert into " . TABLE_CUSTOMERS_INFO . " (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created, customers_info_source_id) values ('" . tep_db_input($customer_id) . "', '-1', now(), '". (int)$source . "')");
      }
// Guest Account End

//Referral start ===========================
      if ($source == '9999') {
        tep_db_query("insert into " . TABLE_SOURCES_OTHER . " (customers_id, sources_other_name) values ('" . (int)$customer_id . "', '". $source_other . "')");
      }
//Referral end ============================

[dasaro]

Well, zilla, it seems that did the trick. I had attempted something of that sort earlier, but obviously it wasn't the correct fix. I do appreciate it.

I'm getting ready to download the latest version. Can't wait! Again, great job on this contrib.

[dasaro]

I just thought of another great addition for this contrib. I'm going to try to work on account_edit.php such that customers who created an account before this referral contribution was added may be able to edit their account and choose the same options.

Not sure right now what that will entail, but why not find out...

[hobbzilla]

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

[dasaro]

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.

[hobbzilla]

Easy enough to fix... would be great for the next release..

only show if customers referral id is = 0.

[estrellashopping]

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!

ENTRY_SOURCE
Fatal error: Call to undefined function: tep_get_source_list() in /home/estrella/public_html/create_account2.php on line 519

[hobbzilla]

You need to update your html_output.php in catalog/includes/functions

function tep_get_source_list() specifically.

[estrellashopping]

yay!! its working now. Thanks alot!

[JoeyT]

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

[Dhananjaya]

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

[hobbzilla]

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?

[Dhananjaya]

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.