Problem with the SQL statement in this MOD

[mariocaz]

Hi AmigaLink, I'm Mario from Mexico city !!

First congratulations for this great MOD !! :wink:

I'm trying to install it in my Forum but I have a problem with the SQL statement when I run it in the phpMyAdmin.

This is the part when I have the problem.

Code: Alles auswählen

CREATE TABLE `phpbb_lexicon` (
  `id` bigint(8) NOT NULL auto_increment,
  `keyword` varchar(250) NOT NULL default '',
  `explanation` longtext NOT NULL,
  `bbcode_uid` varchar(19) NULL,
  'cat' int(8) NOT NULL default '1'
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

INSERT INTO `phpbb_lexicon` VALUES (1, '1th example', 'This is a testentry to example the character-navigation.<br />By default the numbers does not shown. They only will display if exist a entry.');
INSERT INTO `phpbb_lexicon` VALUES (2, 'Testentry', 'This is another entry to example the lexicon.');

The rest I run without problems.

Thanx for your help and sorry for my bad english.

What I have to do ?

I attach the ERROR in my phpMyAdmin.

[oxpus]

Try this:

Code: Alles auswählen

CREATE TABLE `phpbb_lexicon` (
  `id` bigint(8) NOT NULL auto_increment,
  `keyword` varchar(250) NOT NULL default '',
  `explanation` longtext NOT NULL,
  `bbcode_uid` varchar(19) NULL,
  'cat' int(8) NOT NULL default '1' ,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

There was a commata missing after the definition for the field "cat".

[AmigaLink]

Zugefügt nach 13 Minute(n):

Thx, oxpus.

And thanks for the praise and the reference, mario.

I corrected the Modpacket immediately times.

[pepi]

Try this:

Code: Alles auswählen

CREATE TABLE `phpbb_lexicon` (
  `id` bigint(8) NOT NULL auto_increment,
  `keyword` varchar(250) NOT NULL default '',
  `explanation` longtext NOT NULL,
  `bbcode_uid` varchar(19) NULL,
  'cat' int(8) NOT NULL default '1' ,
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

There was a commata missing after the definition for the field "cat".

hallo amiga
bei funktioniert dies nicht in der datenbank

http://www.cool-lighter.com/forum/upload/lexicon.gif

bitte um hilfe

[mariocaz]

Hi AmigaLink !

With this changes...

Code: Alles auswählen

CREATE TABLE `phpbb_lexicon` (
  `id` bigint(8) NOT NULL auto_increment,
  `keyword` varchar(250) NOT NULL default '',
  `explanation` longtext NOT NULL,
  `bbcode_uid` varchar(19) NULL,
  'cat' int(8) NOT NULL default '1',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

I continue having the same problem (ERROR).

What's happen?? Are u very sure that are ok ?

Regards,

Mario

[AmigaLink]

Ok, this must work:

Code: Alles auswählen

CREATE TABLE `phpbb_lexicon` (
  `id` bigint(8) NOT NULL auto_increment,
  `keyword` varchar(250) NOT NULL default '',
  `explanation` longtext NOT NULL,
  `bbcode_uid` varchar(10) default NULL,
  `cat` int(8) NOT NULL default '1',
  PRIMARY KEY  (`id`),
  KEY `cat` (`cat`)
) TYPE=MyISAM;

Because it is an export of my Database.

[pepi]

hallo amiga

der funktioniert
aber das geht auch nicht
alle anderen funktionieren

INSERT INTO `phpbb_lexicon` VALUES (1, '1th example', 'This is a testentry to example the character-navigation.<br />By default the numbers does not shown. They only will display if exist a entry.');
INSERT INTO `phpbb_lexicon` VALUES (2, 'Testentry', 'This is another entry to example the lexicon.');

bis dann

[mariocaz]

Thanx AmigaLink!

That fix that problem.

But now the ERROR is in this part:

Code: Alles auswählen

INSERT INTO `phpbb_lexicon` VALUES (1, '1th example', 'This is a testentry to example the character-navigation.<br />By default the numbers does not shown. They only will display if exist a entry.');
INSERT INTO `phpbb_lexicon` VALUES (2, 'Testentry', 'This is another entry to example the lexicon.');

[AmigaLink]

Code: Alles auswählen

INSERT INTO `phpbb_lexicon` VALUES (1, '1th example', 'This is a testentry to example the character-navigation.<br />By default the numbers does not shown. They only will display if exist a entry.', NULL, 1);
INSERT INTO `phpbb_lexicon` VALUES (2, 'Testentry', 'This is another entry to example the lexicon.', NULL, 1);

[pepi]

danke

perfekt ...