New error

[SmartFlyer]

Thought you'd like to know since the db was just moved:

I was in my PM mailbox and clicked to read a new message when I got this "General Error":

Could not delete oldest privmsgs (sent)

DEBUG MODE

SQL Error : 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 2

DELETE FROM phpbb_privmsgs WHERE privmsgs_id =

Line : 331

File : privmsg.php

[TFM]

Thought you'd like to know since the db was just moved:

I was in my PM mailbox and clicked to read a new message when I got this "General Error":

Could not delete oldest privmsgs (sent)

DEBUG MODE

SQL Error : 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 2

DELETE FROM phpbb_privmsgs WHERE privmsgs_id =

Line : 331

File : privmsg.php

Did this only happen once?

[SmartFlyer]

Yes, it only happened once. I noticed the site was down yesterday for about 45 minutes, and then the db was unavailable for a while in the afternoon. I saw your announcement posted a few minutes ago that the db move is complete, so I'm guessing the above error and the short outages yesterday were caused by the db move and isn't of further concern.

Thanks for your efforts to speed up the forums - it is great so far!

[TFM]

Sorry for the delay, I just got all your databases moved. They are now

on a new server called scooby. The old one, jake, was a bit slow and so

it took longer than expected to move them. Sorry about that.

root@yakko ~ $ ssh jake uptime

11:14:49 up 4 days, 22:03, 0 users, load average: 19.79, 21.93, 19.43

root@yakko ~ $ ssh scooby uptime

11:14:52 up 4 days, 22:53, 0 users, load average: 1.88, 1.94, 1.90

So you should have faster databases now, and all new databases you create

will go to scooby now as well. Give it a try and let me know if you have

further problems or questions.

The move took much longer then anyone thought. The old server "jake" was also very overloaded partly because of us. heh heh.

So it's confirmed done now and any errors were prob ally caused from it being moved. I'm actually amazed it went as smoothly as it did.