Fixing Mysql Database Migration Error where Web Page Dont Display Correctly

View previous topic View next topic 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 : 2195
Join date : 2010-05-09
Age : 34
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 : 2195
Join date : 2010-05-09
Age : 34
Location : UK

http://address-shortner.co.uk

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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