<!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">
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.<br>
<pre class="moz-signature" cols="72">Jamie Holly
<a class="moz-txt-link-freetext" href="http://www.intoxination.net">http://www.intoxination.net</a>
<a class="moz-txt-link-freetext" href="http://www.hollyit.net">http://www.hollyit.net</a></pre>
<br>
On 7/8/2010 11:46 AM, Thijs Hakkenberg wrote:
<blockquote cite="mid:4C35F2D8.1000805@ebrius.nl" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
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>
</blockquote>
</body>
</html>