Home | Webstore
Latest News: OOTP Update 20.5.47 - OOTP 20 Available - FHM 5 Available

SUMMER SALE - OOTP and FHM are 50% off!

  

Go Back   OOTP Developments Forums > Out of the Park Baseball 20 > OOTP Mods > OOTP Mods - Database Tools

OOTP Mods - Database Tools Do you need to take a dump? SQL gurus welcome

Reply
 
Thread Tools
Old 05-23-2017, 07:53 PM   #1
almo
Major Leagues
 
Join Date: Jul 2002
Location: Albany, NY
Posts: 346
Thanks: 3
Thanked 4x in 4 posts
Statslab for OOTP 18 SQL Error

I have been running an online league since OOTP 12 and have had Statslab set up for all of the iterations up to OOTP 16. We skipped version 17 and are in the process of updating to 18. I tried to update the "dbopen.php" file. which appears slightly different in context vs the previous versions of the file. Example:

Old verison I updated with 12-16

<?php
$db = mysql_connect('localhost','fanatic_stats13','yfs~I eUZVJ8%') or die('Could not connect: '.mysql_error());
mysql_select_db('fanatic_StatsLab13');
?>

Dont worry I changed the password so that its diff

New Version with 18:

<?php
$sqlhost = 'sqlhost.domain.com';
$sqluser = 'sqluser';
$sqlpass = 'sqlpassword';
$sqldb = 'sqldb';

##### DO NOT EDIT BELOW THIS LINE #####
$db = mysql_connect($sqlhost,$sqluser,$sqlpass) or die('Could not connect: '.mysql_error());
mysql_select_db($sqldb);

?>

So my question is this....The first line 'sqlhost.domain.com'....is that not
'localhost' anymore? Ive tried:

'localhost'
'localhost.fanaticbaseball.com'

In either of those cases...I get the following errors.



Warning: mysqli_query() expects parameter 1 to be mysqli, resource given in /home/fanatic/public_html/StatsLab/StatsLab/session_functions.php on line 117

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /home/fanatic/public_html/StatsLab/StatsLab/session_functions.php on line 118

Warning: mysqli_close() expects parameter 1 to be mysqli, resource given in /home/fanatic/public_html/StatsLab/StatsLab/session_functions.php on line 129

Warning: mysqli_query() expects parameter 1 to be mysqli, resource given in /home/fanatic/public_html/StatsLab/StatsLab/session_functions.php on line 149

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /home/fanatic/public_html/StatsLab/StatsLab/session_functions.php on line 150

Warning: mysqli_close() expects parameter 1 to be mysqli, resource given in /home/fanatic/public_html/StatsLab/StatsLab/session_functions.php on line 318

Warning: Cannot modify header information - headers already sent by (output started at /home/fanatic/public_html/StatsLab/StatsLab/session_functions.php:74) in /home/fanatic/public_html/StatsLab/StatsLab/session_functions.php on line 341

Warning: mysqli_query() expects parameter 1 to be mysqli, resource given in /home/fanatic/public_html/StatsLab/StatsLab/nav_functions.php on line 838

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /home/fanatic/public_html/StatsLab/StatsLab/nav_functions.php on line 839

Warning: mysqli_close() expects parameter 1 to be mysqli, resource given in /home/fanatic/public_html/StatsLab/StatsLab/nav_functions.php on line 857

Warning: mysqli_real_escape_string() expects parameter 1 to be mysqli, resource given in /home/fanatic/public_html/StatsLab/StatsLab/session_functions.php on line 224

Warning: mysqli_query() expects parameter 1 to be mysqli, resource given in /home/fanatic/public_html/StatsLab/StatsLab/session_functions.php on line 228

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /home/fanatic/public_html/StatsLab/StatsLab/session_functions.php on line 229

Warning: mysqli_close() expects parameter 1 to be mysqli, resource given in /home/fanatic/public_html/StatsLab/StatsLab/session_functions.php on line 318

Warning: Cannot modify header information - headers already sent by (output started at /home/fanatic/public_html/StatsLab/StatsLab/session_functions.php:74) in /home/fanatic/public_html/StatsLab/StatsLab/session_functions.php on line 341

ERROR: OOTP SQL Utilities not configured properly (no ootp_sql_admin table)

Warning: mysqli_query() expects parameter 1 to be mysqli, resource given in /home/fanatic/public_html/StatsLab/StatsLab/html_functions.php on line 100

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /home/fanatic/public_html/StatsLab/StatsLab/html_functions.php on line 101
05-23-2017

BNN Index Scores Standings Stats Teams Players Transactions History


StatsLab Login

Warning: mysqli_close() expects parameter 1 to be mysqli, resource given in /home/fanatic/public_html/StatsLab/StatsLab/html_functions.php on line 188

Warning: mysqli_query() expects parameter 1 to be mysqli, resource given in /home/fanatic/public_html/StatsLab/StatsLab/nav_functions.php on line 370

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /home/fanatic/public_html/StatsLab/StatsLab/nav_functions.php on line 371

Warning: mysqli_close() expects parameter 1 to be mysqli, resource given in /home/fanatic/public_html/StatsLab/StatsLab/nav_functions.php on line 380

Warning: mysqli_query() expects parameter 1 to be mysqli, resource given in /home/fanatic/public_html/StatsLab/StatsLab/nav_functions.php on line 678

Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /home/fanatic/public_html/StatsLab/StatsLab/nav_functions.php on line 679

Warning: mysqli_close() expects parameter 1 to be mysqli, resource given in /home/fanatic/public_html/StatsLab/StatsLab/nav_functions.php on line 712


Warning: mysqli_num_rows() expects parameter 1 to be mysqli_result, null given in /home/fanatic/public_html/StatsLab/StatsLab/nav_functions.php on line 765


Warning: mysqli_close() expects parameter 1 to be mysqli, resource given in /home/fanatic/public_html/StatsLab/StatsLab/login.php on line 211

StatsLab SQL Utilities for OOTP18 v.3.18.01
Tuesday, May 23rd, 2017

Anytips will help. I mean I can always try an recreate the SQL database.
almo is offline   Reply With Quote
Old 05-24-2017, 04:28 PM   #2
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,457
Thanks: 165
Thanked 1,174x in 441 posts
You will need to update dbopen.php with the OOTP18 version. If you notice, the dbopen.php you posted is using mysql_connect. The new version should have mysqli_connect in it.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues
Baseball Cards - Full list of known templates and documentation on card development.
fhomess is offline   Reply With Quote
Old 05-26-2017, 02:15 AM   #3
almo
Major Leagues
 
Join Date: Jul 2002
Location: Albany, NY
Posts: 346
Thanks: 3
Thanked 4x in 4 posts
I did change the dbopen file...same situation with the same errors. not sure what else to do. Ill try to reinstall from scratch i guess.
almo is offline   Reply With Quote
Old 05-26-2017, 02:35 AM   #4
fhomess
Hall Of Famer
 
fhomess's Avatar
 
Join Date: Nov 2002
Posts: 3,457
Thanks: 165
Thanked 1,174x in 441 posts
Quote:
Originally Posted by almo View Post
I did change the dbopen file...same situation with the same errors. not sure what else to do. Ill try to reinstall from scratch i guess.
I'd be happy to take a look personally if needed. Just shoot me a PM.
__________________
StatsLab- PHP/MySQL based utilities for Online Leagues
Baseball Cards - Full list of known templates and documentation on card development.
fhomess is offline   Reply With Quote
Thank you for this post:
almo (06-02-2017)
Old 06-02-2017, 10:52 PM   #5
almo
Major Leagues
 
Join Date: Jul 2002
Location: Albany, NY
Posts: 346
Thanks: 3
Thanked 4x in 4 posts
I really have to thank fhomess for his help. He is second to none and a class act!! I cant say enough good things about him and look up to him as a resource.

Thanks again man!

Chris
FBL - Fanatic Baseball League
almo is offline   Reply With Quote
Thank you for this post:
Max Boyer (04-08-2018)
Reply

Bookmarks

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 08:40 PM.

 

Major League Baseball trademarks and copyrights are used with permission of MLB Advanced Media, L.P. Minor League Baseball trademarks and copyrights are used with the permission of Minor League Baseball. All rights reserved.

The Major League Baseball Players Association (www.MLBPLAYERS.com ) is the collective bargaining representative for all professional baseball players of the thirty Major League Baseball teams and serves as the exclusive group licensing agent for commercial and licensing activities involving active Major League baseball players. On behalf of its members, it operates the Players Choice licensing program and the Players Choice Awards, which benefit the needy through the Major League Baseball Players Trust, a charitable foundation established and run entirely by Major League baseball players. Follow: @MLB_Players; @MLBPAClubhouse; @MLBPlayersTrust

Out of the Park Baseball is a registered trademark of Out of the Park Developments GmbH & Co. KG

Google Play is a trademark of Google Inc.

Apple, iPhone, iPod touch and iPad are trademarks of Apple Inc., registered in the U.S. and other countries.

COPYRIGHT © 2017 OUT OF THE PARK DEVELOPMENTS. ALL RIGHTS RESERVED.

 

Powered by vBulletin® Version 3.8.10
Copyright ©2000 - 2019, vBulletin Solutions, Inc.
Copyright © 2018 Out of the Park Developments