[support] database fields not present
Metzler, David
metzlerd at evergreen.edu
Thu Jul 8 15:51:45 UTC 2010
The reason will be that the module maintainer changed the schema, but
didn't provide an update function in their hook_install to make sure
upgrades happened cleanly. If they had done this, it wouldn've been
taken care of with the normal update.php run. This should really be
filed as an issue on that projects issue queue, to make sure it gets
fixed for other users.
________________________________
From: support-bounces at drupal.org [mailto:support-bounces at drupal.org] On
Behalf Of Thijs Hakkenberg
Sent: Thursday, July 08, 2010 8:47 AM
To: support at drupal.org
Cc: Michel Morelli
Subject: Re: [support] database fields not present
I've tried just that, but the phpMyAdmin didn't like the query, so I
added the trx_id column myself with the parameters specified.
However, now this error arises:
* user warning: Unknown column 'status' in 'field list' query:
INSERT INTO uc_payment_ideal (order_id, trx_id, status, received) VALUES
(13, '0050000553960739', 'OPEN', 1278603694) in
/home/vin/domains/winkel.varkensinnood.nl/public_html/modules/uc_ideal_p
ro/uc_ideal_pro.module on line 271.
* user warning: Unknown column 'status' in 'field list' query:
SELECT trx_id, status FROM uc_payment_ideal WHERE order_id = 13 in
/home/vin/domains/winkel.varkensinnood.nl/public_html/modules/uc_ideal_p
ro/uc_ideal_pro.module on line 286.
it looks like the field 'status' and 'received' should also be added..
But any idea why these fields weren't installed by the module? And why
isn't it possible to do it via drupal again?
Thanks!
On 8-7-2010 2:08, Michel Morelli wrote:
Hi, via mysql cli o phpmyadmin or other administration gui try
this:
ALTER TABLE 'uc_payment_ideal' ADD 'trx_id' VARCHAR( 16 ) NOT
NULL
DEFAULT '0' AFTER 'order_id';
M.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20100708/8d9cc796/attachment-0001.html
More information about the support
mailing list