Project

General

Profile

Actions

Bug #2811

closed

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

Added by Michael Lee over 17 years ago. Updated over 17 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.

Actions #1

Updated by Michael Lee over 17 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

Actions #2

Updated by Michael Lee over 17 years ago

fixed in v205p7

Actions #3

Updated by Redmine Admin over 11 years ago

Original Bugzilla ID was 2811

Actions

Also available in: Atom PDF