Database query error when login as admin

Whenever you get a database error you will get an email also.
Post the content of it for a right solution.

vinilrichard,
could you please post your inquiry in the forums under the appropriate topic?

also please read cyberxing's post about the blog rules

later,
DosDawg

this is the cronjob mail i had
<div style="border:2px solid red;padding:4px;width:600px;margin:0px auto;">
<div style="text-align:center;background-color:red;color:white;font-weight:bold;">Error</div>
<div style="text-align:center;">Database query error</div>
</div>

inc\db.inc.php
change
define( 'DB_FULL_DEBUG_MODE', false );
to
define( 'DB_FULL_DEBUG_MODE', true );
and save file and try login as admin again - You will get more detailed error. Give it to us please

Good, so,
are you can understand first several strings from this error?
Seems error already in english? :)

so, read:
Database query error
Query:
SELECT COUNT(`ID`) AS `Count` FROM `RayLivecamChannels` WHERE `Public`='true'
Mysql error:
Unknown column 'Public' in 'where clause'

last string what mean?
That you haven`t column 'Public' in your `RayLivecamChannels` table, not more :)
And seems that it anybody mod, So you must create this field for this table, understand? :) all simple

I am having the same problem. I get this message in e-mail when trying to login as admin. Actual password is replaced with word password.

Database error in PeNePaL Community
Query:
SELECT * FROM `Admins` WHERE `Name` = 'dolphin' AND `Password` = MD5('password')

Mysql error:
Unknown column 'Name' in 'where clause'

Found error in file /home/penepal/public_html/dolphin/admin/index.php
at line 39. Called db_res function
with erroneous argument #0

Debug backtrace:
Array
(
[1] => Array
(
[file] => /home/penepal/public_html/dolphin/admin/index.php
[line] => 39
[function] => db_res
[args] => Array
(
[0] => SELECT * FROM `Admins` WHERE `Name` = 'dolphin' AND
`Password` = MD5('password')
)

)

)


Called script: /dolphin/admin/index.php

Request parameters:
Array
(
[relocate] => /dolphin/admin/index.php
[ID] => dolphin
[Password] => password
)