The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Something wrong with phpmyadmin

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

  1. Frankc

    Frankc Well-Known Member

    Joined:
    Jun 18, 2005
    Messages:
    98
    Likes Received:
    0
    Trophy Points:
    16
    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?
     
  2. Frankc

    Frankc Well-Known Member

    Joined:
    Jun 18, 2005
    Messages:
    98
    Likes Received:
    0
    Trophy Points:
    16
    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.
     
  3. Frankc

    Frankc Well-Known Member

    Joined:
    Jun 18, 2005
    Messages:
    98
    Likes Received:
    0
    Trophy Points:
    16
    My error sorry.

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

    </thread>
     
Loading...

Share This Page