Error log wc3_error

Senne · Post by **Senne** » Fri Oct 12, 2007 3:47 am

I just set up a new wc3ft server.
I used my saved mysql data from a other database and imported into a new mysql server.
Having war3users + the new tables from RC8.0 ; i then deleted war3users table.

using 1.75a amxmodx
and wc3ft v3.0 RC8.0
(windows server)

and im getting this error:
sometimes i think it makes the server crash (every 20minutes -1h the server crashes)
This error repeats itself each map.

Code: Select all

L 10/11/2007 - 18:55:35: ** Map 'de_aztec' started
L 10/11/2007 - 18:55:35: ** Plugin version: '3.0 RC8' 
L 10/11/2007 - 18:55:37: [MYSQLX] Error in querying database, location: 12
L 10/11/2007 - 18:55:37: [MYSQLX] Message: SELECT command denied to user 'sennewi_senne'@'72.249.51.7' for table 'tables' (1142)
L 10/11/2007 - 18:55:37: [MYSQLX] Query statement: SELECT count(*) FROM information_schema.tables WHERE table_schema = 'sennewi_amxxft' AND table_name = 'war3users';

--- Please enter the following information for support ---
War3ft Version:
Amxmodx Version:
Metamod Version:
amxx list:
amxx modules:
meta list:

Post by **YamiKaitou** » Fri Oct 12, 2007 7:17 am

What version is your MySQL server?

Senne · Post by **Senne** » Sat Oct 13, 2007 5:32 pm

MySQL version 4.1.22-standard

i recreated the user sennewi_senne and adressed him All privilges including the command select. (3 times i did it tho but no changes).

Post by **YamiKaitou** » Sat Oct 13, 2007 7:17 pm

No, the reason is because you are using MySQL 4.x. The information_schema.tables table is in 5.x. So, in the db_mysqlx.inl file, find the MYSQLX_Convert function. It should be starting like this

Code: Select all

#define MYSQL_TOTAL_CONVERSION_QUERY 2
MYSQLX_Convert()
{
	// Make sure our connection is working
	if ( !MYSQLX_Check_Connection() )

Change that to

Code: Select all

#define MYSQL_TOTAL_CONVERSION_QUERY 2
MYSQLX_Convert()
{
    return;
	// Make sure our connection is working
	if ( !MYSQLX_Check_Connection() )

You will get a warning message at compile, you can ignore it. Please note, doing this will NOT convert xp from the 2.x style to the 3.x style

Senne · Post by **Senne** » Sat Oct 13, 2007 7:50 pm

ok, i will try to do this monday evening since im now at 5kb/s bec i downloaded to much...

Out of your experience : would this problem created the crashing?

btw im using RC3.0 tho, so i think your note isnt directed to me?

Senne · Post by **Senne** » Mon Oct 15, 2007 2:06 pm

your thinghy seems to solve it thx a bunch!!!

Post by **Geesu** » Mon Oct 15, 2007 4:05 pm

Yea i need to make a CVAR for this or a #define - I've noticed not all people have permissions on there base accounts for:

information_schema.tables

Which makes sense as it's sort of a "system" database call if that exists

Senne · Post by **Senne** » Tue Oct 16, 2007 9:56 am

thx anyway guys