Results 1 to 5 of 5

Thread: sql error

  1. #1
    Join Date
    Jan 2006

    sql error

    what does that mean? tis hows upwhen i log into phpmyadmin, but everything seems to be working fine.

    SQL query:

    SELECT label, id
    FROM `__DBNAME__`.`PMA_bookmark`
    WHERE dbase = 'Customer'
    AND (

    user = ' ' //username was between the single quotes
    OR user = ''
    ORDER BY label
    MySQL said:

    #1146 - Table '__DBNAME__.PMA_bookmark' doesn't exist

  2. #2
    Join Date
    Aug 2004
    I don't believe FROM database.table is valid. The database is normally selected first via USE (or appropriate function within a script/program, such as mysql_select_db() in MySQL).
    USE `__DBNAME__`;
    SELECT `label`, `id` FROM `PMA_bookmark` . . .
    "Please give us a simple answer, so that we don't have to think, because if we think, we might find answers that don't fit the way we want the world to be."
    ~ Terry Pratchett in Nation

    How to Ask Questions the Smart Way (not affiliated with this site, but well worth reading)

  3. #3
    Join Date
    Jan 2006
    my above post is nothing that i ahve made, it is an error that keeps showing up that does not ahving to do with anything that i know about, nor did i try to craete, update, change, or haave anything to do with a PMA_bookmark?

    i am really confused lol

  4. #4
    Join Date
    Aug 2005
    The Garden State
    this should be a variable


    looks like someone might have changed the config to not use the variable, for some reason. shouldn't have `` around it.
    Acceptable Use | SQL Forum FAQ | celery is tasteless | twitter

    celery is tasteless - currently needing some UI time

  5. #5
    Join Date
    Jun 2006

    This problem can be solved if..

    1) You go to the directory where you had Yahoo! install phpmyadmin
    2) Find the file called "config.inc.php"
    3) Find the line that starts with "$cfg['Servers'][$i]['pmadb']"
    4) Change '__DBNAME__' to 'phpmyadmin'


Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center

Recent Articles