Thread: Bug
View Single Post
  #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