[Dodgy Bob]

Hi all,

Great mod!

I'm using it on our LAN server that also runs mysql and apache/PHP.

I have no problems with the plugin -> mysql and recording the data, that's all fine. But I'm damned if I can get the web pages to access the DB. the createtable.php runs and works (creates the tables) but once they're populated with data, if I run index.php I just have an empty page.

Can't provide the apache error log atm, I'm in work

Bob.

[L4DHelp]

Could it be possible to add "one hit kills from behined"? Like 2 points for killing a zombie with melee from behined.

[Dodgy Bob]

Hi again,

Was bored at work so decided to set up the dedicated server with SM/MM, this plugin, mysql, apache and PHP on my lappy Can't connect but can set it up to test.

All set-up fine and then I ran the createtable.php file. It created the tables OK but didn't populate the maps table. The error in the Apache log is :

[Fri Jan 23 11:45:14 2009] [error] [client 127.0.0.1] PHP Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in C:\\Program Files\\Apache Software Foundation\\Apache2.2\\htdocs\\l4d\\common.ph p on line 84

And the actual web page output was :

Maps table created successfully!

Field 'playtime_nor' doesn't have a default value

Players table created successfully!

All tables created successfully!

Any ideas (I'm not an SQL guy, unix admin. I'm afraid)? Obviously the config.php must be right as it created the tables.

Cheers.

Bob.

[Dodgy Bob]

Hi again,

Done a bit of checking myself. Seems it's just a problem with the field playtime_nor (possibly others as this is just the first it hits).

mysql> desc maps;
+--------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+-------+
| name | varchar(255) | NO | PRI | NULL | |
| playtime_nor | int(11) | NO | | NULL | |
| playtime_adv | int(11) | NO | | NULL | |
| playtime_exp | int(11) | NO | | NULL | |
| restarts_nor | int(11) | NO | | NULL | |
| restarts_adv | int(11) | NO | | NULL | |
| restarts_exp | int(11) | NO | | NULL | |
| points_nor | int(11) | NO | | NULL | |
| points_adv | int(11) | NO | | NULL | |
| points_exp | int(11) | NO | | NULL | |
| kills_nor | int(11) | NO | | NULL | |
| kills_adv | int(11) | NO | | NULL | |
| kills_exp | int(11) | NO | | NULL | |
+--------------+--------------+------+-----+---------+-------+
13 rows in set (0.07 sec)

mysql> INSERT INTO maps (name) VALUES ('l4d_airport01_greenhouse');
ERROR 1364 (HY000): Field 'playtime_nor' doesn't have a default value

Trying to insert just a single entry gives the same error.

Hope this helps.

Bob.

[hockeymike]

Excellent addon, but is there any eta on vs stats tracking? My users love the campaign stats, but we don't really play it as much as vs. Thanks much!

[msleeper]

Originally Posted by ogre_x I installed it on our server yesterday and tested a little. The HUD when typing rank is not always shown. I had some issues in the log claiming the database handle had broken, however, the stats seemed to update. Is the HUD supposed to work with only one human player in the game? The psychostats reader in this forum uses a Threaded SQL-connect. Does it matter if you use that or not?

I haven't been able to reproduce it not showing up, and yes it should work with only 1 Human. I will go ahead and change the Database connect to threaded though for the next update.

Originally Posted by Dodgy Bob I have no problems with the plugin -> mysql and recording the data, that's all fine. But I'm damned if I can get the web pages to access the DB. the createtable.php runs and works (creates the tables) but once they're populated with data, if I run index.php I just have an empty page. Can't provide the apache error log atm, I'm in work

What version of PHP and MySQL (re: your other posts) are you running?

Originally Posted by hockeymike Excellent addon, but is there any eta on vs stats tracking? My users love the campaign stats, but we don't really play it as much as vs. Thanks much!

I don't have a time frame for anything on that, but I know there is a demand for it so I do want to start soon.

[Hijinks]

Well, ran into the same problem with the blank record. I checked the logs last night and I didn't see anything that matched up that would suggest a sql insertion problem.

In phpmyadmin the name and lastonline entries for that record were blank. The rest of the fields had '0' as an entry. The steamid was filled in properly.

I went ahead and dropped the record and its fine again. The database is hosted externally but if it was a connectivity problem I would expect a different result. Like you said I think it just needs some extra error handling or validation.

[msleeper]

Originally Posted by Hijinks Well, ran into the same problem with the blank record. I checked the logs last night and I didn't see anything that matched up that would suggest a sql insertion problem. In phpmyadmin the name and lastonline entries for that record were blank. The rest of the fields had '0' as an entry. The steamid was filled in properly. I went ahead and dropped the record and its fine again. The database is hosted externally but if it was a connectivity problem I would expect a different result. Like you said I think it just needs some extra error handling or validation.

What version of MySQL are you running again (sorry if you already stated this)? Also, have you ran this query on the table?

ALTER TABLE players CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

[Hijinks]

Originally Posted by msleeper What version of MySQL are you running again (sorry if you already stated this)? Also, have you ran this query on the table? ALTER TABLE players CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;

MYSQL Version:
select version();
5.0.67-community-log

The collation change I did yesterday. This happened after the change.

[msleeper]

Ah okay sorry. It's been a long thread with some weird problems.

Is there any way you could get MySQL logging to be turned on? I am curious what is being sent/received by MySQL to make it not update the fields properly. I am kind of stumped on this one.