Bug

Discussion in 'Developers' Forum' started by fobicodam, Jul 18, 2006.

  1. fobicodam

    fobicodam ISPConfig Developer ISPConfig Developer

    Reseller: 500 Mb - 2 MySQL
    2 sites (whitout databases, 50 mb each)

    When try to create the 3rd site:

    You have left only 0 database(s) which you can assign to this website.

    Maybe you are not looking for the "MySQL" checkbox ?
     
  2. falko

    falko Super Moderator ISPConfig Developer

    We will check this.
     
  3. fobicodam

    fobicodam ISPConfig Developer ISPConfig Developer

    Im working a lot right now, when i can find some time ill help you checking some code, i want to learn some php.
     
  4. djtremors

    djtremors ISPConfig Developer ISPConfig Developer

    I saw that too and found it to be taking the co-domain as a site as well.. ie.

    www.mydomainsite.com (auto adds co-domain mydomainsite.com) = 2 sites.

    I think I removed the non www site and it allowed 1 more. I'm not totally sure about this as it was a while and I allowed alot more now anyway.
     
  5. fobicodam

    fobicodam ISPConfig Developer ISPConfig Developer

    But its not a sites problem, its a database one.
     
  6. hamish

    hamish ISPConfig Developer ISPConfig Developer

    has this been resolved by anyone yet?

    hi all

    has anyone fixed this problem yet ?

    cheers

    hamish
     
  7. falko

    falko Super Moderator ISPConfig Developer

    Not yet. We're quite busy, but it's in our bugtracker, so we won't forget that. :)
     
  8. hamish

    hamish ISPConfig Developer ISPConfig Developer

    thanks falko - i saw it in the bugtracker and thought i'd check before looking at trying to fix it

    hamish
     
  9. hamish

    hamish ISPConfig Developer ISPConfig Developer

    cant replicate bug

    I have tried recreating this bug with Fedora Core 5, ISPConfig ver 2.3.1, MySQL 5.0.22 but could not get it to happen.

    I did following:
    - created new reseller (500MB disk space, unlimited bandwith, 2 MySQL databases)
    - created 6 new sites under reseller with varying amounts of disk space, DNS records but no databases enabled)

    worked correctly - no error messages. Sats summary shows 0 of 2 databases used.

    Also tried adding extra "A" DNS records to all sites - still no problems adding new sites.

    I have updated bugtracker with findings and set to resolved/works for me.
     
  10. fobicodam

    fobicodam ISPConfig Developer ISPConfig Developer

    :mad: because yo tested it on another Linux version, with a dev ispconfig ? i still have the same problem :mad: i had to set 50 databases to all my resellers to make it work, i hope nobody will sell more than 50 sites before the fix is done :mad:
     
  11. hamish

    hamish ISPConfig Developer ISPConfig Developer

    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
     
  12. hamish

    hamish ISPConfig Developer ISPConfig Developer

    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
     
  13. fobicodam

    fobicodam ISPConfig Developer ISPConfig Developer

    Thanks, ill check
     

Share This Page