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.

phpmyadmin not updating row

Discussion in 'Database Discussions' started by xoviboy, Jun 12, 2007.

  1. xoviboy

    xoviboy Member

    Joined:
    Jul 28, 2006
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    1
    Hello,

    I have one problem with an update of a row on a table. I'm using phpmyadmin 2.10.0.2 from cPanel 11.4.6-R13580 and mysql version 4.1.22
    The thing is when I try to edit one row, after saving the modification it does not update anything in the table data.

    I've tried so far, restarting, see if table is locked (with mysqladmin processlist), deleted the table and recreate.

    Any help is welcome.

    Regards,
    mrx
     
  2. eNetHosts

    eNetHosts Well-Known Member

    Joined:
    Apr 21, 2007
    Messages:
    195
    Likes Received:
    0
    Trophy Points:
    16
    SSH in as root and and do

    /scripts/mysqlup --force

    and then

    /scripts/upcp --force

    and then

    /etc/init.d/cpanel restart
     
  3. xoviboy

    xoviboy Member

    Joined:
    Jul 28, 2006
    Messages:
    13
    Likes Received:
    0
    Trophy Points:
    1
    Thank you for your answer. I've tried that and still doesn't work...
     
  4. eNetHosts

    eNetHosts Well-Known Member

    Joined:
    Apr 21, 2007
    Messages:
    195
    Likes Received:
    0
    Trophy Points:
    16
    Does the database have write access, this can prevent changes been saved?

    Was there any changes to the server software around the time it stopped working and what build of cPanel/SQL/OS are you running?
     
  5. acenetryan

    acenetryan Well-Known Member
    PartnerNOC

    Joined:
    Aug 21, 2005
    Messages:
    197
    Likes Received:
    1
    Trophy Points:
    18
    Another possibility that we came across today was the presence of HTML within the data causing issues with PHPMyAdmin.

    In our case, we were able to edit other databases and other tables which did not contain HTML tags in the data. The manual SQL feature within PHPMyAdmin was able to successfully update the table as it did not have to load any HTML for display. I would assume it's the HTML tags interfering with the form tags, but I didn't dig any deeper once I found the cause.
     
  6. mctDarren

    mctDarren Well-Known Member

    Joined:
    Jan 6, 2004
    Messages:
    664
    Likes Received:
    2
    Trophy Points:
    18
    Location:
    New Jersey
    cPanel Access Level:
    Root Administrator
    I had that problem before and I simply cannot find the link to the mysql web site that explained the problem now. What database type are the ones you cannot update? I believe we did one of two things:

    1. Changed the database type from Innodb to myISAM (and back again if warranted)
    2. or simply exported the db to a sql text file and recreated it from scratch by importing the sql file.

    It was awhile ago when we ran 4, so I forget which one did the job...
     
  7. cPanelKenneth

    cPanelKenneth cPanel Development
    Staff Member

    Joined:
    Apr 7, 2006
    Messages:
    4,461
    Likes Received:
    22
    Trophy Points:
    38
    cPanel Access Level:
    Root Administrator
    What you describe (i.e the original poster) matches some bugs fixed in newer versions of PHPMyAdmin. 2.11 is in the Current and EDGE branches and will be available in Release and Stable in the coming weeks.
     
Loading...

Share This Page