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

CommentFileSizeAuthor
#4 sql_syntax_error-1203982-4.patch443 bytesdkingofpa

Comments

SharonD214@aol.com’s picture

SharonD214@aol.com commented

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

SharonD214@aol.com’s picture

SharonD214@aol.com commented

Never mind -
I figured it out. Line #560 of lm_paypal.install should read

'size' => 'medium',

instead of

'length' => 'medium',

Sharon

ejwensley’s picture

ejwensley commented

That fixed it for me.

dkingofpa’s picture

dkingofpa commented
Status: Active » Needs review
StatusFileSize
new sql_syntax_error-1203982-4.patch443 bytes

Patch attached

L-four’s picture

L-four commented
Status: Needs review » Fixed

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

Anonymous’s picture

Anonymous (not verified) commented

using 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?

Anonymous’s picture

Anonymous (not verified) commented
Status: Closed (fixed) » Active
L-four’s picture

L-four commented

I have not personally tested upgrading from 6.x to 7.x. Can you tell me which version you are trying to upgrade from?

Anonymous’s picture

Anonymous (not verified) commented

from 6.x-2.x-dev 2011-Dec-30
to 7.x-1.x-dev 2012-May-10

L-four’s picture

L-four commented

Thanks I will have a look at this later today.