mySQL version
-
Hi
I can not do an automatic upgrade as I am been told 3.2.1 requires version 5 or greater mySQL and I only have mySQL version 4.122 but my hosting company state they are running 5.0.84
Any ideas?
Cheers
John
-
Cheers
My website is http://www.thestottfamily.co.uk and the wordpress login details are the same as on the hosting so I should have no problems
Many thanks
Jo0hn
Hi John. Yeah, if you can’t delete files, most likely your server is not running suPHP (or some type of variation). What’s most likely happening is that WordPress is running as “nobody”, and when it downloads files / etc they are owned by “nobody”. When you login via FTP, you’re logged in as your username (userna5) in this example. “userna5” does not have access to files owned by “nobody”, therefor you cannot modify or delete them.
More information on this can be found on the suPHP section here:
http://www.webhostinghub.com/support/edu/wordpress/wordpress-migrate/migrate-wordpress-informationOther programs, such as Joomla, have the same types of issues when not being ran on a suPHP server. To resolve the issue with your current host, you may want to find a File Manager type plugin for WordPress. What this will do is allow you to browse your files from within WordPress as the “nobody” user. This will allow you to edit / delete those files owned by “nobody”.
I never tried it, but http://wordpress.org/extend/plugins/wp-filemanager/ may help you.
On a side note, I agree with esmi in that you contact your host for the best resolution. While I could offer suggestions all day, your host knows what’s going on with your files / permissions.
Cheers i am with jabwebsolutions.co.uk which are owned by Knightmaster Enterprises (UK)
Not had any problems in the past.
Thanks
John
P.S Just did not like to be annoying but i think i need to….
P.S.S I am pissed off now so may well change to another host….
It used to run fine upto a few month ago
http://www.thestottfamily.co.uk
http://www.seroxatmad.co.uk
http://www.disabledparkingbays.co.ukContact your hosts.
Hi
Thanks I will…..a bit sh*t when u cant delete files via FTP etc
Thanks
John
Hi, since no one really seemed to answer seroxatmad’s first question, i will give you a solution…go into your word press directory on FTP and find the file named “version.php” in the directory “wp-includes”. Open that file, and about line 42 or so, you should see something like this “$required_mysql_version = ‘5.0’;”
Change the 4 to a 5 and your Word Press website will work and allow upgrades. There is no need to upgrade your MySQL and that is a very bad idea because it may break other things running off databases that are not word press, and shared hosting accounts won’t let you generally.
Officially, new releases of Word Press have abandoned testing for MySQL prior to 5, however, it still works, they just don’t test it anymore, so don’t want to say they support it. In my experience, there are no functions in the new Word Press that your old MySQL won’t work with though. So, there you go…a little late, but just saw this thread.
and I obviously meant to write change the 5 to a 4, sorry.
Hi
Thanks will give it a try.
John
The topic ‘mySQL version’ is closed to new replies.