Advanced Poll 2.0 (MySQL version) - Strange problem

Anonymous — GMT

Bascially my content system builds a features bar along the right of every page and one section of this was going to include the poll. I'm having problems getting it to work though.

If I create a file called polltest.php just containing this:
[code] // Important! You have to include it before your html code
include_once "/home/maxpayne/cgi-bin/site/poll/poll_cookie.php";
?>

include_once "/home/maxpayne/cgi-bin/site/poll/booth.php";
echo $php_poll->poll_process(2);
?>

[/code]

Then it works fine.

However, the problem occurs when I try to put it into my content system.
The way it differs is the file display.php is called with a page name. As the cookie information needs to be sent before headers, this is where poll_cookie.php is included. display.php then includes global.inc.php for common functions including one called rightBar(). In rightBar rightBar.inc.php is included and this runs through drawing out the different sections. When it hit's:

[code]include_once "/home/maxpayne/cgi-bin/site/poll/booth.php";
echo $php_poll->poll_process(2);[/code]

I get:
[code]Warning: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/maxpayne/cgi-bin/site/poll/include/class_mysql.php on line 30

Warning: MySQL Connection Failed: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/maxpayne/cgi-bin/site/poll/include/class_mysql.php on line 30
Connection Error
--------------------------------------------------------------------------------

MySQL Error : Connection Error
Error Number: 2002 Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Date : Tue, April 9, 2002 11:52:31
IP : 213.1.128.93
Browser : Mozilla/4.0 (compatible; MSIE 6.0; Windows 98; PCPLUS)
Referer :
PHP Version : 4.1.2
OS : Linux
Server : Apache/1.3.23 (Unix) PHP/4.1.2
Server Name : dynamic4.gamespy.com
Script Name : /~maxpayne/site/display.php[/code]

I've also tried putting it all in a seperate file and including that but this just results in the same problems.

I've also tried moving the booth.php include to one of the preceding files (display.php or global.inc.php) but all this results in is a different error:

[code]Fatal error: Call to a member function on a non-object in /home/maxpayne/cgi-bin/site/rightBar.inc.php on line 120[/code]

The only way I have got it to work so far is include it in display.php (the originally called file) so I guess I might be able to rework my rightBar function into 2 pieces so I can do the following in display.php:

[code]...
...
...
rightBarTop();
include_once "/home/maxpayne/cgi-bin/site/poll/booth.php";
echo $php_poll->poll_process(2);
rightBarBotton();
...
...
...
[/code]

But I really don't want to have to do that unless it's absolutely necessary, and this is the best poll system I've seen, so if anyone has any suggestions they'd be greatly appreciated.

Thx in advance

(Oh and I've tried the textfile version but this just results in a different problem, all the $question, etc variables in the templates get replaced with nothing so it doesn't work too well... :wink:)

Latest posts for the topic "Advanced Poll 2.0 (MySQL version) - Strange problem"

Advanced Poll 2.0 (MySQL version) - Strange problem