4 comments

Add a comment…

Sign in

prestine

Your email address

Check!

invalid email

(thinking…)

Reset

or sign in with

• 
• 

UserVoice password

Forgot password?

Create a password

Your name

I agree to the terms of service

Signed in as (Sign out)

Close

Close

Post comment Submitting...

• Ye Yu commented  ·  March 11, 2013 10:29 a.m.  ·  Flag as inappropriateFlag as inappropriate  ·  Delete

  could you share the database script which cause error?

• alexei commented  ·  March 5, 2013 11:25 p.m.  ·  Flag as inappropriateFlag as inappropriate  ·  Delete

  Hi, thanks for your reply
  No, i created database in phpmyadmin or directly in mysql cmd
  So database created and im trying to create new table
  In other apps i can, but through webmatrix im getting this error

• Alexei Kositsin commented  ·  March 4, 2013 5:54 a.m.  ·  Flag as inappropriateFlag as inappropriate  ·  Delete

  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 'database.`test` (`Name` varchar(50) NULL)' at line 1

  MySql.Data.MySqlClient.MySqlException (0x80004005): 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 'database.`test` (`Name` varchar(50) NULL)' at line 1
  at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
  at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
  at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int64& insertedId)
  at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
  at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
  at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
  at Microsoft.WebMatrix.DatabaseManager.MySqlDatabase.MySqlDatabaseProvider.CreateTable(DbConnection connection, DbTransaction transaction, String schema, TableInfo tableInfo)
  at Microsoft.WebMatrix.DatabaseManager.MySqlDatabase.MySqlDatabaseProvider.CreateTable(String connectionString, String schema, TableInfo tableInfo)
  at Microsoft.WebMatrix.DatabaseManager.IisDbManagerModuleService.CreateTable(DatabaseConnection databaseConnection, String schema, Object tableInfoData, String configPathState)
  at Microsoft.WebMatrix.DatabaseManager.Client.ClientConnection.CreateTable(String schema, Object tableInfoData)
  at Microsoft.WebMatrix.DatabaseManager.Client.ClientTable.CommitChanges()
  at Microsoft.WebMatrix.DatabaseManager.Client.TableDesignerViewModel.PerformSave()

  This error i'm getting!

• Ye Yu commented  ·  February 28, 2013 2:20 p.m.  ·  Flag as inappropriateFlag as inappropriate  ·  Delete

  where did you see the error dialog? do you mean you create an empty mysql database fail?