Using lm_paypal on Site: mexicohospitality.com; Drupal 5.1

1) create table fails
2) Is there an alternate version of lm_paypal that should be used with Drupal 5.1?

Background:
I downloaded lm_paypal in early June. It appeared to be working and I was able to create subscriptions.
I noticed that a newer version of lm_paypal (head-Jun 14) was available and downloaded it. Possibly a mistake, because I then encountered a sql problem and discovered that lm_paypal_subscriptions was missing from the mySqlDatabase.

I then did the following
-unchecked all lm_paypal modules in admin/modules
-checked to see if there was an uninstall for lm_paypal in admin/modules -- there was none
-deleted [lm_paypal] directory from [modules] directory
-ran drop_test.sql on database to delete lm_paypal tables -- tables were removed
-re-downloaded the latest version [head-June 14] of lm_paypal from drupal
-copied [lm_paypal] into [modules] directory
-activated all lm_ modules via admin/modules

RESULTS

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

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 '(2000), nearend_days int unsigned not null 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 in /home/mexicoho/public_html/includes/database.mysql.inc on line 172.

Thank you for creating this module!

CommentFileSizeAuthor
#5 patches.zip_.txt22.77 KBseanenroute
#4 lm_paypal_textfix.patch3.55 KBLeeMcL

Comments

betsyj’s picture

betsyj commented

Problem occurs using MySQL Server version: 4.0.27-standard
phpMyAdmin - 2.10.0.2
MySQL client version: 4.1.10

Create table fails on data type "Text(2000)". Changing the datatype to "Text" allows the subscritption table to be created.

davss’s picture

davss commented

had exactly the same error. you can try it out at

http://webcoder.eu/durpal/
u: david
p: 12345678

hope to keep this install for a week.

seanenroute’s picture

seanenroute commented

For us noobs, where do you change Text(2000) to Text?
Also, will this be fixed soon. I am also having this same problem with a Drupal 5.1 / MySQL 4 setup.

LeeMcL’s picture

LeeMcL commented
Assigned: Unassigned » LeeMcL
StatusFileSize
new lm_paypal_textfix.patch3.55 KB

I changed the mail messages for subscriptions from varchar(255) to text(2000). This worked fine for me on MySQL 4.1.11 and, according to my reading of the MySQL manuals, should have worked on all other versions.

From these error reports this isn't the case. So I'll change the effected fields to just text (without any size).

Attached is a patch to correct this problem. As I'm not having this problem I cannot easily test if it fixes it. Can someone who is hit by this please try this patch and let me know how they get on, please?

Lee

seanenroute’s picture

seanenroute commented
StatusFileSize
new patches.zip_.txt22.77 KB

Still no go with the subscription module.

I applied the patch to both the install file and the module file, ran update and got back the following error:

* user warning: Table 'db202747356.lm_paypal_subscriptions' doesn't exist query: ALTER TABLE lm_paypal_subscriptions CHANGE send_user_onsub_body send_user_onsub_body text in /homepages/10/d87384619/htdocs/drupal51_w4/includes/database.mysql.inc on line 172.
* user warning: Table 'db202747356.lm_paypal_subscriptions' doesn't exist query: ALTER TABLE lm_paypal_subscriptions CHANGE send_user_onnearend_body send_user_onnearend_body text in /homepages/10/d87384619/htdocs/drupal51_w4/includes/database.mysql.inc on line 172.
* user warning: Table 'db202747356.lm_paypal_subscriptions' doesn't exist query: ALTER TABLE lm_paypal_subscriptions CHANGE send_user_onend_body send_user_onend_body text in /homepages/10/d87384619/htdocs/drupal51_w4/includes/database.mysql.inc on line 172.
* user warning: Table 'db202747356.lm_paypal_subscriptions' doesn't exist query: ALTER TABLE lm_paypal_subscriptions CHANGE terms terms text in /homepages/10/d87384619/htdocs/drupal51_w4/includes/database.mysql.inc on line 172.

and:

The following queries were executed
lm_paypal_subscriptions module
Update #9

* Failed: ALTER TABLE {lm_paypal_subscriptions} CHANGE send_user_onsub_body send_user_onsub_body text
* Failed: ALTER TABLE {lm_paypal_subscriptions} CHANGE send_user_onnearend_body send_user_onnearend_body text
* Failed: ALTER TABLE {lm_paypal_subscriptions} CHANGE send_user_onend_body send_user_onend_body text
* Failed: ALTER TABLE {lm_paypal_subscriptions} CHANGE terms terms text

When I try to create a Subscription I get the following warning:

user warning: Table 'db202747356.lm_paypal_subscriptions' doesn't exist query: SELECT subid, item_name, description, status, kind, rid FROM lm_paypal_subscriptions in /homepages/10/d87384619/htdocs/drupal51_w4/includes/database.mysql.inc on line 172

The MySQL database doesn't show any table for lm_paypal_subscriptions. Just to make sure there wasn't any residue from a previous install I then also removed the module in it's entirety and did a fresh install with the same results.

My setup is as follows: Drupal 5.1 ,MySQL 4.0.27, and PHP 4.4.7.

And in the off chance I botched the patches I've enclosed them for comparison. Remove the ".txt" extension, it's the only way I could send a zip file.

Cheers

seanenroute’s picture

seanenroute commented

AAAAAAGGGHHHHHHH!!!!

I still can't get it to work after mucking about with the patch. It refuses to create a lm_paypal_subscriptions table in MySQL.

Does anyone have a working version of the patched module they can post here?

Thanks.

LeeMcL’s picture

LeeMcL commented

I've updated the version in cvs HEAD to have all the TEXT fields as unlimited.

seanenroute’s picture

seanenroute commented

Thank you for updating the head. But... your going to hate me.....I got the following error when I fired up the new version of the module.

user warning: Table 'db210629654.lm_paypal_subscriptions' doesn't exist query: SELECT subid, item_name, description, status, kind, rid FROM lm_paypal_subscriptions in /homepages/10/d87384619/htdocs/drupal51_wild4/includes/database.mysql.inc on line 172.

I erased the previous version of the module from both the database and from the modules file so it was a fresh install. For some reason it just will not create a table for lm_paypal_subscriptions. It does create the 'donations' table however. It didn't show any table for 'ipns'

I'm running a fresh install of Drupal 5.1 and MySQL 4.11.

Sorry for the hassles, I really do appreciate the work you are doing on this, thanks.. Sean

seanenroute’s picture

seanenroute commented

I meant MySQL 4.0.27 - I don't know if that makes a difference.

Nick Urban’s picture

Nick Urban commented
Title: Failed to create table:lm_paypal_subscriptions » same problem as seanenroute

Except I got the error for the ipns table.

seanenroute’s picture

seanenroute commented
Title: same problem as seanenroute » Subscriptions and IPNS tables can't be created in Drupal 5.1

Just checking to see if there was any headway in fixing this bug. I'm sorry that I don't know enough PHP scripting to help. Good luck.

john franklin’s picture

john franklin commented
Status: Active » Closed (won't fix)

Closing all 5.x and earlier issues. If this is still an issue, please reopen and update with 6.x or 7.x details.