Can't enter SQL commands phpMyAdmin

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
User avatar
TFotH
Forum Newbie
Posts: 2
Joined: Mon Mar 24, 2014 10:38 am

Can't enter SQL commands phpMyAdmin

Post by TFotH »

Hi,

I'm using Debian(jessie). I created a database(Cars) using phpMyAdmin's Create database function. I'm following along a book "The Joy of php". After the table is created the author wants to create a table (INVENTORY) using SQL commands. Well, phpMyAdmin will not let me enter any text in the SQL query text area. I created the table using the Create table function(buttons). If I click on the INVENTORY table in the left window-pane or the tab above I get the following error message:
Error

SELECT 'prefs' FROM 'phpmyadmin' . 'pma__table_uiprefs' WHERE 'username' = 'jeff' AND 'db_name' = 'Cars' AND 'table_name' = 'INVENTORY'

MySQL said:

#1146 - Table 'phpmyadmin.pma__table_uiprefs'
doesn't exist
If I click on columns under INVENTORY or the Structure tab above I can view the table and columns. Also when I click on the SQL tab I can view the table columns in the right-hand pane and the number 1 appears in the SQL command text field. If more information is needed please let me know.

Thanks,
Jeff
User avatar
Celauran
Moderator
Posts: 6427
Joined: Tue Nov 09, 2010 2:39 pm
Location: Montreal, Canada

Re: Can't enter SQL commands phpMyAdmin

Post by Celauran »

Could it be this? http://stackoverflow.com/a/20731569

Do the queries work from the MySQL console?
User avatar
TFotH
Forum Newbie
Posts: 2
Joined: Mon Mar 24, 2014 10:38 am

Re: Can't enter SQL commands phpMyAdmin

Post by TFotH »

Hi Celauran,

Thanks for replying. I can input queries using MYSQL workbench. I looked at the link you offered and that doesn't seem to be my problem, but I'm not positive as I am quite new to all of this. Below is some of the file that was discussed in the link. I hope it will help you. I realize that I could do most everything from the workbench but I am also trying to learn php.

Thanks,
Jeff

$cfg['Servers'][$i]['pmadb'] = $dbname;
$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]['table_uiprefs'] = 'pma__table_uiprefs';
$cfg['Servers'][$i]['tracking'] = 'pma__tracking';
$cfg['Servers'][$i]['designer_coords'] = 'pma__designer_coords';
$cfg['Servers'][$i]['userconfig'] = 'pma__userconfig';
$cfg['Servers'][$i]['recent'] = 'pma__recent';
$cfg['Servers'][$i]['users'] = 'pma__users';
$cfg['Servers'][$i]['usergroups'] = 'pma__usergroups';
$cfg['Servers'][$i]['navigationhiding'] = 'pma__navigationhiding';
Post Reply