on a new installation (4.7) with nothing else installed I copied current verion of lm_paypal (cvs, 21/10/2006 - 21:45, 51.7 KB) and attempted to instal - I got the following errors:

* user warning: You have an error in your SQL syntax near '; ' at line 100 query: CREATE TABLE lm_paypal_ipns ( id mediumint not null auto_increment, # My ID for received IPNs timestamp int(11) unsigned not null, # unix time when ipn arrived txn_id varchar(20) not null default '', # Paypal generated transaction id processed int(1) default '0', # set if processed test_ipn int(1) default null, # Only set by sandbox to 1 verify_sign varchar(20) default null, # Security string # Website Payments Standard, Website Payments Pro, and Refund Information # SOME FIELDS OMITTED parent_txn_id varchar(20) default null, # In the case of a refund, reversal, or canceled reversal, this variable contains the txn_id of the original transaction, while txn_id contains a new ID for the new transaction. payment_date varchar(28) default n in /home/sites/drupal/includes/database.mysql.inc on line 120.
* user warning: You have an error in your SQL syntax near '; ' at line 13 query: CREATE TABLE lm_paypal_donations ( udid int unsigned not null auto_increment, uid int(10) unsigned null, datepaid int(11) not null, txn_id varchar(20) not null default '', # Paypal generated transaction id mc_gross decimal(10,2) default '0.00' not null, mc_fee decimal(10,2) default '0.00' not null, mc_currency varchar(3) default null, item_name varchar(127) not null default '', primary key(udid) ) /*!40100 DEFAULT CHARACTER SET utf8 */ ; in /home/sites/drupal/includes/database.mysql.inc on line 120.
* user warning: You have an error in your SQL syntax near '; ' at line 16 query: CREATE TABLE lm_paypal_subscribers ( usid int unsigned not null auto_increment, kind int unsigned not null default 0, uid int(10) unsigned not null, nid int(10) unsigned not null default 0, subid mediumint unsigned not null, started int(11) unsigned not null, status int(4) unsigned not null, subscr_id varchar(20) default null, # ID generated by PayPal for this subscription email_sent int(1) unsigned not null default '0', KEY uid (uid), KEY subscr_id (subscr_id), PRIMARY KEY(usid) ) /*!40100 DEFAULT CHARACTER SET utf8 */ ; in /home/sites/drupal/includes/database.mysql.inc on line 120.
* user warning: You have an error in your SQL syntax near '; ' at line 39 query: CREATE TABLE lm_paypal_subscriptions ( subid mediumint unsigned not null auto_increment, kind int unsigned not null default 0, rid int(10) unsigned not null, item_name varchar(127) not null default '', description varchar(200) default '', a1 decimal(10,2) default null, p1 mediumint unsigned default null, t1 char(1) default null, a2 decimal(10,2) default null, p2 mediumint unsigned default null, t2 char(1) default null, a3 decimal(10,2) default null, p3 mediumint unsigned default null, t3 char(1) default null, src int(1) default null, srt mediumint unsigned default null, currency_code varchar(3) default null, status int(4) not in /home/sites/drupal/includes/database.mysql.inc on line 120.

* lm_paypal FAILED to create tables:Failed to create table:lm_paypal_ipns.
* lm_paypal_donations FAILED to create tables:Failed to create table:lm_paypal_donations.
* lm_paypal_subscriptions FAILED to create tables:Failed to create table:lm_paypal_subscribers. Failed to create table:lm_paypal_subscriptions.
* The configuration options have been saved.

CommentFileSizeAuthor
#1 create_tables.patch2.38 KBLeeMcL

Comments

LeeMcL’s picture

LeeMcL commented
Assigned: Unassigned » LeeMcL
Status: Active » Reviewed & tested by the community
StatusFileSize
new create_tables.patch2.38 KB

This is, apparantly, caused by an odd bug in MySQL 3. More details near the bottom of this issue report for the banner module:

http://drupal.org/node/77055

I've attached a patch that should help and I'm updating CVS.

Can you try it out and let me know how you get on.

Lee

LeeMcL’s picture

LeeMcL commented

I forgot to add that before you apply that patch you need to go to admin/modules and disable the lm_paypal modules. Then run the drop_test.sql script so when you install the patched version Drupal will run the install scripts:

mysql -u DBUSER -pDBPASSWORD DBNAME < drop_test.sql

Normally you should never run my drop_test.sql except if there are serious problems like this as it wipes out the contents of the lm_paypal tables.

Lee

debsjenkins’s picture

debsjenkins commented

Hi Lee

I downloaded your most recent download (can't work out how to do patches!) and it ALMOST worked - think you have one still to fix:
* lm_paypal created tables
* lm_paypal_donations created tables
* lm_paypal_subscriptions FAILED to create tables:Failed to create table:lm_paypal_subscriptions.
* The configuration options have been saved.

I looked in lm_paypal_subscriptions.install - the subscribers table gets created properly, but the naughty quote is still in the wrong place for subscriptions
thanks for your help
Debs

debsjenkins’s picture

debsjenkins commented

on line 69 in lm_paypal_subscriptions.install I changed to

*/;";

and removed line 70 and it worked - great!

LeeMcL’s picture

LeeMcL commented
Status: Reviewed & tested by the community » Closed (fixed)

Sorry I missed that one, thanks for letting me know. I've patched CVS to match.

As this issue is now solved I'm closing it.

Lee

Patricia_W’s picture

Patricia_W commented
Version: master » 6.x-1.0
Component: Code » LM Paypal Donations
Priority: Normal » Critical
Status: Closed (fixed) » Active

I've encountered the same problem. Although I can use LM_PayPal_Donations I get an error message that the lm_paypal_donations table does not exist and when I check the database that is the case.

MySQL client version: 4.1.22

lyricnz’s picture

lyricnz commented
Version: 6.x-1.0 » master
Component: LM Paypal Donations » Code
Priority: Critical » Normal
Status: Active » Closed (fixed)

Please open a new issue, and include the exact error messages that you are getting.