Project

General

Profile

Bug #2811

Opening database fails when user in CVS_Entry_options isn't in user_entry

Added by Michael Lee over 12 years ago. Updated over 12 years ago.

Status:
Resolved
Priority:
Normal
Assignee:
Category:
EntryDB
Target version:
Start date:
04/06/2007
Due date:
% Done:

0%

Estimated time:
Bugzilla-Id:
2811

Description

SQL joining two tables is inner join to keep writable, but need a different solution, as this prevents opening the db, with no recourse!

This would only happen if someone (like me) was monkeying with the innards of the db.

History

#1 Updated by Michael Lee over 12 years ago

Fix:

SELECT cvs_entry_options.*, getCurrentUser_directly(True) AS userName, "not " & [userName] & "?" AS thisIsNotMe, "version " & getValFrmSQL("SELECT versionText FROM Z_VersionCurrent_withAllInfo;") AS version
FROM cvs_entry_options;

as src of cvs_entry_options form

#2 Updated by Michael Lee over 12 years ago

fixed in v205p7

#3 Updated by Redmine Admin over 6 years ago

Original Bugzilla ID was 2811

Also available in: Atom PDF