Fixing Mysql Database Migration Error where Web Page Dont Display Correctly

Go down

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
avatar
jamied_uk
Admin

Posts : 2320
Join date : 2010-05-09
Age : 35
Location : UK

http://address-shortner.co.uk

Back to top Go down

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

avatar
jamied_uk
Admin

Posts : 2320
Join date : 2010-05-09
Age : 35
Location : UK

http://address-shortner.co.uk

Back to top Go down

Back to top

- Similar topics

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