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] see more => 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
)

I am also getting the same error now even my full site is down after some time showing the same error

This also happens when you overwrite the administration index.php with the front page index.php or vice-versa.

This will always happen whenever you empty the cache, so dont empty the cache. My whole site is down. Can anybody help?