Giter Club home page Giter Club logo

fire-department-management-system's People

Contributors

jdougherty avatar rozant avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar

Forkers

rmyers343

fire-department-management-system's Issues

Can't create a database

I tried to start up a new instance of FDMS, but I got the error message that "Database could not be created" whenever I tried to go through the setup. I'm running Win7 x64, and was running the latest version of the project with Qt Creator 2.3.1 with Qt 4.7.4 32 bit. The full set of log files from the program during a run follows.

Initialized at Sat Oct 15 14:56:48 2011
Settings Manager: C:/Users/okeefm/AppData/Roaming/FDMS/FDMS.ini does not exist.
Running program setup.
Setup: User wants to install a new instance.
Setup: Database path: C:\cygwin\home\okeefm\fdms_stuff
Database Manager: Closed 
Database Manager: C:\cygwin\home\okeefm\fdms_stuff\fdms.db does not exist.
Database Manager: Opened C:\cygwin\home\okeefm\fdms_stuff\fdms.db
Database Manager: Creating the tables.
Database Manager: Structure Initialization: CREATE TABLE department(name TEXT,address TEXT)
Database Manager: Structure Initialization: CREATE TABLE Firefighters(id INTEGER PRIMARY KEY,PI_FirstName TEXT,PI_MiddleName TEXT,PI_LastName TEXT,PI_LocalID TEXT,PI_StateID TEXT,PI_Address TEXT,PI_City TEXT,PI_State TEXT,PI_ZipCode TEXT,PI_Status TEXT,PI_Hphone TEXT,PI_Wphone TEXT,PI_Cphone TEXT,PI_DrvLic TEXT,PI_CDL TEXT)
Database Manager: Structure Initialization: CREATE TABLE training(id INTEGER PRIMARY KEY,title TEXT)
Database Manager: Structure Initialization: CREATE TABLE fftraining(id INTEGER PRIMARY KEY,tid INTEGER,ffid INTEGER,ffesig TEXT,supesig TEXT,tdate TEXT,FOREIGN KEY(tid) REFERENCES training(id),FOREIGN KEY(ffid) REFERENCES firefighters(id))
Database Manager: Structure Initialization: CREATE TABLE equipment(id INTEGER PRIMARY KEY,title TEXT)
Database Manager: Structure Initialization: CREATE TABLE ffequipment(id INTEGER PRIMARY KEY,eqid INTEGER,ffid INTEGER,issued INTEGER,size TEXT,type TEXT,serial TEXT,year TEXT,FOREIGN KEY(eqid) REFERENCES equipment(id),FOREIGN KEY(ffid) REFERENCES firefighters(id))
Database Manager: Structure Initialization: CREATE TABLE Drills(id INTEGER PRIMARY KEY,DI_StartTime INTEGER,DI_DrillNumber TEXT,DI_EndTime INTEGER,DI_Location TEXT,DI_InHouse INTEGER,DI_IncidentCommander TEXT,DI_Description TEXT)
Database Manager: Structure Initialization: CREATE TABLE drillsheet(id INTEGER PRIMARY KEY, did INTEGER,ffid INTEGER,timein TEXT,timeout TEXT,FOREIGN KEY(did) REFERENCES drills(id) ,FOREIGN KEY(ffid) REFERENCES firefighters(id))
Database Manager: Structure Initialization: CREATE TABLE inventory(id INTEGER PRIMARY KEY,name TEXT,description TEXT,category TEXT)
Database Manager: Structure Initialization: CREATE TABLE inventorycheck(id INTEGER PRIMARY KEY,iid INTEGER,name TEXT,description TEXT,category TEXT,checked INTEGER)
QSqlQuery::prepare: empty query
Database Manager: Executing Query: 
Database Manager: Could not create table 'Calls': No query Unable to fetch row
Setup: Critical Error - Database: Could not be created.
QSqlDatabasePrivate::removeDatabase: connection 'qt_sql_default_connection' is still in use, all queries will cease to work.

Query preparation verification

With prepared statements, QSqlQuery::prepare() will fail on SQL syntax errors, which QSqlQuery::exec() will not catch (it will fail for not having the right number of parameters). Currently, almost none of the prepare() calls are checked for return value.

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.