Project

General

Profile

Actions

Bug #490

closed

Preventing duplicate database tables creation and data insertion

Added by Eric Hou over 14 years ago. Updated over 14 years ago.

Status:
Closed
Priority:
Urgent
Assignee:
Amber Herold
Category:
-
Target version:
Start date:
05/17/2010
Due date:
% Done:

100%

Estimated time:
Affected Version:
Show in known bugs:
Workaround:

Description

Wizard does not know the databases' tables had been created or initialized, so it will keep insert data in to the table if user run it again.
We need to stop this happening.

Thanks.

Actions #1

Updated by Eric Hou over 14 years ago

  • Subject changed from Need a way to stop wizard run tables creatation and initialization more than once. to Preventing duplicate database tables creation and data insertion
Actions #2

Updated by Eric Hou over 14 years ago

myamiweb/setup/initDBTables.php
I put a version number in the 'project' database. The current version number is 2.0. Please update your own project database if you don't have this number.

Please test this page and all the functions as list below.

Thanks.

r13968, r13969, r13970

Test case 1:
Database Username or password is not correct should display error message.

Test case 2:
Leginon or Project database has not been created should display error message.

Test case 3:
When both databases’ tables have been created and initialized.
Display the current version number and both databases’ names. User doesn’t need to do anything.

Test case 4:
When user has both empty databases.
Display both databases name and user can start to do table creation and data initialization.

Actions #3

Updated by Eric Hou over 14 years ago

  • Status changed from Assigned to In Code Review
  • Assignee changed from Eric Hou to Amber Herold
Actions #4

Updated by Amber Herold over 14 years ago

  • Status changed from In Code Review to In Test
Actions #5

Updated by Amber Herold over 14 years ago

  • Status changed from In Test to Closed
Actions #6

Updated by Neil Voss over 14 years ago

  • % Done changed from 0 to 100
Actions

Also available in: Atom PDF