[rt-users] RTFM - Database Schema

[Ben Butler]

Hi,

Further difficulties...

I have located a file schema.html in the docs directory under the extracted
RTFM-2.0.4.tar.gz

Good stuff I think, I will create the tables by hand.

Although it is apparent that the schema descibed about does not match the
actaul structure.  I am now getting the following error:

Couldn't execute the query 'INSERT INTO FM_Classes (LastUpdatedBy,
SortOrder, Created, Name, Description, Creator, LastUpdated) VALUES (?, ?,
?, ?, ?, ?, ?)'Unknown column 'LastUpdatedBy' in 'field list' 

Where as the file describes the table as:

FM_Classes

Fields:
id INTEGER NOT NULL AUTO_INCREMENT 
Name varchar(255) NULL 
Description varchar(255) NULL 
SortOrder integer NULL 
Disabled int(2) not null default '0' 

Feeling a little stuck now.

Kind Regards

Ben

-----Original Message-----
From: Ben Butler [mailto:ben.butler at c2internet.net] 
Sent: 14 January 2005 12:46
To: rt-users at lists.bestpractical.com
Subject: [rt-users] RTFM - Database Schema

Hi,

I am running Debian sarge / apache 2 / mysql.

RT is all installed and working fine.

Installed RTFM by doing an apt-get

Restarted apache

And I now have the RTFM item in the menu, so all looks good.

However when trying to create a class I get an error:

RTFM Error     
Internal Error: Couldn't execute the query 'INSERT INTO FM_Classes
(LastUpdatedBy, SortOrder, Created, Name, Description, Creator, LastUpdated)
VALUES (?, ?, ?, ?, ?, ?, ?)'Table 'rtdb.FM_Classes' doesn't exist  

Upon investigation I discover that the table does not exist in the database.
I suspect that it has not created the database schema for any extra tables.

Is it possible to run something to initialise the database for the extra
tables?


Kind Regards

Ben Butler
++++++++++++++++++++++++++++++++++++++
C2 Internet Ltd
Alvaston House
Alvaston Business Park
Nantwich
Cheshire
CW5 6PF
W http://www.c2internet.net/
T +44-(0)845-658-0020
F +44-(0)845-658-0070

All quotes & services from C2 are bound by our standard terms and conditions
which are available on our website at:

http://www.c2internet.net/legal/main.htm#tandc

_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users

Be sure to check out the RT wiki at http://wiki.bestpractical.com

- ---------------------------------------------------------
 C2i Business Internet           http://www.c2internet.net/
 ----------------------------------------------------------
 This message has been checked for all known viruses by the  MessageLabs
Virus Scanning Service.
 ----------------------------------------------------------

- ---------------------------------------------------------
 C2i Business Internet           http://www.c2internet.net/
 ----------------------------------------------------------
 This message has been checked for all known viruses by the  MessageLabs
Virus Scanning Service.
 ----------------------------------------------------------