Hi,

I have v1.7.3 running for past 18 months, thought time to upgrade. Read need to delete all tables. Have kept as plan to use roster2_ for new tables until I know all working.

Trouble is when I try to run install.php from my new path roster2.domain.co.uk I get the below error message:

Detected invalid access to this file!

The chmod for the folders is 755 and the files are set to 644. I have also confirmed the permissions used before on my old v1.7.3 folder structure and they match.

Any help appreciated please - driving me mad.

PS: I have looked at another post with this issue but no solution was posted. Post 4177

You need to call index.php - it will automatically detect the installer needs to be run.

Sorted, thanks.

However...says MySQL not right version yet...

Step 1 shows:

WoWRoster Installation
Step 1
Installation Note
Roster has scanned your server and determined that it meets the minimum requirements.

Version
Using: 2.0.0
Latest: 2.0.0

PHP Info
View phpinfo()
Version: Using: 4.4.9 Required: 4.3.0 +
MySQL Module: Available: Yes Required: 4.1.0 +
GD Module: Available: Yes Required: Optional

BUT.. when get to tell to proceed with install, I get:

Notice: Undefined index: default_lang in /homepages/34/d74488454/htdocs/roster2/install.php on line 893

WoWRoster Logo
WoWRoster Installation
Step 3

MySQL server version 4.1.0 or higher is required for Roster.

You are running:

* Your server version: 4.0.27-standard-log
* Your client version: 5.0.32

We are sorry, your MySQL server version is not high enough to install Roster, please upgrade MySQL.

Please help, I dont understand why Step 1 said all was ok and then Step 3 throws up this error? Is my hosting company not maintaining the actual database version and MySQL in synce?

Thanks in advacne for any help

This :

Gkaruk wrote:PHP Info
View phpinfo()
Version: Using: 4.4.9 Required: 4.3.0 +
MySQL Module: Available: Yes Required: 4.1.0 +
GD Module: Available: Yes Required: Optional[/i]

says your PHP is ok - and it talks ONLY about your PHP version.
True is, it detects the MySQL extension (so we know that PHP supports MySQL here)

Gkaruk wrote:MySQL server version 4.1.0 or higher is required for Roster.
You are running:
* Your server version: 4.0.27-standard-log
* Your client version: 5.0.32[/i]

This talks about your SQL version on your host (or: what your host offers you) : its the version your grand father used

Version 5.0 (or even higher) is current now.

Think about this : MySQL can only be checked AFTER you gave the access credentials. You can not see version info before.
So its's normal it complains after step 3.

You could try opening install.php dans change line 270

Code: Select all

    'mysql_version'  => '4.1.0' 

but think about the fact that if 4.1.0 is asked then there is a reason for that - other problem WILL araise !!

Gkaruk wrote:Notice: Undefined index: default_lang in /homepages/34/d74488454/htdocs/roster2/install.php on line 893

Use the search function on this forum and the word default_lang, you find some post about the subject.

PS : Do not use the Database Create username: and Database Create password: entries - except if you KNOW that YOU have to create a database yourself.
Quiet rare, in fact.

Thanks tuigii

Sadly I cant resolve the issue and use WoWRoster 2

It my hosting supplier which controls the version of MySQL and therefore I am unable to update to a newer version

I have raised this with them as been with them near 6yrs and they been very supportive in the past so hopeful can come to some resolution.

Thanks again

That's weird that your client version is so much higher than the server version of mysql

There are two mysql versions involved: The client (the functions in PHP), and the server (the actual database).

Your host may not realize only one of these has been upgraded.

Thanks all still waiting for a response from 1and1.co.uk

Once I get one I post here to keep the investiagation for resolution going.

Interestng to see MySQL can have different Client and Server versions.

I dont suppose anyone else here hosts with 1and1.co.uk and has resolved this?

Thanks again all