Upgrading from SQL to SQLI
-
Hi friends,
I'm stuck up with an issue, and require your expertise to help resolve it. I'm a creative professional with no coding and programming knowledge. I've three domains, hosted on GoDaddy Servers.Recently, the themes I had purchased required me to upgrade from PHP 5.6 to PHP 7. The moment I did that, my website started throwing up errors, both at frontend and backend. The issue, as identified by GoDaddy support team is that PHP 7 and later versions support SQLI and not SQL. And my 2 year old WordPress website used SQL, and not SQLI. I'm being advised by GoDaddy support team to make changes to WP-Config file. This would help me retain all the content and data, and upgrade the database to SQLi.
The issue is, I don't know how to code, leave alone tweaking wp-config. Is there a workaround that can help me switch the database from SQL to SQLI without coding or programming? I've upgraded to latest version of WordPress, still the issue persists.
If there's no alternate workaround, would humbly request if some support can be extended to tweak the WP-Config file so the database changes from SQL to SQLi. I hope asking for help here doesn't violate the forum policies.
kindly let me know if its fine sharing the code of wp-config.php file for kind perusal of the group members.
-
First, I'm not aware of a version of SQL that's referred to as SQLi. So I searched online for it, and the references seem to largely suggest that SQLi stands for SQL Injection, which for a website, is a bad thing. For GoDaddy in particular, they actually had to patch a bug at some point to prevent a specially crafted SQL command from bypassing their WAF filter. Thus I have to ask what you really mean when you want to convert SQL to SQLi. There doesn't appear to be any reasonable context in which to answer that question. Thus, I'll approach this a different way. What database management software is installed for your website? Is it actually Microsoft's SQL Server? And if so, what version? Or is it MySQL, which is an Oracle product ?
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy) -
You may be able to get some benefit looking here:
https://stackoverflow.com/questions/36777724/cant-connect-to-sql-database-in-godaddy-server
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy) -
Thanks a-lot for the reply. Actually MySQL, PHP, and all these technologies are new to me. I used WordPress as its a DIY platform requiring zero coding knowledge. Just trying my best to share whatever little I could understand from GoDaddy support staff.
Allow me to share few snapshots to explain the issue at hand.
The code in the WP-Config file I'm being advised to tweak to change database from MySQL to MySQLI.
<?php
/**
* The base configuration for WordPress
*
* The wp-config.php creation script uses this file during the
* installation. You don't have to use the web site, you can
* copy this file to "wp-config.php" and fill in the values.
*
* This file contains the following configurations:
*
* * MySQL settings
* * Secret keys
* * Database table prefix
* * ABSPATH
*
* @link https://codex.wordpress.org/Editing_wp-config.php
*
* @package WordPress
*/// ** MySQL settings - You can get this info from your web host ** //
/** The name of the database for WordPress */
define('DB_NAME', 'i2182544_wp2');/** MySQL database username */
define('DB_USER', 'i2182544_wp2');/** MySQL database password */
define('DB_PASSWORD', 'S&HKtgf2KhRiISuKuB(49##2');/** MySQL hostname */
define('DB_HOST', 'localhost');/** Database Charset to use in creating database tables. */
define('DB_CHARSET', 'utf8');/** The Database Collate type. Don't change this if in doubt. */
define('DB_COLLATE', '');/**#@+
* Authentication Unique Keys and Salts.
*
* Change these to different unique phrases!
* You can generate these using the {@link https://api.wordpress.org/secret-key/1.1/salt/ WordPress.org secret-key service}
* You can change these at any point in time to invalidate all existing cookies. This will force all users to have to log in again.
*
* @since 2.6.0
*/
define('AUTH_KEY', '5KJv9fSfwNefFx646CIRtuhJ8v7jtC25GZZBxwmWax9zrHQNXSZ6rYlEVcTNeAqq');
define('SECURE_AUTH_KEY', 'gIao7Df0Am1SiYV8vrNtf05MSXeQ2VZthrLjs6wjuQBXtnVEP74kaiaROTI4nvg7');
define('LOGGED_IN_KEY', 'JDvHrNPo9SwRvbebe6TF8s9138yEPLhrp7Ng9woPjDjnvxQArkecm1QO151HIneY');
define('NONCE_KEY', 'jW2ZcAmYU6nlEamtX0M5PtbZ8KcvrH0R0GLFKFEBtdmKKCLCqQKFrihuoJeN0MxS');
define('AUTH_SALT', 'j2i4sO3xVUrb0Qp3vjGd51IKiy5k1HuJaelMZRFTAoT4hPtnVEbMRIWYrRKq8AjS');
define('SECURE_AUTH_SALT', '6yvLQmJ9qYQtrhulc8cNT8QFJKdnW9pLsU5iWVwHwZa4ZMbxnpUZWwMNxozUDRym');
define('LOGGED_IN_SALT', 'dbzbOXK7OM8u01Q1Np7Bl8IGfzRdp55Iq6wz8flu1752oNWCFS5KZaP7vO2je3Z0');
define('NONCE_SALT', '2oKrpdYXaZlzWS461f6Fio2Kwt9VYwhWJ67BytyZxzp8nFCJ3i02ptN2hHvx5dGE');/**
* Other customizations.
*/
define('FS_METHOD','direct');define('FS_CHMOD_DIR',0755);define('FS_CHMOD_FILE',0644);
define('WP_TEMP_DIR',dirname(__FILE__).'/wp-content/uploads');/**
* Turn off automatic updates since these are managed upstream.
*/
define('AUTOMATIC_UPDATER_DISABLED', true);/**#@-*/
/**
* WordPress Database Table prefix.
*
* You can have multiple installations in one database if you give each
* a unique prefix. Only numbers, letters, and underscores please!
*/
$table_prefix = 'wp_';/**
* For developers: WordPress debugging mode.
*
* Change this to true to enable the display of notices during development.
* It is strongly recommended that plugin and theme developers use WP_DEBUG
* in their development environments.
*
* For information on other constants that can be used for debugging,
* visit the Codex.
*
* @link https://codex.wordpress.org/Debugging_in_WordPress
*/
define('WP_DEBUG', false );
define( 'WP_DEBUG_LOG', true );/* That's all, stop editing! Happy blogging. */
/** Absolute path to the WordPress directory. */
if ( !defined('ABSPATH') )
define('ABSPATH', dirname(__FILE__) . '/');/** Sets up WordPress vars and included files. */
require_once(ABSPATH . 'wp-settings.php'); -
Chances are, either WordPress uses MySQL functions in it's PHP, or you do, and they ALL need to be changed to MySQLi functions. See the following page for what PHP supports:
https://www.w3schools.com/php/php_ref_mysqli.asp
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy) -
Also take a look at this page:
https://stackoverflow.com/questions/34433535/updating-wordpress-to-use-mysqli-instead-of-mysql
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply