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
You are not logged in. Please login or register.
PunBB Forums → PunBB 1.2 bug reports → 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
remove all the tables and try to reinstall.
That seems a bit extreme. Is there a reason?
Deleted tables, re-installed, same problem
Have you checked that the database settings in config.php are correct?
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.
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.
using PHP 4.2.3 and MySQL 3.23.52 on Apache 1.3.27
If I keep talking to myself, I may move from 'New Member' to 'Member' in a single topic. Wahoo!
delete the database, its corrupted maybe?
I'll try it
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 it - same error
okay start screaming.
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
try upgrading php
I really like this script. I don't want to have to search for another.
btw, at one of the forums i post at, i went from member to official pcf groupie in one day (thats about 200 posts)
I am now a 'Member'! Wahooooo!!!
lol, i like it too,
http://apmb.pc-forums.net register and post please.
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.
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)
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());
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)
PunBB Forums → PunBB 1.2 bug reports → just installed
Powered by PunBB, supported by Informer Technologies, Inc.