[rt-users] RTFM - Database Schema

[Ruslan U. Zakirov]

Ben Butler wrote:
> 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.
read debian package description there should be instructions.

> 
> 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