I'm creating my own customer backend (and started with the provided example
backend) and am getting the following error:
-----
An error was found at 01/14/2005 16:21:56 (1105748516) on line '745' of
script
'/var/www/developer/support/include/customer/class.techsoft_support.php'.
The error message passed to us was' 'DB Error: no such table' A more
detailed error message follows:
'SELECT
usr_email,
usr_password,
usr_full_name
FROM
techsoft.eventum_
WHERE
usr_customer_contact_id = 87 [nativecode=1146 ** Table 'techsoft.eventum_'
doesn't exist]'
-----
The SELECT at line 745 of the customer backend is taking place inside the
'getContactLoginDetails' function, which is appaerntly failing to specificy
the 'usr' table in it's MySQL 'SELECT' command:
function getContactLoginDetails($contact_id)
{
$stmt = "SELECT
usr_email,
usr_password,
usr_full_name
FROM
" . APP_DEFAULT_DB . "." . APP_TABLE_PREFIX . "
the last line apparently should read:
" . APP_DEFAULT_DB . "." . APP_TABLE_PREFIX . "user
Rob
