error 1103

[salgrev]

I have used a mysql data base for long.

I am trying sqlyog.

Connection is ok but I have no way to access the existing tables. I always get error 1103.

A solution ?

Thanks

Niala

[Ritesh]

Can you tell me the complete error message?

When are you getting the error message?

[Shadow]

You obviously use a character that is not allowed in table names ('.', '/'). Perhaps you put the`-characters at wrong places, e.g. select * `mydb.mytable` => incorrect table name (1103). It should be select * from `mytdb`.`mytable`.

[salgrev]

Thanks for your answers.

I get, for example – Error No 1103 Incorrect table name 'biblio' – when I click on any table or any + sign of the list of tables of my database. Here the table is – biblio – No strange or unallowed character is used. This tables are in uses since more than 2 years and evolve every day (about 100 visit per day).

Up to now I have used PhpMyAdmin without trouble, except for its complexity.

Any suggestion is welcome.

Sincerely,

[Shadow]

I thought it was not going to be that simple…

We'll need additional info to be able to help you out. What version of SQLyog and MySql are you running? Could you reproduce the errors a few times more and paste/send the corresponding entries from the history pane to this topic?

[salgrev]

Thanks,

I use version 3.63 (test)of SQLyog

The version of My SQL is defined by my hosting cy http://www.online.fr I do nt know it.

I paste below some history, wher I systematically got error 1103 :

[11:59:46][ 62 ms] use `e-verglas.com`

[11:59:46][ 31 ms] use “

[11:59:49][ 63 ms] show tables from `e-verglas.com`

[11:59:50][ 47 ms] describe `e-verglas.com`.`biblio`

[11:59:55][ 31 ms] show full fields from `e-verglas.com`.`biblio`

[12:00:04][ 62 ms] describe `e-verglas.com`.`lectures`

[12:00:07][ 31 ms] show full fields from `e-verglas.com`.`lectures`

[12:00:09][ 31 ms] show full fields from `e-verglas.com`.`listinfos`

[12:00:11][ 31 ms] describe `e-verglas.com`.`listinfos`

Sincerely

[Shadow]

Well, this explains a lot…

QUOTE

[11:59:50][ 47 ms] describe `e-verglas.com`.`biblio`

Notice the '.' in the db name: `e-verglas.com`.`biblio`. Now, that is not allowed in MySql. It's got nothing to do with SQLyog, your ISP broke the rules laid out by MySql… I can't really explain, why PHPMyAdmin works fine given the circumstances. As if there had been a topic about this issue in this forum… Perhaps, PHPMyAdmin does not issue context commands all the time. You should contact your ISP and ask them to correct the problem!

P.s.: issue a SELECT VERSION(); command from SQLyog, Tools -> Show -> Variables -> Version to obtain the version of the connected MySql server.

[Shadow]

Gotcha! This topic has already dealt with this issue. Unfortunately, it was inconclusive.

Ritesh, you should look at this problem carefully and see if SQLyog can be bended to handle these situations!

[salgrev]

Thanks to all of you for your help.

It is clear that the use of domain name as name of data base creates a problem with the dot in yhe middle.

From previous attempts it seems unlikely that the hosting Cy, Online, will change its policy. They are too cheap…

The other way is you to give a right to this domain name with a dot to become acceptable in your program for a data base name.

I give up for a while, and will check again in the future.

Sincerely.

[Author]

Posts