PhpMyAdmin: Cannot create a Relational Database

[sprash25]

Hello!

I am trying to create a relational database using PhpMyAdmin 2.3.2.

I am getting the following error:

PMA Database ... OK

relation Table ... not OK [ Documentation ]
General relation features: Disabled

FindArt is my Database, which has 2 tables - Artist & Customer

I did check the documentation, and performed the following steps :

1. Created the PMA Database

2. Set the following in 3 locations of in the config.inc.php:
   $cfg['Servers'][$i]['pmadb'] = 'FindArt'

3. Created the PMA_relation
   in my database, i.e. in FindArt

4 Set the following in 3 locations of in the config.inc.php:
$cfg['Servers'][$i]['relation'] = 'PMA_relation'

... and I still cannot get the relational stuff working!! 😕

Spent 5 hours, no luck! any clues?

Thanks in advance!
Sprash

[Sul]

Hi

I'm having similar problems...I did the same as you in the config script. And the problem I'm having is that I can't create a record in the master table with phpmyadmin...are you having the same SQL error?

Please help... someone!!

--using phpmyadmin version 2.5.5-pl1 (currently latest stable release)