проблмы с update mysql

i am having the same issue. I never touch the database manually - so how can I check the collation on the tables?I never deleted or updated anything manually before when upgrading Mantis. Usually the upgrade SW/files provide a script to be run, when things were necessary, or some type of instructions. I didn't really see any this time around, so I did the usually install.php and check.php etc.Thx

Problem fixed:These "bad" collations were zero tables in the database.MySQLAdministrator GUI hadn`t shown them, but using the console (show table status) they got listed.I deleted the zero tables manually in /var/lib/mysql/bugtracker...now everything is fine.Thanks,Torsten

Posts: 427Joined: Nov 25, 2007 3:05 amLocation: Kaliningrad, RF

Hi,thanks for your help.I checked all tables in MySQL Administrator and all have the same collation asyou can see in this screenshot: Is this collation the right one?Best regardsTorsten

Posts: 427Joined: Nov 25, 2007 3:05 amLocation: Kaliningrad, RF

Collation of some tables are incorrect. Check see collation each of table.

Hello together,i have a problem with updating Mantis from 1.0.6 to 1.2.0.I converted the mysql db to UTF 8 (from latin 1) as describted here , but i still get some errors when i run /admin/check.php...see screenshot here .How to fix them?Server is OpenSuse with Apache 2, MySql and PHP 5.2Thanks for your help!TorstenEdit: If i take a look at one of the "bad" tables like project_table i looks like everything's OK...please take a look

Forums - Mantis Bug Tracker • View topic - Update Mantis: UTF8 Unicode Problem