[Owncloud] ownCloud 4.5 beta 3

Manuel Delgado manuel.delgado at ucr.ac.cr
Thu Sep 13 19:54:59 UTC 2012

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.

Manuel Delgado


*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>

More information about the Owncloud mailing list