Forum Posts Vanishing

AndyCr15 · 01-09-2006, 09:40 PM

Hi, my website is on Banana I believe (www.lanarchy.co.uk). Today we seem to have had our database 'rolled back' a couple of times. Just before I went to work I noticed '27 new posts' had appeared... but they were all posts from last night, which I'd already read and all of the recent posts had vanished.

Anyone know what might have happened, or still is for that matter. I just got home from work and people are complaining posts have gone missing through the day.

Jacob · 01-09-2006, 10:02 PM

Hi,

Please can you open a ticket about this and we can have a look.

Regards,

Jacob

robertc · 02-09-2006, 03:24 AM

It turns out it's a bit more subtle than database resets - someone moved our website to blueberry without telling us! I know there was some issue with Spamcop from cat2 to the domain where we have our personal email so the message may have gone by the wayside.

Anyway, I'm assuming because both the banana and the blueberry versions of the site are both up some users are getting one and some the other depending on how up to date their DNS is. It's all made a bit of a mess of the database but I think it's mostly sorted out now. Some queries seem to be timing out though - perhaps stuff in the database which needs repairing or perhaps some incompatibilities between MySQL 4.0 (banana) and 4.1 (blueberry) which are upsetting phpBB. Is there anyway we can get an error log out of the MySQL server or do we have to debug with PHP?

Rob

paulredpath · 02-09-2006, 09:09 AM

Rob,

All users that were having sites moved were emailed a few days before.

robertc · 02-09-2006, 11:36 AM

Yeah, that's OK, like I said there have been some issues sending email from my cat2 account to the domain that my main email address is on because of Spamcop - I even raised a ticket about it, but there's nothing that could be done. So I'm assuming the email went astray. What I'm more interested in right now is working out why some parts of phpbb seem to have stopped working.

Rob

01-09-2006, 09:40 PM	#1 (permalink)
AndyCr15 Registered User Join Date: Apr 2004 Posts: 7	Forum Posts Vanishing Hi, my website is on Banana I believe (www.lanarchy.co.uk). Today we seem to have had our database 'rolled back' a couple of times. Just before I went to work I noticed '27 new posts' had appeared... but they were all posts from last night, which I'd already read and all of the recent posts had vanished. Anyone know what might have happened, or still is for that matter. I just got home from work and people are complaining posts have gone missing through the day.

01-09-2006, 10:02 PM	#2 (permalink)
Jacob Administrator Join Date: May 2003 Posts: 1,299	Hi, Please can you open a ticket about this and we can have a look. Regards, Jacob __________________ Jacob Colton jacob@catalyst2.com Open a ticket \| Knowledgebase \| Rate catalyst2 \| Review catalyst2

02-09-2006, 09:09 AM	#4 (permalink)
paulredpath Bring me your problems :p Join Date: Jan 2003 Location: /dev/ahhhhhhhhh Posts: 3,536	Rob, All users that were having sites moved were emailed a few days before. __________________ Paul Redpath paul@catalyst2.com Go on, review Us at OC Host Review!

Thread Tools
Show Printable Version Email this Page
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

02-09-2006, 03:24 AM	#3 (permalink)
robertc Registered User Join Date: Jul 2003 Location: London Posts: 22	It turns out it's a bit more subtle than database resets - someone moved our website to blueberry without telling us! I know there was some issue with Spamcop from cat2 to the domain where we have our personal email so the message may have gone by the wayside. Anyway, I'm assuming because both the banana and the blueberry versions of the site are both up some users are getting one and some the other depending on how up to date their DNS is. It's all made a bit of a mess of the database but I think it's mostly sorted out now. Some queries seem to be timing out though - perhaps stuff in the database which needs repairing or perhaps some incompatibilities between MySQL 4.0 (banana) and 4.1 (blueberry) which are upsetting phpBB. Is there anyway we can get an error log out of the MySQL server or do we have to debug with PHP? Rob

02-09-2006, 11:36 AM	#5 (permalink)
robertc Registered User Join Date: Jul 2003 Location: London Posts: 22	Yeah, that's OK, like I said there have been some issues sending email from my cat2 account to the domain that my main email address is on because of Spamcop - I even raised a ticket about it, but there's nothing that could be done. So I'm assuming the email went astray. What I'm more interested in right now is working out why some parts of phpbb seem to have stopped working. Rob