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

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

      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.

        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.

          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

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

              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.

                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.

                  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.

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

                      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"

                        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

                          Write a Reply...