[Owncloud] ownCloud 4.5 beta 3

[Manuel Delgado]

Hi Dirk

I got the same error days ago... ('owncloud.dual')

I think it is due to an error in a SQL statement in access.php, in the
mapComponent(..) method, it says:

        if($dbtype == 'mysql') {
            $sqlAdjustment = 'FROM `dual`';
        }

And MySQL doc reads: "You are permitted to specify DUAL as a dummy table
name in situations where no tables are referenced"[1]. But in this case the
table name must be DUAL not `dual`, because it can conflict with a table in
the database (the case of "owncloud.dual", where the table not even exist)

I changed the code to:

        if($dbtype == 'mysql') {
            $sqlAdjustment = 'FROM DUAL';
        }

And works for me.


Regards,
Manuel Delgado

[1]https://dev.mysql.com/doc/refman/5.0/en/select.html

-----------------------------------------------------------
*Usuario Linux* *#520940 <http://counter.li.org/>*

Bach. Computación e Informática
Universidad de Costa Rica





On Thu, Sep 13, 2012 at 6:15 AM, Dirk Kastens <
dirk.kastens at uni-osnabrueck.de> wrote:

>  I updated the beta3 with the latest fixes from master
>> http://owncloud.org/releases/**owncloud-4.5.0-beta3.tar.bz2<http://owncloud.org/releases/owncloud-4.5.0-beta3.tar.bz2>
>>
> No chance. I always get an HTTP 500 error and the message
>
> PHP Fatal error:  Uncaught exception 'PDOException' with message
> 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'owncloud.dual'
> doesn't exist' in /var/www/html/owncloud/lib/db.**php:696\nStack
> trace:\n#0 /var/www/html/owncloud/lib/db.**php(696):
> PDOStatement->execute(Array)\**n#1 /var/www/html/owncloud/apps/**user_ldap/lib/access.php(403):
> PDOStatementWrapper->execute(**Array)\n#2 /var/www/html/owncloud/apps/**user_ldap/lib/access.php(258):
> OCA\\user_ldap\\lib\\Access->**mapComponent('cn=ustudent,ou=.**..',
> 'ustudent', false)\n#3 /var/www/html/owncloud/apps/**user_ldap/lib/access.php(317):
> OCA\\user_ldap\\lib\\Access->**dn2ocname('cn=ustudent,ou=...'**,
> 'ustudent', false)\n#4 /var/www/html/owncloud/apps/**user_ldap/lib/access.php(295):
> OCA\\user_ldap\\lib\\Access->**ldap2ownCloudNames(Array, false)\n#5
> /var/www/html/owncloud/apps/**user_ldap/group_ldap.php(212):
> OCA\\user_ldap\\lib\\Access->**ownCloudGroupNames(Array)\n#6
> /var/www/html/owncloud/lib/**group.php(243): OCA\\user_ldap\\GROUP_LDAP->*
> *getGroups('', -1, 0)\n#7 /var/www/html/owncloud/**settings/users.php(23):
> OC_G in /var/www/html/owncloud/lib/db.**php on line 696
>
> This message also appears when the owncloud admin user clicks on the
> "Users" button.
>
> Dirk
>
>
> _______________________________________________
> Owncloud mailing list
> Owncloud at kde.org
> https://mail.kde.org/mailman/listinfo/owncloud
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/owncloud/attachments/20120913/a70723eb/attachment.html>