Column count doesnt match - za delete upitJel ovo neki bug ili sta je reci?
Ovo je rezultat "SHOW CREATE TABLE....":
Code:
CREATE TABLE `eradovi__paper_files` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`paper_id` int(10) NOT NULL,
`lang` varchar(3) CHARACTER SET utf8 NOT NULL,
`fileType` enum('1','2','3','4','5') CHARACTER SET utf8 NOT NULL DEFAULT '1',
`filename` varchar(200) CHARACTER SET utf8 NOT NULL,
`price` decimal(5,2) NOT NULL DEFAULT '0.00',
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`user_id` int(11) NOT NULL,
`notes` text COLLATE utf8_unicode_ci,
PRIMARY KEY (`id`),
KEY `paper_id` (`paper_id`),
KEY `user_id` (`user_id`),
CONSTRAINT `eradovi__paper_files_ibfk_1` FOREIGN KEY (`paper_id`) REFERENCES `eradovi__paper` (`id`),
CONSTRAINT `eradovi__paper_files_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `eradovi__user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1040 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
CREATE TABLE `eradovi__paper_files` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`paper_id` int(10) NOT NULL,
`lang` varchar(3) CHARACTER SET utf8 NOT NULL,
`fileType` enum('1','2','3','4','5') CHARACTER SET utf8 NOT NULL DEFAULT '1',
`filename` varchar(200) CHARACTER SET utf8 NOT NULL,
`price` decimal(5,2) NOT NULL DEFAULT '0.00',
`created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`user_id` int(11) NOT NULL,
`notes` text COLLATE utf8_unicode_ci,
PRIMARY KEY (`id`),
KEY `paper_id` (`paper_id`),
KEY `user_id` (`user_id`),
CONSTRAINT `eradovi__paper_files_ibfk_1` FOREIGN KEY (`paper_id`) REFERENCES `eradovi__paper` (`id`),
CONSTRAINT `eradovi__paper_files_ibfk_2` FOREIGN KEY (`user_id`) REFERENCES `eradovi__user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1040 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
Hvala unaprijed.
