<!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 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>
</body>
</html>