Database Query Error

Database error in

Query:

SELECT COUNT(`Profiles`.`ID`) FROM `Profiles`  WHERE `Profiles`.`Status` = 'Active' and (`Profiles`.`Couple` = 0 or `Profiles`.`Couple` > `Profiles`.`ID`)

Mysql error: Table 'theoneroom2.Profiles' doesn't exist

Found error in the file '/home/fhlinux140/t/theoneroom.co.uk/user/htdocs/Live7/templates/base/scripts/BxBaseIndexPageView.php' at line 356.
Called 'db_value' function with erroneous argument #0.

I've just moved this site from my home server, which is working to my live host, and now I get this.... I've checked the DB settings and the tables are all present, I uploaded a SQL dump from my live server without issues, but this error stays all the time.

Any ideas everyone?

Anyone seen this b4?

Hello!

Seems during operation script lost connection with DB. Try to increase wait_timeout option in MySQL settings.

Regard

Seems to indicate it can't find the DB, which is weird because all the settings are correct.

This works perfectly on my DEV site, which is on my own server... however my host doesn't.

Lee

Just noticed at the bottom of the debug backtrace the following shows:

Called script: /newsite/index.php

Request parameters:

Array
(
    [__utmz] => 66069611.1257369008.1.1.utmcsr=(direct)|utmccn=(direct)|utmcmd=(none)
    [phpbb3_p3lvg_u] => 1
    [phpbb3_p3lvg_k] => 
    [phpbb3_p3lvg_sid] => 08a5b19a37d8aa5d077901d27dfbc7fd
    [__utma] => 66069611.1437484899.1257369008.1266161947.1266580509.16
    [__utmc] => 66069611

Any ideas anyone?

All sorted guys, incorrectly captialised letter "P" on the profiles table caused all this issue.