Creating New Table By SQL Fails

GoogleCodeExporter commented 9 years ago

> 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

Original issue reported on code.google.com by volom...@gmail.com on 9 Jun 2011 at 9:29

GoogleCodeExporter commented 9 years ago

[deleted comment]

GoogleCodeExporter commented 9 years ago

Yeah, I confirm this bug

Original comment by owl.brai...@gmail.com on 9 Jun 2011 at 8:38

GoogleCodeExporter commented 9 years ago

Yep, it is same for me.

Original comment by oguzc...@gmail.com on 31 Oct 2011 at 9:55

GoogleCodeExporter commented 9 years ago

- 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.

Original comment by crazy4ch...@gmail.com on 7 Oct 2012 at 11:34

Changed state: Fixed

opless / phpliteadmin

Creating New Table By SQL Fails #38