Posted by SharonD214 on June 29, 2011 at 3:06pm
5 followers
| Project: | lm_paypal |
| Version: | 7.x-1.x-dev |
| Component: | Miscellaneous |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed (fixed) |
Issue Summary
I'm getting the following database error when updating to most recent version of lm_paypal
lm_paypal module
Update #7001
Failed: DatabaseSchemaObjectExistsException: Cannot add field lm_paypal_ipns.handling_amount: field already exists. in DatabaseSchema_mysql->addField() (line 323 of C:\wamp\www\drupal\includes\database\mysql\schema.inc).
Any ideas?
Thanks
Sharon
Comments
#1
Any help with this? I've tried removing from the database the fields that already exist: handling_amount, Protection_eligibility, and Transaction_subject, but am still getting an error when trying to update.
Update #7001
Failed: PDOException: SQLSTATE[42000]: Syntax error or access violation: 1064 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 'medium) DEFAULT NULL COMMENT 'Tracking id'' at line 1: ALTER TABLE {lm_paypal_ipns} ADD `ipn_track_id` TEXT(medium) DEFAULT NULL COMMENT 'Tracking id'; Array ( ) in db_add_field() (line 2781 of C:\wamp\www\drupal\includes\database\database.inc).
Thanks
Sharon
#2
Never mind -
I figured it out. Line #560 of lm_paypal.install should read
'size' => 'medium',
instead of
'length' => 'medium',
Sharon
#3
That fixed it for me.
#4
Patch attached
#5
#6
Automatically closed -- issue fixed for 2 weeks with no activity.