View Topic

Bug Search

Leinad4Mind
Posts: 25
Joined: June 2nd 2015
Leinad4Mind
An error on last version (atleast) and on this forum itself. I can't search and if I click on the "Advanced Search" this appears:

Select allCode
General Error

MySQL ERROR

Table 'php-bbdr.FORUMS_ACCESS_TABLE' doesn't exist [1146]

An SQL error occurred while fetching this page. Please contact the Board Administrator if this problem persists.
Please notify the board administrator or webmaster: admin@php-bbdr.com


And in my forum:
Select allCode
MySQL ERROR

Table 'phpbb.FORUMS_ACCESS_TABLE' doesn't exist [1146]

SQL

SELECT f.forum_id, f.forum_name, f.parent_id, f.forum_type, f.left_id, f.right_id, f.enable_indexing, fa.user_id FROM dr_forums f LEFT JOIN FORUMS_ACCESS_TABLE fa ON (fa.forum_id = f.forum_id AND fa.session_id = '8cf49a5e6d09b1023bb45433e8915458') ORDER BY f.left_id ASC

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/includes/db/dbal.php
LINE: 999
CALL: trigger_error()

FILE: [ROOT]/includes/db/dbal.php
LINE: 191
CALL: dbal->sql_error()

FILE: [ROOT]/search.php
LINE: 1104
CALL: dbal->sql_query()

FILE: [ROOT]/index.php
LINE: 42
CALL: include('[ROOT]/search.php')


The table is missing on database.
Dion
Posts: 123
Joined: December 29th 2014
AVATAR
Dion
Yes, that's a bug. :oops: The table isn't missing; the search.php script referenced a table that was removed from earlier versions of php-bbdr. I did a thorough check and found the same problem in the adm/acp_forums.php file. I've attached a ZIP archive containing replacements for the two files. These replacements will be in the next build of php-bbdr.

search.zip
You do not have the required permissions to view the files attached to this post.
Leinad4Mind
Posts: 25
Joined: June 2nd 2015
Leinad4Mind
Thanks!