Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Something wrong with phpmyadmin

Discussion in 'Database Discussion' started by Frankc, Nov 10, 2009.

  1. Frankc

    Frankc Well-Known Member

    Joined:
    Jun 18, 2005
    Messages:
    103
    Likes Received:
    1
    Trophy Points:
    168
    I intensively worked with phpmyadmin during the past few days but a hour or so ago phpmyadmin become relative problematic.

    Anyone else experienced this type of behaviour?

    1) Right-click on edit a row don't work. Right-click on edit gives popup window with the field data.

    2) Delete a row or more and instead of the normal "Do you really want to delete from TABLE where ID = xx" etc, the system now wants to confirm EVERYTHING in that field.

    Do you really want to delete from TABLE where ID = 1 AND field 2 = xx AND field 3 = xx and field 4 = xxx. (Even if field 4 (xxx) represent a LONGTEXT field, then the system still say AND field 4 = "xxxxx LONGTEXT .....xxxx")

    I already restarted mysql as well as my computer but still the same problem with very slow reaction from phpmyadmin.

    Any ideas would be appreciated please?
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  2. Frankc

    Frankc Well-Known Member

    Joined:
    Jun 18, 2005
    Messages:
    103
    Likes Received:
    1
    Trophy Points:
    168
    Explaining above don't let it seems like a major problem but just consider the following if you have a lot to do.

    If you select 10 data rows and click delete.

    Instead of a confirm deletion message with 10 rows, one for each data row where ID = 1 ... up to... 10, the system instead

    Start processing and display ALL data in above 10 rows so if some of the fields in a row is longtext or whatever, a large amount of data are displayed and if you click yes, the system then compare and check each and every field with the generated field = xxx statement.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Frankc

    Frankc Well-Known Member

    Joined:
    Jun 18, 2005
    Messages:
    103
    Likes Received:
    1
    Trophy Points:
    168
    My error sorry.

    (During database manipulation I change the primary key to index and forgot to change it back to primary key)

    </thread>
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice