1
tedsmith
CBB 3.04 - Bizarre Error Message
  • 2006/11/16 20:51

  • tedsmith

  • Home away from home

  • Posts: 1151

  • Since: 2004/6/2 1


Xoops 2.0.13.2 and CBB 3.04

My forums have been fine for months. The other day I deleted a cateogry and a couple of the forums belonging to that category.

Since then, whenever anyone tries to view a forum they get :

Quote:

update error: UPDATE firstforensicforum_bb_forums SET firstforensicforum_bb_forums.forum_last_post_id = @last_post =( SELECT MAX(post_id) AS last_post FROM firstforensicforum_bb_posts WHERE approved=1 AND forum_id = firstforensicforum_bb_forums.forum_id ) WHERE firstforensicforum_bb_forums.forum_last_post_id <> @last_post


I've gone into the module and tried to run Sync, but I get the same message. Also, all the dates and times are blank.

Any ideas?

Cheers

Ted

2
tedsmith
Re: CBB 3.04 - Bizarre Error Message
  • 2006/11/16 22:40

  • tedsmith

  • Home away from home

  • Posts: 1151

  • Since: 2004/6/2 1


It was the 'In Use' issue in the MySQL database. A flush should have fixed it (which it kind of did) but I've ended up deleting every single post on my forums going back 18 months. And my last backup was made in June 2006 because I thought (wrongly) that my host provided a daily backup and restore service. Wrong - they only backup to protect themsevles in the event of system failure - they don't backup resotres for individuals. Oh dear. I am screwed now!

But hey, nothing to do with CBB. All my fault. I am an idiot for not backing up.

Right - time to write my resignation letter as web administrator.

3
phppp
Re: CBB 3.04 - Bizarre Error Message
  • 2006/11/16 23:53

  • phppp

  • XOOPS Contributor

  • Posts: 2857

  • Since: 2004/1/25


Valuable experiences, should be posted to FAQ

4
irmtfan
Re: CBB 3.04 - Bizarre Error Message
  • 2006/11/17 4:15

  • irmtfan

  • Module Developer

  • Posts: 3419

  • Since: 2003/12/7


Ah that "In use" can be solved just with a simple "Repair"
i have that in my share hopsting sometimes in large tables but after go for a dedi its gone!

Login

Who's Online

407 user(s) are online (298 user(s) are browsing Support Forums)


Members: 0


Guests: 407


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits