Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQL error with PostgreSQL #29

Open
sciurius opened this issue Jun 23, 2014 · 1 comment
Open

SQL error with PostgreSQL #29

sciurius opened this issue Jun 23, 2014 · 1 comment

Comments

@sciurius
Copy link

When OC is run with PostgreSQL ad database, journal yields a fatal error.
The cause of the error is line 38 in lib/vjournal.php. The string "VJOURNAL" should be 'VJOURNAL' (single quotes).

Fix is trivial: change line 38
$stmt = \OCP\DB::prepare('SELECT * FROM _PREFIX_clndr_objects WHERE calendarid = ? AND objecttype = "VJOURNAL"');

to
$stmt = \OCP\DB::prepare('SELECT * FROM _PREFIX_clndr_objects WHERE calendarid = ? AND objecttype = 'VJOURNAL'');

@nialldaley
Copy link

I can confirm the error and the fix for postgres.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants