<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
I've posted the issue: <a class="moz-txt-link-freetext" href="http://drupal.org/node/853842">http://drupal.org/node/853842</a><br>
<br>
On 13-7-2010 16:09, Thijs Hakkenberg wrote:
<blockquote cite="mid:4C3C7396.6070107@ebrius.nl" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
<title></title>
Thanks, I will. <br>
<br>
On 8-7-2010 17:51, Metzler, David wrote:
<blockquote
cite="mid:52177C930FA90F4D9888B0343FDB79FB0277E050@birch.evergreen.edu"
type="cite">
<div class="moz-text-html" lang="x-western">
<div dir="ltr" align="left"><span class="977394915-08072010"><font
size="2" color="#0000ff" face="Arial">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" dir="ltr" align="left"
lang="en-us">
<hr tabindex="-1"> <font size="2" face="Tahoma"><b>From:</b>
<a moz-do-not-send="true" class="moz-txt-link-abbreviated"
href="mailto:support-bounces@drupal.org">support-bounces@drupal.org</a>
[<a moz-do-not-send="true" class="moz-txt-link-freetext"
href="mailto:support-bounces@drupal.org">mailto:support-bounces@drupal.org</a>]
<b>On Behalf Of </b>Thijs Hakkenberg<br>
<b>Sent:</b> Thursday, July 08, 2010 8:47 AM<br>
<b>To:</b> <a moz-do-not-send="true"
class="moz-txt-link-abbreviated"
href="mailto:support@drupal.org">support@drupal.org</a><br>
<b>Cc:</b> Michel Morelli<br>
<b>Subject:</b> Re: [support] database fields not present<br>
</font><br>
</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>
<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>
</div>
<div class="moz-text-plain" wrap="true" graphical-quote="true"
style="font-family: -moz-fixed; font-size: 14px;"
lang="x-western">
<pre wrap=""><fieldset class="mimeAttachmentHeader"></fieldset>
<div class="moz-txt-sig">--
[ Drupal support list | <a moz-do-not-send="true" class="moz-txt-link-freetext" href="http://lists.drupal.org/">http://lists.drupal.org/</a> ]</div></pre>
</div>
</blockquote>
</blockquote>
</body>
</html>