Ошибка incorrect table name

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 »

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;

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?

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?

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

Got it. Thank you again. Everything seems to be working great now. Couldn’t have done it without your help. Many thanks!

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 ‘

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.

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