Sandbox

Posted: **Mon Jan 09, 2006 4:34 am**

there an ambiguous table field in Joomla!
field option in jos_component
and field fulltext in jos_content
fulltext and option show command in mySQL eyes, but in joomla they are show field

if i dump my sql to my database uing PhpMyAdmin, always showing error on it..
and i edit my sql file, especialy structure and data

just like this-->

#
# Table structure for table `jos_components`
#

DROP TABLE IF EXISTS jos_components;
CREATE TABLE jos_components (
id int(11) NOT NULL auto_increment,
name varchar(50) NOT NULL default '',
link varchar(255) NOT NULL default '',
menuid int(11) unsigned NOT NULL default '0',
parent int(11) unsigned NOT NULL default '0',
admin_menu_link varchar(255) NOT NULL default '',
admin_menu_alt varchar(255) NOT NULL default '',
option varchar(50) NOT NULL default '',
ordering int(11) NOT NULL default '0',
admin_menu_img varchar(255) NOT NULL default '',
iscore tinyint(4) NOT NULL default '0',
params text NOT NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;

make a little bit edit in option field, it should be-->

#
# Table structure for table `jos_components`
#

DROP TABLE IF EXISTS jos_components;
CREATE TABLE jos_components (
id int(11) NOT NULL auto_increment,
name varchar(50) NOT NULL default '',
link varchar(255) NOT NULL default '',
menuid int(11) unsigned NOT NULL default '0',
parent int(11) unsigned NOT NULL default '0',
admin_menu_link varchar(255) NOT NULL default '',
admin_menu_alt varchar(255) NOT NULL default '',
`option` varchar(50) NOT NULL default '',
ordering int(11) NOT NULL default '0',
admin_menu_img varchar(255) NOT NULL default '',
iscore tinyint(4) NOT NULL default '0',
params text NOT NULL,
PRIMARY KEY (id)
) TYPE=MyISAM;

dont forget to edit in field fulltext table jos_content

Sandbox

Ambiguous Table Field in jos_

Ambiguous Table Field in jos_