Fehler im Insert Befehl

[locc]

Hallo,

ich bekommen den Fehler

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 ' 1, 'erster bug', 1258126626, 1258126626, 1, 'Blabla Schalala', 1, 3, 2, 1, 'geh' at line 1

Wenn ich versuche folgenden Insert Befehl:

INSERT INTO thebuggenie.tbg3_issues (issue_no, title, posted, last_updated, project_id, long_description, state, posted_by, owned_by, assigned_to, reproduction, resolution, issue_type, status, priority, category, severity, reproducability, scrumcolor, estimated_months, estimated_weeks, estimated_days, estimated_hours, estimated_points, spent_months, spent_weeks, spent_days, spent_hours, spent_points, percent_complete, assigned_type, owned_type, duplicate, deleted, blocking, locked, user_working_on, user_worked_on_since, milestone, scope)

VALUES (1, 'erster bug', 1258126626, 1258126626, 1, 'Blabla Schalala', 1, 3, 2, 1, 'geht nicht',2,2,2,2,2,2,2,'#FFFFFF', 2,2,2,2, 0.5, 1,1,1,1, 0.5, 50, 2,2, 0,0,0,0, 1, 1258126626, 0,1);

In folgende Tabelle einzutragen:

CREATE TABLE `tbg3_issues` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `issue_no` int(11) DEFAULT '0',
  `title` varchar(200) DEFAULT NULL,
  `posted` int(11) DEFAULT '0',
  `last_updated` int(11) DEFAULT '0',
  `project_id` int(10) unsigned DEFAULT '0',
  `long_description` text,
  `state` tinyint(1) DEFAULT '0',
  `posted_by` int(10) unsigned DEFAULT '0',
  `owned_by` int(11) DEFAULT '0',
  `assigned_to` int(11) DEFAULT '0',
  `reproduction` text,
  `resolution` int(10) unsigned DEFAULT '0',
  `issue_type` int(10) unsigned DEFAULT '0',
  `status` int(10) unsigned DEFAULT '0',
  `priority` int(10) unsigned DEFAULT '0',
  `category` int(10) unsigned DEFAULT '0',
  `severity` int(10) unsigned DEFAULT '0',
  `reproducability` int(10) unsigned DEFAULT '0',
  `scrumcolor` varchar(7) DEFAULT '#FFFFFF',
  `estimated_months` int(11) DEFAULT '0',
  `estimated_weeks` int(11) DEFAULT '0',
  `estimated_days` int(11) DEFAULT '0',
  `estimated_hours` int(11) DEFAULT '0',
  `estimated_points` float DEFAULT '0',
  `spent_months` int(11) DEFAULT '0',
  `spent_weeks` int(11) DEFAULT '0',
  `spent_days` int(11) DEFAULT '0',
  `spent_hours` int(11) DEFAULT '0',
  `spent_points` float DEFAULT '0',
  `percent_complete` int(11) DEFAULT '0',
  `assigned_type` int(11) DEFAULT '0',
  `owned_type` int(11) DEFAULT '0',
  `duplicate` tinyint(1) DEFAULT '0',
  `deleted` tinyint(1) DEFAULT '0',
  `blocking` tinyint(1) DEFAULT '0',
  `locked` tinyint(1) DEFAULT '0',
  `user_working_on` int(10) unsigned DEFAULT '0',
  `user_worked_on_since` int(11) DEFAULT '0',
  `milestone` int(10) unsigned DEFAULT '0',
  `scope` int(10) unsigned DEFAULT '0',
   PRIMARY KEY (`id`)
   )

Ich bin langsam wirklich am verzweifeln, kann mir jemand sagen wo das Problem liegt?

[locc]

Ok, ich benötige keine Hilfe mehr. Es hat genügt einfach eine ID mitzugeben...

CLOSED