BleepingComputer.com: PHP MySQL Error on my forums.

when i go to post a topic ... it gives me this error:

i have added a few mods, but i dont think they did anything like this... is there any query that i can do to in MyPHPAdmin? or anything like that? i just used the PHPBB3 files that you can download from phpbb3.com and some mods on there also...

General Error
SQL ERROR [ mysql4 ]

Unknown column 'b.group_bypass_post_req' in 'field list' [1054]

SQL

SELECT b.group_bypass_post_req AS requirement FROM phpbb_user_group a, phpbb_groups b WHERE user_id = 2 AND a.group_id = b.group_id

BACKTRACE

FILE: includes/db/mysql.php
LINE: 174
CALL: dbal->sql_error()

FILE: posting.php
LINE: 60
CALL: dbal_mysql->sql_query()

The error is saying that there is no column called "group_bypass_post_req" in the table that you are querying.

how do i make said column?

The first question is what good is it going to do? If you query a column that has no information in it, then you may end up with other bad results. What information is the query supposed to be returning? OR maybe the column exists in a different table. Did you create the query, or was it pre-existing in the software package?

ThaTweaker, you didnt run the sql command on the mod you installed,

i think you installed this mod: http://www.phpbb.com/community/viewtopic.p...69&t=937065

at the top of the xml install file it says SQL and has a series of code, that is needed to make the mod work, you would want to run it in PHPMyAdmin
if thats not the correct mod, then you would want to find the mod you installed that deals with permissions on post requirements, that one just happened to be the only one i could find with that column

This post has been edited by mckooter: 29 April 2009 - 01:34 PM