[RESOLVED] PHPMyAdmin error

n0uhad

Could someone please tell me why how to resolve a '#1146 - Table 'phpmyadmin.pma_bookmark' doesn't exist' Error?

Piranha

Some code would be helpful. And the structure of the database. But basically there is no table with that exact name.

n0uhad

My config.inc.php had these settings in them :

/* Advanced phpMyAdmin features */
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
$cfg['Servers'][$i]['relation'] = 'pma_relation';
$cfg['Servers'][$i]['table_info'] = 'pma_table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma_column_info';
$cfg['Servers'][$i]['history'] = 'pma_history';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = 'root';

Is it safe to remove the values? e.g. $cfg['Servers'][$i]['bookmarktable'] = ' '; ?

Or would i have to create those tables?

The error appeared when i inserted values into my table using PHPMyAdmin.

Piranha

It is good that you supply some of the code. But I ment to submit the query you try when you get the error. And I need to know how your database tables look like.

Does any queries work?

As another point you really should not use 'root' as password.

n0uhad

This is the error as it appears at the bottom of my PHPMyAdmin page, when I use it to insert random values into my table :

Error SQL query: SELECT label, id FROM phpmyadmin.pma_bookmark WHERE dbase = 'test' AND ( user = 'root' OR user = '' ) ORDER BY label MySQL said: #1146 - Table 'phpmyadmin.pma_bookmark' doesn't exist

Seeing as im running this server on a local machine, do you recommend I change or keep the password as it is

Warlock

It's look like sql table missing which is strange since phpmyadmin is loader not mysqldatabase.

ClarkF1

There is a database in phpmyadmin called phpmyadmin

At least there is in my version, and it includes a table called pma_bookmark

However, out of the 7 tables the database contains, there is only one row of data and that is in the pma_bookmark table

I think it's something phpmyadmin uses and is not for general use

Edit:

I've just worked out that the row contains a query I saved when fixing tables in one of my databased from within phpmyadmin so I wouldn't have to type it in again in future.

Piranha

Edit: My wrong, I didn't even know it was possible to do a query like that.

About the password. I would never use "root" as a password, it does not matter i it is local or not. And to be honest I really doubt that it is really local, it is probably connected to Internet some way even if it is ment to be local.

liquorvicar

No Piranha, the dot is correct. The query is of the form

SELECT label,id FROM `db`.`table`

and not a multi-table query.

n0uhad - what version of PMA have you got? On my copy of PMA 2.9.1.1 I don't have those tables but I don't get any errors.

n0uhad

Sorry, liquorvicar, but how would I go about checking its version?

rincewind456

If you read the install text you'll see that if you want to make use of all the features of phpmyadmin then you have to create these tables, the sql code for them is in the phpmyadmin/scripts/ folder in a file called "create_tables_mysql_4_1_2+.sql"

n0uhad

rincewind456 wrote:
If you read the install text you'll see that if you want to make use of all the features of phpmyadmin then you have to create these tables, the sql code for them is in the phpmyadmin/scripts/ folder in a file called "create_tables_mysql_4_1_2+.sql"

This should sort it out. Thread resolved, thank you all for the help

-nouhad