Database Error

[CHIPIT]

Hello.

I'm using vbDrupal 5.2.0 RC 1 and vBulletin 3.6.8

My installation/upgrade history:
-Installed vB 3.6.7PL1 using: database charset: utf8_unicode_ci, with utf8 set in the config.php file and uft-8 encoding set in the default language settings.
-Installed vBdrupal 4.7.7.0
-Upgraded to vB 3.6.8
-Upgraded to vBdrupal 5.2.0 Beta 3
-Upgraded to vBdrupal 5.2.0 RC 1

Whenever vBdrupal cron is run I get the following database error sent to me in an email:

Database error in vBulletin 3.6.8:

Invalid SQL:
SHOW VARIABLES LIKE 'character_set_connection';

MySQL Error :
Error Number :
Date : Wednesday, August 8th 2007 @ 05:39:03 PM
Script : http://www.mysite.com/cron.php
Referrer :
IP Address : 69.36.187.79
Username : Unregistered
Classname : vB_Database_MySQLi


And when I visit the cron page directly, the page looks like this:

Warning: include_once(./includes/database.vbulletin.inc) [function.include-once]: failed to open stream: No such file or directory in /var/www/html/***/home/includes/database.inc on line 118

Warning: include_once() [function.include]: Failed opening './includes/database.vbulletin.inc' for inclusion (include_path='.:/php/includes:/usr/local/lib/php:/usr/local/php/lib/php') in /var/www/html/***/home/includes/database.inc on line 118

Warning: mysqli_query() [function.mysqli-query]: Couldn't fetch mysqli in /var/www/html/***/forums/includes/class_core.php on line 1075

Warning: mysqli_error() [function.mysqli-error]: Couldn't fetch mysqli in /var/www/html/***/forums/includes/class_core.php on line 845

Warning: mysqli_errno() [function.mysqli-errno]: Couldn't fetch mysqli in /var/www/html/***/forums/includes/class_core.php on line 863

...followed by the database error message.

Any idea what could be causing this?

And also, the search function isn't working properly, nothing is getting indexed... I know that new pages get indexed when cron is run... so maybe these issues are related?

Thanks,
~CHIP

[elmuerte]

I think I know what is causing this.
And the end of the cron run, drupal will add a message to the drupal log that the cron has run succesfully, but before the message is added the database connection has been closed (by vBulletin). And this results in some weird side effects causing various other errors.
This only happens when the cron times out (too much to do), in this case first the vBulletin cleanup kicks in, and after that the drupal cron will do some things.

damn shutdown functions

[CHIPIT]

I think I know what is causing this.
And the end of the cron run, drupal will add a message to the drupal log that the cron has run succesfully, but before the message is added the database connection has been closed (by vBulletin). And this results in some weird side effects causing various other errors.
This only happens when the cron times out (too much to do), in this case first the vBulletin cleanup kicks in, and after that the drupal cron will do some things.

damn shutdown functions

So... is this something that will need to be fixed in a future version?
or is this something I will need to fix on my end?

(And by the way: your "forum/images/misc/navbits_finallink_ltr.gif" is missing...)

[elmuerte]

it will be fixed in RC2 which I'm going to release today

[CHIPIT]

Alright, thank you.

[jumper12]

Had same fetch mysqli issue.

Worked around by changing DB type mysqli -> mysql in VB config