Receiving errors using firestats, with puarcade

[bhurst@…]

Hello,

I installed firestats stable version on Joomla 1.5. I installed it to my rootserver, and on Mysql 5.0. I get this error when I try to play a game on my site using the PUARCADE extension. I have narrowed it down to this program. When I disable the firestats plugin, the error goes away. When I enable the plugin, it comes back. Here is the error I get below.

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Can't connect to local MySQL server through socket '/tmp/mysqld.sock' (2) in /homepages/29/d259121369/htdocs/new/components/com_puarcade/includes/core/class.puarcade.php on line 397

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in /homepages/29/d259121369/htdocs/new/components/com_puarcade/includes/core/class.puarcade.php on line 397

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Can't connect to local MySQL server through socket '/tmp/mysqld.sock' (2) in /homepages/29/d259121369/htdocs/new/components/com_puarcade/cls.puarcade.php on line 1367

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in /homepages/29/d259121369/htdocs/new/components/com_puarcade/cls.puarcade.php on line 1367

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Can't connect to local MySQL server through socket '/tmp/mysqld.sock' (2) in /homepages/29/d259121369/htdocs/new/components/com_puarcade/cls.puarcade.php on line 1360

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in /homepages/29/d259121369/htdocs/new/components/com_puarcade/cls.puarcade.php on line 1360 PUArcade Pacman

Leaderboard Newest Games Popular Games All

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Can't connect to local MySQL server through socket '/tmp/mysqld.sock' (2) in /homepages/29/d259121369/htdocs/new/components/com_puarcade/puarcade.class.php on line 150

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in /homepages/29/d259121369/htdocs/new/components/com_puarcade/puarcade.class.php on line 150 DB function failed with error number 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near at line 1 SQL=select c.id, c.name, c.description, c.warningrequired, c.imagename from jos_puarcade_games as g, jos_puarcade_contentrating as c where g.contentratingid = c.id and g.id =

[omry]

See ticket #869 there is a workaround there.

make sure you apply the workaround for your FireStats version (read all the comments carefully before making a change).

[bhurst@…]

Thank you. I had just found that before you replied. I appreciate all your help, and this is a great program. As soon as I get paid, I plan on donating :). That work around did just the trick.

[omry]

good. I will consider changing this behavior to be the default.

[omry]

changed default behavior to leave the connection open in 1.6.0-RC2