https://www.icyphoenix.com/viewtopic.php?f=35&t=6356
-----------------------------------
Nirose
Tue 25 Aug, 2009 03:45

Problem Setting Up Sql At Install.
-----------------------------------
I have 
PHP version	5.2.9
MySQL version	5.0.81-community
 on my server and while trying to install i get the following error

The used table type doesn't support FULLTEXT indexes 

After that i copied the file with the type changed to MyISAM

Then again while trying to install i get this error

An error occurred trying to update the database
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 '=MyIsam' at line 1

Tried replacing with 
)TYPE=MyISAM;
and
)TYPE = MyISAM;
How do i fix this. :(  :(


-----------------------------------
Lopalong
Tue 25 Aug, 2009 04:06

Re: Problem Setting Up Sql At Install.
-----------------------------------
Is this "localhost" on your PC, and if so - what are you using - XAMPP - SLAMPP etc ?


-----------------------------------
Nirose
Tue 25 Aug, 2009 04:13

Re: Problem Setting Up Sql At Install.
-----------------------------------
No its a web server on my site.


-----------------------------------
Lopalong
Tue 25 Aug, 2009 05:17

Re: Problem Setting Up Sql At Install.
-----------------------------------
Sorry! I should have also asked:

Free Hosting or Paid Hosting?

If it's FREE, would you like to tell us who the host is please? ;)


-----------------------------------
Nirose
Tue 25 Aug, 2009 08:43

Re: Problem Setting Up Sql At Install.
-----------------------------------
Its Free hosting from atbhost.net

i have my own paid reseller hosting but was lazy to do all the transfer.


-----------------------------------
Lopalong
Tue 25 Aug, 2009 09:15

Re: Problem Setting Up Sql At Install.
-----------------------------------
Thank You,

Most FREE hosting is not suitable for Icy Phoenix because they have all sorts of blockers in place that either restrict the user, or the applications they try to use. :(

Your problem is with your FREE host, and I doubt if anyone here will want to run with your problem in attempting to patch it etc - because we've been through it so many times before, and seldom if ever was it resolved because of those restrictions.

 :cry:


-----------------------------------
Nirose
Tue 25 Aug, 2009 09:29

Re: Problem Setting Up Sql At Install.
-----------------------------------
This is the info on the server. please check it if something is missing.

http://jucktion.com/info.php


-----------------------------------
Lopalong
Tue 25 Aug, 2009 10:47

Re: Problem Setting Up Sql At Install.
-----------------------------------
I can only suggest that you [b][i]initially[/i][/b] take this up with your host as they are providing the service that is restricting your installation of Icy Phoenix.

Please consider that no-one else has had this problem, and I doubt if any of them use a free host.

For your info - Your host is using Suhosin:

[quote]Will my application break because Suhosin is too restrictive?

Some people fear that the protections implemented by Suhosin are too restrictive for their applications and that after installing it, their applications stop working. Therefore Suhosin comes with a special configuration option: suhosin.simulation. When this is enabled Suhosin will continue logging violated rules but the actual blocking will not be performed.

How can I find out the problem when my application breaks?

The Troubleshooting section should answer all questions regarding this question.

Are there any compatibility problems with applications?

In the Troubleshooting section you will find information about all incompatibilities we know about. It will list the Configuration switches that might be needed to get a certain application working correctly.[/quote]


http://www.hardened-php.net/suhosin/faq.html


-----------------------------------
DWho
Tue 25 Aug, 2009 10:57

Re: Problem Setting Up Sql At Install.
-----------------------------------
after to doing a quick search here have a read of this thread

http://www.icyphoenix.com/viewtopic.php?f=4&t=2520&highlight=fulltext+indexes

not that it is going to stop you running into more problems as lopalong has pointed out

 :mrgreen:  :mrgreen:


-----------------------------------
Nirose
Wed 26 Aug, 2009 05:14

Re: Problem Setting Up Sql At Install.
-----------------------------------
Thanks for the support guys

so if Suhosin is present i will not be able to get it to work right. 

What about rewindd.net i have a hosting with them and they are paid. and i can ask them to add a feature as they have great support.


-----------------------------------
Lopalong
Wed 26 Aug, 2009 13:52

Re: Problem Setting Up Sql At Install.
-----------------------------------
[quote user="Nirose" post="43424"] So if Suhosin is present i will not be able to get it to work right.  [/quote]

[b]OT:[/b] I'm not a 100% sure what Suhosin is all about? But from what I've read it appears that it can be used to add certain restrictions to the server etc. If they have done this to obstruct certain functions - Then I suppose any other discussion on this host is pointless. ;)

But! You do have the option to take this issue up with them - If you want to continue with them as your provider.  :shock: 

[quote user="Nirose" post="43424"]
What about rewindd.net i have a hosting with them and they are paid. and i can ask them to add a feature as they have great support. [/quote]

[b][i]So what are you waiting for[/i][/b]  :?: 

 :mricy:


-----------------------------------
Nirose
Wed 26 Aug, 2009 16:46

Re: Problem Setting Up Sql At Install.
-----------------------------------
Then i will get my cpanel transferred.


-----------------------------------
Nirose
Fri 28 Aug, 2009 07:10

Re: Problem Setting Up Sql At Install.
-----------------------------------
ITs working now. Man i had my own hosting(reseller hosting) and was on free host. Its perfect

Thanks for the developers.


-----------------------------------
Lopalong
Fri 28 Aug, 2009 08:05

Re: Problem Setting Up Sql At Install.
-----------------------------------
Glad you made it - - - -

Don't forget to Check out both the forums and the menu for templates and mods etc. 

 Welcome Aboard!  :mryellow:


