vb.org Archive - Major Additions - ibProArcade

ERROR: Cannot find database <removed>  



    There is a SQL error.

    You can contact the board administrator by clicking here



mySQL query error: SELECT * FROM ahgames_settings



mySQL error: 

mySQL error code: 

Date:

I tried editing the arcade.php to reflect the new mysqli statement,

Code:

$sql_driver = FUNCTIONS_PATH . "dbclass_mysqli.php";

but still does not connect. Am I missing something obvious?

stangger5

10-27-2018 01:15 PM

Did you upload and overwrite admincp/arcade.php and the includes folder files with the new one`s from 2.7.5+?

MarkFL

10-27-2018 02:01 PM

Quote:

Originally Posted by MrZeropage (Post 2597031)

You set vBulletin now to mysqli (config.php) or changed ibProArcade back to mysql?

I think I should read the config.php and use the value from there, to always fit the right database-driver... hmmmm first feature for v2.7.6 :cool:

The best I can tell, that's what you're already doing. It was because I had the config.php file set to "mysql" that the wrong dbclass file was being read. Your product was functioning correctly, it was because I had the wrong value in my config.php file that the problem occurred.

You have the following code in arcade.php:

PHP Code:


		
			
// support for mysqli by MrZeropage

if ((strtolower($config['Database']['dbtype']) == "mysqli") && ($MYSQLI == 1))

{

    $sql_driver = FUNCTIONS_PATH . "dbclass_mysqli.php";

}

That was what led me to check my config.php file, and there I discovered I needed to edit that file to define the db as "mysqli" and once I did everything worked flawlessly.

hirlas

10-27-2018 04:10 PM

Quote:

Originally Posted by stangger5 (Post 2597043)

Did you upload and overwrite admincp/arcade.php and the includes folder files with the new one`s from 2.7.5+?

Brand new install using ibProArcade 2.7.5+.zip

vbulletin 4.2.3
php 5.6

MrZeropage

10-27-2018 05:47 PM

@hirlas:

Quote:

Cannot find database <removed>

This is strange... looks like it does not find the DB itself ?!

Your TABLE_PREFIX seems to be "ah"
Which database-type you defined in /config.php?

For personal support, provide AdminCP-Account and FTP-Access via PM (!) to me, then I take a look and find the problem :)

snakes1100

10-28-2018 01:05 PM

Just updated a working arcade to the latest version on a 4.2.5 board, this has resulted in the same error as hirlas.

ERROR: Cannot find database xxxxxxx

mySQL query error: SELECT arcade_access, p_require FROM usergroup WHERE usergroupid = 1

mySQL error:
mySQL error code:
Date: Sunday 28th 2018f October 2018 02:06:51 PM

snakes1100

10-28-2018 01:33 PM

Flipped a few switches, to give some more insite:

PHP Warning: mysqli_connect(): (HY000/2002): Connection refused in ..../arcade/functions/dbclass_mysqli.php on line 44

PHP Warning: mysqli_select_db() expects parameter 1 to be mysqli, boolean given in ..../arcade/functions/dbclass_mysqli.php on line 48
ERROR: Cannot find database xxxxxxxx
PHP Warning: mysqli_query() expects parameter 1 to be mysqli, boolean given in ..../arcade/functions/dbclass_mysqli.php on line 185

PHP Warning: mysqli_error() expects exactly 1 parameter, 0 given in ..../arcade/functions/dbclass_mysqli.php on line 504

DieselMinded

10-28-2018 01:41 PM

Thanks for the update!

hirlas

10-28-2018 06:47 PM

Quote:

Originally Posted by MrZeropage (Post 2597048)

@hirlas:

This is strange... looks like it does not find the DB itself ?!

Your TABLE_PREFIX seems to be "ah"
Which database-type you defined in /config.php?

For personal support, provide AdminCP-Account and FTP-Access via PM (!) to me, then I take a look and find the problem :)

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

All times are GMT. The time now is 07:20 AM.

Page 749 of 758

749

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.06585 seconds Memory Usage 1,746KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (1)bbcode_php_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (4)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: