Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 5th May 2006, 23:26
md@waw.co.uk md@waw.co.uk is offline
Junior Member
 
Join Date: May 2006
Posts: 24
Thanks: 2
Thanked 1 Time in 1 Post
Default phpMyAdmin - panick attack

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
Reply With Quote
Sponsored Links
  #2  
Old 6th May 2006, 12:06
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 Posts
Default

There'S a major bug in PHP 5.1.3, as you can see on http://www.php.net/ :
Quote:
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
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 8th May 2006, 11:03
md@waw.co.uk md@waw.co.uk is offline
Junior Member
 
Join Date: May 2006
Posts: 24
Thanks: 2
Thanked 1 Time in 1 Post
Default Thanks

Thank you

that worked a treat...

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

All the best

Martin
Reply With Quote
  #4  
Old 9th May 2006, 22:56
Norman Norman is offline
HowtoForge Supporter
 
Join Date: May 2006
Posts: 242
Thanks: 0
Thanked 18 Times in 14 Posts
Default

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.
__________________
http://www.xh.se
Reply With Quote
  #5  
Old 21st May 2006, 23:35
trueshanti trueshanti is offline
Member
 
Join Date: May 2006
Posts: 41
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
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 ?
Reply With Quote
  #6  
Old 22nd May 2006, 08:58
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 Posts
Default

It will soon be released.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #7  
Old 3rd September 2006, 20:52
klaus++ klaus++ is offline
Junior Member
 
Join Date: May 2006
Location: Berlin
Posts: 19
Thanks: 4
Thanked 1 Time in 1 Post
 
Default 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
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
installing PHPmyadmin guidovanh Installation/Configuration 1 24th March 2006 20:20
phpMyAdmin question? ctroyp Installation/Configuration 1 20th March 2006 23:19
Latest version of phpMyAdmin (phpMyAdmin-2.6.4-pl2) as pkg file. yvovandoorn Feature Requests 8 23rd February 2006 13:10
phpMyAdmin string error IntnsRed General 2 7th November 2005 10:48
mbstring prob with phpMyAdmin hyperclock General 10 22nd September 2005 15:27


All times are GMT +2. The time now is 14:09.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.