ben.butler at c2internet
Jan 14, 2005, 5:09 AM
Post #2 of 4
(1288 views)
Permalink
|
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]
Sent: 14 January 2005 12:46
To: rt-users [at] lists
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.
----------------------------------------------------------
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Be sure to check out the RT wiki at http://wiki.bestpractical.com
|
