https://www.icyphoenix.com/viewtopic.php?f=4&t=2520
-----------------------------------
novice programmer
Tue 24 Jul, 2007 21:05

DEBUG - Mysql Errors Solution While Installing
-----------------------------------
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:
[code linenumbers=false]
Search

CREATE TABLE

Search

);

In-line remplace with:

)TYPE=MyIsam;

[/code]

Until the end of the file.
That´s all.

Note: Thanks for the zone moving


[size=18][b][u]DO NOT DOWNLOAD THIS FILES IF VARIOUS BOARD DB USERS USED[/u][/b][/size]


-----------------------------------
novice programmer
Tue 24 Jul, 2007 21:15

Re: Mysql Errors Solution While Installing
-----------------------------------
Both files have to be uploaded to:

[code linenumbers=false]install/schemas/[/code]


-----------------------------------
Zuker
Tue 24 Jul, 2007 21:19

Re: Mysql Errors Solution While Installing
-----------------------------------
thanks ;)


-----------------------------------
novice programmer
Tue 24 Jul, 2007 22:03

Re: Mysql Errors Solution While Installing
-----------------------------------
[quote user="Zuker" post="17943"]thanks ;)[/quote]

post traduced to spanish & posted in [url=http://www.phpbb-es.com/foro/viewtopic.php?p=71189#p71189]phpbb-es.com post


-----------------------------------
Mighty Gorgon
Wed 25 Jul, 2007 23:58

Re: Mysql Errors Solution While Installing
-----------------------------------
I can't remember why... but I have removed the [b]TYPE=MyISAM[/b] for one particular reason...

I'll try to investigate why and eventually I'll let you know.


-----------------------------------
novice programmer
Thu 26 Jul, 2007 00:12

Re: Mysql Errors Solution While Installing
-----------------------------------
MG or another with permmision for moving:

Rate if [url=http://www.icyphoenix.com/viewtopic.php?t=2528]this other topic should be in this section.


-----------------------------------
novice programmer
Fri 27 Jul, 2007 21:58

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


-----------------------------------
novice programmer
Wed 01 Aug, 2007 22:02

Re: Mysql Errors Solution While Installing
-----------------------------------
[size=18]ONLY DOWNLOAD THIS FILES IF YOU USE VARIOUS DB USERS ON THE BOARD DB[/size]

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

Re: Mysql Errors Solution While Installing
-----------------------------------
Thanks [b]novice programmer[/b] for all these hints. :wink:


-----------------------------------
moreteavicar
Wed 19 Mar, 2008 03:12

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:

[code linenumbers=false]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;[/code] 
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 ([url=http://www.mysqlperformanceblog.com/2007/01/08/innodb-vs-myisam-vs-falcon-benchmarks-part-1/]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  :mrgreen:


-----------------------------------
novice programmer
Wed 19 Mar, 2008 21:07

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!)


-----------------------------------
moreteavicar
Thu 20 Mar, 2008 20:30

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 ;)


-----------------------------------
novice programmer
Thu 20 Mar, 2008 21:05

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.


-----------------------------------
Gushh
Tue 08 Sep, 2009 14:34

Re: DEBUG - Mysql Errors Solution While Installing
-----------------------------------
[quote user="novice programmer" post="17941"]
The changes are:
[code linenumbers=false]
Search

CREATE TABLE

Search

);

In-line remplace with:

)TYPE=MyIsam;

[/code]
[/quote]

agrego eso al final del .sql?? o busco la parte ); y reemplazo por )TYPE=MyIsam; ??

todavia no pude instalar el icy  :cry:  :cry:


-----------------------------------
novice programmer
Tue 08 Sep, 2009 15:42

Re: DEBUG - Mysql Errors Solution While Installing
-----------------------------------
[quote user="Gushh" post="44119"][quote user="novice programmer" post="17941"]
The changes are:
[code linenumbers=false]
Search

CREATE TABLE

Search

);

In-line remplace with:

)TYPE=MyIsam;

[/code]
[/quote]

agrego eso al final del .sql?? o busco la parte ); y reemplazo por )TYPE=MyIsam; ??

todavia no pude instalar el icy  :cry:  :cry:[/quote]

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 [url=http://translate.google.com]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 [url=http://www.icyphoenix.es]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 [url=http://www.icyphoenix.es]Icy Phoenix Spain, recognized by this site, with several of their mods/admins also at the staff groups here.


