Displaying 2 results from an estimated 2 matches for "etikettend_metainfo".
2019 Apr 24
2
mariadb: How to delete foreign key constraint from non-existing table?
Hi,
somehow phpmyadmin messed things up when I was trying to modify a table.
The table disappeared, and now it's impossible to re-create it:
MariaDB [time]> create table etikettend_metainfo (userID integer(6)
unsigned, stationsnummer integer(4) unsigned, primary key (userID));
ERROR 1005 (HY000): Can't create table `time`.`etikettend_metainfo`
(errno: 150 "Foreign key constraint is incorrectly formed")
MariaDB [time]> show tables like 'etikettend%';
+-------...
2019 Apr 24
0
mariadb: How to delete foreign key constraint from non-existing table?
...f6-f49b-988ab125b7f6 at gc-24.de>,
hwilmer <hw at gc-24.de> wrote:
>
> Hi,
>
> somehow phpmyadmin messed things up when I was trying to modify a table.
> The table disappeared, and now it's impossible to re-create it:
>
>
> MariaDB [time]> create table etikettend_metainfo (userID integer(6)
> unsigned, stationsnummer integer(4) unsigned, primary key (userID));
> ERROR 1005 (HY000): Can't create table `time`.`etikettend_metainfo`
> (errno: 150 "Foreign key constraint is incorrectly formed")
> MariaDB [time]> show tables like 'etiket...