Dear List,
I am using an module 'ideal professional' for ubercart. Everything works well, but when an user finishes an payment, the following error is shown:
* user warning: Unknown column 'trx_id' in 'field list' query: INSERT INTO uc_payment_ideal (order_id, trx_id, status, received) VALUES (11, '0050000551913841', 'OPEN', 1278337590) in //public_html/modules/uc_ideal_pro/uc_ideal_pro.module on line 271. * user warning: Unknown column 'trx_id' in 'field list' query: SELECT trx_id, status FROM uc_payment_ideal WHERE order_id = 11 in /public_html/modules/uc_ideal_pro/uc_ideal_pro.module on line 286.
I've looked in the datbase and can't find the trx_id column. The uc_ideal_pro.install file contains this:
function uc_ideal_pro_schema() { $schema = array();
$schema['uc_payment_ideal'] = array( 'description' => t('Logs iDEAL transaction statuses.'), 'fields' => array( 'order_id' => array( 'description' => t('The Ubercart order ID.'), 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0, ), 'trx_id' => array( 'description' => t('The iDEAL transaction ID.'), 'type' => 'varchar', 'length' => 16, 'not null' => TRUE, 'default' => 0, ), 'status' => array( 'description' => t('The iDEAL transaction status.'), 'type' => 'varchar', 'length' => 10, 'not null' => TRUE, 'default' => 'OPEN', ), 'received' => array( 'description' => t('The transaction status timestamp.'), 'type' => 'int', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0, ), ), 'primary key' => array('order_id'), 'unique keys' => array( 'vid' => array('trx_id'), ), 'indexes' => array( 'status' => array('status', 'received'), ), );
return $schema; }
/** * Implementation of hook_install(). */ function uc_ideal_pro_install() { drupal_install_schema('uc_ideal_pro');
$t = get_t(); db_query("INSERT INTO {uc_order_statuses} (order_status_id, title, state, weight, locked) VALUES ('ideal_pending', '%s', 'payment_received', 7, 1);", $t('i\ DEAL pending')); }
So it looks like the database fields weren't modified during install. I tried the update.php script, but it won't show this module. Any other way to modify the db?
Cheers, Thijs Hakkenberg
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.
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.
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.
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.
No. Issues are typically visible immediately after you create them. If you don't see the issue in the open issues queue, perhaps something went wrong with the submit?
________________________________
From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Thijs Hakkenberg Sent: Tuesday, July 13, 2010 8:41 AM To: support@drupal.org Subject: Re: [support] database fields not present
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.
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_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.
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/ ]
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/ ]