[support] database fields not present

[Thijs Hakkenberg]

  I've posted the issue: http://drupal.org/node/853842

On 13-7-2010 16:09, Thijs Hakkenberg wrote:
> 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/20100714/81672a7f/attachment.html