[support] database fields not present

[Thijs Hakkenberg]

  Thanks, I will.

On 8-7-2010 17:51, Metzler, David wrote:
> 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_pro/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_pro/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.
>>
>
>
> -- [ Drupal support list | http://lists.drupal.org/ ]
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20100713/b7712b68/attachment.html