Ubercart

I am getting this error on install. I tried playing with the install SQL a bit, but I could not get around this error. I feel like its something small and I just can't see it.

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'unsigned NOT NULL DEFAULT 0, `order_id` unsigned NOT NULL DEFAULT 0, `lead_so' at line 2 query: CREATE TABLE uc_leads ( `lead_id` unsigned NOT NULL DEFAULT 0, `order_id` unsigned NOT NULL DEFAULT 0, `lead_source` VARCHAR NOT NULL DEFAULT 0, `lead_other` VARCHAR NOT NULL DEFAULT 0, PRIMARY KEY (lead_id), INDEX order_id (order_id) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in /XXX/XXXX/public_html/XXXX/includes/database.inc on line 515.

My version of MySQL is 5.0.67-community.

Any thoughts on this?

Regards,

Shaun

Just to help anyone else, if you bypass the error when you install this. And you had an error, you will get this in your checkout.

    * user warning: Table 'XXXX_XXXX.uc_leads' doesn't exist query: UPDATE uc_leads SET lead_source = 'Please select one...', lead_other = '' WHERE order_id = 1 in /XXXXX/XXXXXX/public_html/XXXXX/modules/uc_lead/uc_lead.module on line 50.

Regards,

Shaun

I received the same error message:

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'unsigned NOT NULL DEFAULT 0, `order_id` unsigned NOT NULL DEFAULT 0, `lead_so' at line 2 query: CREATE TABLE uc_leads ( `lead_id` unsigned NOT NULL DEFAULT 0, `order_id` unsigned NOT NULL DEFAULT 0, `lead_source` VARCHAR NOT NULL DEFAULT 0, `lead_other` VARCHAR NOT NULL DEFAULT 0, PRIMARY KEY (lead_id), INDEX order_id (order_id) ) /*!40100 DEFAULT CHARACTER SET UTF8 */ in S:\www\ubercart\includes\database.inc on line 515.

The attached file is a slightly updated module to fix the schema problems (and some other issues) reported above. The uninstall method was also broken in the above module, so be sure you really have it uninstalled and the table removed before installing this version - it's not an update.

Removed the previous (non-functional) lead tracker as best I could, installed the revised one, but error after install:

Khalor, try with my fix...

Thanks grungy, that works great.

How difficult would it be to add additional text fields if the "other" option is selected?

To clarify, I would like to have three different text fields for options like name, phone, and birthdate if the "other" option is selected.

Any help would be greatly appreciated.

Thanks

Hi,

I am using this module to build a new own checkout pane (so customers can set a date and time to pick up their order). And i was wondering what the following is doing in uc_lead.install :

I am sorry for this probably silly question. But this is the first time I've really started on the code of drupal.

When i try to de-install the module I get these warnings:

I got this msg while trying to de-install my own module based on Lead-Tracker. After hours of head-scratching and trying to fix my 'cloned' module I realised the same error shows up when I de-install the original version 'Lead Tracker for Ubercart 2.x'

What can I do to help alleviate this problem?

I've posted a module in contrib called Referral Sources that provides similar functionality to Lead Tracker, but allows you to embed "Where did you hear about us?" type prompts anywhere in your site (registration, checkout, webforms, any other form) and track all submission data in a central location. It's written for D6/UC2.

See here: http://www.ubercart.org/contrib/11656

I try to modify uc_lead to fit my own purposes.
I try to edit uc_checkout_pane_lead -hook:

This is the original code:

I want to change 'select' to 'checkboxes'.
After this change the form won't pass any values. With select you have one value, but with checkboxes you can have multiple values. However, I'm using just one option with the checkbox.

How could I make this work? I don't really know what happens when user proceeds from the check out page.

cool module, thank you! working like charm. suggestions: make the lead tracking choise mandatory

Just want I needed. Thanks Adamo!

Tanya

I want to add an extra field on checkout page ??

How to configure this lead tracker module.
I have installed uc_lead_0_1.zip but i can see any extra thing in ubercart configuration.

I need an help kindly help
Thanks in advance

I want to add extra taxonomy field on checkout page

Install success. No options for new 'panes'. Nothing happens.

I have installed the 6.x version of Lead Tracker and am getting the following error when I test the checkout as an authenticated user:

• user warning: Table 'mysite_drp1.drp_uc_leads' doesn't exist query: UPDATE drp_uc_leads SET lead_source = 'Facebook', lead_other = '' WHERE order_id = 419 in /mysite/public_html/sites/all/modules/contributed/uc_lead/uc_lead.module on line 50.
• user warning: Table 'mysite_drp1.drp_uc_leads' doesn't exist query: SELECT * FROM drp_uc_leads WHERE order_id = 419 in /mysite/public_html/sites/all/modules/contributed/uc_lead/uc_lead.module on line 59.

I can see the pane and have enabled it. Everything appears fine but I'm getting this error. Apparently the table(s) are not being created?

Can anyone help with this?

Thanks so much - grungy's version finally worked for me. This is really valuable for us!

The only problem, though, is that the "saved addresses" select list has disappeared from the checkout, i.e., so now even returning customers need to retype their address information into the form.

Anyone have a patch or a solution for this?

Thanks so much!

Grungy's works great, thanks!

Just noticed though that the uninstall was not removing the uc_leads table.

the drupal_uninstall_schema('uc_leads'); just needs to be changed to drupal_uninstall_schema('uc_lead');

And the uninstall should now remove the table.

Anyone know if the lead tracker module is being updated for 3.x? Its seems like a great idea. I was going to just re-label the coupon code module and run it that way, but this would be certainly more efficient.