1 Topic by M_B

  • M_B
  • Junior Member
  • Offline
  • Registered: 2006-01-03
  • Posts: 3

Topic: Unable to fetch subscription info

Unable to fetch subscription info

The message above is shown on the screen when submitting a new topic, or  a reply to an existing topic. The message is submitted OK, but every user in my forum gets the same error.

How can I solve this? Using PubBB 1.2.10 by the way.

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: Unable to fetch subscription info

http://punbb.org/docs/faq.html#faq2_7

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

3 Reply by M_B

  • M_B
  • Junior Member
  • Offline
  • Registered: 2006-01-03
  • Posts: 3

Re: Unable to fetch subscription info

Rickard wrote:

http://punbb.org/docs/faq.html#faq2_7

Thanks! the debugging info made it possible to solve my problem.

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: Unable to fetch subscription info

Let me guess. A crashed table?

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

5 Reply by M_B

  • M_B
  • Junior Member
  • Offline
  • Registered: 2006-01-03
  • Posts: 3

Re: Unable to fetch subscription info

Rickard wrote:

Let me guess. A crashed table?

The collation type of the table was wrong.
I ran the forum on a test server first, which had a strange collation, utf-swedish or something like that. I thought I fixed that all before I moved the forum to the live server. But I forgot a table.
Thanks for your support.

  • Registered: 2007-11-08
  • Posts: 7

Re: Unable to fetch subscription info

I tryed the debugging and once I did then i got this error.

File: /home/thefoacl/public_html/forum/post.php
Line: 218

PunBB reported: Unable to fetch subscription info

Database reported: Table 'thefoacl_forum.bans' doesn't exist (Errno: 1146)

any suggestion?

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: Unable to fetch subscription info

You dropped your bans table. Create it again.

  • Registered: 2007-11-08
  • Posts: 7

Re: Unable to fetch subscription info

Could you please show me where i could info on how to create it cuz im still new at( this trying to keep my head  afloat (HEEHE)) So im not at 100% sure of myself.
Thanks

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: Unable to fetch subscription info

Well, it shouldn't be deleted in the first place unless you did something tongue
Anyway, run the following SQL to create the table:

CREATE TABLE bans (
id INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
username VARCHAR(200),
ip VARCHAR(255),
email VARCHAR(50),
message VARCHAR(255),
expire INT(10) UNSIGNED,
PRIMARY KEY (id)
) TYPE=MyISAM