Topic: just installed

I installed punbb 1.0.1 and I logged in, but I am getting the following error:

An error was encountered
Error: Unable to fetch category/forum list.

MySQL permissions wrong?  That's all I can think of.

Thanks

2

Re: just installed

remove all the tables and try to reinstall.

Re: just installed

That seems a bit extreme.  Is there a reason?

Re: just installed

Deleted tables, re-installed, same problem

5

Re: just installed

Have you checked that the database settings in config.php are correct?

Re: just installed

ps21 wrote:

Have you checked that the database settings in config.php are correct?

Yes, everything is right in config.php.  I am getting this error when I run admin_index.php:

An error was encountered
Error: Unable to fetch table status.

I ran this query in PHPMyAdmin:

SHOW TABLE STATUS FROM PUNBB

and I get an error near 'TABLE STATUS FROM PUNBB'

The problem is in the DB.  I just figure out where.

Re: just installed

Line 58 in admin_index.php:

$result = $db->query('SHOW TABLE STATUS FROM `'.$db_name.'`') or error(

I am not able to run that query manually.  That is why the script is breaking.

Re: just installed

using PHP 4.2.3 and MySQL 3.23.52 on Apache 1.3.27

Re: just installed

If I keep talking to myself, I may move from 'New Member' to 'Member' in a single topic.  Wahoo!

10

Re: just installed

delete the database, its corrupted maybe?

Re: just installed

I'll try it

12

Re: just installed

if that doesn't work....i suggest you run around the room screaming and pulling your hair untill it magically comes into your head that you are insane, then call the police so they take you to a big padded room in a small padded box,where you will spend the rest of your days fearing mysql.

Re: just installed

did it - same error

14

Re: just installed

okay start screaming.

Re: just installed

fly wrote:

if that doesn't work....i suggest you run around the room screaming and pulling your hair untill it magically comes into your head that you are insane, then call the police so they take you to a big padded room in a small padded box,where you will spend the rest of your days fearing mysql.


Did that too - didn't fix it

16

Re: just installed

try upgrading php

Re: just installed

I really like this script.  I don't want to have to search for another.

18

Re: just installed

btw, at one of the forums i post at, i went from member to official pcf groupie in one day (thats about 200 posts)

Re: just installed

I am now a 'Member'!  Wahooooo!!!

20

Re: just installed

lol, i like it too,

21

Re: just installed

http://apmb.pc-forums.net register and post please.

Re: just installed

digimatt: Please enable DEBUG and try again. It won't work then either, but we'll see whats going wrong.

You enabled DEBUG by removing // from the beginning of a line in include/common.php. Open it up and you will see.

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

Re: just installed

Thanks Kennel.  Your code rocks!

Here is what it says:

An error was encountered
File: /usr/home/quartzsite/public_html/forum/index.php
Line: 64

PunBB reported: Unable to fetch category/forum list
Database reported: You have an error in your SQL syntax near 'INNER JOIN forums AS f ON c.id=f.cat_id ORDER BY c.position, cid, f.position' at line 1 (Errno: 1064)

Re: just installed

Line 64:

$result = $db->query('SELECT c.id AS cid, c.cat_name, f.id AS fid, f.forum_name, f.forum_desc, f.moderators, f.num_topics, f.num_posts, f.last_post, f.last_post_id, f.last_poster, f.closed FROM '.$db->prefix.'categories AS c INNER JOIN '.$db->prefix.'forums AS f ON c.id=f.cat_id'.$extra.' ORDER BY c.position, cid, f.position') or error('Unable to fetch category/forum list', __FILE__, __LINE__, $db->error());

Re: just installed

admin_index.php gives this error:

An error was encountered
File: /usr/home/quartzsite/public_html/forum/admin_index.php
Line: 58

PunBB reported: Unable to fetch table status
Database reported: You have an error in your SQL syntax near 'TABLE STATUS FROM `punbb`' at line 1 (Errno: 1064)