[DrGamez]

Didn't seem to fix anything, still getting errors on new people.

L 09/09/2009 - 16:36:09: [ptt.smx] [PTT] ERROR: Problem with the insert SQL query! (INSERT INTO TimeTracker VALUES ('Muffin', 'STEAM_0:1:25494851', '55', '1'))

L 09/09/2009 - 16:37:40: [ptt.smx] [PTT] ERROR: Problem with the insert SQL query! (INSERT INTO TimeTracker VALUES ('( + )> Dr. Glitzkrieg', 'STEAM_0:0:25024432', '9', '1'))

[DrGamez]

Originally Posted by DrGamez Just got this error, not sure what it is: L 09/08/2009 - 13:34:11: "Havoc_0987<12><STEAM_0:0:20619192><>" STEAM USERID validated L 09/08/2009 - 13:35:03: [ptt.smx] [PTT] ERROR: Problem with the insert SQL query! (INSERT INTO TimeTracker VALUES ('Havoc_0987', 'STEAM_0:0:20619192', '52', '1')) Just switched to 2.3.1 from the previous version (2.2.1). edit: I deleted the cfg like the instructions state and let one be auto-generated again, let me see if that fixed any issues. double edit: Column count doesn't match value count when I try to paste the raw SQL into mysql either.

Fixed my own problem. I don't know if you even use StoredTime in the db anymore so I didn't just outright drop the column, so I just filled in the column you were missing with a harmless 0.

line 235

Format(query, sizeof(query), "INSERT INTO %s VALUES ('%s', '%s', '%i','%i')", pttTable, escapedName, steamid, RoundToFloor(GetClientTime(target)), action);

changed to

Format(query, sizeof(query), "INSERT INTO %s VALUES ('%s', '%s', '%i', 0,'%i')", pttTable, escapedName, steamid, RoundToFloor(GetClientTime(target)), action);

line 488

Format(query, sizeof(query), "INSERT INTO %s VALUES ('%s', '%s', '%i', '%i')", pttTable, escapedName, auth, RoundToFloor(GetClientTime(client)), action);

changed to

Format(query, sizeof(query), "INSERT INTO %s VALUES ('%s', '%s', '%i', 0, '%i')", pttTable, escapedName, auth, RoundToFloor(GetClientTime(client)), action);

[crazydog]

Yeah, that was it. I forgot to tell people to remove the StoredTime column. Oops.

[DrGamez]

It seemed to be working fine, but all of a sudden now I'm getting corrupted times again. I went from 69 hours to now 1 hour :/

[decaprime]

Originally Posted by DrGamez It seemed to be working fine, but all of a sudden now I'm getting corrupted times again. I went from 69 hours to now 1 hour :/

Yeah, I just experienced the same. Not from 69->1 hour but my head admin idles in the server sometimes so he was over 80 hours and now he's at like 40 and jumped down the list =/

I mean no offense by this crazydog you've persevered through a lot of versions but this plugin seems inexorably cursed.

[crazydog]

I really wish I knew why it would do that. The only thing I could think of is that the entry in the database is somehow being lost and re-added.

All that happens is that every x seconds, x seconds is added to everyone's time. I really have no idea why it would be dropping, unless they are getting removed+readded to the database.

[crazydog]

I've decided to stop supporting this plugin. It's having problems that I can't figure out why they exist, and I don't have the time to debug or modify the plugin anymore. I have programming that I'm doing for a grade, and working on this would take away too much time from that.

if anyone wants to take it over, that would be fine. If not, I guess this plugin will eventually become unapproved since I won't support it anymore.

[zeroibis]

Yea for some reason even a fresh install of this plugin does not track player times correctly and makes up strange steamids.

[bouncer]

So this plugin doesnt work at all anymore or does it still work? Because it's in the approved section...

If not, can someone fix up the code maybe?

[PAL-18]

It doesnt work anymore. Im using a custom database on a remote sql server and this plugin keeps trying to connect to the local sqlite database instead (even though its configured to use the remote db).