Weird navicat error?

[ZnyX]

Hey folks, i got a small problem with a freinds navicat, when he's trying to execute Spartans and even Silvermoon's DB


Error that accoured, is the following.

[Err] 1074 - Column length too big for column 'regex_ignore_if_matched' (max = 255); use BLOB or TEXT instead
[Err] -- ----------------------------
-- Table structure for wordfilter_character_names
-- ----------------------------
CREATE TABLE `wordfilter_character_names` (
`regex_match` varchar(500) NOT NULL,
`regex_ignore_if_matched` varchar(500) NOT NULL default ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
[Msg] Finished - Unsuccessfully
--------------------------------------------------


I've never seen it before, and i'm totaly clueless, hope we got a guy here thats able to solve the problem

Thanks in advance!

[latruwski]

Hey folks, i got a small problem with a freinds navicat, when he's trying to execute Spartans and even Silvermoon's DB


Error that accoured, is the following.

[Err] 1074 - Column length too big for column 'regex_ignore_if_matched' (max = 255); use BLOB or TEXT instead
[Err] -- ----------------------------
-- Table structure for wordfilter_character_names
-- ----------------------------
CREATE TABLE `wordfilter_character_names` (
`regex_match` varchar(500) NOT NULL,
`regex_ignore_if_matched` varchar(500) NOT NULL default ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
[Msg] Finished - Unsuccessfully
--------------------------------------------------


I've never seen it before, and i'm totaly clueless, hope we got a guy here thats able to solve the problem

Thanks in advance!

the table you are trying to create has too big column ...

instead of:

 CREATE TABLE `wordfilter_character_names` (
  `regex_match` varchar(500) NOT NULL,
  `regex_ignore_if_matched` varchar(500) NOT NULL default ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

try this one:

 CREATE TABLE `wordfilter_character_names` (
  `regex_match` varchar(255) NOT NULL,
  `regex_ignore_if_matched` varchar(255) NOT NULL default ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

[Ellenor]

or use it on an empty database!

It will solve the promb and latru i think u are wrong... its a sql promblem that cant read it

(i may be wrong too... but i had the same prob like 2 weeks before):P

[Ellenor]

btw u cant use the repack on an existing database:P

[ZnyX]

I executet it on a clean DB, i'm running Silvermoon myself, and had absolutly not problems executing it at all?. And yeah latruwski i thought of changing that, i was just not to sure about it . I'll try it later, hope it works. What about the first error? The one with

1074 - Column length too big for column 'regex_ignore_if_matched' (max = 255); use BLOB or TEXT instead

Anything to do there? Or?

[latruwski]

this is the one from ncdb (latest)

/*!40100 SET CHARACTER SET cp1250*/;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0*/;


DROP TABLE IF EXISTS `wordfilter_character_names`;

#
# Table structure for table 'wordfilter_character_names'
#

CREATE TABLE `wordfilter_character_names` (
  `regex_match` varchar(500) NOT NULL,
  `regex_ignore_if_matched` varchar(500) NOT NULL default ''
) ENGINE=MyISAM /*!40100 DEFAULT CHARSET=latin1*/;



#
# Dumping data for table 'wordfilter_character_names'
#

# (No data found.)

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS*/;

[ZnyX]

Thanks a lot latruwski, the change of

CREATE TABLE `wordfilter_character_names` (
`regex_match` varchar(500) NOT NULL,
`regex_ignore_if_matched` varchar(500) NOT NULL default ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

To CREATE TABLE `wordfilter_character_names` (
`regex_match` varchar(255) NOT NULL,
`regex_ignore_if_matched` varchar(255) NOT NULL default ''
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Worked, apriciate it.

EDIT: 1x rep, sorry i can't give anymore , you were very helpfull.

[latruwski]

or use it on an empty database!

It will solve the promb and latru i think u are wrong... its a sql promblem that cant read it

(i may be wrong too... but i had the same prob like 2 weeks before):P

thah i guess i was right after all :P

anyhow no problem m8, we are here to help

grtz