Radicore Forum: Bug Reports » Proble with primary key + unique

Home » RADICORE development » Bug Reports » Proble with primary key + unique

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Proble with primary key + unique [message #1463]

Mon, 14 July 2008 15:01

bonzo_bcn
Messages: 152
Registered: June 2008

Senior Member

I found out that when importing this table to radicore and exporting to php:

CREATE TABLE IF NOT EXISTS `programa` (
	`programa_id` integer NOT NULL AUTO_INCREMENT,
	`entidad_id` integer NOT NULL ,
	`nombre` varchar(30) NOT NULL default '',

	PRIMARY KEY  (`programa_id`),
	UNIQUE KEY  (`entidad_id`,`nombre`),
	unique (`programa_id`)
) TYPE=MyISAM;

the .dict.inc file generated includes this code which gives an error:


    $this->unique_keys[]                    = array(,
                                                    'nombre');

Report message to a moderator

Re: Proble with primary key + unique [message #1468 is a reply to message #1463]

Mon, 14 July 2008 20:41

AJM
Messages: 2382
Registered: April 2006
Location: Surrey, UK

Senior Member

Yes, this is a bug - fix attached.

BTW, declaring 'programa_id' as both 'primary_key' and 'unique' is superfluous as a primay key is automatically unique.

Attachment: dict_table_s02.class.zip
(Size: 5.03KB, Downloaded 1051 times)

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Previous Topic:	Fatal error: Cannot use string offset as an array in ...
Next Topic:	Two fields not showing -Solved

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Tue Sep 16 08:15:18 EDT 2025

Total time taken to generate the page: 0.00998 seconds