[TM] Broken Database

[Pierre SULPICE]

Hello,

I have unusable tables when I do the following process :

• Open an existing table
• Clic on "Create table script" -> Copy the content
• Clic on "New query"
• Paste the script previously copied -> Change the table name (to not create the new one under the same name)
• Execute the query
  The new table is here but can't be opened, so I can't even delete it...

What to do from here ^^" ?

Thanks,
Best regards,

[Wassim]

Hello Pierre,

Just tried to follow your procedure and it worked well for me.
Would you mind to post screenshots or all column details?

Thank you

[Pierre SULPICE]

Hello,

Here is one of the scripts I used with the new table name :
CREATE TABLE PP-MOONAGE_leads (
id int(11) NOT NULL AUTO_INCREMENT COMMENT '::',
visitor_id int(11) DEFAULT NULL COMMENT 'select:MOONAGE_visitors:id',
email varchar(200) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'email::',
pack varchar(12) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '::',
completed tinyint(4) DEFAULT NULL COMMENT '::',
action_time timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '::',
PRIMARY KEY (id)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

The original table looks like this then :

Maybe an issue with the link field ?

Once created if I click on it I have the Databases dashboard (with stats and all):

I now have 4 unusable tables

Thanks,
Best regards,

[Joseph Benguira]

Hey Pierre,

your issue is coming from "-" in table name ... it's a forbidden character with MySQL ...
Internally we do have a trick to be able to use it but it's really not recommended ... you will have to backtick the table name everywhere in your queries because of this...

My advice, follow best pratices a just don't use forbidden characters in your table names

[Pierre SULPICE]

Ooooh ok my bad !

I deleted the 4 tables by query, created a new one the same way, worked flawlessly !

Thanks a lot, my be a good idea to forbid it upfront since the interface can't print it ^^"

See you,

[Daniel Mulroy]

This post is deleted!

[Pierre SULPICE]

@Daniel-Mulroy the generated script is fine, I added manually the '-' when I copy/pasted it in a new query to add a prefix
If you create a table the managed way, it will prevent you to put a '-' altogether.

[Daniel Mulroy]

Oops, I misunderstood!