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 – see You can convert this to a string using a PHP function like date() – pass the timestamp as the second parameter. Eg: ; Check out the other related functions at

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