Ambiguous Table Field in jos_

If you have any 'mechanical' forge related issues/suggestions, pop them in here.
Post Reply
User avatar
apung
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Sun Sep 18, 2005 8:53 am
Location: Jakarta, Indonesia (GMT +7)
Contact:

Ambiguous Table Field in jos_

Post by apung » 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
.. may the source be with us ..
http://www.apung.web.id

Post Reply