• Registered: 2004-10-31
  • Posts: 6

Topic: Reports problem

I have been using the punbb forum for months now and I haven't got any problems... but I visited my forum a few hours ago and it was working perfectly fine..

but now I don't see the forum and all I see is this error:

Error: Unable to fetch reports info.

what does it mean? I haven't changed any file...

I do have another admin besides myself and a couple of moderators.. could they have done something to produce that error? thanks! ^_________^

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

Re: Reports problem

Enable DEBUG mode and try again. Then paste the full error message here.

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

Rickard's Website

3 Reply by Lacaille (edited by Lacaille 2004-11-01 02:47)

  • Registered: 2004-10-31
  • Posts: 6

Re: Reports problem

Here's the fulll error message:

File: /home/www/web153/html/forum/header.php
Line: 201

PunBB reported: Unable to fetch reports info
Database reported: (Errno: )

and here is line 201 of header.php

    $result_header = $db->query('SELECT COUNT(id) FROM '.$db->prefix.'reports WHERE zapped IS NULL') or error('Unable to fetch reports info', __FILE__, __LINE__, $db->error());

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

Re: Reports problem

Hmm, what the hell? No error message from MySQL. Perhaps it's a corrupt table. Try running a REPAIR on the reports table in a MySQL administration toll (such as phpMyAdmin).

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

Rickard's Website

5 Reply by Lacaille (edited by Lacaille 2004-11-01 10:15)

  • Registered: 2004-10-31
  • Posts: 6

Re: Reports problem

Done... phpmyadmin said OK... the table is repaired...

still the error is there... the forum is situated here:

http://wings.aniwaii.com/forum/index2.php

thanks in advance, by the way... wink

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

Re: Reports problem

What if you run the query manually in phpMyAdmin?

SELECT COUNT(id) FROM reports WHERE zapped IS NULL

If you use a table prefix, you have to put that in front of "reports".

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

Rickard's Website

  • Registered: 2004-10-31
  • Posts: 6

Re: Reports problem

ok...

it said this:

COUNT(id) 
0

erm... what's next? sad

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

Re: Reports problem

I have no idea what the hell is wrong. The query works fine when you run it manually, but when PunBB runs it, it fails, but does not generate an error message. Very strange. Have you modified the scripts in any way?

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

Rickard's Website

  • Registered: 2004-08-16
  • Posts: 577

Re: Reports problem

Rickard wrote:

Have you modified the scripts in any way?

Lacaille wrote:

I haven't changed any file...



also for that link, why is it index2.php? and that isnt even found.. so if its index2.php for the forum, some code must have been changed

Indocron
$theQuestion = (2*b) || !(2*b);
  • Registered: 2004-10-31
  • Posts: 6

Re: Reports problem

I just changed the files months ago to interface it with my site and it was working fine for months... I haven't changed any file from then till now...

I changed the filename to index2.php bec. too may people know the link to my forum and I wanted to be able to fix it without them seeing any error message...

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

Re: Reports problem

Ok, but before we continue, upload a fresh 1.1.5 install into a subdirectory and copy your config.php into that directory. That way, we can make sure it's not a problem with any of your modifications.

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

Rickard's Website