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:
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.
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: ; Check out the other related functions at http://php.net/manual/en/ref.datetime.php
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
