www.webdeveloper.com
Results 1 to 5 of 5

Thread: sql error

  1. #1
    Join Date
    Jan 2006
    Posts
    63

    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
    Location
    Ankh-Morpork
    Posts
    19,604
    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).
    Code:
    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

    eBookworm.us

  3. #3
    Join Date
    Jan 2006
    Posts
    63
    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
    Location
    The Garden State
    Posts
    5,634
    this should be a variable

    `__DBNAME__`

    looks like someone might have changed the config to not use the variable, for some reason. shouldn't have `` around it.

  5. #5
    Join Date
    Jun 2006
    Posts
    1

    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'

    HTH

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