MySQL error in version 2.2.5

Striker · Post by **Striker** » Mon Aug 08, 2005 4:38 pm

I got this error-log:

L 08/09/2005 - 00:36:58: [AMXX] [MYSQL] Invalid database handle -1
L 08/09/2005 - 00:36:58: [AMXX] Displaying call trace (plugin "cstrike/addons/amxmodx/plugins/warcraft3FT.amxx")
L 08/09/2005 - 00:36:58: [AMXX]    [0] XP.inl::XP_Set_DBI (line 565)
L 08/09/2005 - 00:36:58: [AMXX]    [1] XP.inl::XP_Retreive (line 341)
L 08/09/2005 - 00:36:58: [AMXX]    [2] war3ft.inl::WAR3_chooserace (line 206)
L 08/09/2005 - 00:36:58: [AMXX]    [3] other.inl::getuserinput (line 151)
L 08/09/2005 - 00:37:03: [AMXX] [MYSQL] Invalid database handle -1
L 08/09/2005 - 00:37:03: [AMXX] Displaying call trace (plugin "cstrike/addons/amxmodx/plugins/warcraft3FT.amxx")
L 08/09/2005 - 00:37:03: [AMXX]    [0] XP.inl::XP_Set_DBI (line 565)
L 08/09/2005 - 00:37:03: [AMXX]    [1] XP.inl::XP_Retreive (line 341)
L 08/09/2005 - 00:37:03: [AMXX]    [2] war3ft.inl::WAR3_chooserace (line 206)
L 08/09/2005 - 00:37:03: [AMXX]    [3] clientCommands.inl::change_race (line 16)
L 08/09/2005 - 00:37:03: [AMXX]    [4] clientCommands.inl::cmd_Say (line 78)
L 08/09/2005 - 00:37:17: [AMXX] [MYSQL] Invalid database handle -1
L 08/09/2005 - 00:37:17: [AMXX] Displaying call trace (plugin "cstrike/addons/amxmodx/plugins/warcraft3FT.amxx")
L 08/09/2005 - 00:37:17: [AMXX]    [0] XP.inl::XP_Set_DBI (line 565)
L 08/09/2005 - 00:37:17: [AMXX]    [1] XP.inl::XP_Retreive (line 341)
L 08/09/2005 - 00:37:17: [AMXX]    [2] war3ft.inl::WAR3_chooserace (line 206)
L 08/09/2005 - 00:37:17: [AMXX]    [3] other.inl::getuserinput (line 151)
L 08/09/2005 - 00:37:18: [AMXX] [MYSQL] Invalid database handle -1
L 08/09/2005 - 00:37:18: [AMXX] Displaying call trace (plugin "cstrike/addons/amxmodx/plugins/warcraft3FT.amxx")
L 08/09/2005 - 00:37:18: [AMXX]    [0] XP.inl::XP_Set_DBI (line 565)
L 08/09/2005 - 00:37:18: [AMXX]    [1] XP.inl::XP_Retreive (line 341)
L 08/09/2005 - 00:37:18: [AMXX]    [2] war3ft.inl::WAR3_chooserace (line 206)
L 08/09/2005 - 00:37:18: [AMXX]    [3] other.inl::getuserinput (line 151)
L 08/09/2005 - 00:37:23: [AMXX] [MYSQL] Invalid database handle -1
L 08/09/2005 - 00:37:23: [AMXX] Displaying call trace (plugin "cstrike/addons/amxmodx/plugins/warcraft3FT.amxx")
L 08/09/2005 - 00:37:23: [AMXX]    [0] XP.inl::XP_Set_DBI (line 565)
L 08/09/2005 - 00:37:23: [AMXX]    [1] XP.inl::XP_Retreive (line 341)
L 08/09/2005 - 00:37:23: [AMXX]    [2] war3ft.inl::WAR3_chooserace (line 206)
L 08/09/2005 - 00:37:23: [AMXX]    [3] clientCommands.inl::change_race (line 16)
L 08/09/2005 - 00:37:23: [AMXX]    [4] clientCommands.inl::cmd_Say (line 78)
L 08/09/2005 - 00:43:46: [AMXX] [MYSQL] Invalid database handle -1
L 08/09/2005 - 00:43:46: [AMXX] Displaying call trace (plugin "cstrike/addons/amxmodx/plugins/warcraft3FT.amxx")
L 08/09/2005 - 00:43:46: [AMXX]    [0] XP.inl::XP_Set_DBI (line 565)
L 08/09/2005 - 00:43:46: [AMXX]    [1] XP.inl::XP_Retreive (line 341)
L 08/09/2005 - 00:43:46: [AMXX]    [2] war3ft.inl::WAR3_chooserace (line 206)
L 08/09/2005 - 00:43:46: [AMXX]    [3] other.inl::getuserinput (line 151)

war3ft don't work at all...

Striker · Post by **Striker** » Mon Aug 08, 2005 5:04 pm

eeehhh, someone moved my post...

Post by **Lazarus Long** » Mon Aug 08, 2005 5:05 pm

Hello, Striker:

Post split and moved to help forum.

This is MySQL related, you get several times the

Code: Select all

L 08/09/2005 - 00:36:58: [AMXX] [MYSQL] Invalid database handle -1

error message. Please post how you got MySQL server and connectivity set up.

Regards,

Striker · Post by **Striker** » Mon Aug 08, 2005 5:14 pm

My MySQL Server don't cause the problem/error message.

Everything was working fine with 2.2.4 and amxx 1.01.

The mySQL Server is a part of a packet (apache+mysql+confixx+...)

-- phpMyAdmin SQL Dump
-- version 2.6.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Date: 09. August 2005 at 01:09
-- Server Version: 4.0.21

Post by **Lazarus Long** » Mon Aug 08, 2005 5:21 pm

Striker:

Striker wrote:My MySQL Server don't cause the problem/error message.

I didn't say it did, I only said it's MySQL related.

OK, but how is AMX Mod X setup to connect to the MySQL server? Which modules are being used, the stock ones or the extra ones in the SQLModules package? And wich ones were used in AMX Mod X 1.01?

Regards,

Striker · Post by **Striker** » Mon Aug 08, 2005 5:28 pm

I use the mysql-module which is included in the amxmodx packet (not the extra SQLModules package) with AMXX 1.01 and 1.50.

; -------------------------------------------
; Database Access - only enable one of these
; -------------------------------------------
; MySQL
mysql_amxx_i386.so

3 Servers are using the same mysql-database. 1 Server connect over localhost and the 2 other servers over IP.

Post by **Lazarus Long** » Mon Aug 08, 2005 5:37 pm

Striker:

OK, lets see if we can figure it out then.

Is this hapening with the 3 servers? If only one is it the one that connects via localhost?

Did you make sure you have the connection to the database setup correctly (I mean FT_mysql_host, FT_mysql_user, FT_mysql_pass and FT_mysql_db)?

Also do you use MySQL for admins? If so, please try to start your server with both the Warcraft 3 FT module and plugin disabled and watch the log to see if your server reads the admins from the database.

Regards,

Striker · Post by **Striker** » Mon Aug 08, 2005 5:45 pm

Did you make sure you have the connection to the database setup correctly (I mean FT_mysql_host, FT_mysql_user, FT_mysql_pass and FT_mysql_db)?

LOL! I found the problem... I forgot to change the IP from localhost to 62.75.216.223.

This will never happen again

sorry... my fault

and thanks for help

Post by **Geesu** » Mon Aug 08, 2005 9:01 pm

LOL!!!