Error in RTFM Administration

RT Users
1

Hi RT Users,

i get a strange error in our RTFM installation:

Whenever I try to create an class in FAQ. I get the following error message.

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

I’m not sure whats wrong, because, the RTFM is installed and untouched since one year…argh…

Thanks

Torsten

2

Most probably you forgot to upgrade DB as
etc/upgrade/2.2.0RC2/schema.* files add this column to the table.On 2/5/07, Ham MI-ID, Torsten Brumm torsten.brumm@kuehne-nagel.com wrote:

Hi RT Users,

i get a strange error in our RTFM installation:

Whenever I try to create an class in FAQ. I get the following error message.

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

I’m not sure whats wrong, because, the RTFM is installed and untouched since one year…argh…

Thanks

Torsten

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

Best regards, Ruslan.

3

Hi Ruz,

thanks, that was the pouint.

Thanks2007/2/5, Ruslan Zakirov ruslan.zakirov@gmail.com:

Most probably you forgot to upgrade DB as
etc/upgrade/2.2.0RC2/schema.* files add this column to the table.

On 2/5/07, Ham MI-ID, Torsten Brumm torsten.brumm@kuehne-nagel.com wrote:

Hi RT Users,

i get a strange error in our RTFM installation:

Whenever I try to create an class in FAQ. I get the following error
message.

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

I’m not sure whats wrong, because, the RTFM is installed and untouched
since one year…argh…

Thanks

Torsten

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

–
Best regards, Ruslan.

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

MFG

Torsten Brumm

http://www.torsten-brumm.de

4

Hi RT Users,

i get a strange error in our RTFM installation:

Whenever I try to create an class in FAQ. I get the following error message.

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

I’m not sure whats wrong, because, the RTFM is installed and untouched since one year…argh…

Did you run all the upgrade scrips?

5

Hi Jesse,

nope i forgot some :frowning: Fixed it after a hint from Ruz.

Torsten2007/2/5, Jesse Vincent jesse@bestpractical.com:

On Mon, Feb 05, 2007 at 05:19:15PM +0100, Ham MI-ID, Torsten Brumm wrote:

Hi RT Users,

i get a strange error in our RTFM installation:

Whenever I try to create an class in FAQ. I get the following error
message.

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

I’m not sure whats wrong, because, the RTFM is installed and untouched
since one year…argh…

Did you run all the upgrade scrips?

Thanks

Torsten

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

–

The rt-users Archives

Community help: http://wiki.bestpractical.com
Commercial support: sales@bestpractical.com

Discover RT’s hidden secrets with RT Essentials from O’Reilly Media.
Buy a copy at http://rtbook.bestpractical.com

MFG

Torsten Brumm

http://www.torsten-brumm.de

6

Hi Jesse,

nope i forgot some :frowning: Fixed it after a hint from Ruz.

Sorry about that. That’s what I get for forgetting to turn on threaded
mode before replying to mail.