Weird Database problem

[shadowman123]

when i Save the Chi Class Value by Inserting Method i get this Error

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 '8,value 9,value 10,value 11) VALUES ('ShallWeDance',1,0,0,0,0)' at line 1

what iam doing wrong to get it ?

regards
shadowman123

[Super Aids]

Post your sql query since that's what's causing it.

[shadowman123]

Saving Void

PHP Code:

public static void Save(Client.GameState client, byte GroupNumber)
{
MySqlCommand cmd = new MySqlCommand(MySqlCommandType.INSERT);
                cmd.Insert("chitable").Insert("Name", client.Entity.Name).Insert("LearnedClasses", GroupNumber++)
                   .Insert("value " + (GroupNumber * 4), client.Chi.ChiValues[GroupNumber * 4])
                   .Insert("value " + ((GroupNumber * 4) + 1), client.Chi.ChiValues[(GroupNumber * 4) + 1])
                   .Insert("value " + ((GroupNumber * 4) + 2), client.Chi.ChiValues[(GroupNumber * 4) + 2])
                   .Insert("value " + ((GroupNumber * 4) + 3), client.Chi.ChiValues[(GroupNumber * 4) + 3])
                   .Execute();
} 


Query

PHP Code:

-- ----------------------------
-- Table structure for `chitable`
-- ----------------------------
DROP TABLE IF EXISTS `chitable`;
CREATE TABLE `chitable` (
  `Name` varchar(80) CHARACTER SET utf8 NOT NULL,
  `LearnedClasses` mediumint(80) NOT NULL DEFAULT '0',
  `Value 0` bigint(80) NOT NULL DEFAULT '0',
  `Value 1` bigint(80) NOT NULL DEFAULT '0',
  `Value 2` bigint(80) NOT NULL DEFAULT '0',
  `Value 3` bigint(80) NOT NULL DEFAULT '0',
  `Value 4` bigint(80) NOT NULL DEFAULT '0',
  `Value 5` bigint(80) NOT NULL DEFAULT '0',
  `Value 6` bigint(80) NOT NULL DEFAULT '0',
  `Value 7` bigint(80) NOT NULL DEFAULT '0',
  `Value 8` bigint(80) NOT NULL DEFAULT '0',
  `Value 9` bigint(80) NOT NULL DEFAULT '0',
  `Value 10` bigint(80) NOT NULL DEFAULT '0',
  `Value 11` bigint(80) NOT NULL DEFAULT '0',
  `Value 12` bigint(80) NOT NULL DEFAULT '0',
  `Value 13` bigint(80) NOT NULL DEFAULT '0',
  `Value 14` bigint(80) NOT NULL DEFAULT '0',
  `Value 15` bigint(80) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1; 


[pro4never]

Your issue is that the sql wrapper you're using doesn't support spaces in field or table names.

Re-name your tables to not contain a space, re-write the sql wrapper or write your own sql system (or use nhibernate <3)

[shadowman123]

After alot of Trial and Error i Discovered that the Problem was .. the MySQL Command doesnt allow inserting at columns that contain numbers in their name

This can be Closed Now

[pro4never]

Unless you have an updated version of the wrapper it also has an issue with spaces in column names.

[shadowman123]

Yea .. to be Honest i havent gone Through Database part ... as i dont got alot of time , havent finished learning C# but Am sure that my database wrapper is bad .. and impulse himself told me that using ORM Database is bad as well as Subsonic System .. NHibernate is the best Ever