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.  / Forum error
Register
11
phppp
Re: Forum error

  • 2004/6/2 14:01

  • phppp

  • XOOPS Contributor

  • Posts: 2857

  • Since: 2004/1/25


1 switch debug mode to MySQL output
2 modules/newbb/index.php
around line 61, right after
$sql .= ' ORDER BY f.cat_id, f.forum_id';


add

echo "<br>".$sql;


12
Guido83
Re: Forum error

  • 2004/6/2 21:12

  • Guido83

  • Just popping in

  • Posts: 60

  • Since: 2003/12/7


Now I get:

SELECT f.*, u.uname, u.uid, p.topic_id, p.post_time, p.subject, p.icon FROM xoops_bb_forums f LEFT JOIN xoops_bb_posts p ON p.post_id = f.forum_last_post_id LEFT JOIN xoops_users u ON u.uid = p.uid ORDER BY f.cat_id, f.forum_idError

Any ideas? Thanks!
13
Guido83
Re: Forum error

  • 2004/6/3 17:42

  • Guido83

  • Just popping in

  • Posts: 60

  • Since: 2003/12/7


Come on guys, I'm getting pretty desperate here...
14
Guido83
Re: Forum error

  • 2004/6/4 16:37

  • Guido83

  • Just popping in

  • Posts: 60

  • Since: 2003/12/7


Please?
15
phppp
Re: Forum error

  • 2004/6/4 20:50

  • phppp

  • XOOPS Contributor

  • Posts: 2857

  • Since: 2004/1/25


sorry for the ignorance

did you do this?
Quote:

1 switch debug mode to MySQL output


and any message when loading index.php?

BTW: I am enabling the option of Notify me of new posts in this thread
16
Guido83
Re: Forum error

  • 2004/6/4 21:21

  • Guido83

  • Just popping in

  • Posts: 60

  • Since: 2003/12/7


Yes I turned it on. One line appears in red:

SELECT COUNT(*) FROM xoops_priv_msgs WHERE (read_msg = 0 AND to_userid = 46)
Error number: 1016
Error message: Can't open file: 'xoops_priv_msgs.MYD'. (errno: 145)

Any ideas? Thanks!
17
phppp
Re: Forum error

  • 2004/6/4 21:28

  • phppp

  • XOOPS Contributor

  • Posts: 2857

  • Since: 2004/1/25



what's in table 'xoops_priv_msgs'?

empty the table 'xoops_priv_msgs' and send a message to yourself, then check again.
18
phppp
Re: Forum error

  • 2004/6/4 21:40

  • phppp

  • XOOPS Contributor

  • Posts: 2857

  • Since: 2004/1/25


after a quick search over MySQL errno: 145, I would suggest you check your database
19
Guido83
Re: Forum error

  • 2004/6/4 23:40

  • Guido83

  • Just popping in

  • Posts: 60

  • Since: 2003/12/7


I don't realy understand ...

How do I 'check my database'?
What's the 'xoops_priv_msgs table' and how do I empty it?

I'm rather new with the XOOPS system, so excuse me for coming across a bit ignorant.
20
phppp
Re: Forum error

  • 2004/6/5 0:13

  • phppp

  • XOOPS Contributor

  • Posts: 2857

  • Since: 2004/1/25


errno: 145 usually indicates a MySQL error, which means that it is not caused by XOOPS but your mysql.


THe weird point is that it only happens with newbb index.php --- I really do not understand. might too many queries by newbb?
« 1 (2) 3 »

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

82 user(s) are online (54 user(s) are browsing Support Forums)

Members: 0

Guests: 82

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