CMS DB Error with new widget

محروم.كوم · #1 04-30-2010, 11:40 AM

I created a widget which needs a own db connection
so i created a php widget with following code:
[php]require_once DIR .'/userwidget.php';
and the files code is:
PHP Code:
$userdb = new vB_Database(vB::$vbulletin);

// hier die parameter anpassen
$connectiondata = array(
'db' => 'userdatabase',
'server' => 'localhost',
'user' => 'root',
'pw' => ''
);

$userdb->connect($connectiondata['db'], $connectiondata['server'], 3306, $connectiondata['user'], $connectiondata['pw']);
$user = $userdb->query("...");

Error i got:
Quote:
Warning: mysql_query(): 7 is not a valid MySQL-Link resource in C:\Programme\Zend\Apache2\htdocs\vb42\includes\cla ss_core.php on line 412

Warning: mysql_error(): 7 is not a valid MySQL-Link resource in C:\Programme\Zend\Apache2\htdocs\vb42\includes\cla ss_core.php on line 982

Warning: mysql_errno(): 7 is not a valid MySQL-Link resource in C:\Programme\Zend\Apache2\htdocs\vb42\includes\cla ss_core.php on line 1000

Warning: mysql_query(): 7 is not a valid MySQL-Link resource in C:\Programme\Zend\Apache2\htdocs\vb42\includes\cla ss_core.php on line 412

Warning: mysql_error(): 7 is not a valid MySQL-Link resource in C:\Programme\Zend\Apache2\htdocs\vb42\includes\cla ss_core.php on line 982

Warning: mysql_errno(): 7 is not a valid MySQL-Link resource in C:\Programme\Zend\Apache2\htdocs\vb42\includes\cla ss_core.php on line 1000

Database error in vBulletin 4.0.3:

Invalid SQL:

SELECT data, expires, locktime, serialized
FROM cache
WHERE cacheid = 'widget.5a145f78ebc3ea96da4903bc313ea91b';

MySQL Error :
Error Number :
Request Date : Friday, April 30th 2010 @ 0343 PM
Error Date : Friday, April 30th 2010 @ 0343 PM
Script : http://localhost:81/vb42/content.php
Referrer :
IP Address : 127.0.0.1
Username : ragtek
Classname : vB_Database
MySQL Version :

Stack Trace:

#0 vB_Database->halt() called in [path]\includes\class_core.php on line 421
#1 vB_Database->execute_query() called in [path]\includes\class_core.php on line 498
#2 vB_Database->query_first() called in [path]\includes\class_core.php on line 529
#3 vB_Database->query_first_slave() called in [path]\vb\cache\db.php on line 142
#4 vB_Cache_Db->readCache() called in [path]\vb\cache.php on line 364
#5 vB_Cache->read() called in [path]\packages\vbcms\widget\recentcmscomments.php on line 211
#6 vBCms_Widget_RecentCmsComments->getPageView() called in [path]\packages\vbcms\controller\content.php on line 224
#7 vBCms_Controller_Content->actionView() called in on line
#8 call_user_func_array() called in [path]\vb\controller.php on line 185
#9 vB_Controller->getResponse() called in [path]\packages\vbcms\route\content.php on line 92
#10 vBCms_Route_Content->getResponse() called in [path]\vb\router.php on line 248
#11 vB_Router::getResponse() called in [path]\vb\bootstrap.php on line 58
#12 require_once([path]\vb\bootstrap.php) called in [path]\content.php on line 30 __DEFINE_LIKE_SHARE__