Bug #63

Unable to Archive older races

Added by Anonymous over 10 years ago. Updated over 9 years ago.

Status:ClosedStart date:03/28/2012
Priority:NormalDue date:
Assignee:Jamie Pate% Done:

0%

Category:databaseSpent time:3.50 h
Target version:1.3.13

Description

When trying to archive older races I receive the following error

SQL Error:Not unique table/alias:'raceregistration'

unarchive_error.jpg (59.1 KB) Walter Pate, 05/02/2012 08:01 PM

unarchive_mysql_error.mbk (96.6 KB) Walter Pate, 05/02/2012 08:01 PM

archive_error_not_valid_date.jpg (25.4 KB) Walter Pate, 01/05/2013 07:45 AM

Database_repair_issue_.jpg (107 KB) Walter Pate, 01/05/2013 07:45 AM

non_valid_date.mbk (1.3 MB) Walter Pate, 01/05/2013 07:45 AM

Associated revisions

Revision 576
Added by max over 10 years ago

fixes #63
also, now refreshes database after an archive, as well as refreshing the eventsetup page when a db refresh happens
fixed 'please set an eventformat' message when closing and the event is empty

History

#1 Updated by Jamie Pate over 10 years ago

fixed in rev 576

#2 Updated by Jamie Pate over 10 years ago

  • Status changed from New to Resolved

#3 Updated by Jamie Pate over 10 years ago

  • Target version set to 1.3.13

#4 Updated by Walter Pate over 10 years ago

1 The panel that opens to archive is not large enough, you can not read the titlebar and does not give any prompts on what to do. the only choice is to select a date. what if the user wants to selectively retain specific events ?
2 When I tried to unarchive events there was a mysql error during the unarchive procedure

#5 Updated by Jamie Pate over 10 years ago

  • Status changed from Feedback to Resolved

Please create a separate issue for the layout issues and another one for the unarchive issue

#6 Updated by Walter Pate over 9 years ago

when trying to archive a database a not valid date error occurs now
when I try to do a database repair another non valid date occurs (see Database repair error) will report this as an issue

#7 Updated by Walter Pate over 9 years ago

  • Category set to database

Jamie changed parameters so the database sets up using universal settings, not local machine settings for the date line.

#8 Updated by Walter Pate over 9 years ago

  • Status changed from In Progress to Closed

now closed see new error on un archiving

Also available in: Atom PDF