Icy Phoenix
Old Support Topics - Problem Setting Up Sql At Install.
Nirose [ Tue 25 Aug, 2009 03:45 ]
Post subject: 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 ]
Post subject: 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 ]
Post subject: Re: Problem Setting Up Sql At Install.
No its a web server on my site.
Lopalong [ Tue 25 Aug, 2009 05:17 ]
Post subject: 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 ]
Post subject: 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 ]
Post subject: 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.
Nirose [ Tue 25 Aug, 2009 09:29 ]
Post subject: 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 ]
Post subject: Re: Problem Setting Up Sql At Install.
I can only suggest that you
initially 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.
http://www.hardened-php.net/suhosin/faq.html
DWho [ Tue 25 Aug, 2009 10:57 ]
Post subject: 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...ulltext+indexes
not that it is going to stop you running into more problems as lopalong has pointed out
Nirose [ Wed 26 Aug, 2009 05:14 ]
Post subject: 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 ]
Post subject: Re: Problem Setting Up Sql At Install.
So if Suhosin is present i will not be able to get it to work right.
OT: 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.
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.
So what are you waiting for
Nirose [ Wed 26 Aug, 2009 16:46 ]
Post subject: Re: Problem Setting Up Sql At Install.
Then i will get my cpanel transferred.
Nirose [ Fri 28 Aug, 2009 07:10 ]
Post subject: 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 ]
Post subject: 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!