Hi Jens,
Hallo,
bei uns laeuft z.Zt. eGroupware 14.3.005 und mir ist gerade aufgefallen das
im Projektmanager beim Auflisten der Projekte ploetzlich Datenbankfehler
auftauchen:
Database error
Invalid SQL: SELECT SQL_CALC_FOUND_ROWS *,CASE WHEN
link_app1=‘projectmanager’ AND link_id1=pm_id THEN link_app2 ELSE link_app1
END AS pe_app,CASE WHEN link_app1=‘projectmanager’ AND link_id1=pm_id THEN
link_id2 ELSE link_id1 END AS pe_app_id,link_remark AS pe_remark FROM
egw_pm_elements ,egw_links WHERE pe_id=link_id ORDER BY
(link_app1=‘projectmanager’ AND link_app2=‘projectmanager’) DESC,pm_real_end
ASC
Unknown column ‘pm_real_end’ in ‘order clause’ (1054)
You need to delete your projectmanager preferences in the database:
Find you account_id, eg. by looking at the url when you double-click
your account in admin.
Run the following SQL replacing $account_id with the number you found
for your account:
DELETE FROM egw_preferences WHERE preference_owner=$account_id and
preference_app=‘projectmanager’
Then delete cache (and register hooks) in admin.
I tried to reproduce your problem, but was not able to 
If you can reproduce it, after fixing it like described above, please
let me know. Or better create a trial
(https://www.egroupware.org/en/products/cloud-services-30-day-free-trial.html),
reproduce it there and report it with the credentials you received on
my.stylite.de.
Ralf
ein "Downgrade auf vorherige 14.3er Version hat leider nichts veraendert,
eine De- und Neuionstallieren der Projektmanager App leider auch nichts.
Jetzt habe ich keine Idee mehr wie ich weiterkomme.
Hat jemand einen Hinweis?
–
View this message in context: http://egroupware.219119.n3.nabble.com/Database-Error-tp4009036.html
Sent from the egroupware-german mailing list archive at Nabble.com.
egroupware-german mailing list
egroupware-german@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/egroupware-german
–
Ralf Becker
Director Software Development
Stylite AG
Isaac-Fulda-Allee 9 | Tel. +49 6131 32702-0
D-55124 Mainz | Fax. +49 6131 32702-70
Email: rb@stylite.de
www.stylite.de | www.egroupware.org
Managing Directors: Andre Keller | Ralf Becker | Gudrun Mueller
Chairman of the supervisory board: Prof. Dr. Birger Leon Kropshofer
VAT DE214280951 | Registered HRB 46224 Mainz Germany
