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` = '[email protected]', `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
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
Thanks Thank you that worked a treat... I have to say we like ISPConfig - much nicer to use that Cpanel. All the best Martin
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.
THX - patch worked 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
