SQL Error (1103): Incorrect table name ''

User, date Message
Written by Allineer
2 years ago
Category: HeidiSQL portable
41 posts since Thu, 01 Jul 10 		1. Select table in the VT;
2. Select Data page, view table content;
3. Select Database page and refresh it by pressing F5 button;
4. Return to Data page and try to refresh data by pressing F5 button;
5. See error massage: SQL Error (1103): Incorrect table name ''
Written by Allineer
2 years ago
41 posts since Thu, 01 Jul 10 		Sorry.
Screenshot

Table structure:

CREATE TABLE `rep_triggers` (
`gid` INT(3) UNSIGNED NOT NULL,
`trigger` VARCHAR(50) NOT NULL,
`name` VARCHAR(100) NOT NULL,
`url` VARCHAR(100) NULL DEFAULT NULL,
`mark` INT(1) UNSIGNED NOT NULL DEFAULT '0',
`mark2` INT(1) UNSIGNED NOT NULL DEFAULT '0',
`DTLM` INT(10) UNSIGNED NOT NULL,
PRIMARY KEY (`trigger`)
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM;
Written by Allineer
2 years ago
41 posts since Thu, 01 Jul 10 		Fixed @tm. Thanks.
Written by ansgar
2 years ago
4027 posts since Fri, 07 Apr 06 		what is "@tm"?
Written by Allineer
2 years ago
41 posts since Thu, 01 Jul 10 		"at this moment"
Written by ansgar
2 years ago
4027 posts since Fri, 07 Apr 06 		Ah, thanks for the enlightment. I assume you did update your heidisql.exe to a nighly build which then fixed it, as I recall there was a recent fix for exactly this error.
 

Please login to leave a reply, or register at first.