SQL Error (1103): Incorrect table name ''

Allineer's profile image Allineer posted 12 years ago in HeidiSQL portable Permalink
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 ''



Allineer's profile image Allineer posted 12 years ago Permalink
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;
Allineer's profile image Allineer posted 12 years ago Permalink
Fixed @tm. Thanks.
ansgar's profile image ansgar posted 12 years ago Permalink
what is "@tm"?
Allineer's profile image Allineer posted 12 years ago Permalink
"at this moment"
ansgar's profile image ansgar posted 12 years ago Permalink
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.
[expired user #8006]'s profile image [expired user #8006] posted 10 years ago Permalink
Hi,

I am having the save problem with "SQL Error (1103): Incorrect table name "

here is what's been triggering the 1103 error code:


SQL query:

CREATE TABLE `admin_pay' (
` pay_id ' bigint(20) NOT NULL auto_increment, `pay_amount'double NOT NULL default '0',
PRIMARY KEY ( `pay_id` ) );

MySQL said: Documentation
#1103 - Incorrect table name 'admin_pay' (


I tried adding the

)
COLLATE='utf8_general_ci'
ENGINE=MyISAM;

to the original SQl.php script like this:

CREATE TABLE `admin_pay' (
`pay_id' bigint(20) NOT NULL auto_increment,
`pay_amount' double NOT NULL default '0',
PRIMARY KEY (`pay_id`)
);

--
-- Dumping data for table `admin_pay`
--

INSERT INTO `admin_pay` VALUES (1, 0);
)
COLLATE='utf8_general_ci'
ENGINE=MyISAM;


but it still returned the same 1103 error code.
Can you offer any suggestions that might help solve this error problem?







ansgar's profile image ansgar posted 10 years ago Permalink
You have the table name enclosed in two different quote chars: backtick and single quote. Only backticks are allowed quote chars in mysql.
[expired user #8006]'s profile image [expired user #8006] posted 10 years ago Permalink
Thank you for bringing that to my attention! Before you mentioned it, I didn't know a "backtick" and a "single quote" were different. Indeed I did add some "single quotes" to the sql.php page because the "backticks" were so faint and hard to see. I had no clue I was effectively messing up the sql.php page by adding those single quotes to it. Excellent call!

However, I have now replaced all the single quotes I had previously changed, and put with "backticks" in their place. But I'm still get the same "1103" error flag.

So, apparently the " SQL Error (1103): Incorrect table name" error flag I'm getting isn't being triggered by the single quotes I had added to the page. But rather, it's being triggered by different problem I haven't been able to locate yet.

Excellent call, though. Thank you so much for pointing that out! Do you have any more ideas I might try?
jfalch's profile image jfalch posted 10 years ago Permalink
when I execute

CREATE TABLE admin_pay (
pay_id bigint(20) NOT NULL auto_increment,
pay_amount double NOT NULL default '0',
PRIMARY KEY (pay_id)
);

it works ok on my system. donĀ“t know why you use all the quotes.
jfalch's profile image jfalch posted 10 years ago Permalink
CREATE TABLE admin_pay (
pay_id bigint(20) NOT NULL auto_increment,
pay_amount double NOT NULL default '0',
PRIMARY KEY (pay_id)
)
COLLATE=utf8_general_ci
ENGINE=MyISAM;

works as well.
[expired user #8006]'s profile image [expired user #8006] posted 10 years ago Permalink
Wow...I am thoroughly hyped now! I got it to work just as you said! Once I replaced all the single quotes with backticks, it works great! Thanks again!

Maybe you can help me with another issue?


-- Table structure for table `affil_heap_sessionid`
--
CREATE TABLE `affil_heap_sessionid` (
`heap_id` bigint( 20 ) NOT NULL default '0',
`heap_name` varchar( 255 ) NOT NULL default '0',
`heap_regdate` datetime NOT NULL default '0000-00-00.00.00',
`heap_approved` bigint( 20 ) NOT NULL default '0',
`heap_pending` bigint( 20 ) NOT NULL default '0',
`heap_paid` bigint( 20 ) NOT NULL default '0',
PRIMARY KEY ( `heap_id` )

I'm getting a syntax error 1064 that states:
Message: %s near '%s' at line %d

ansgar's profile image ansgar posted 10 years ago Permalink
The heap_regdate column has an invalid default value:
Wrong: 0000-00-00.00.00
Right: 0000-00-00 00:00:00
[expired user #8006]'s profile image [expired user #8006] posted 10 years ago Permalink
Got it. Thank you again. Everything seems to be working great now. Couldn't have done it without your help. Many thanks!
[expired user #8894]'s profile image [expired user #8894] posted 9 years ago Permalink
CREATE TABLE `project`.`registration ` (

`name ` VARCHAR( 200 ) NOT NULL ,
`email` VARCHAR( 200 ) NOT NULL ,
`password` VARCHAR( 100 ) NOT NULL ,
`mobile` VARCHAR( 100 ) NOT NULL ,
`dob` VARCHAR( 100 ) NOT NULL ,
`pre_add` VARCHAR( 200 ) NOT NULL ,
`profession` VARCHAR( 200 ) NOT NULL ,
`org` VARCHAR( 200 ) NOT NULL ,
`designation` VARCHAR( 200 ) NOT NULL ,
`passyr` DATE NOT NULL ,
`passgrp` VARCHAR( 100 ) NOT NULL ,
`gender` VARCHAR( 50 ) NOT NULL ,
`m_status` VARCHAR( 50 ) NOT NULL ,
`bloodgrp` VARCHAR( 50 ) NOT NULL ,
`sl` INT( 10 ) NOT NULL AUTO_INCREMENT ,
`par_add` VARCHAR( 200 ) NOT NULL ,
PRIMARY KEY ( `sl` )
) ENGINE = INNODB;

MySQL said: Documentation

#1103 - Incorrect table name 'registration '
BubikolRamios's profile image BubikolRamios posted 8 years ago Permalink

Same problem in previous post, I guess.

CREATE TABLE `tezaver_metaphone ` (
    `term` VARCHAR(400) NOT NULL,
    `metaphone` TEXT NOT NULL
)
COLLATE='utf8_slovenian_ci'
ENGINE=MyISAM
;

/* SQL Error (1103): Incorrect table name 'tezaver_metaphone ' */

Note space after 'tezaver_metaphone ', that could be auto removed by Heidi, I guess.

[expired user #10775]'s profile image [expired user #10775] posted 7 years ago Permalink

I run into this error message using the following workflow. Let me know if this should be a new ticket instead.

SQL Error (1103): Incorrect table name ''

Version: 9.4.0.5174 / MariaDB server Steps to reproduce:

  1. Open any tables data tab
  2. Go back to the tree or database views
  3. Drop that table
  4. Go back to the data tab
  5. Refresh
  6. See this error
  7. Run a script or use a different client to re-create the table
  8. Refresh again

The heidi client is requesting "SELECT * FROM db.`` LIMIT 1000;"

Proposed ideas:

  • Dropping a table should keep the old table name around, and properly tell you dropped_table doesn't exist
  • Have Data tab realize there is no table, so refresh isn't an option

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