Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > Developers' Forum

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 25th August 2008, 11:36
FractalizeR FractalizeR is offline
Member
 
Join Date: Aug 2008
Posts: 44
Thanks: 0
Thanked 2 Times in 2 Posts
Default [Solved] PHP Include errors in latest ISPConfig 2.2.24

Having successfully installed ISPConfig, I opened it's web interface, logged in and after that, if I navigated to either page, I got a bunch of include errors:

Code:
Warning: include(/go_info.inc.php) [function.include]: failed to open stream: No such file or directory in /home/admispconfig/ispconfig/lib/session.inc.php on line 220

Warning: include() [function.include]: Failed opening '/go_info.inc.php' for inclusion (include_path='.:') in /home/admispconfig/ispconfig/lib/session.inc.php on line 220

Warning: include(/web//lib/module.inc.php) [function.include]: failed to open stream: No such file or directory in /home/admispconfig/ispconfig/lib/session.inc.php on line 241

Warning: include() [function.include]: Failed opening '/web//lib/module.inc.php' for inclusion (include_path='.:') in /home/admispconfig/ispconfig/lib/session.inc.php on line 241
It looks completely like this two-year-old problem.

I attempted to resolve a problem using the same solution:
In both files
  • /root/ispconfig/scripts/lib/classes/ispconfig_db_mysql.lib.php
  • /home/admispconfig/ispconfig/lib/classes/ispconfig_db_mysql.lib.php
to the end of the method function db_mysql() right after $this->connect() call before closing curly brace you need to add the following lines:

PHP Code:
mysql_query("SET character_set_client = 'latin1'");
mysql_query("SET character_set_results = latin1");
mysql_query("SET character_set_connection = utf8"); 
And this resolves the problem.

My server is running latest CentOS 5.2 with latest MySQL 5.0.67. In MySQL default character set for tables is utf8. Default collation is utf8_general_ci. All character sets are included in server and supported. Server is fresh (just installed everything under VMWare). Apache + MySQL + PHP are built from sources.

I think this fix should be incorporated into source code, because such problem will happen on. BTW, why isn't it included in source already? I guess it will affect anyone with non-utf8 connection charset provided...
Reply With Quote
The Following User Says Thank You to FractalizeR For This Useful Post:
orfi (26th July 2010)
Sponsored Links
  #2  
Old 25th August 2008, 13:30
FractalizeR FractalizeR is offline
Member
 
Join Date: Aug 2008
Posts: 44
Thanks: 0
Thanked 2 Times in 2 Posts
Default

I will test tonigh if this problem is related to this one
Reply With Quote
  #3  
Old 26th August 2008, 11:29
FractalizeR FractalizeR is offline
Member
 
Join Date: Aug 2008
Posts: 44
Thanks: 0
Thanked 2 Times in 2 Posts
 
Default

I tested. Both errors has the same reason: MySQL default charset is not latin1.

To install and use ISPConfig currently one has to have MySQL default charset set to latin1. Otherwise, installation will be corrupted.
No need to patch anything
Reply With Quote
The Following User Says Thank You to FractalizeR For This Useful Post:
orfi (26th July 2010)
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
network issues now it says "401 The web site is blocked by administrator" Check General 3 26th February 2008 15:22
ERROR: The PHP binary coming with ISPConfig does not work properly on your system! yahooadam Installation/Configuration 9 15th November 2007 22:18
Questions on Upgrading PHP, and ISPConfig bagpiperdude90 Installation/Configuration 2 8th June 2007 17:45
Another ERROR: The PHP binary coming with ISPConfig does not work properly on your sy hoopsx3 Installation/Configuration 2 29th January 2007 08:56
PHP Errors in the "WEB-FTP" module crudolphy General 9 27th December 2005 21:17


All times are GMT +2. The time now is 21:57.


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