[support] database fields not present

[Metzler, David]

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 at drupal.org [mailto:support-bounces at drupal.org] On Behalf Of Thijs Hakkenberg
Sent: Tuesday, July 13, 2010 8:41 AM
To: support at 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.
			
			    

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20100713/26972ca7/attachment-0001.html