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. 2.3.x Support 
  4.  / Posts missing
Register
1
NickJames
Posts missing

  • 2010/2/7 6:30

  • NickJames

  • Just popping in

  • Posts: 11

  • Since: 2006/9/27


Running XOOPS 2.3.2 and CBB 3.08 successfully for a long time.

About three days ago, a problem developed. The posts are not being displayed. It appears that the posts are still there, but when they are 'displayed', there is nothing there.

http://ladads.info/modules/newbb/viewtopic.php?viewmode=flat&order=ASC&topic_id=1562&forum=2&move=prev
2
Mamba
Re: Posts missing

  • 2010/2/7 7:09

  • Mamba

  • Moderator

  • Posts: 11409

  • Since: 2004/4/23


This is weird. Turn on the debug and tell us what the error says?

Did you host upgraded PHP version? What is your current version?

Did you do any changes to the installation?

Try to repair/optimize your database - it might help.
3
NickJames
Re: Posts missing

  • 2010/2/7 8:44

  • NickJames

  • Just popping in

  • Posts: 11

  • Since: 2006/9/27


Turned on the 'inline error handling'

There is this message at the top of the page

NewbbTopicHandler::getAllPosts error:SELECT p.*, t.* FROM lad_bb_posts p, lad_bb_posts_text t WHERE p.topic_id=1591 AND p.post_id = t.post_id AND p.approved = 1 ORDER BY p.post_id ASC
4
NickJames
Re: Posts missing

  • 2010/2/7 8:45

  • NickJames

  • Just popping in

  • Posts: 11

  • Since: 2006/9/27


When posting a message, I get this error:

Array
(
)

Could not insert forum post

Array
(
[0] => post text insert error
)
5
NickJames
Re: Posts missing

  • 2010/2/7 8:52

  • NickJames

  • Just popping in

  • Posts: 11

  • Since: 2006/9/27


The test post must be there. I can 'find' it by going to an earlier post.

Then using the 'next post' feature to cycle through the posts.

It shows the title for the 'test post', but it does not show the text section.

The forum had been working in its current configuration for a long while.

I haven't made any system changes in a while. The last major change I remember making was deleting a number of user groups I no longer needed. I had 'mail groups 1 through 10 - so I could send out system messages to all users batchwise. But since the revision to have the program send more than 100 message, I no longer needed them.

I have been just using the site. It was working as recently as 2/3 21:43 because that is the time stamp for my last post.


Nick


P.S. One other symptom. The 'test post' does not show on the index. so the index is froze.

P.P.S I tried using the 'compact' feature on the database in the forum controls. It appeared to work, but did not fix the problem.
6
NickJames
Re: Posts missing

  • 2010/2/7 8:56

  • NickJames

  • Just popping in

  • Posts: 11

  • Since: 2006/9/27



An Error Occured
SELECT t.*, p.post_time as last_post_time, p.poster_name as last_poster_name, p.icon, p.post_id, p.uid, p.post_karma, p.require_reply, pt.post_text FROM lad_bb_topics t LEFT JOIN lad_bb_posts p ON p.post_id = t.topic_last_post_id LEFT JOIN lad_bb_posts_text pt ON pt.post_id = t.topic_last_post_id WHERE (p.post_time > 0 OR t.topic_sticky=1) AND t.forum_id = 7 AND t.approved = 1 AND p.approved = 1 ORDER BY t.topic_sticky DESC, p.post_time DESC

If the page does not automatically reload, please click here
All errors (37) queries (64) blocks (19) extra (0) timers (5)
7
NickJames
Protector issue?

  • 2010/2/7 9:09

  • NickJames

  • Just popping in

  • Posts: 11

  • Since: 2006/9/27


Wait a minute. Perhaps this is a PROTECTOR issue?

I had gotten locked out and banned by my site.

To fix that problem, I switched to a proxy IP address, logged in; and modified the protector to delete the banned sites and the log files.

Now is there some way that could be related to this issue.

That change would be about the time that the error happened.
8
ghia
Re: Posts missing

  • 2010/2/7 9:25

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Did you reset your connection from proxy to direct?
Did you try to repair your tables in phpMyAdmin?
9
NickJames
Re: Posts missing

  • 2010/2/7 9:31

  • NickJames

  • Just popping in

  • Posts: 11

  • Since: 2006/9/27


OH
10
sailjapan
Re: Posts missing

Man, I feel for you. You sound just like me. 3 hours of frantic head scratching followed by a slap to the forehead
Hope you're all sorted now.

Happy xoopsing
(1) 2 »

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

313 user(s) are online (113 user(s) are browsing Support Forums)

Members: 0

Guests: 313

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