I'm getting this in terminal after running the bot_start... Any ideas?

PS. the bot "works", and is irc yet I imagine these issues are bad.

PHP Warning:  MySQL server has gone away
query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', '<em>MySQL server has gone away\nquery: SELECT * FROM variable</em> in <em>/home/noob/public_html/includes/database.mysqli.inc</em> on line <em>151</em>.', 2, '', 'http://example.org//bot_start.php', '', '', 1187045526) in /home/noob/public_html/includes/database.mysqli.inc on line 151

Comments

czarphanguye’s picture

Note; this seems to match my.conf's wait_timeout. If set to 30seconds and no one speaks to the bot in 30seconds the db connection is lost. is this right?

morbus iff’s picture

Yes, that would be correct. You should either a) increase the timeout to something like 2 minutes, then b) run your cron.php every 1 minute (the bot.module ships with a keepalive that is triggered via cron), or add it to more active rooms ;)

czarphanguye’s picture

I dunno, w/ a one minute crontab and mysql time'out set to 180 the bot still times out a little after 3 minutes. Cron reports success every (single) minute to the watchdog.

morbus iff’s picture

Status: Active » Fixed

This was fixed in a recent commit - we're now setting the wait_timeout in the bot_start.php ourselves.

Anonymous’s picture

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for two weeks with no activity.