phpMyAdmin - panick attack

[md@waw.co.uk]

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

[falko]

There'S a major bug in PHP 5.1.3, as you can see on http://www.php.net/ :

A critical bug with $_POST array handling as well as the FastCGI sapi have been discovered in PHP 5.1.3. A new PHP release 5.1.4 is now available to address these issues. All PHP users are encouraged to upgrade to this release as soon as possible.

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

[md@waw.co.uk]

Thank you

that worked a treat...

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

All the best

Martin

[Norman]

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.

[trueshanti]

Originally Posted by falko

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

is there a similiar UPGRADE to 5.1.4 too ?

[falko]

It will soon be released.

[klaus++]

Thanks a lot. I had the same kind of problem and solved them following your instructions below:
http://www.howtoforge.com/forums/showthread.php?t=3695