I am trying to Empty the Search Index from Repair/OptimizeTables to fix a mysql error number: 1033...and when trying to empty the search index i get the exact same mysql error so i cant do anything.
then I need to know what this means......
DROP TABLE IF EXISTS `postindex`;
CREATE TABLE postindex (
wordid INT UNSIGNED NOT NULL DEFAULT '0',
postid INT UNSIGNED NOT NULL DEFAULT '0',
intitle SMALLINT UNSIGNED NOT NULL DEFAULT '0',
score SMALLINT UNSIGNED NOT NULL DEFAULT '0',
UNIQUE KEY wordid (wordid, postid)""
then I need to know what this means......
DROP TABLE IF EXISTS `postindex`;
CREATE TABLE postindex (
wordid INT UNSIGNED NOT NULL DEFAULT '0',
postid INT UNSIGNED NOT NULL DEFAULT '0',
intitle SMALLINT UNSIGNED NOT NULL DEFAULT '0',
score SMALLINT UNSIGNED NOT NULL DEFAULT '0',
UNIQUE KEY wordid (wordid, postid)""
Comment