Fatal error with mysqli

You get the error when you create an account in vBulletin, Drupal, or both?

Check you database configurations. "alexrpa_vbulletin.system" means it is looking in your vBulletin database for the table system which doesn't exist because system is a table in the Drupal database. So to put it straight, it's looking in the wrong database.

Post you config files up and we can see if you made a mistake. Of course erase your password before posting it ;-)

Just to double check, you did copy your vBulletin config file to the Drupal vB folder, correct?

That file you attached looks fine btw

Well I actually haven't developed Drupal vB at all, so I'm not an expert on it. I will look through the code again to see what would cause the issue you are having, and let you know what I find ;-)

What version of vBulletin are you using? I'm fairly certain this is being caused by vBulletin at this point.

Here, replace your files with these two just temporarily. Probably best to rename your old ones by adding ".bak" after .php in the file name so you can just rename them when you are done and not screw up anything.

Once you replace the files, clear your browsers cache, cookies, all that crap. Make sure there are NO cookies stored. Then restart your browser. Try to make an account. Once you do it once, log back in and look in the logs. You should see a bunch of message from drupalvb. Post me the messages it put in the logs for drupalvb.

http://stealth17.com/hosting/files/1/drupalvb_files.zip

So with the new files it didn't throw ANY messages that say "Got to point x?"

Is your site on a sub domain, or different domain?

It is mysqlI !

Warning: Table 'vbulletin.system' doesn't exist query: SELECT * FROM system WHERE type = 'theme' in D:\User\Constantine\My Documents\_Sites\localhost\drupal\includes\database.mysqli.inc on line 151

this error message just only appear in use mysqli connecting,
use mysql connect is okay!

in vbulletin 3.6.x
the database connecting has two method, mysql and mysqli

I found the drupalvb create new account SQL error is appear in mysqli connect

any idea?

in vbulletin config
$config['Database']['dbtype'] = 'mysqli';

in drupal setting

$db_url['default'] = 'mysqli://twxxx:L5SXw123@localhost/drupal';
$db_url['vbulletin'] = 'mysqli://twonesmall:123@localhost/vbulletin';

then got "SQL error" problem.

then use mysql instead of mysqli
in drupal setting

$db_url['default'] = 'mysql://twxxx:L5SXw123@localhost/drupal';
$db_url['vbulletin'] = 'mysql://twonesmall:123@localhost/vbulletin';

the got NO problem.

heh, I just reproduced the error on my test site and I have no clue why it is happening. I did narrow it down to being something with vB for sure. I changed the vB database name in the Drupal vB config file and the error was still looking in the same vB database. hmmmmm

@Bob445:
Hello,
I noticed mysql8.ixwebhosting.com in your config file, so I'm guessing, you host your Drupal there. If that's true, I could only recommend switching to other hoster as soon as possible. Over 1 year (bye bye to IXWH in January, 2007) I have only bad memories.

I think you don't meet the minimum requirements to run Drupal on IX Web Hosting. Notice the PHP (and MySQL...?) version.

As I remember, you have MySQL 4.0.xx; if you're not concerned about *non-latin* content it could be fine, but if you go elsewhere one day (you will!) and want/use UTF-8, your db dump file (backups) will be almost useless.
Horrible host. Don't fall on their *24/7 live chat support*. After all, they are useless too. They don't fix anything...but you can chat about whatever except your account or problems, anytime :)
You will face numerous MySQL monthly outages which is their ethernal story -> never solved. Also if you don't want mysql goodies, then you'll be very happy with pure HTML pages ;)

Sorry, it's off topic. Consider this note when you test or run your website there.
-- Cheers!

This is because drupalvb executes queries with (hard-coded) mysql_* function calls.
Bad for you, great for me. I already considered to re-factor the vB database integration.

Drupalvb 5.x-2.x implements a completely overhauled database interface to vBulletin now. A development snapshot should be available within the next 12 hours. A first release candidate will follow in the next days, so stay tuned.