PDA

View Full Version : cant get MySQL to add a table?


glo
10-02-2004, 01:31 AM
I have installed vB2.3.0 and have tried to add a table to MySQL via running a query and also command through PhpMyAdmin but it wont add the table at all. vB installed fine with all the default tables but i just cant add any others.

What can i try??

Thanks

glo
10-02-2004, 01:41 AM
This is what PhpMyAdmin says:

Error
The additional Features for working with linked Tables have been deactivated. To find out why click here.

Which links to the below message.

PMA Database ... not OK[ Documentation ]
General relation features Disabled

How can i enable this???

Thanks

Modin
10-03-2004, 02:23 AM
how are you going about to creating this table?

It looks like the table you're trying to create is using an unsupported feature

glo
10-03-2004, 04:31 AM
i originally tried to create a new table using Logicians query hack (using his complete instructions) but it wouldnt respond and i could see through phpMyAdmin that no tables were added, so i thought i'd try to run the command through phpMyAdmin instead.

When using phpMyAdmin, that message " Error
The additional Features for working with linked Tables have been deactivated. To find out why click here." appears at the bottom of the "structure" tab.

I ended up going to the SQL tab and running the command there which finally worked, but every time i tried to run the command from the "Query window" located in the bottom left corner, below all the tables, it would not respond!

For now, i have gotten it to create the table as i need, but i'd still like to know how to rectify MySQL propoerly so that i can run the command from a script like Logicians!