Page 1 of 1

A few errors i have still :( help plz :)

Posted: Sun Jun 03, 2012 12:53 pm
by MPFzunnie
Hey,

We reinstalled ut3statsdb for our UT3 servers today, after adjsuting the slq files to work with the mysql database
i find that some page entries are still bugged a bit and i dont know how to fix them..

The stats db can be found here: http://stats.ut4evah.com
When you click on the "Matches" you will notice an error: "Deprecated: Function ereg_replace() is deprecated in C:\xampp\htdocs\ut3stats\includes\main.inc.php on line 60"
And when you click on a match entry that has been played it will repeat that error several times.

Does anyone know how to fix this? It's all working but this thingy and i would love to see it fixed :)

Thanks for your help :)

Re: A few errors i have still :( help plz :)

Posted: Sun Jun 03, 2012 1:01 pm
by MPFzunnie
On line 60 in main.inc.php Replace all eregi by mb_ereg and your problem should be fixed :)

Source: http://marcelmarnix.com/wordpress/artik ... recated-in

Re: A few errors i have still :( help plz :)

Posted: Sun Jun 03, 2012 1:03 pm
by MPFzunnie
Im getting this error still with the Query thing:

"Notice: Undefined index: score in C:\xampp\htdocs\ut3stats\serverquery.php on line 1145"

Anyone have an idea how to fix this?

Re: A few errors i have still :( help plz :)

Posted: Sun Jun 03, 2012 1:08 pm
by MPFzunnie
I'm also getting ONE more error although it seems to not have any negative effects as far as i can see now.
When parsing the logs i get this error:

"Processing log 'Stats-8888-20120603.153812.log'...Error creating temp table for weapon specific per player totals."

Anyone know how i can fix this one maybe ? :)

Re: A few errors i have still :( help plz :)

Posted: Sun Jun 03, 2012 2:51 pm
by Panther
Newer versions of MySQL have a separate permission for creating temporary tables. Just modify and execute the following to grant the permission to the database user:

GRANT CREATE TEMPORARY TABLES ON database.* TO dbuser@localhost;

Re: A few errors i have still :( help plz :)

Posted: Fri Nov 01, 2013 7:23 am
by Pada
I had this "Error creating temp table for weapon specific per player totals" error too with MySQL 5.5, which was due to an error in the SQL syntax in includes/logsave.php, where it used "Type=HEAP" instead of "Engine=HEAP".

I struggled quite a bit to get UTStats working, seeing that OLStats crashed my server on map end when the "bExportHTMLLogs" setting in OLStats.ini was set to True.

I didn't have to replace the 'ereg_replace' function at all and I'm using php 5.4.17.