Activate Alias Error

    Hi,


    First, server setup:
    i-MSCP version 1.1.14
    Debian wheezy
    No add-ons


    I have a client that just made an alias and I got the e-mail to approve. But when I hit the Domain Aliases button/link I get the following error (see screenshot). What can I do to fix this?

    Files

    Concrete5 Denmark - CMS til alle
    --------------------------
    Michael Jensen-Maar
    Concrete5 Danmark
    --------------------------

    Just to add...


    The server send me an error email:


    Dear admin, An exception with the following message has been thrown in file /var/www/imscp/gui/library/shared-functions.php (Line: 2527):
    =================================================================
    SQLSTATE[HY093]: Invalid parameter number: no parameters were bound Query was: SELECT admin_id FROM admin WHERE created_by = ?
    =================================================================
    Debug backtrace:
    ---------------
    File: /var/www/imscp/gui/library/reseller-functions.php (Line: 64)Function: exec_query()
    File: /var/www/imscp/gui/public/reseller/alias.php (Line: 262)Function: generate_reseller_user_props()
    Additional information:
    ----------------------
    Http User Agent: Mozilla/5.0 (Windows NT 6.3; WOW64; rv:32.0)
    Gecko/20100101 Firefox/32.0
    Request Uri: /reseller/alias.php
    Http Referer: http://host1.concrete5.dk/reseller/users.php
    Remote Addr: 91.144.xxx.xx
    Server Addr: 10.100.60.6
    ____________________________________________________________
    i-MSCP Exception Mail Writer
    Note: If an exception of same type is thrown again, you will not receive this mail before an expiration time that is currently fixed at6 hour(s).

    Concrete5 Denmark - CMS til alle
    --------------------------
    Michael Jensen-Maar
    Concrete5 Danmark
    --------------------------

    Hello ;


    I'll check and fix if needed ;)

    badge.php?id=1239063037&bid=2518&key=1747635596&format=png&z=547451206

    SSH key for online support

    @MGAV


    I've tried with the 1.1.x branch and I've not encountered any problem (I've ordered a new alias as customer and activated that alias using the reseller).
    Could you give me an access to the server? This must be a problem in the databse.


    Thanks.

    badge.php?id=1239063037&bid=2518&key=1747635596&format=png&z=547451206

    SSH key for online support

    @MGAV


    I've checked the code.
    You must update to the 1.1.x branch or wait for next release. This is a bug which have been fixed. The problem was about the $resellerId variable which was undefined, leading to SQL invalid parameter number error.

    badge.php?id=1239063037&bid=2518&key=1747635596&format=png&z=547451206

    SSH key for online support

    @Athar


    Did you looked correctly? https://github.com/i-MSCP/imsc…46890f87c0d8b2ae857dd4d63


    This is so fixed in 1.1.x. This fix is not part of the 1.1.14 release which explains why @MGAV encounters the problem

    badge.php?id=1239063037&bid=2518&key=1747635596&format=png&z=547451206

    SSH key for online support

    See also for changes made in1.1.x since the 1.1.14 release: https://github.com/i-MSCP/imscp/compare/1.1.14...1.1.x

    badge.php?id=1239063037&bid=2518&key=1747635596&format=png&z=547451206

    SSH key for online support

    I'm so tired :p


    I only take a look on the Bug tracker (most of the time you post the modification done on it too :D my bad on that^^)


    Well, since 1.1.13, some changes, will get the last 1.1.x release, have a little bug in 1.1.13, maybe related to the change of my certs, or in the SSLv3 lockdown... (can't add FTP accounts, well if confirmed after update, will open my post^^)



    Thanks nuxwin to answer so quickly :p