Error: 1064

[Ryan Butler]

Hi,

Recently purchased Webyog for MySQL and I cannot create a table inside a database. I keep getting the error code 1064. My SQL syntax looks fine. Perhaps its a versioning issue? The database server is running 3.2 for mySQL.

Appreciate any insight anyone could provide.

Thanks,

[peterlaursen]

We do support MySQL versions from 3.23.x and forward (not the early betas and RC's).

What is the EXACT MySQL version? This SQL:

Code:

select version():

.. will tell

[Ryan Butler]

3.23.58

Thanks for any suggestions.

[peterlaursen]

We should support this.

Now what is the SQLyog version that you are using?

Is it each and every database (in case you have more) where this is a problem?

What happens if you execute this SQL:

Code:

CREATE TABLE `aaaaa` (
`a` bigint(20) default NULL,
`b` bigint(20) default NULL)

You can see the SQL that generates the error in HISTORY tab. Please paste in a simple example that does not work.

[Ryan Butler]

Quote:

Now what is the SQLyog version that you are using?

v5.2 Beta 3

Quote:

Is it each and every database (in case you have more) where this is a problem?

Any table I try to create inside a database has this problem.

If I try and create a simple table with a primary key here's the history tab results:

Code:

/*[8:07:46 AM][ 16 ms]*/ create table `application`.`appTest` ( `applicationID` int (1) NOT NULL AUTO_INCREMENT UNIQUE PRIMARY KEY ( `applicationID`))

This gives me an error every time through the GUI. Ironically enough, I can manually do in the interface and it works fine.

[peterlaursen]

Code:

create table `appTest` ( `applicationID` int (1) NOT NULL AUTO_INCREMENT, PRIMARY KEY ( `applicationID`));

..would be the normal SQL to use. No 'UNIQUE' keyword when 'PRIMARY' keword is used and a COMMA before 'PRIMARY'. I do not remember if there was such issue with this early beta, but please install beta 10! It works here.

[Ryan Butler]

What one do I download from this page to get beta 10?

http://www.webyog.com/en/downloads.php

[peterlaursen]

Just click the link reading 'SQLyog Enterprise 5.2 (BETA) Full' (this links to registered version)

[Ryan Butler]

Thanks for the help, I ended having to go with version 19.

[xlmdxlmd1]

Thanks for all suggestions

[Author]

Posts