Public bug reported:
Hi,
I freshly installed apache2, php5 and mysql5 from officials repositories
in my freshly installed Ubuntu 8.10 Intrepid Ibex. Everything was
working fine.
I installed the GUI tools for mysql (mysql-query-browser). I can launche
MySQL Query Browser, execute queries etc.
When I try to create a simple table (or even when I try to edit an existing
one), I do "Create table", I describe my table in the Table Editor and I click
"Apply changes". A popup show me the executing request :
CREATE TABLE `prov`.`test` (
`a` INT NOT NULL AUTO_INCREMENT,
`b` VARCHAR NOT NULL,
`c` VARCHAR NOT NULL,
PRIMARY KEY (`a`)
)
ENGINE = InnoDB;
I then click "Execute" and the following error occurs :
Error executing SQL commands to create table.
MySQL Error Nr. 1064
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 'NOT NULL,
`c` VARCHAR NOT NULL,
PRIMARY KEY (`a`)
)
ENGINE = InnoDB' at line 3
** Affects: mysql-query-browser (Ubuntu)
Importance: Undecided
Status: New
--
MySQL Query Browser is unable to create a table
https://bugs.launchpad.net/bugs/297536
You received this bug notification because you are a member of Ubuntu
Bugs, which is subscribed to Ubuntu.
--
ubuntu-bugs mailing list
ubuntu-bugs@lists.ubuntu.com
https://lists.ubuntu.com/mailman/listinfo/ubuntu-bugs
