[support] database fields not present

[Thijs Hakkenberg]

  Thanks, I installed the Devel module.  Reïnstallation did the trick, 
and I created an Issue, but it's not visible yet.
Does it take a while when you make a new issue on drupal.org?

On 8-7-2010 17:49, Jamie Holly wrote:
> Download the Devel module and install it. There's an option in there 
> to "reinstall modules". Just select the module from that page and 
> reinstall it. It will destroy all the tables that that module makes, 
> so any data in them will be lost.
> Jamie Holly
> http://www.intoxination.net
> http://www.hollyit.net
>
> On 7/8/2010 11:46 AM, Thijs Hakkenberg wrote:
>> 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.
>>>
>>>      
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20100713/26aaf816/attachment.html