Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > ISPConfig 3 Priority Support

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 30th April 2013, 16:45
lee.veal lee.veal is offline
Member
 
Join Date: Apr 2013
Posts: 34
Thanks: 6
Thanked 5 Times in 5 Posts
Default mod_fcgid: stderr: PHP Fatal error:

When deleting Mail Domain's I get the following error:

[Tue Apr 30 09:50:36 2013] [warn] [client XXX.XXX.XXX.XXX] mod_fcgid: stderr: PHP Fatal error: Call to a member function fetch_assoc() on a non-object in /usr/local/ispconfig/interface/lib/classes/db_mysql.inc.php on line 181, referer: https://xxxxxxxx.net:8080/index.php#


[notice] Apache/2.2.17 (Ubuntu) DAV/2 mod_fcgid/2.3.6 PHP/5.3.5-1ubuntu7.11 with Suhosin-Patch mod_ssl/2.2.17 OpenSSL/0.9.8o configured -- resuming normal operations

I am able to delete records from DNS/Sites with out an issue. It looks to only be an issue with this table (dbispconfig.mail_domain) command line MYSQL works fine.


Thanks for looking!

Lee
Reply With Quote
Sponsored Links
  #2  
Old 30th April 2013, 18:44
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,446
Thanks: 813
Thanked 5,216 Times in 4,089 Posts
Default

Do you have any functions disabled in php.ini?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 30th April 2013, 19:27
lee.veal lee.veal is offline
Member
 
Join Date: Apr 2013
Posts: 34
Thanks: 6
Thanked 5 Times in 5 Posts
Default

No sir


root@web:/usr/local/ispconfig/interface/lib# for i in `locate php.ini` ;do grep disable_functions $i; done
disable_functions =
disable_functions =
disable_functions =
;disable_functions = "highlight_file,ini_alter,ini_restore,openlog,pass thru,
disable_functions =
disable_functions =
disable_functions =
disable_functions =
Reply With Quote
  #4  
Old 30th April 2013, 20:08
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,446
Thanks: 813
Thanked 5,216 Times in 4,089 Posts
Default

I checked it in the ispconfig code, there might be an issue with the new mysqli library were a error condition is not catched in case that there is no record returned in the nextRecord function. I was not able to reproduce that here. Have you checked the mysql database table with phpmyadmin's check and optimize functions?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
The Following User Says Thank You to till For This Useful Post:
lee.veal (30th April 2013)
  #5  
Old 30th April 2013, 20:26
lee.veal lee.veal is offline
Member
 
Join Date: Apr 2013
Posts: 34
Thanks: 6
Thanked 5 Times in 5 Posts
Default

Table returned OK, but the error persists.

turned up logging and got the following


613 Query SELECT forwarding_id as id FROM mail_forwarding WHERE source like '%@birch.XXXXXX.com' OR (destination like '%@birch.XXXXXX.com' AND type != 'forward'
613 Query INSERT INTO sys_log (server_id,datalog_id,loglevel,tstamp,message) VALUES (0,0,1,1367345944,'[INTERFACE]: DB::query(SELECT forwarding_id as id FROM mail_forwarding WHERE source like \'%@birch.XXXXXX.com\' OR (destination like \'%@birch.XXXXXX.com\' AND type != \'forward\') -> mysqli_query You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'\' at line 1')

mysql Ver 14.14 Distrib 5.1.63, for debian-linux-gnu (x86_64) using readline 6.2
Reply With Quote
  #6  
Old 30th April 2013, 20:36
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,446
Thanks: 813
Thanked 5,216 Times in 4,089 Posts
Default

Seems as if the closing ) is missing in the query. I just chekd it in svn and it is there, maybe it has been fixed in the meantime. Does line 63 in the file /usr/local/ispconfig/interface/web/mail/mail_domain_del.php looks like this on your server?

Code:
$records = $app->db->queryAllRecords("SELECT forwarding_id as id FROM mail_forwarding WHERE source like '%@".$app->db->quote($domain)."' OR (destination like '%@".$app->db->quote($domain)."' AND type != 'forward')");
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #7  
Old 30th April 2013, 20:42
lee.veal lee.veal is offline
Member
 
Join Date: Apr 2013
Posts: 34
Thanks: 6
Thanked 5 Times in 5 Posts
Default

SQL works fine from the console

Database changed
mysql> SELECT forwarding_id as id FROM mail_forwarding WHERE source like '%@birch.XXXXX.com' OR (destination like '%@birch.XXXXX.com' AND type != 'forward');
Empty set (0.00 sec)
Reply With Quote
  #8  
Old 30th April 2013, 20:43
lee.veal lee.veal is offline
Member
 
Join Date: Apr 2013
Posts: 34
Thanks: 6
Thanked 5 Times in 5 Posts
Default

Code:
                // Delete all forwardings where the osurce or destination belongs to this domain
                $records = $app->db->queryAllRecords("SELECT forwarding_id as id FROM mail_forwarding WHERE source like '%@".$app->db->quote($domain)."' OR (destination like '%@".$app->db->quote($domain)."' AND type != 'forward'");
                foreach($records as $rec) {
                        $app->db->datalogDelete('mail_forwarding','forwarding_id',$rec['id']);
                }
Reply With Quote
  #9  
Old 30th April 2013, 20:47
lee.veal lee.veal is offline
Member
 
Join Date: Apr 2013
Posts: 34
Thanks: 6
Thanked 5 Times in 5 Posts
 
Default

Works perfect now, thank you! I own ya a pint or 3 .. Thanks!
Reply With Quote
The Following User Says Thank You to lee.veal For This Useful Post:
till (30th April 2013)
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
Only Problems since Updating from 3.0.3.3 to 3.0.4.1 mbay General 4 17th May 2012 12:56
Apache not restart after change php mode wiss Installation/Configuration 15 3rd November 2010 15:43
ffmpeg Video support for ubuntu 7.10 [suphp-ispconfig] amaurib Installation/Configuration 13 16th February 2010 17:26
LB1 Not Taking Over Shared IP Using Heartbeat 2.1.3 On FC10 64Bit asyadiqin Installation/Configuration 5 11th February 2009 20:11
ispconfig php 5 errors itamarjp Installation/Configuration 8 25th April 2008 10:20


All times are GMT +2. The time now is 06:52.


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