-
The default primary key field for the 'rs_times' table (and others) is mediumint(8). This is equivalent to a signed 24-bit value.
If more than ~8 million times are stored then new inserts fail. This actually happened on one of our servers...
Solution: change the ID field to 'int(11) unsigned' (in aseco.sql, and plugin.rasp.php).
2009-04-14 07:48:54 UTC in ASECO - Automatic Server Control
-
If a track name exceeds the default 50 character limit (from aseco.sql) the insert into the DB fails. However LocalDB->challenge['Id'] doesn't get overwritten, so any subsequent updates to the 'records' table are recorded against the wrong track.
Fix:
1. update aseco.sql so that track names are stored with up to 255 characters
2. set $this->challenge['Id'] to 0 before inserting the track...
2009-04-14 07:27:02 UTC in ASECO - Automatic Server Control
-
The minrank setting (to control how many records are necessary to record a rank) has an off-by-one error
In line 234 of plugins/rasp/plugin.rasp.php the comparison should be >=, not >
Ray.
2008-06-02 11:08:45 UTC in ASECO - Automatic Server Control
