BleepingComputer.com: PHP MySQL Error on my forums.

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

PHP MySQL Error on my forums.

#1 User is offline   ThaTweaker 

  • New Member
  • Pip
  • Find Topics
  • Group: Members
  • Posts: 3
  • Joined: 28-April 09

Posted 28 April 2009 - 10:46 PM

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()


#2 User is offline   groovicus 

  • Hail Groovicus!
  • PipPipPipPipPipPip
  • Find Topics
  • Group: Moderator
  • Posts: 9,605
  • Joined: 05-June 04
  • Gender:Male
  • Location:Centerville, SD

Posted 29 April 2009 - 10:46 AM

The error is saying that there is no column called "group_bypass_post_req" in the table that you are querying.
"Take the risk of thinking for yourself, much more happiness, truth, beauty, and wisdom will come to you that way" - Christopher Hitchens

#3 User is offline   ThaTweaker 

  • New Member
  • Pip
  • Find Topics
  • Group: Members
  • Posts: 3
  • Joined: 28-April 09

Posted 29 April 2009 - 12:55 PM

how do i make said column?

#4 User is offline   groovicus 

  • Hail Groovicus!
  • PipPipPipPipPipPip
  • Find Topics
  • Group: Moderator
  • Posts: 9,605
  • Joined: 05-June 04
  • Gender:Male
  • Location:Centerville, SD

Posted 29 April 2009 - 01:19 PM

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?
"Take the risk of thinking for yourself, much more happiness, truth, beauty, and wisdom will come to you that way" - Christopher Hitchens

#5 User is offline   mckooter 

  • Forum Regular
  • PipPipPip
  • Find Topics
  • Group: Members
  • Posts: 211
  • Joined: 29-May 08
  • Gender:Male
  • Location:Maine

Posted 29 April 2009 - 01:33 PM

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

You can just call me Chris

Pandy said:

I found out I was Marilyn Monroe in a previous life

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users