[MaNGOSWeb] Errors...

[fullalliance]

Getting this error on the site we're working on for Project Yaris, Wondering if anyone else has had this issue.

It happens on the forums and parts of the Admin Panel only. (From what we can tell)

SQL Error: Unknown column 'data' in 'field list' at /home/sysgamin/public_html/core/class.auth.php line 124

Array
(
[code ] => 1054
[message] => Unknown column 'data' in 'field list'
[query] => SELECT count(*) FROM pms WHERE owner_id='9' AND showed=0
[context] => /home/sysgamin/public_html/core/class.auth.php line 124
)

 function check_pm()
{
$result = $this->DB->selectCell("SELECT count(*) FROM pms WHERE owner_id=? AND showed=0",$this->user['id']);
return $result;
} 

Any idea on how to resolve this?

[fullalliance]

-Bangs head off desk-

/cry THIS THING IS DRIVING ME CRAZY?!

[Kiev]

What is count(*) defined as? Im guessing the SQL query that is defined in two parts has the wrong database structure.

[fullalliance]

Found the issue, Since the updates to mangos revisions the column 'data' no longer exists, Hence Errors!

Going through page by page at the moment on mangos web removing all calls to c.data

[RESOLVED]