Database Error with OC 7.0.2
tadeomarti opened this issue · 6 comments
I recently installed ocUsageCharts v3.2 on my ownCloud v7.0.2.1. At charts menu the stats from my users are not shown.
Log show this error:
Fatal index Doctrine\DBAL\DBALException: An exception occurred while executing 'SELECT DISTINCT CONCAT(MONTH("created"), ' ', YEAR("created")) as month, avg("usage") as average, username FROM oc_uc_storageusage WHERE "usage" > 0 AND created > ? GROUP BY username, month': SQLSTATE[42883]: Undefined function: 7 ERROR: function month(timestamp without time zone) does not exist LINE 1: SELECT DISTINCT CONCAT(MONTH("created"), ' ', YEAR("created"... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts
My ownCloud is running under:
Ubuntu 14.04.1 LTS
Apache/2.4.7 (Ubuntu)
PHP 5.5.9-1ubuntu4.4
External Database: PostgreSQL 9.1.14
LDAP
Regards
Thanks for the bug report, i will see if i can fix it on short notice.
Sadly i could not fix it in short notice, i was low on time to actually test and fix it, and im going on holiday very soon. I will pick it up in december.
Ok don't worry. Thanks you.
this are due the storagechar are using my-puach-sql like sentences and no standar sql99 sentences.. must retrieve the month with standar querys, not usin a specific DBMS funtion... owncloud uses many databases not only the little mysql.. the most powered installation uses large scallar DBMS such oracle or postgres...
I know the issue, it is on my high priority list to fix.
Others are obviously also welcome to fix it.
Sorry about the massive delay, my laptop died on me and needed a new one. Which i have right now.
So it should be fixed