Creating New Table By SQL Fails

[Former user]

Originally reported on Google Code with ID 38 ```

What steps will reproduce the problem?

1. Click your database name on the left sidebar. 2. Click SQL tab. 3. Paste in something like this:

CREATE TABLE IF NOT EXISTS `product` ( `serial` TEXT PRIMARY KEY, `prodname` TEXT NOT NULL );

4. Click Go. 5. You'll get an error: "There is a problem with the syntax of your query (Query was not executed)". 6. Click the Go button again. Goes through just fine.

What is the expected output?

No error.

What do you see instead?

Error.

What version of the product are you using?

1.8.6

On what operating system?

• Ubuntu 10.04.2 LTS

• PHP 5.3.2-1ubuntu4.9 with Suhosin-Patch (cli) (built: May 3 2011 00:43:34) Copyright (c) 1997-2009 The PHP Group Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies with the ionCube PHP Loader v4.0.8, Copyright (c) 2002-2011, by ionCube Ltd.

• PDO

• SQLite3

```

Reported by `volomike` on 2011-06-09 09:29:14

[Former user]

``` Yeah, I confirm this bug ```

Reported by `owl.brainworker` on 2011-06-09 20:38:31

[Former user]

``` Yep, it is same for me. ```

Reported by `oguzcang` on 2011-10-31 21:55:05

[Christopher Kramer]

``` - I could reproduce this bug in phpliteadmin 1.8.6 The error messages is wrong, the query is executed correctly. You do not have to run the query again, simply choose some table or something and you'll see that the table is being created. - I could not reproduce this issue in 1.9.2 or the current version from SVN. So this bug has already been fixed.

-> I'm marking it as fixed.

Please comment on this issue again if you still see it in at least version 1.9.2. ```

Reported by `crazy4chrissi` on 2012-10-07 23:34:18 - Status changed: `Fixed`