Vanilla 1 is no longer supported or maintained. If you need a copy, you can get it here.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.

Database prefix?

edited July 2006 in Vanilla 1.0 Help
Is it possible to change the database prefix from LUM_ to something else? I don't remember seeing it when installing the forum, and I've checked the config files but I don't see anything.


  • You wouldn't believe. The minute I posted this, I found it in the change log. For the record, it's the "DATABASE_TABLE_PREFIX" setting.
  • but some extensions are hard coded ... be aware of that.
  • If you could make a list of extensions which are it could be useful cause they really aught to be changed.
  • I'll go through the ones I have installed and post any which are hardcoded. Thanks for the heads up.
  • In addition to $Configuration['DATABASE_TABLE_PREFIX'] setting in appg/settings.php, there is also $DatabaseTables['User'] setting in appg/database.php which must be changed too (otherwise Vanilla itself will use LUM_User database table).

    Some of hardcoded extensions are: MarkAllRead, Notify, SavedSearches.

    I think that good example of correct working with database is WhosOnline extension. It use SqlBuilder class from Vanilla Framework.
  • 130, Thanks. I'll see if the $DatabaseTables['User'] setting helps any. BBInsertBar is hardcoded too. Will keep looking.
  • BBInsertBar, ShortStat are the only two which are hardcoded (that I'm using). The $DatabaseTables['User'] setting worked well, thanks!
  • lechlech Chicagoland
    I think this might be a wake-up call to those writing extensions and hard-coding the prefix to update their code to utilize the prefix options.
  • Let's hope so. :)
  • mark should change install screens so user could input prefix ... ? or what about the forum hosting poject?
  • lechlech Chicagoland
    Changing the input prefix is more or less for advanced installs, it's unecessary to change it, although it would be nice as a feature durring the setup/upgrade but left as optional if nothing is specified where it defaulted to "LUM_" if nothing was chosen.
  • edited July 2006
    Mmm... you're right.. the table creations in my extensions are hardcoded... It does work with the $DatabaseTables thingy, but didn't pay attention on the create command :D Thanks for pointing that out ^^
This discussion has been closed.