CiviCRM Community Forums (archive)

Hi,

    I am starting to play with CiviSchool. I have drupal installed already (Acquia version based on Druapal 6.19) (PHP 5.2.14, MySql  5.0.51a). I am following the instructions to load the civischool data as mentioned in the sticky post. But I am getting db error - The table dbname.users does not exist.


Array
(
    [callback] => Array
        (
            \[0] => CRM_Core_Error
            [1] => handle
        )
 

    code] => -18
    [message] => DB Error: no such table
    [mode] => 16
    [debug_info] => SELECT u.* FROM users u WHERE LOWER(u.name) = 'admin' AND u.pass = 'XXXX' AND u.status = 1 [nativecode=1146 ** Table 'dbname.users' doesn't exist]
    [type] => DB_Error
    [user_info] => SELECT u.* FROM users u WHERE LOWER(u.name) = 'admin' AND u.pass = 'XXXX' AND u.status = 1 [nativecode=1146 ** Table 'dbname.users' doesn't exist]
    [to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT u.* FROM users u WHERE LOWER(u.name) = 'admin' AND u.pass = 'XXXX' AND u.status = 1 [nativecode=1146 ** Table 'dbname.users' doesn't exist]"]

I think the db_prefix is somehow not getting handled properly. (It is "acquia_" BTW).

What could be the error ?

Thanks!
Amit

Thanks Kiran. The name of the table should actually be acquia_users. Somehow the code is not using the db_prefix value from drupal settings. I am trying to figure out the place which calls this query. Can you tell me where can I modify the query ?

Thanks Lobo. That seemed to have worked. I didn't have the right tablename set there. The import went okay...

Thanks!
Amit