#1206 problem withe the table editor on a 4.11 server

[Anonymous]

Originally created by: andreas....@gmail.com

I have copied a table from a MySQL 4.1.22 server to a 5.0.45 server
Almost every modification on a database or a table causes an error
message, even changing the description of a database. The HeidiSQL logs of
the two servers are as follows:
4.1.22
ALTER TABLE `wetterstationen`  COMMENT = '',  COLLATE =
latin1_german1_ci,  CHANGE COLUMN `id` `id` INT(4) NOT NULL DEFAULT '0'
COLLATE NULL FIRST,  CHANGE COLUMN `name` `name` VARCHAR(250) NOT NULL
DEFAULT '' COLLATE latin1_german1_ci AFTER `id` ;

5.0.45
ALTER TABLE `wetterstationen`  COMMENT = '',  COLLATE =
latin1_german1_ci,  CHANGE COLUMN `id` `id` INT(4) NOT NULL DEFAULT '0'
FIRST,  CHANGE COLUMN `name` `name` VARCHAR(250) NOT NULL DEFAULT ''
COLLATE latin1_german1_ci AFTER `id` ;

[Anonymous]

Originally posted by: rosenfie...@gmail.com

What is the error message?

Please use the problem report template, it includes information critical to resolving
the problem such as this.

Status: NeedInfo

[Anonymous]

Originally posted by: a...@anse.de

> even changing the description of a database

Databases cannot have a description in MySQL, guessing you mean tables?

[Anonymous]

Originally posted by: andreas....@gmail.com

Yes, I meant a table description. Trying to change that on a ver4 causes that error
message:
/* SQL Error: You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'NULL
FIRST,  CHANGE COLUMN `typ` `typ` VARCHAR(50) NO */

On the 4.1.22 there is a string "COLLATE NULL FIRST" inside the command wereas in
5.0.45 there is just "FIRST".