Icy Phoenix

Well I have failed to install Icy Phoenix successfully! It seems my MySQL is not liking the DB!
Here are some specs:
System: Windows
MySQL: 5.1 - 4.1(tried both)

My Error:
default db engine doesn´t support the fulltext index

I have tried 2 guides and no luck with them.
Guide 1
During the extraction, I received errors [cannot extract or w/e]. I still managed to place the 2 files in the right spot. After entering the install info, I got a MySQL error - Look in handbook for... not correct version... and so on.

Guide 2
I then tried this, but in my.ini file it was different. but i found INNODB and changed it to MyISAM. That also didnt work during the install.

Please help!

Hi, this might seem a silly / obvious question, but are you sure it is MySQL and not MSSQL?

Naw, It is MySQL. I have used it before but now when i try installing it on my Windows Server (Friends and their games... it would be linux) it gives me errors all over the place. It is after the screen where you enter you MySQL info and all [I get the following errors]:

First - TEXT ERROR thing (MyISAM)
Second[After Guide 1] - Wrong MySQL Version Error or w/e
Third[After Guide 2] - Same as first.

Yes sorry, suddenly realised after posting mssql would make a hell of a lot more error messages than that if you tried it!
Did you actually use the files from guide 1? Because the files there are out of date for the latest Icy Phoenix. I also think there is a fundamental problem in the second part of guide 1 (the INNODB zip file) because all that has been done is append TYPE=INNODB to all the tables, but 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... (in fact I'm just about to post this in that guide link).

I am thinking it would be better to modify the latest install script and update all the tables to type=myisam. I can do this very quickly in tswebeditor if you want...

Did it in two shakes... actually I used ENGINE = MYISAM, as TYPE is very outdated - it is possible that the MS mysql server is not so backward compatible, and possibly why part 1 of guide 1 didn't work...

You probably know where to put this file, but I'll explain for future ref: ip_root/install/schemas

Hope it helps ;)

Tried it on both MySQL 5.1 and 4.1 and received this error:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ENGINE = MYISAM' at line 6

Well, that rules out MS MYSQL being up-to-date...

Try this instead...

Another error! =(

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE=MyIsam' at line 1

Well this is really strange... all these variants work fine on mysql on a linux box (just tried them).

Just another shot in the dark now then, but perhaps it wants spaces between ) TYPE = xx, or MYISAM in caps... (this also works fine on my server, can't check windows server) - try this updated file then... although I'm beginning to think nothing will work... and that you might need to check with your host if MYISAM support is even installed on the mysql server...

Naw same thing!
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE = MYISAM' at line 1

Well I host my own server and your saying i need support for MyISAM? Where would i get this?

Oh and thanks so much BTW!

Shadowed wrote: [View Post]

Oh and thanks so much BTW!

You're welcome, sorry I am not much use here! I don't know about running mysql on windows, so missing engine support was just a guess, and probably wrong, since going by this article it appears myisam should be available no matter what install options you choose. (Perhaps it might be worth reinstalling mysql and changing the default engine choice, perhaps using the above article link for reference)?

Another possibility here may be the choice of delimiter at the end of the statement... the default in mysql is ";", but maybe your install has something else. It is easy to specify the delimiter by used of the delimiter command - just put on a line before the first create table statement, maybe that will help?

BTW do you have something like phpmyadmin running on your server? Maybe if will help for you to try running a single create table query in there - it being more straightforward to test different queries than modifying, uploading and executing the db schema file and install script...

Hmm actually a delimiter error would display the delimiter and the following CREATE TABLE line, not the type=myisam that precedes it...

Also, which version of MYSQL did you try the last file on? I say that because I've just found in mysql bugs section that mysql version 5.1 definitely produces the error "check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE = MYISAM' at line 1 " - it now only supports ENGINE and not TYPE, but some people call this a bug because the main documentation specifies that although TYPE is deprecated, it is "still supported", which is incorrect... i.e. a bug with the documentation (or else they should include backward functionality again)! This is perhaps why I don't have any problems, my server is still running Server version: 5.0.51...

So... perhaps have a try in the mysql command window with a single create table declaration from the mysql schema file, but with ENGINE instead of TYPE...

moreteavicar, you have to type this exactily:



Notice, all caps are capital except the "y".

Well now i have tried: MySQL - 4.1 ~ 5 ~ 5.1
Same all the way through... Im going to try whatever i can do tomorrow to get this. I am up for any suggestions!

novice programmer wrote: [View Post]

moreteavicar, you have to type this exactily:

Code: [Download] [Hide] [Select]

Code: [Download] [Show]

TYPE=MyISAM

Notice, all caps are capital except the "y".

No novice programmer... mysql is case insensitive. Read the docs next time ;)

To help out, here we go or 5.1:

MySQL 5.1 Documentation wrote: 

"Keywords may be entered in any lettercase"

Source: http://dev.mysql.com/doc/refman/5.1/en/entering-queries.html:

Official engine declaration example with all CAPS:

MySQL 5.1 Documentation wrote: 

CREATE TABLE t (i INT) ENGINE = MYISAM;

Source: http://dev.mysql.com/doc/refman/5.1...age-engine.html

That caps are used at all is convention - but a logical convention, since it helps to distinguish between queries and table / field names. look in some of the phpbb / icy phoenix code, you sill see a few sql queries dotted about in lowercase - "select" as opposed to SELECT being a common one.

You should be able to issue the command:
or
Try it... ;)