next »

[dimitrifrom31]

Trying to setup B3+xlrstats. B3 install goes just fine, the plugin part of xlrstats is easy and had no problems importing the mysql file in phpmyadmin.

However when I go to http://mywebsite.com/xlrstats/install after accepting the terms on first page and filling the mysql info on second I get a single error :
"You need to enable MySQL support"
all the rest is fine.

I assume it means my PHP setup is detected as not supporting mysql or something like that however it is/should.

in my PHP.ini :
extension=php_mysql.dll

and yes i got the dll at the proper place.

Is there anything I should check/test ?


My setup :
OS : windows 2003 server standard 64 bits
IIS 6 with  fastcgi php support
the MySQL db is hosted remotely and I have root permissions.

any help apreciated

[Freelander]

Please check your phpinfo if mysql is enabled there. If not, it's a good idea to read this:

http://www.php.net/mysql#mysql.installation.windows

[dimitrifrom31]

Please check your phpinfo if mysql is enabled there. If not, it's a good idea to read this:

http://www.php.net/mysql#mysql.installation.windows

thx for your help

actually the setup was correct but using phpinfo pointed me out that I forgot to include the path to php in the environment path. That part is now solved I can do the setup until last step where i get the following error :
Could not connect to the database!
Did you setup this statsconfig file () correctly?

I have triple checked db info and everything is correct. Its using the same info as B3 bot itself and b3 bot can connect without problem.
For now Im doing the setup using the "root" mysql user so its not a permission issue.

I wonder if there is some king of debug file/log so I can get more specific details about this error. I have even recreated the mysql tables for xlrstats with no luck so I assme its the main connection that can't be established but I dont see why it couldnt as root has permissions to connect from anywhere "%" and as b3 bot can connect (it's a remote database)

Sorry if this was already discussed but somehow the search funtion returns me inaccurate results however i keep browsing the forums.

[Freelander]

Please open install/index.php and replace line 27 with

Code: php

$debuginstaller = 1;

You can also open config/install_award_idents.php and replace line 38 with

Code: php

error_reporting(E_ALL); 

Please try with these settings and let us know the error messages you have.

[dimitrifrom31]

Please open install/index.php and replace line 27 with

Code: php

$debuginstaller = 1;

You can also open config/install_award_idents.php and replace line 38 with

Code: php

error_reporting(E_ALL); 

Please try with these settings and let us know the error messages you have.

after editing index.php the installer main page doesnt display anymore and returns the following page :

Code:

PHP Notice:  Undefined index:  start_install in C:\inetpub\wwwroot\xlrstats\install\index.php on line 40
PHP Notice:  Undefined index:  step1 in C:\inetpub\wwwroot\xlrstats\install\index.php on line 41
PHP Notice:  Undefined index:  step2 in C:\inetpub\wwwroot\xlrstats\install\index.php on line 42
PHP Notice:  Undefined index:  step3 in C:\inetpub\wwwroot\xlrstats\install\index.php on line 43
PHP Notice:  Undefined index:  step4 in C:\inetpub\wwwroot\xlrstats\install\index.php on line 44
PHP Notice:  Undefined index:  step5 in C:\inetpub\wwwroot\xlrstats\install\index.php on line 45
PHP Notice:  Undefined index:  hostname in C:\inetpub\wwwroot\xlrstats\install\index.php on line 47
PHP Notice:  Undefined index:  username in C:\inetpub\wwwroot\xlrstats\install\index.php on line 48
PHP Notice:  Undefined index:  password in C:\inetpub\wwwroot\xlrstats\install\index.php on line 49
PHP Notice:  Undefined index:  databasename in C:\inetpub\wwwroot\xlrstats\install\index.php on line 50
PHP Notice:  Undefined index:  game in C:\inetpub\wwwroot\xlrstats\install\index.php on line 52
PHP Notice:  Undefined index:  publicip in C:\inetpub\wwwroot\xlrstats\install\index.php on line 53
PHP Notice:  Undefined index:  statusurl in C:\inetpub\wwwroot\xlrstats\install\index.php on line 54
PHP Notice:  Undefined index:  websiteurl in C:\inetpub\wwwroot\xlrstats\install\index.php on line 55
PHP Notice:  Undefined index:  websitename in C:\inetpub\wwwroot\xlrstats\install\index.php on line 56
PHP Notice:  Undefined index:  template in C:\inetpub\wwwroot\xlrstats\install\index.php on line 57
PHP Notice:  Undefined index:  sigmodule in C:\inetpub\wwwroot\xlrstats\install\index.php on line 58
PHP Notice:  Undefined index:  pagetitle in C:\inetpub\wwwroot\xlrstats\install\index.php on line 59
PHP Notice:  Undefined index:  teambased in C:\inetpub\wwwroot\xlrstats\install\index.php on line 60
PHP Notice:  Undefined index:  actionbased in C:\inetpub\wwwroot\xlrstats\install\index.php on line 61
PHP Notice:  Undefined index:  use_geoip in C:\inetpub\wwwroot\xlrstats\install\index.php on line 62
PHP Notice:  Undefined index:  geoip_path in C:\inetpub\wwwroot\xlrstats\install\index.php on line 63
PHP Notice:  Undefined index:  toplist_max in C:\inetpub\wwwroot\xlrstats\install\index.php on line 65
PHP Notice:  Undefined index:  maplist_max in C:\inetpub\wwwroot\xlrstats\install\index.php on line 66
PHP Notice:  Undefined index:  weaplist_max in C:\inetpub\wwwroot\xlrstats\install\index.php on line 67
PHP Notice:  Undefined index:  separatorline in C:\inetpub\wwwroot\xlrstats\install\index.php on line 68
PHP Notice:  Undefined index:  toplist_block in C:\inetpub\wwwroot\xlrstats\install\index.php on line 69
PHP Notice:  Undefined index:  user_length in C:\inetpub\wwwroot\xlrstats\install\index.php on line 70
PHP Notice:  Undefined index:  minkills in C:\inetpub\wwwroot\xlrstats\install\index.php on line 71
PHP Notice:  Undefined index:  minrounds in C:\inetpub\wwwroot\xlrstats\install\index.php on line 72
PHP Notice:  Undefined index:  exclude_ban in C:\inetpub\wwwroot\xlrstats\install\index.php on line 73
PHP Notice:  Undefined index:  ShowRatioGraph in C:\inetpub\wwwroot\xlrstats\install\index.php on line 74
PHP Notice:  Undefined index:  MaxKillRatio in C:\inetpub\wwwroot\xlrstats\install\index.php on line 75
PHP Notice:  Undefined index:  maxdays in C:\inetpub\wwwroot\xlrstats\install\index.php on line 76
PHP Notice:  Undefined index:  map_minkills in C:\inetpub\wwwroot\xlrstats\install\index.php on line 77
PHP Notice:  Undefined index:  map_minrounds in C:\inetpub\wwwroot\xlrstats\install\index.php on line 78
PHP Notice:  Undefined index:  weap_minkills in C:\inetpub\wwwroot\xlrstats\install\index.php on line 79
PHP Notice:  Undefined index:  aliashide_level in C:\inetpub\wwwroot\xlrstats\install\index.php on line 80
PHP Notice:  Undefined index:  limitplayerstats in C:\inetpub\wwwroot\xlrstats\install\index.php on line 81
PHP Notice:  Undefined index:  enemies_max in C:\inetpub\wwwroot\xlrstats\install\index.php on line 82
PHP Notice:  Undefined index:  showclansearch in C:\inetpub\wwwroot\xlrstats\install\index.php on line 83
PHP Notice:  Undefined index:  use_localtime in C:\inetpub\wwwroot\xlrstats\install\index.php on line 84
PHP Notice:  Undefined index:  useppllist in C:\inetpub\wwwroot\xlrstats\install\index.php on line 85
PHP Notice:  Undefined index:  pll_noteams in C:\inetpub\wwwroot\xlrstats\install\index.php on line 86
PHP Notice:  Undefined index:  stylepicker in C:\inetpub\wwwroot\xlrstats\install\index.php on line 87
PHP Notice:  Undefined index:  disable_configpicker in C:\inetpub\wwwroot\xlrstats\install\index.php on line 88
PHP Notice:  Undefined index:  debug in C:\inetpub\wwwroot\xlrstats\install\index.php on line 89

[dimitrifrom31]

I figured some errors.

They were coming from the path variable that has different format on windows. So I edited a few php files replicing path variables by their absolute path like C:\inetpub\wwwroot\xlrstats\

I have then installed successfuly xlrstats but now when going on index.php page (after renaming the install folder) I got this :

Code:

PHP Warning:  end() [<a href='function.end'>function.end</a>]: Passed variable is not an array or object in C:\inetpub\wwwroot\xlrstats\lib\autocomplete\localdata.php on line 18
PHP Warning:  Invalid argument supplied for foreach() in C:\inetpub\wwwroot\xlrstats\lib\autocomplete\localdata.php on line 21

[Freelander]

I don't have access to a IIS server. If you are familiar with php you can try editing  "config/inc_constants.php". This is where absolute path (XLRSTATS_ROOT_DIR) is defined.

[dimitrifrom31]

I don't have access to a IIS server. If you are familiar with php you can try editing  "config/inc_constants.php". This is where absolute path (XLRSTATS_ROOT_DIR) is defined.

Im afraid theres not such a file in my config folder :

[Freelander]

I thought you were using the latest version 

Please download and install the latest version, or version 2.2 beta better.

[dimitrifrom31]

I thought you were using the latest version 

Please download and install the latest version, or version 2.2 beta better.

It is latest version downloaded this week  XLRstats 2.1.0 (2010)

[Freelander]

Sorry my bad. You're right, it was added after that release. I believe your problem will be solved if you download and install 2.2beta.