Category Archives: MySQL

By October 07, 2019

Error:Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation You need to execute a alter table statement for each table. The statement would follow this form: Now to get all the tables in the database you would need to execute the following query: So now let MySQL write the code for you:


Read More
By April 17, 2013

Full error: Can’t log to error log and syslog at the same time. Remove all –log-error configuration I fixed this error by locating my.cnf config file and commenting out #log_error = /var/log/mysql/error.log  . i let the server log to syslog instead.  


Read More
By April 23, 2012

ever perform a mysql query and the date column returns 1334349567   The number in the database is a “unix time”, aka timestamp – seehttp://en.wikipedia.org/wiki/Unix_time You can convert this to a string using a PHP function like date() http://php.net/date – pass the timestamp as the second parameter. Eg: <?php echo date(‘Y-m-d H:i:s’, 1334349567); ?>; Check out the other


Read More
By November 17, 2011

Full Error: Warning: #1264 Out of range value adjusted for column ‘id’ at row 1 We have a database that was used to store some valuable data. The Id column was set to auto increment when a new record was inserted. After about 127 records we started to get the above error message. come to


Read More
1 2 3 5