Bug

[hamish]

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

[hamish]

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

[fobicodam]

Thanks, ill check