#11  
Old 8th August 2006, 04:50
hamish hamish is offline
Junior Member
 
Join Date: Jul 2006
Location: Perth, Australia
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Unhappy

fobicodam

it wasnt saying it is not an issue in 2.2.5 - i was trying to say that it appears to have been fixed in 2.3.1 (either intentionally or otherwise)

if you are unable to wait until 2.3.2 i will have a look at 2.2.5 and see if i can find the problem and get it fixed for the next release (2.2.6 ?)

hamish
Reply With Quote
Sponsored Links
  #12  
Old 10th August 2006, 12:01
hamish hamish is offline
Junior Member
 
Join Date: Jul 2006
Location: Perth, Australia
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Smile fixed!

I have found the problem and have a fix for it below (nned to edit one file). I have also checked the changes in to the open (dev) release 2.3.1.

You need to edit the following in the file /admispconfig/ispconfig/lib/classes/ispconfig_isp_web.lib.php

on approx line 280 make the code look as follows:

// Datenbanken
// if($reseller["limit_mysql"] == 1 && $reseller["limit_mysql_anzahl_dbs"] >= 0){
if($web["web_mysql"] == 1 && $reseller["limit_mysql_anzahl_dbs"] >= 0){
$datenbankanzahl = $go_api->db->queryOneRecord("SELECT sum(isp_isp_web.web_mysql_anzahl_dbs) as datenbankanzahl from isp_isp_web,isp_nodes where isp_isp_web.doc_id = isp_nodes.doc_id and isp_nodes.groupid = '$resellerid' and isp_nodes.doctype_id = ".$this->web_doctype_id." and isp_isp_web.web_mysql = 1");


on approx line 630 make the code look as follows:

// Datenbanken
// if($reseller["limit_mysql"] == 1 && $reseller["limit_mysql_anzahl_dbs"] >= 0){
if($web["web_mysql"] == 1 && $reseller["limit_mysql_anzahl_dbs"] >= 0){
$datenbankanzahl = $go_api->db->queryOneRecord("SELECT sum(isp_isp_web.web_mysql_anzahl_dbs) as datenbankanzahl from isp_isp_web,isp_nodes where isp_isp_web.doc_id = isp_nodes.doc_id and isp_nodes.groupid = '$resellerid' and isp_nodes.doctype_id = ".$this->web_doctype_id." and isp_isp_web.web_mysql = 1");

hope this helps
Reply With Quote
  #13  
Old 10th August 2006, 14:18
fobicodam fobicodam is offline
Senior Member
 
Join Date: Apr 2006
Location: Argentina
Posts: 346
Thanks: 0
Thanked 1 Time in 1 Post
Send a message via MSN to fobicodam
 
Default

Thanks, ill check
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


All times are GMT +2. The time now is 10:44.


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