Table doesn't exist anymore

[Lord Zedd]

Hello,

I am looking for some help. I'll try to explain my situation. I was able to establish a succesfull bridge between Joomla 1.012 and Vbulletin 3.6.0. No problems at all. The login worked fine.
Three days ago I decided to upgrade Joomla to 1.5 stable version. It was succesfull. But because of that the login from vbulletin doesn't not work now anymore. Now no member can log in anymore. What can I do about that? I don't get any help from the Joomla community or where I bought the bridge from. So I really hope anyone of you can help me out please? It says the table users doesnt' exist and it is right. The migration from Joomla 1.0 to 1.5 was succesfull. It even transfered the members. I also have a database backup from a little while back. Any help is much appreciated.

Database error in vBulletin 3.6.0:

Invalid SQL:
SELECT * FROM users
WHERE LOWER(username)='anubis'
LIMIT 1;

MySQL Error : Table 'stargate.users' doesn't exist
Error Number : 1146
Date : Sunday, February 3rd 2008 @ 09:42:38 PM
Script : http://www.XXXXXX.com/forum/login.php?do=login
Referrer : http://www.XXXXXX.com/forum/admincp/index.php
IP Address :
Username : Anubis
Classname : vb_database

[nexialys]

you need to know the TABLE_PREFIX in your installation to be able to connect to that table... it is not deleted, it is just not identicated properly.

[Lynne]

Are you sure that query is correct? vbulletin has a "user" table, but not a "users" table. Maybe change that query to say "user" and not "users".

(If you do have a "users" table also, then disregard my post. I actually do have both because I have a tracker integrated into my site and it uses a "users" table.)

[nexialys]

actually, this query comes from the Joomla integration...