Support for Drupal 7 is ending on 5 January 2025—it’s time to migrate to Drupal 10! Learn about the many benefits of Drupal 10 and find migration tools in our resource center.
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
Comment | File | Size | Author |
---|---|---|---|
#4 | sql_syntax_error-1203982-4.patch | 443 bytes | dkingofpa |
Comments
Comment #1
SharonD214@aol.com CreditAttribution: SharonD214@aol.com commentedAny 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
Comment #2
SharonD214@aol.com CreditAttribution: SharonD214@aol.com commentedNever mind -
I figured it out. Line #560 of lm_paypal.install should read
'size' => 'medium',
instead of
'length' => 'medium',
Sharon
Comment #3
ejwensley CreditAttribution: ejwensley commentedThat fixed it for me.
Comment #4
dkingofpa CreditAttribution: dkingofpa commentedPatch attached
Comment #5
L-four CreditAttribution: L-four commentedComment #7
Anonymous (not verified) CreditAttribution: Anonymous commentedusing the "fixed" version I still get the error during d6 to d7 upgrade.
lm_paypal module
Update #7001
Failed: DatabaseSchemaObjectExistsException: Cannot add field lm_paypal_ipns.handling_amount: field already exists. in DatabaseSchema_mysql->addField() (line 328 of /includes/database/mysql/schema.inc).
Any help?
Comment #8
Anonymous (not verified) CreditAttribution: Anonymous commentedComment #9
L-four CreditAttribution: L-four commentedI have not personally tested upgrading from 6.x to 7.x. Can you tell me which version you are trying to upgrade from?
Comment #10
Anonymous (not verified) CreditAttribution: Anonymous commentedfrom 6.x-2.x-dev 2011-Dec-30
to 7.x-1.x-dev 2012-May-10
Comment #11
L-four CreditAttribution: L-four commentedThanks I will have a look at this later today.