where are the commands located

[azog]

I may have messed something up or something may have changed. In the database there is a table called commands that has stuff in it in my older database, in the new one it is empty.

Are they found somewhere else now, or should I try and figure out how To get the old command table into the new database?

[Vexyl]

Did you source the user_tables SQL file into the database?

[azog]

Originally Posted by Vexyl

Did you source the user_tables SQL file into the database?

yes I did,



lanys T'Vyl

[rencro]

The daily dumps commands table only has 2 columns, assuming you are doing a new db, and after sourcing the db, you then source the user_tables. The new commands table with the missing column being "descriptions", the one that describes the commands, which I assume the peq guys dont need or want...If you like you could grab the descriptions from the old commands sql in the 2506 svn in the user tables folder...

I havent diffed them for a while, but from about a month ago the tables were alike, sans the 3rd description column.. You could either drop commands table, then source the commands.sql from the 2506 user tables folder to get them back, with descriptions included...Or import the 2506 commands into a temp db, then run a query that updates the current table with the description info from the old commands table...Myself I just drop commands then source the old one...

But the new commands table are source in when you source the user_table##### sql from the daily dumps...But I havent done this in over a month so not sure if anything changed..

EDIT....Did you refresh the view after sourcing in the user tables???

[azog]

it was an empty table so i sourced a diff in from my backup database now its full of commands with descriptions. I just didn't want to mess anything up by doing that.


I wonder where it is getting the current command sets from?