[NBLUG/talk] nblug website down?

matt matt at cfxnetworks.com
Sun Feb 25 19:14:10 PST 2007


On Sunday 25 February 2007 18:58:12 E Frank Ball wrote:
> On Sun, Feb 25, 2007 at 06:28:16PM -0800, Bob Blick wrote:
>  > Anyone else geting a mysql error message instead of a web page?
>
> Yes it's been down all day.  It's spewing error messages too:
>
> To: root at enigma.wiredgoats.com
> Subject: Cron <root at enigma>    run-parts --report /etc/cron.hourly
> Date: Sun, 25 Feb 2007 18:17:03 -0800
> X-CRM114-Status: Good  ( pR: 8.0771 )
>
> /etc/cron.hourly/drupal:
> <br />
> <b>Fatal error</b>:  Duplicate entry '0' for key 2
> query: INSERT INTO sessions (sid, uid, hostname, timestamp) VALUES
> ('dcfb6ebfe153c6134405a7a4897334e5', 0, '208.201.242.2', 1172456221) in
> <b>/title/nblug.org/htdocs/includes/database.mysql.inc</b> on line
> <b>66</b><br />
>
>
> Anybody know how to fix it?
>
> I don't do databases.

Yeah, I do as well. I'd say "DELETE * FROM `sessions`" should probably do the 
trick.

Put:
	mysql_query("DELETE * FROM `sessions`") or die(mysql_error());
in a PHP script somewhere on the server to fix it. Make sure the script has a 
connection to the database. If not, you need:
	mysql_connect("host", "username", "password);
	mysql_select_db("database_name");
before that line. Replace those values with the correct ones.

-- 
Valê,
Matt
matt at cfxnetworks.com



More information about the talk mailing list