Re: [support] database fields not present

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@drupal.org [mailto:support-bounces@drupal.org] *On Behalf Of *Thijs Hakkenberg *Sent:* Thursday, July 08, 2010 8:47 AM *To:* support@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/ ]