|
Brian - 2019-09-13 21:17:06
Ok, I'm migrating over to a new server that has php 7. I'm trying to setup the MySQL to MySQLi, but having some issues.
1) I've uploaded the 2 files mysql2i.class.php and mysql2i.func.php into a folder called Connections.
2) I've added the appropriate connection info to the top of the page <?php include_once('Connections/mysql2i.class.php');?>
3) I deleted the original MySQL connection info and I'm getting the page to show up now, but with errors.
Please see jswalls.com/index2.php for reference.
I'm at a lose at what I'm missing....but I know it has to be something. Any help would be greatly appreciated. I need to have this completed by Sunday at the latest, as the old server is End of Life and being wiped.
Dave Smith - 2019-09-13 21:56:44 - In reply to message 1 from Brian
You need your original connection file, include the mysql2i class at the top of that original file after the line that starts php ( either <?php or <? ).
Dave
Brian - 2019-09-15 15:20:05 - In reply to message 2 from Dave Smith
Tried that, but still nothing. Actually getting an 500 error now, with no website showing.
This is what I have at the stop of the page.
<?php ini_set('error_reporting', E_ALL);
ini_set('display_errors', 'On'); //On or Off ?>
<?php include_once('Connections/mysql2i.class.php');?>
<?php require_once('Connections/MainConnection.php')?>
Brian - 2019-09-15 15:30:18 - In reply to message 2 from Dave Smith
This is the actual error I'm seeing, not the 500 now
Warning: mysqli_connect(): (HY000/1045): Access denied for user 'jswalls'@'localhost' (using password: YES) in /home/jswalls/public_html/Connections/mysql2i.class.php on line 395
Warning: mysqli_error() expects parameter 1 to be mysqli, boolean given in /home/jswalls/public_html/Connections/mysql2i.class.php on line 397
Warning: mysqli_error() expects parameter 1 to be mysqli, boolean given in /home/jswalls/public_html/Connections/mysql2i.class.php on line 136
Fatal error: in /home/jswalls/public_html/Connections/MainConnection.php on line 9
Dave Smith - 2019-09-24 20:12:31 - In reply to message 4 from Brian
Sorry for the delay, I didn't get any notifications that there where replies...
That error is indicating that the credentials are wrong. If you would like me to take a look at your site, contact me through email... dave at wagontrader dot com
Dave
|