XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Modules Support forums / 
  3. Module troubleshooting 
  4.  / CBB errors when upgrading to 2.0.14
Register
1
Chappy
CBB errors when upgrading to 2.0.14

  • 2006/5/28 0:05

  • Chappy

  • Friend of XOOPS

  • Posts: 456

  • Since: 2002/12/14


I get the following errors after upgrading to 2.0.14 along with a blank page when accessing the forums:

Quote:

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

update error: UPDATE xoops_bb_forums SET xoops_bb_forums.forum_posts = @posts =( SELECT COUNT(*) AS posts FROM xoops_bb_posts WHERE approved=1 AND forum_id = xoops_bb_forums.forum_id ) WHERE xoops_bb_forums.forum_posts <> @posts

update error: UPDATE xoops_bb_forums SET xoops_bb_forums.forum_topics = @topics =( SELECT COUNT(*) AS topics FROM xoops_bb_topics WHERE approved=1 AND forum_id = xoops_bb_forums.forum_id ) WHERE xoops_bb_forums.forum_topics <> @topics


When running debug, I also get the following error:

Quote:
Fatal error: Cannot redeclare get_total_topics() (previously declared in /home/mysite/public_html/modules/newbb/include/functions.php:374) in /home/mysite/public_html/modules/newbb/functions.php on line 25
MMM...It tastes like chicken! ...
2
davidl2
Re: CBB errors when upgrading to 2.0.14

  • 2006/5/28 0:07

  • davidl2

  • XOOPS is my life!

  • Posts: 4843

  • Since: 2003/5/26


Which cbb version are you running?
3
Chappy
Re: CBB errors when upgrading to 2.0.14

  • 2006/5/28 0:17

  • Chappy

  • Friend of XOOPS

  • Posts: 456

  • Since: 2002/12/14


3.02...
MMM...It tastes like chicken! ...
4
alyussiu
Re: CBB errors when upgrading to 2.0.14

  • 2006/6/19 12:49

  • alyussiu

  • Not too shy to talk

  • Posts: 119

  • Since: 2004/4/9 9


Hello.

I've the same error and was wondering if you found a way to fix it?

Thanks :)).
5
msdana
Re: CBB errors when upgrading to 2.0.14

  • 2006/6/19 12:54

  • msdana

  • Just can't stay away

  • Posts: 817

  • Since: 2005/12/11


Perhaps if you upgrade to CBB version 3.04 that may solve your problem.

Just a guess...
[size=x-small]If God is watching us, the least we can do is be entertaining.[/size]
Graphic Worx : Xoops Themes
6
Chappy
Re: CBB errors when upgrading to 2.0.14

  • 2006/6/19 22:04

  • Chappy

  • Friend of XOOPS

  • Posts: 456

  • Since: 2002/12/14


Okay, so I think the issue is related to something in the downgrade of 2.2.4 to 2.0.13.2 and then the upgrade to 2.0.14. There were several other mods that seemed to have some difficulties with those transitions. I ended up Cleaning out all my files, creating a new XOOPS installation with all my old settings, instaling the modules as new, and then cutting and pasting all the old sql into my modules. That seems to have worked. Apart from that, I have no idea how to fix it.

It would be interesting to know if you had the same course of downgrading and then upgrading that I did.
MMM...It tastes like chicken! ...

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

197 user(s) are online (125 user(s) are browsing Support Forums)

Members: 0

Guests: 197

more...

Donat-O-Meter

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

Latest GitHub Commits