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 Community Support forums / 
  3. Q and A 
  4.  / CBB Missing postings
Register
1
limecity
CBB Missing postings

  • 2009/3/17 6:24

  • limecity

  • Friend of XOOPS

  • Posts: 1602

  • Since: 2003/7/6 0


Still trying to figure out this problem for the past 3 months now after upgrading cbb and xoops.

forum topic page 1

forum topic last page

there are suppose to be postings on the last few pages. but all of them are missing. I don't know why.

I tried to sync the forum. but it says "Got error 134 from storage engine".

I turn on the debug inline so you can see.

can anyone help?
hhttp://www.mounthiking.com
all your hiking gears and gadgets

2
Anonymous
Re: CBB Missing postings

  • 2009/3/17 8:50

  • Anonymous

  • Posts: 0

  • Since:


Which version of XOOPS were you using when you upgraded CBB?

There was a problem with 2.3.x prior to 2.3.2b where updating or synching the module caused lost posts. From the checks I made the posts were lost permanently.

The problem was solved with the 2.3.2b update, but that won't help if you updated or synched the Forums before then.
3
limecity
Re: CBB Missing postings

  • 2009/3/17 10:34

  • limecity

  • Friend of XOOPS

  • Posts: 1602

  • Since: 2003/7/6 0


for that site you see. I done a fresh installation of the new xoops. and installed cbb 3.08
and ported it over.

I check the forum postings in the sql database and all the postings are still intact. just that its not displaying somehow.

On the main live site, the forum is displaying as it is and I dare not to touch anything after the upgrade to 3.08. However there was a problem with the administration. I lost my administrative power particularly to the forum like what i posted here problem still unsolved.

It was upgraded from newbb 1.15 to cbb 3.08

I maintain a consistent update of xoops. from one version to another.



hhttp://www.mounthiking.com
all your hiking gears and gadgets

4
limecity
Re: CBB Missing postings

  • 2009/3/17 16:38

  • limecity

  • Friend of XOOPS

  • Posts: 1602

  • Since: 2003/7/6 0


bump!
hhttp://www.mounthiking.com
all your hiking gears and gadgets

5
limecity
Re: CBB Missing postings

  • 2009/3/18 1:47

  • limecity

  • Friend of XOOPS

  • Posts: 1602

  • Since: 2003/7/6 0


Help
hhttp://www.mounthiking.com
all your hiking gears and gadgets

6
Mamba
Re: CBB Missing postings

  • 2009/3/18 2:08

  • Mamba

  • Moderator

  • Posts: 11409

  • Since: 2004/4/23


I think, it's a data mismatch, i.e. your messages ( those older than the first two) are having a different topic Id. The Table Topic (or whatever it is called) has the counter of 1586 messages. But when XOOPS is going to find the individual message in the "message table", it cannot find any (except those first two) because they have a different Topic ID.

You would need to go into phpMyAdmin to check the tables and see what TopicID those missing messages have - I guess, it's not 838.

Then you would have to replace the TopicID with that value.
Support XOOPS => DONATE
Use 2.5.11 | Docs | Modules | Bugs
7
limecity
Re: CBB Missing postings

  • 2009/3/18 2:17

  • limecity

  • Friend of XOOPS

  • Posts: 1602

  • Since: 2003/7/6 0


ooo.. that could be the problem.
I'll take a look into the database and report back

I turned on the debug. but need to login i guess.
username: test , pw: 123
hhttp://www.mounthiking.com
all your hiking gears and gadgets

8
limecity
Re: CBB Missing postings

  • 2009/3/18 2:35

  • limecity

  • Friend of XOOPS

  • Posts: 1602

  • Since: 2003/7/6 0


just check the database.
the postings seemed to be OK.

Resized Image
the ids seems to be there.

the image above refers to this forum section:
this

with the ID 3701

do login to see the debug msg

hhttp://www.mounthiking.com
all your hiking gears and gadgets

9
ghia
Re: CBB Missing postings

  • 2009/3/18 11:46

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


OK, that's bb_posts. Do you find the post_id also in bb_posts_text?
What is the result of this query in phpMyAdmin?
SELECT p.*, t.* FROM bb_posts p, bb_posts_text t WHERE p.topic_id=3701 AND p.post_id = t.post_id AND p.approved = 1 ORDER BY p.post_id ASC LIMIT 0, 10
10
limecity
Re: CBB Missing postings

  • 2009/3/18 12:53

  • limecity

  • Friend of XOOPS

  • Posts: 1602

  • Since: 2003/7/6 0


it says:

MySQL said: Documentation
#1146 - Table 'catscity_test09.bb_posts' doesn't exist


is the query command correct? the table prefix is xxx tw
hhttp://www.mounthiking.com
all your hiking gears and gadgets

(1) 2 »

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

422 user(s) are online (332 user(s) are browsing Support Forums)

Members: 0

Guests: 422

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