Fixing Mysql Database Migration Error where Web Page Dont Display Correctly

Go down

Fixing Mysql Database Migration Error where Web Page Dont Display Correctly Empty Fixing Mysql Database Migration Error where Web Page Dont Display Correctly

Post by jamied_uk on 7th May 2017, 23:21

Fixing Mysql Database Migration Error where Web Page Dont Display Correctly!



Run this in sql query for a temporary fix or add contents below for permanent fix like i recommend!

Code:
SET @@global.sql_mode= 'NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION';



To make this fix permanent:

Code:
sudo gedit /etc/mysql/my.cnf


Code:
!includedir /etc/mysql/conf.d/
!includedir /etc/mysql/mysql.conf.d/
[mysqld]
sql-mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
sql_mode = "NO_ENGINE_SUBSTITUTION"


Restart mysql

Code:
sudo service mysql restart





Notes:

stackoverflow.com/questions/18897420/data-too-long-for-column-why


stackoverflow.com/questions/28849293/how-to-make-sql-mode-no-engine-substitution-permanent-in-mysql-my-cnf
jamied_uk
jamied_uk
Admin

Posts : 2466
Join date : 2010-05-09
Age : 36
Location : UK

http://address-shortner.co.uk

Back to top Go down

Fixing Mysql Database Migration Error where Web Page Dont Display Correctly Empty Re: Fixing Mysql Database Migration Error where Web Page Dont Display Correctly

Post by jamied_uk on 8th May 2017, 15:38

For Linux Apache Web Server Hardening

jamied_uk
jamied_uk
Admin

Posts : 2466
Join date : 2010-05-09
Age : 36
Location : UK

http://address-shortner.co.uk

Back to top Go down

Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum