phpMyAdmin - panick attack

Discussion in 'General' started by md@waw.co.uk, May 5, 2006.

  1. md@waw.co.uk

    md@waw.co.uk New Member

    Hello
    This is my first port - and I have to say that I think ISPconfig is very nice.

    Getting the strangest thing happening - ISPconfig 2.2.2 with the latest phpMyAdmin package 2.6.4-pl3 / Fedora core 4

    If I use pages on websites (database connected) to edit data - no problems.

    If I use my own ver. of phpMyAdmin - (inside a domain - with full root access) no problem editing data (oddly it shows the wrong ver. of PHP - i.e. the system ver.)

    If I use the.pkg ver (tools -> phpMyAdmin -> root user) or if I log in as the customer (DB_User + Password) I get this (see below) when I try to update a table.

    Oddly if the table is very small, 2 or 3 cols it works. but 5 or more &....

    I do not have any Array's in my code - or in the database.

    EXAMPLE ***********************START*************

    Warning: urldecode() expects parameter 1 to be string, array given in /home/admispconfig/ispconfig/web/phpmyadmin/tbl_replace.php on line 168

    Warning: urldecode() expects parameter 1 to be string, array given in /home/admispconfig/ispconfig/web/phpmyadmin/tbl_replace.php on line 168

    Warning: preg_match() expects parameter 2 to be string, array given in /home/admispconfig/ispconfig/web/phpmyadmin/tbl_replace.php on line 155

    Warning: preg_match() expects parameter 2 to be string, array given in /home/admispconfig/ispconfig/web/phpmyadmin/tbl_replace.php on line 157

    Warning: urldecode() expects parameter 1 to be string, array given in /home/admispconfig/ispconfig/web/phpmyadmin/tbl_replace.php on line 168

    Warning: urldecode() expects parameter 1 to be string, array given in /home/admispconfig/ispconfig/web/phpmyadmin/tbl_replace.php on line 168

    Warning: preg_match() expects parameter 2 to be string, array given in /home/admispconfig/ispconfig/web/phpmyadmin/tbl_replace.php on line 155

    Warning: preg_match() expects parameter 2 to be string, array given in /home/admispconfig/ispconfig/web/phpmyadmin/tbl_replace.php on line 157

    Warning: urldecode() expects parameter 1 to be string, array given in /home/admispconfig/ispconfig/web/phpmyadmin/tbl_replace.php on line 168

    Warning: urldecode() expects parameter 1 to be string, array given in /home/admispconfig/ispconfig/web/phpmyadmin/tbl_replace.php on line 168

    Warning: urldecode() expects parameter 1 to be string, array given in /home/admispconfig/ispconfig/web/phpmyadmin/tbl_replace.php on line 168

    Warning: preg_match() expects parameter 2 to be string, array given in /home/admispconfig/ispconfig/web/phpmyadmin/tbl_replace.php on line 155

    Warning: preg_match() expects parameter 2 to be string, array given in /home/admispconfig/ispconfig/web/phpmyadmin/tbl_replace.php on line 157

    Warning: preg_match() expects parameter 2 to be string, array given in /home/admispconfig/ispconfig/web/phpmyadmin/tbl_replace.php on line 155

    Warning: preg_match() expects parameter 2 to be string, array given in /home/admispconfig/ispconfig/web/phpmyadmin/tbl_replace.php on line 157

    Warning: preg_match() expects parameter 2 to be string, array given in /home/admispconfig/ispconfig/web/phpmyadmin/tbl_replace.php on line 155

    Warning: preg_match() expects parameter 2 to be string, array given in /home/admispconfig/ispconfig/web/phpmyadmin/tbl_replace.php on line 157

    Warning: Cannot modify header information - headers already sent by (output started at /home/admispconfig/ispconfig/web/phpmyadmin/tbl_replace.php:168) in /home/admispconfig/ispconfig/web/phpmyadmin/libraries/ob.lib.php on line 61

    Warning: Cannot modify header information - headers already sent by (output started at /home/admispconfig/ispconfig/web/phpmyadmin/tbl_replace.php:168) in /home/admispconfig/ispconfig/web/phpmyadmin/libraries/header_http.inc.php on line 14

    Warning: Cannot modify header information - headers already sent by (output started at /home/admispconfig/ispconfig/web/phpmyadmin/tbl_replace.php:168) in /home/admispconfig/ispconfig/web/phpmyadmin/libraries/header_http.inc.php on line 15

    Warning: Cannot modify header information - headers already sent by (output started at /home/admispconfig/ispconfig/web/phpmyadmin/tbl_replace.php:168) in /home/admispconfig/ispconfig/web/phpmyadmin/libraries/header_http.inc.php on line 16

    Warning: Cannot modify header information - headers already sent by (output started at /home/admispconfig/ispconfig/web/phpmyadmin/tbl_replace.php:168) in /home/admispconfig/ispconfig/web/phpmyadmin/libraries/header_http.inc.php on line 17

    Warning: Cannot modify header information - headers already sent by (output started at /home/admispconfig/ispconfig/web/phpmyadmin/tbl_replace.php:168) in /home/admispconfig/ispconfig/web/phpmyadmin/libraries/header_http.inc.php on line 20


    AND THE SQL IS FAULTY

    UPDATE `customers` SET `company` = NULL ,
    `Title` = 'Mr',
    `Firstname` = 'Array',
    `phone` = '01424 44 77 44',
    `mobiletelephone` = NULL ,
    `fax` = NULL ,
    `eve_tel_show` = Array(
    'N'
    ),
    `mob_tel_show` = 'N',
    `email_show` = 'Array',
    `email` = 'md@waw.co.uk',
    `web` = NULL ,
    `picture_show` = Array(
    'Y'
    ),
    `address2` = NULL ,
    `city` = 'St Leonards-on-Sea',
    `courseCode` = 'Array',
    `whenQualified` = NULL ,
    `insurance_details` = 'Array',
    `associate_body_notes` = NULL ,
    `eventswork` = 'Array',
    `owntransport` = Array(
    'Y'
    ),
    `agreeterms` = Array(
    'Array'
    ),
    `customerVATnumber` = 'Array',
    `account_activated` = 'Array',
    `authorised` = 'Array',
    `userlevel` = 'Array',
    `expiry_date` = Array(
    '1177521600'
    ) WHERE `cid` =4 LIMIT 1

    ************** END ****************

    Any ideas???

    Thanks

    Martin
     
  2. falko

    falko Super Moderator

    There'S a major bug in PHP 5.1.3, as you can see on http://www.php.net/ :
    I guess your errors are related to this problem...
    You can downgrade to PHP5.0.4 which works stable: http://www.howtoforge.com/forums/showthread.php?t=3695
     
  3. md@waw.co.uk

    md@waw.co.uk New Member

    Thanks

    Thank you

    that worked a treat...

    I have to say we like ISPConfig - much nicer to use that Cpanel.

    All the best

    Martin
     
  4. Norman

    Norman HowtoForge Supporter

    I've tried using the phpmyadmin provided in the .pkg on 2.2.2 . However it seems that it causes ISPadmin_httpd process to go to 99% cpu-usage and simply get stuck at that when I run bigger SQL-commands. Exporting, importing and the like.

    It also doesnt seem to be liking to do proper SQL, it seems to try to write all SQL commands in some form of array .
    Which of course mysql 4.0 and 4.1 doesnt support.

    I suggest that package on ispconfig.com is pulled off the site.
     
  5. trueshanti

    trueshanti New Member

  6. falko

    falko Super Moderator

    It will soon be released. :)
     
  7. klaus++

    klaus++ New Member

Share This Page