No error message showed for this issue.
I’m trying to create relation between two tables on my database but after selecting the primary and foreign key, it ask if you want to create the relation, after clicking on Ok, nothing happens.
I assume you’re trying to do this through phpMyAdmin? Because phpMyAdmin tends to be a bit finicky with error handling.
It usually means the relation you’ve configured is not valid, but phpMyAdmin is just not very good at telling you about it.
To fix this, you can configure the relation as before, and let phpMyAdmin generate the corresponding SQL statement for you. Then you can copy that SQL statement, and manually run it through the SQL tab. Then phpMyAdmin should show you a proper error message.
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.