MyBB Community Forums

MyBB Community Forums > Extensions > Plugins > Plugin Support > lots of errors! (MYSQL)
Full Version: lots of errors! (MYSQL)
You're currently viewing a stripped down version of our content. View the full version with proper formatting.

Tom K.

2010-07-13, 08:34 AM
ok, I installed the Ad Randomizer plugin and now I get a hell of a lot of MySQL errors on the index and in threads:
The following warnings occurred:
Warning [2] mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 52 - Line: 437 - File: inc/db_mysql.php PHP 5.3.2 (Linux)
File 	Line 	Function
[PHP] 	  	errorHandler->error
/inc/db_mysql.php 	437 	mysql_result
/inc/plugins/ads.php 	88 	DB_MySQL->fetch_field
[PHP] 	  	ads_globals
/inc/class_plugins.php 	101 	call_user_func_array
/global.php 	96 	pluginSystem->run_hooks
/showthread.php 	21 	require_once
Warning [2] mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 54 - Line: 437 - File: inc/db_mysql.php PHP 5.3.2 (Linux)
File 	Line 	Function
[PHP] 	  	errorHandler->error
/inc/db_mysql.php 	437 	mysql_result
/inc/plugins/ads.php 	96 	DB_MySQL->fetch_field
[PHP] 	  	ads_globals
/inc/class_plugins.php 	101 	call_user_func_array
/global.php 	96 	pluginSystem->run_hooks
/showthread.php 	21 	require_once
Warning [2] mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 54 - Line: 437 - File: inc/db_mysql.php PHP 5.3.2 (Linux)
File 	Line 	Function
[PHP] 	  	errorHandler->error
/inc/db_mysql.php 	437 	mysql_result
/inc/plugins/ads.php 	97 	DB_MySQL->fetch_field
[PHP] 	  	ads_globals
/inc/class_plugins.php 	101 	call_user_func_array
/global.php 	96 	pluginSystem->run_hooks
/showthread.php 	21 	require_once
Warning [2] mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 54 - Line: 437 - File: inc/db_mysql.php PHP 5.3.2 (Linux)
File 	Line 	Function
[PHP] 	  	errorHandler->error
/inc/db_mysql.php 	437 	mysql_result
/inc/plugins/ads.php 	98 	DB_MySQL->fetch_field
[PHP] 	  	ads_globals
/inc/class_plugins.php 	101 	call_user_func_array
/global.php 	96 	pluginSystem->run_hooks
/showthread.php 	21 	require_once
Warning [2] mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 54 - Line: 437 - File: inc/db_mysql.php PHP 5.3.2 (Linux)
File 	Line 	Function
[PHP] 	  	errorHandler->error
/inc/db_mysql.php 	437 	mysql_result
/inc/plugins/ads.php 	99 	DB_MySQL->fetch_field
[PHP] 	  	ads_globals
/inc/class_plugins.php 	101 	call_user_func_array
/global.php 	96 	pluginSystem->run_hooks
/showthread.php 	21 	require_once
Warning [2] mysql_result() [function.mysql-result]: Unable to jump to row 0 on MySQL result index 54 - Line: 437 - File: inc/db_mysql.php PHP 5.3.2 (Linux)
File 	Line 	Function
[PHP] 	  	errorHandler->error
/inc/db_mysql.php 	437 	mysql_result
/inc/plugins/ads.php 	100 	DB_MySQL->fetch_field
[PHP] 	  	ads_globals
/inc/class_plugins.php 	101 	call_user_func_array
/global.php 	96 	pluginSystem->run_hooks
/showthread.php 	21 	require_once
http://dev-network.com
(obviously I have disabled it now Toungue)

Sajuuk

2010-07-13, 01:26 PM
mysql_result() is trying to go to row 0, when no such row exists. Check the code.

Matt

2010-07-13, 05:41 PM
Not the first time this plugin has caused this error.

This is exactly what we want to stop with the 'Trusted Developer' status for plugin authors at some point; people will know which users will always be around and which might suddenly disappear and leave users hanging with broken plugins.

Tom K.

2010-07-15, 08:52 PM
Strange, because i used this on another forum and it was fine Sad
MyBB Community Forums > Extensions > Plugins > Plugin Support > lots of errors! (MYSQL)