1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

phpMyAdmin stopped working after upgrade to 10

Discussion in 'Plesk 10.x for Linux Issues, Fixes, How-To' started by webcie, Nov 16, 2010.

  1. webcie

    webcie Guest

    0
     
    Hello,

    I upgraded 2 CentOS 4.8 servers from Plesk 9.5.3 to Plesk 10.0.1. Everything seemed to be fine execept for phpMyAdmin. It show an error which states (translated from dutch) U need to upgrade to MySQL or higher.

    I'm running MySQL 4.1.22


    Any suggestions?


    Jef
     
  2. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
  3. webcie

    webcie Guest

    0
     
    Hello Igor,

    I think that is the problem. If I'm correct it's version 3.3.3 of phpMyAdmin that is installed on Plesk 10. And that version requires mySQL v5.

    So if I'm correct mySQL 4 will work for Plesk but not for phpMyAdmin in Plesk 10.

    Jef
     
  4. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    Really, according to http://www.phpmyadmin.net/documentation/Documentation.html#faq1_17

    but we support mysql version 4.x too.
    I have reported this problem to developers and I will update thread with results as soon as I receive it.
     
  5. calderwood

    calderwood Regular Pleskian

    25
     
    Joined:
    May 12, 2006
    Messages:
    103
    Likes Received:
    0
    PHPmyAdmin error with log errors

    Did you find a fix for this??? I upgraded to Plesk 10 and now I cannot do any functions from the admin panel in MySQL. If I try to import or export I get the error message:
    import.php: Missing parameter: import_type (FAQ 2.8)

    On export the error message is:
    export.php: Missing parameter: what (FAQ 2.8)
    export.php: Missing parameter: export_type (FAQ 2.8)



    Server: Localhost via UNIX socket
    Server version: 5.0.77
    Protocol version: 10
    User: fairh_adminword@localhost
    MySQL charset: UTF-8 Unicode (utf8)
    Web server
    sw-cp-server/1.0.0
    MySQL client version: 5.0.77
    PHP extension: mysql

    LOG FILES:

    110102 21:20:21 InnoDB: Starting shutdown...
    110102 21:20:23 InnoDB: Shutdown completed; log sequence number 0 1884609048
    110102 21:20:23 [Note] /usr/libexec/mysqld: Shutdown complete

    110102 21:20:23 mysqld ended

    110102 21:20:23 mysqld started
    110102 21:20:23 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
    110102 21:20:23 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
    110102 21:20:23 InnoDB: Started; log sequence number 0 1884609048
    110102 21:20:23 [Note] /usr/libexec/mysqld: ready for connections.
    Version: '5.0.77' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution

    Number of processes running now: 0
    110114 04:17:01 mysqld restarted
    110114 4:17:05 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
    110114 4:17:05 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
    InnoDB: The log sequence number in ibdata files does not match
    InnoDB: the log sequence number in the ib_logfiles!
    110114 4:17:07 InnoDB: Database was not shut down normally!
    InnoDB: Starting crash recovery.
    InnoDB: Reading tablespace information from the .ibd files...
    InnoDB: Restoring possible half-written data pages from the doublewrite
    InnoDB: buffer...
    110114 4:17:15 InnoDB: Started; log sequence number 0 1967964520

    phpMyAdmin
    Version information: 3.3.3
     
    Last edited: Jan 14, 2011
  6. lhwparis

    lhwparis Guest

    0
     
    u can setup your own phpmyadmin with a lower version which supports mysql 4.x?
     
  7. IgorG

    IgorG Forums Analyst Staff Member

    49
    24%
    Joined:
    Oct 27, 2009
    Messages:
    24,572
    Likes Received:
    1,243
    Location:
    Novosibirsk, Russia
    We don't have plans to correct here something. It is not good idea to use old version of software and OSes. It should be updated. Yes, we have support mysql 4 version - you can created databases from plesk on this mysql version and you can install Plesk on server with mysql 4 version but phpmyadmin doesn't work with this version. We have the same behaviour with windows mailservers, for example. Not all Plesk features are supported by some windows mailservers.
    So, phpmyadmin is opensource software and code is not crypted - you can modify it as you want.
     
Loading...