bkkn
Karma: 0
|
cannot enter the Term.....SOS!! - 2007/06/04 12:23
If I enter two same Term (but they have different definitions) it does not take the second one.
Can you please tell how can i add two same terms.
It happens even if i add Terms in different categories.
Thanks for your help in advance
|
|
|
| | Sorry, you do not currently have permission to write here. |
bengim2
Karma: 0
|
Re:cannot enter the Term.....SOS!! - 2007/06/04 21:46
bkkn;
firstly you must delete glossary compenant and open compenant xml file and delete UNIQUE KEY `term` (`tterm`), like this after zip files and upload your sites . ok
</files>
<install>
<queries>
<query>
CREATE TABLE IF NOT EXISTS `#__glossary` (
`id` int(10) NOT NULL auto_increment,
`tletter` char(1) NOT NULL default '',
`tterm` varchar(40) NOT NULL default '',
`tdefinition` text NOT NULL,
`tname` varchar(20) NOT NULL default '',
`tloca` varchar(60) default NULL,
`tmail` varchar(60) default NULL,
`tpage` varchar(150) default NULL,
`tdate` datetime default NULL,
`tcomment` text,
`tedit` enum('y','n') NOT NULL default 'n',
`teditdate` datetime default NULL,
`published` tinyint(1) NOT NULL default '0',
`catid` int(3) NOT NULL default '0',
`checked_out` int(11) NOT NULL default '0',
UNIQUE KEY `term` (`tterm`),
PRIMARY KEY (`id`),
FULLTEXT (`tdefinition`)
) TYPE=MyISAM
</query>
</queries>[size=4][/size]
Post edited by: bengim2, at: 2007/06/08 19:23
|
|
|
| | Sorry, you do not currently have permission to write here. |
bkkn
Karma: 0
|
Re:cannot enter the Term.....SOS!! - 2007/06/05 16:02
thanks a lot for your reply..
i change the line from
UNIQUE KEY `term` (`tterm`),
to
UNIQUE KEY `term`,
then i zipped it but while uploading it i am getting following error
SQL Error DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' PRIMARY KEY (`id`), FULLTEXT (`tdefinition`) ) TYP' at line 17 SQL=CREATE TABLE IF NOT EXISTS `jos_glossary` ( `id` int(10) NOT NULL auto_increment, `tletter` char(1) NOT NULL default '', `tterm` varchar(40) NOT NULL default '', `tdefinition` text NOT NULL, `tname` varchar(20) NOT NULL default '', `tloca` varchar(60) default NULL, `tmail` varchar(60) default NULL, `tpage` varchar(150) default NULL, `tdate` datetime default NULL, `tcomment` text, `tedit` enum('y','n') NOT NULL default 'n', `teditdate` datetime default NULL, `published` tinyint(1) NOT NULL default '0', `catid` int(3) NOT NULL default '0', `checked_out` int(11) NOT NULL default '0', UNIQUE KEY `term`, PRIMARY KEY (`id`), FULLTEXT (`tdefinition`) ) TYPE=MyISAM
SQL =
CREATE TABLE IF NOT EXISTS `jos_glossary` (
`id` int(10) NOT NULL auto_increment,
`tletter` char(1) NOT NULL default '',
`tterm` varchar(40) NOT NULL default '',
`tdefinition` text NOT NULL,
`tname` varchar(20) NOT NULL default '',
`tloca` varchar(60) default NULL,
`tmail` varchar(60) default NULL,
`tpage` varchar(150) default NULL,
`tdate` datetime default NULL,
`tcomment` text,
`tedit` enum('y','n') NOT NULL default 'n',
`teditdate` datetime default NULL,
`published` tinyint(1) NOT NULL default '0',
`catid` int(3) NOT NULL default '0',
`checked_out` int(11) NOT NULL default '0',
UNIQUE KEY `term`,
PRIMARY KEY
(`id`),
FULLTEXT (`tdefinition`)
) TYPE=MyISAM
Can you please explain what should i do for this?
thanks in advance
|
|
|
| | Sorry, you do not currently have permission to write here. |
bengim2
Karma: 0
|
Re:cannot enter the Term.....SOS!! - 2007/06/06 07:39
open phpmyadmin and delete jos_glossary table
and again install compenant it must be because I can use this like you can see www.turkbirlik.gen.tr
Post edited by: bengim2, at: 2007/06/06 06:40
|
|
|
| | Sorry, you do not currently have permission to write here. |
bkkn
Karma: 0
|
Re:cannot enter the Term.....SOS!! - 2007/06/06 23:19
Hi again thanks for your reply....
i fixed this one...
i did the following change first time
-------------------------------
from
UNIQUE KEY `term` (`tterm`),
to
UNIQUE KEY `term`,
-------------------------------
but i had to delete the complete line
UNIQUE KEY `term` (`tterm`),
then it worked...
thanks a lot
|
|
|
| | Sorry, you do not currently have permission to write here. |
bengim2
Karma: 0
|
Re:cannot enter the Term.....SOS!! - 2007/06/08 20:23
ok bkkn can you write your web site here
|
|
|
| | Sorry, you do not currently have permission to write here. |
|
Forum
