I´ve detected that the mysql_schema.sql file doesn´t specify the engine of the tables while installing.
In some servers it gives an error message because of it, becase the default db engine doesn´t support the fulltext index
Error repared with this file for new installs.
The changes are:
Until the end of the file.
That´s all.
Note: Thanks for the zone moving
DO NOT DOWNLOAD THIS FILES IF VARIOUS BOARD DB USERS USED
Icy Phoenix
Documentation And How To - DEBUG - Mysql Errors Solution While Installing
novice programmer [ Tue 24 Jul, 2007 21:05 ]
Post subject: DEBUG - Mysql Errors Solution While Installing
Post subject: DEBUG - Mysql Errors Solution While Installing
novice programmer [ Tue 24 Jul, 2007 21:15 ]
Post subject: Re: Mysql Errors Solution While Installing
Post subject: Re: Mysql Errors Solution While Installing
Zuker [ Tue 24 Jul, 2007 21:19 ]
Post subject: Re: Mysql Errors Solution While Installing
Post subject: Re: Mysql Errors Solution While Installing
thanks 
novice programmer [ Tue 24 Jul, 2007 22:03 ]
Post subject: Re: Mysql Errors Solution While Installing
Post subject: Re: Mysql Errors Solution While Installing
Mighty Gorgon [ Wed 25 Jul, 2007 23:58 ]
Post subject: Re: Mysql Errors Solution While Installing
Post subject: Re: Mysql Errors Solution While Installing
I can't remember why... but I have removed the TYPE=MyISAM for one particular reason...
I'll try to investigate why and eventually I'll let you know.
I'll try to investigate why and eventually I'll let you know.
novice programmer [ Thu 26 Jul, 2007 00:12 ]
Post subject: Re: Mysql Errors Solution While Installing
Post subject: Re: Mysql Errors Solution While Installing
novice programmer [ Fri 27 Jul, 2007 21:58 ]
Post subject: Re: Mysql Errors Solution While Installing
Post subject: Re: Mysql Errors Solution While Installing
I know what reason was that:
MyISAM is a non-transaccional db motor which uses table-level blocks.
So this means that it will get inter-block every time!!!
And many actions will be interrupted because another user was looking in that table.
--------------------------
The solution is puting the engine to InnoDB, which is a transaccional db motor which uses row-level blocks.
That means I´ll update the files with that & the index will be of kind of "INDEX"
EDITING:
IT gives errors when changing to InnoDB db motor if similar topics activated
MyISAM is a non-transaccional db motor which uses table-level blocks.
So this means that it will get inter-block every time!!!
And many actions will be interrupted because another user was looking in that table.
--------------------------
The solution is puting the engine to InnoDB, which is a transaccional db motor which uses row-level blocks.
That means I´ll update the files with that & the index will be of kind of "INDEX"
EDITING:
IT gives errors when changing to InnoDB db motor if similar topics activated
novice programmer [ Wed 01 Aug, 2007 22:02 ]
Post subject: Re: Mysql Errors Solution While Installing
Post subject: Re: Mysql Errors Solution While Installing
ONLY DOWNLOAD THIS FILES IF YOU USE VARIOUS DB USERS ON THE BOARD DB
This others files use the TYPE=InnoDB
This will allow to users of une board page use it without stopping by the others users of the other page.
The similar topics has to be disabled.
This others files use the TYPE=InnoDB
This will allow to users of une board page use it without stopping by the others users of the other page.
The similar topics has to be disabled.
Mighty Gorgon [ Fri 10 Aug, 2007 18:03 ]
Post subject: Re: Mysql Errors Solution While Installing
Post subject: Re: Mysql Errors Solution While Installing
Thanks novice programmer for all these hints.
moreteavicar [ Wed 19 Mar, 2008 03:12 ]
Post subject: Re: Mysql Errors Solution While Installing
Post subject: Re: Mysql Errors Solution While Installing
I suspect the tables here are a bit out of date now, but I thought I'd point out something. In the InnoDB script given above, all that has been done is to put TYPE=InnoDB at the end of each table. How does this actually solve the problem of a full text table index on MS servers?
Look for instance at:
hack_name and hack_file are still both text keys... so nothing has been done to change the indexes that are used - where there are text indexes in the MYISAM tables, they remain text indexes in INNODB tables, surely this will cause the same "The used table type doesn't support FULLTEXT indexes" error...
I also don't think "multiple database users" is the reason MYISAM was dropped - since most MYSQL servers assign MYISAM by default! If you wanted to avoid MYISAM, your won't get round it by not declaring an alternative engine. (Perhaps that was what MG had in mind, or perhaps the fact that "TABLE" is deprecated, and was going to replace with "ENGINE"?).
Interesting note - MYSQL supports hyper-threading regardless of engine, and in fact in a number of cases MYISAM scales the better with multiple threads than InnoDB (See here), even if slower in some other cases (contrary to rumour that most people think MYISAM is the fastest of the disk engines, the truth is a lot more subtle - it depends largely on the sort of queries you're most likely to make).
Perhaps we should just use HEAP engines
Look for instance at:
CREATE TABLE `phpbb_hacks_list` (
`hack_id` mediumint(8) unsigned NOT NULL auto_increment,
`hack_name` varchar(255) NOT NULL default '',
`hack_desc` varchar(255) NOT NULL default '',
`hack_author` varchar(255) NOT NULL default '',
`hack_author_email` varchar(255) NOT NULL default '',
`hack_author_website` tinytext NOT NULL,
`hack_version` varchar(32) NOT NULL default '',
`hack_hide` enum('Yes','No') NOT NULL default 'No',
`hack_download_url` tinytext NOT NULL,
`hack_file` varchar(255) NOT NULL default '',
`hack_file_mtime` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`hack_id`),
UNIQUE KEY `hack_name` (`hack_name`),
KEY `hack_file` (`hack_file`),
KEY `hack_hide` (`hack_hide`)
)TYPE=InnoDB;
`hack_id` mediumint(8) unsigned NOT NULL auto_increment,
`hack_name` varchar(255) NOT NULL default '',
`hack_desc` varchar(255) NOT NULL default '',
`hack_author` varchar(255) NOT NULL default '',
`hack_author_email` varchar(255) NOT NULL default '',
`hack_author_website` tinytext NOT NULL,
`hack_version` varchar(32) NOT NULL default '',
`hack_hide` enum('Yes','No') NOT NULL default 'No',
`hack_download_url` tinytext NOT NULL,
`hack_file` varchar(255) NOT NULL default '',
`hack_file_mtime` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`hack_id`),
UNIQUE KEY `hack_name` (`hack_name`),
KEY `hack_file` (`hack_file`),
KEY `hack_hide` (`hack_hide`)
)TYPE=InnoDB;
hack_name and hack_file are still both text keys... so nothing has been done to change the indexes that are used - where there are text indexes in the MYISAM tables, they remain text indexes in INNODB tables, surely this will cause the same "The used table type doesn't support FULLTEXT indexes" error...
I also don't think "multiple database users" is the reason MYISAM was dropped - since most MYSQL servers assign MYISAM by default! If you wanted to avoid MYISAM, your won't get round it by not declaring an alternative engine. (Perhaps that was what MG had in mind, or perhaps the fact that "TABLE" is deprecated, and was going to replace with "ENGINE"?).
Interesting note - MYSQL supports hyper-threading regardless of engine, and in fact in a number of cases MYISAM scales the better with multiple threads than InnoDB (See here), even if slower in some other cases (contrary to rumour that most people think MYISAM is the fastest of the disk engines, the truth is a lot more subtle - it depends largely on the sort of queries you're most likely to make).
Perhaps we should just use HEAP engines
novice programmer [ Wed 19 Mar, 2008 21:07 ]
Post subject: Re: Mysql Errors Solution While Installing
Post subject: Re: Mysql Errors Solution While Installing
MyISAM engine is the unique engine that allows the FULLTEXT indexes.
InnoDB allows that two different users (from the mysql system, not from the net) can read the table at the same moment if one of them is writting data in the table, as MyISAM blocks the table from reading while it is being written, which do not happens with the InnoDB engine.
PS: Thanks for remember me that was out-of-date. I will start making the file for the lastest bulid right now (Thanks to god I am on holidays, no more things I have to study!)
InnoDB allows that two different users (from the mysql system, not from the net) can read the table at the same moment if one of them is writting data in the table, as MyISAM blocks the table from reading while it is being written, which do not happens with the InnoDB engine.
PS: Thanks for remember me that was out-of-date. I will start making the file for the lastest bulid right now (Thanks to god I am on holidays, no more things I have to study!)
moreteavicar [ Thu 20 Mar, 2008 20:30 ]
Post subject: Re: Mysql Errors Solution While Installing
Post subject: Re: Mysql Errors Solution While Installing
Hail! I know what the differences between the two are.
What I mean is - the table fields are exactly the same in both your MyISAM and InnoDB schema files, the only difference is the type declaration. This means that any tables in the sql schema that have full text indexes will still remain, and so surely it should still generate errors on MS mysql servers
What I mean is - the table fields are exactly the same in both your MyISAM and InnoDB schema files, the only difference is the type declaration. This means that any tables in the sql schema that have full text indexes will still remain, and so surely it should still generate errors on MS mysql servers
novice programmer [ Thu 20 Mar, 2008 21:05 ]
Post subject: Re: Mysql Errors Solution While Installing
Post subject: Re: Mysql Errors Solution While Installing
It do not give any error if you remove the "ADD FULLTEXT ..." lines at the script.
The only thing it affect is to the similar topics, which has to be deactivated.
The only thing it affect is to the similar topics, which has to be deactivated.
Gushh [ Tue 08 Sep, 2009 14:34 ]
Post subject: Re: DEBUG - Mysql Errors Solution While Installing
agrego eso al final del .sql?? o busco la parte ); y reemplazo por )TYPE=MyIsam; ??
todavia no pude instalar el icy
Post subject: Re: DEBUG - Mysql Errors Solution While Installing
novice programmer wrote: [View Post]
agrego eso al final del .sql?? o busco la parte ); y reemplazo por )TYPE=MyIsam; ??
todavia no pude instalar el icy
novice programmer [ Tue 08 Sep, 2009 15:42 ]
Post subject: Re: DEBUG - Mysql Errors Solution While Installing
tienes que reemplazar todos los ); por )TYPE=MyIsam; para las consultas de tipo "CREATE TABLE" (hay algunas que no son para hacer una tabla, sino para meter datos, que no necesitan este cambio.
por cierto, este foro usa como idioma primario el ingles, y pedimos a todos los usuarios que intenten usar este lenguaje para preguntar, ya que asi pueden conseguir soporte mas rapidamente. Tambien puedes escribir en ambos idiomas en tus mensajes. En caso de que tengas problemas al traducir, prueba a usar Google Translate. Ayuda mucho en esos casos.
En caso de que te sea muy dificil, hay una comunidad de soporte hispana de Icy Phoenix en Icy Phoenix España, reconocido por este sitio, y con varios de sus moderadores/administradores en nuestros esquipos de moderacion/administracion
__________________________
have to replace all ); for )TYPE=MyISAM; for all the queries of the "CREATE TABLE" kind (there are some that are not for creating a table, but for inserting data, which do not require this change.
BTW, this forum used as the primary language English, and we ask all users to try to use this language in their posts, so they can get answers and support quicker. You can also write in both languages on your messages. In case you have trouble translating, try using [url = http://translate.google.com] Google Translate [/ url]. It helps a lot in such cases.
Finally, in case you find posting in english very difficult, there is a Spanish support community for Icy Phoenix at Icy Phoenix Spain, recognized by this site, with several of their mods/admins also at the staff groups here.
Post subject: Re: DEBUG - Mysql Errors Solution While Installing
Gushh wrote: [View Post]
tienes que reemplazar todos los ); por )TYPE=MyIsam; para las consultas de tipo "CREATE TABLE" (hay algunas que no son para hacer una tabla, sino para meter datos, que no necesitan este cambio.
por cierto, este foro usa como idioma primario el ingles, y pedimos a todos los usuarios que intenten usar este lenguaje para preguntar, ya que asi pueden conseguir soporte mas rapidamente. Tambien puedes escribir en ambos idiomas en tus mensajes. En caso de que tengas problemas al traducir, prueba a usar Google Translate. Ayuda mucho en esos casos.
En caso de que te sea muy dificil, hay una comunidad de soporte hispana de Icy Phoenix en Icy Phoenix España, reconocido por este sitio, y con varios de sus moderadores/administradores en nuestros esquipos de moderacion/administracion
__________________________
have to replace all ); for )TYPE=MyISAM; for all the queries of the "CREATE TABLE" kind (there are some that are not for creating a table, but for inserting data, which do not require this change.
BTW, this forum used as the primary language English, and we ask all users to try to use this language in their posts, so they can get answers and support quicker. You can also write in both languages on your messages. In case you have trouble translating, try using [url = http://translate.google.com] Google Translate [/ url]. It helps a lot in such cases.
Finally, in case you find posting in english very difficult, there is a Spanish support community for Icy Phoenix at Icy Phoenix Spain, recognized by this site, with several of their mods/admins also at the staff groups here.