search

magicbug / Cloudlog

Web based amateur radio logging application built using PHP & MySQL supports general station logging tasks from HF to Microwave with supporting applications to support CAT control.
http://www.cloudlog.co.uk
MIT License
460 stars 190 forks source link

Database Error Adding QSO #102

Closed m1geo closed 12 years ago

m1geo commented 12 years ago

When trying to add a QSO, I receive the following error

http://www.george-smart.co.uk/Cloudlog/index.php/qso

A Database Error Occurred Error Number: 1146

Table 'loggerdb.cat' doesn't exist

SELECT id, radio FROM (cat)

Filename: /var/www/Cloudlog/models/cat.php

Line Number: 55

This from a fresh install via git clone, on Sunday 20 May 2012, ~9:40pm. The file mentioned does not exist, and I could not find it anywhere.

George, M1GEO.

magicbug commented 12 years ago

George,

This is my fault.. we've added a new table run the following

CREATE TABLE IF NOT EXISTS cat ( id int(11) NOT NULL AUTO_INCREMENT, radio varchar(250) NOT NULL, frequency int(11) NOT NULL, mode varchar(10) NOT NULL, timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (id) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

Its come about due to the attention of building in basic cat support with a desktop application

Pete

m1geo commented 12 years ago

That's no problem. Fixed it right away. Cheers mate! :)

magicbug commented 12 years ago

No problem, hopefully have some sort of CAT application released soon.