<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.6000.16981" name=GENERATOR></HEAD>
<BODY text=#000000 bgColor=#ffffff>
<DIV dir=ltr align=left><SPAN class=977394915-08072010><FONT face=Arial
color=#0000ff size=2>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. </FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> support-bounces@drupal.org
[mailto:support-bounces@drupal.org] <B>On Behalf Of </B>Thijs
Hakkenberg<BR><B>Sent:</B> Thursday, July 08, 2010 8:47 AM<BR><B>To:</B>
support@drupal.org<BR><B>Cc:</B> Michel Morelli<BR><B>Subject:</B> Re: [support]
database fields not present<BR></FONT><BR></DIV>
<DIV></DIV>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. <BR><BR>However,
now this error arises: <BR>
<DIV class="messages error">
<UL>
<LI>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.
<LI>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. </LI></UL>it looks like the field 'status' and 'received' should
also be added.. <BR><BR>But any idea why these fields weren't installed by the
module? And why isn't it possible to do it via drupal again?
<BR><BR>Thanks!<BR></DIV><BR><BR>On 8-7-2010 2:08, Michel Morelli wrote:
<BLOCKQUOTE cite=mid:4C3516FB.8080509@ziobuddalabs.it type="cite"><PRE wrap="">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.
</PRE></BLOCKQUOTE></BODY></HTML>