Title: WordPress database errors in php5.6 error log Last modified: August 30, 2016 --- # WordPress database errors in php5.6 error log * Resolved [philsalt](https://wordpress.org/support/users/philsalt/) * (@philsalt) * [10 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-errors-in-php56-error-log/) * Installed plugin & have the following php errors: * On initial install: ——————- [14-Sep-2015 23:24:02 UTC] WordPress database error Table ‘5aZy8J3nef.fold_wp_xxxredirect_it’ doesn’t exist for query SHOW COLUMNS FROM fold_wp_xxxredirect_it made by activate_plugin, include_once(‘/plugins/cleverwise- redirect-it/index.php’), QM_DB->query * [14-Sep-2015 23:24:02 UTC] WordPress database error Table ‘5aZy8J3nef.fold_wp_xxxredirect_it’ doesn’t exist for query alter table fold_wp_xxxredirect_it ADD ri_link_aliases TEXT NOT NULL made by activate_plugin, include_once(‘/plugins/cleverwise-redirect- it/index.php’), QM_DB->query * Are these 1st two errors due to my prefix fold_wp? * On rebuild redirect process: —————————- [14-Sep-2015 23:46:54 UTC] PHP Warning: Division by zero in /srv/users/serverpilot/apps/shop/public/wp-content/plugins/ cleverwise-redirect-it/ria.php on line 478 * [14-Sep-2015 23:46:54 UTC] WordPress database error You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ” at line 1 for query SELECT ri_link_id,ri_link_name FROM fold_wp_1Sa9y5redirect_it where (ri_link_name like “%feeds%” or ri_link_url like “%feeds%” or ri_link_notes like “%feeds%” or ri_link_aliases like “%feeds%”) order by ri_link_name limit 0, made by do_action(‘toplevel_page_cw-redirect-it’), call_user_func_array, cw_redirect_it_aside, QM_DB->query * After clicking Build Redirect File permissions problems are displayed. * redirectit.php is located in * /srv/users/serverpilot/apps/shop/public/redirectit.php * with permissions 777. I guess this relates to incorrect install because of database errors above. * Thanks in advance, * [https://wordpress.org/plugins/cleverwise-redirect-it/](https://wordpress.org/plugins/cleverwise-redirect-it/) Viewing 5 replies - 1 through 5 (of 5 total) * Plugin Author [Me](https://wordpress.org/support/users/cyberws/) * (@cyberws) * [10 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-errors-in-php56-error-log/#post-6546118) * There is something odd about the messages you have posted. The system is saying it can’t find the “5aZy8J3nef.fold_wp_xxxredirect_it” and “fold_wp_1Sa9y5redirect_it” tables. * If your prefix is “fold_wp” those should both read “fold_wpredirect_it” not “ 5aZy8J3nef.fold_wp_xxxredirect_it” and “fold_wp_1Sa9y5redirect_it”. * I am unsure sure why your WP install is trying to find two different table names, but that would explain the error. * Do you know how to view the tables in your database? If so look and see if “fold_wpredirect_it” exists. * Thread Starter [philsalt](https://wordpress.org/support/users/philsalt/) * (@philsalt) * [10 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-errors-in-php56-error-log/#post-6546140) * Hi Jeremy, * Table fold_wp_1Sa9y5redirect_it exists via phpMyAdmin. * 1. I changed file permissions for redirectit.php to 755 * 2. Looked at the settings page & URL To Redirect File looked odd, it was showing [http:///https:shop.suttoncoldfieldhypnotherapyclinic.com](https://wordpress.org/support/topic/wordpress-database-errors-in-php56-error-log/?output_format=md). Re-entered as //https:shop.suttoncoldfieldhypnotherapyclinic.com. Can’t enter// https:shop.suttoncoldfieldhypnotherapyclinic.com without recreating [http:///https:shop.suttoncoldfieldhypnotherapyclinic.com](https://wordpress.org/support/topic/wordpress-database-errors-in-php56-error-log/?output_format=md) * [http://snag.gy/n1JbI.jpg](http://snag.gy/n1JbI.jpg) * redirectit.php is now being written to & log errors have disappeared. * Cheers * Plugin Author [Me](https://wordpress.org/support/users/cyberws/) * (@cyberws) * [10 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-errors-in-php56-error-log/#post-6546157) * If the table is named with “fold_wp_1Sa9y5” then your prefix must be that instead of just “fold_wp”. If it is working at any rate. * As for the second item delete all the information in that box and enter: * [https://shop.suttoncoldfieldhypnotherapyclinic.com](https://shop.suttoncoldfieldhypnotherapyclinic.com) * Thread Starter [philsalt](https://wordpress.org/support/users/philsalt/) * (@philsalt) * [10 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-errors-in-php56-error-log/#post-6546161) * Meant to say above that when [https://shop.suttoncoldfieldhypnotherapyclinic.com](https://shop.suttoncoldfieldhypnotherapyclinic.com) is entered in “URL To Redirect File” box [http:///https:shop.suttoncoldfieldhypnotherapyclinic.com](https://wordpress.org/support/topic/wordpress-database-errors-in-php56-error-log/?output_format=md) is produced. * Entering //:shop.suttoncoldfieldhypnotherapyclinic.com creates [http://shop.suttoncoldfieldhypnotherapyclinic.com](http://shop.suttoncoldfieldhypnotherapyclinic.com). Not a problem as site redirects to https. * Thank you for your assistance. * Plugin Author [Me](https://wordpress.org/support/users/cyberws/) * (@cyberws) * [10 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-errors-in-php56-error-log/#post-6546162) * You are right. I need to change that! * I am slowly switching all sites at my company to https and I don’t like that behavior. * Great catch! I will alter that behavior this week and release a new version. * SSL everywhere! Viewing 5 replies - 1 through 5 (of 5 total) The topic ‘WordPress database errors in php5.6 error log’ is closed to new replies. * ![](https://s.w.org/plugins/geopattern-icon/cleverwise-redirect-it.svg) * [Cleverwise Redirect It](https://wordpress.org/plugins/cleverwise-redirect-it/) * [Frequently Asked Questions](https://wordpress.org/plugins/cleverwise-redirect-it/#faq) * [Support Threads](https://wordpress.org/support/plugin/cleverwise-redirect-it/) * [Active Topics](https://wordpress.org/support/plugin/cleverwise-redirect-it/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/cleverwise-redirect-it/unresolved/) * [Reviews](https://wordpress.org/support/plugin/cleverwise-redirect-it/reviews/) ## Tags * [redirect plugin](https://wordpress.org/support/topic-tag/redirect-plugin/) * 5 replies * 2 participants * Last reply from: [Me](https://wordpress.org/support/users/cyberws/) * Last activity: [10 years, 8 months ago](https://wordpress.org/support/topic/wordpress-database-errors-in-php56-error-log/#post-6546162) * Status: resolved