Blog Documentation Book a Demo
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?

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

Comments

  • VanillaHostVanillaHost
    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.
  • NinaNina
    but some extensions are hard coded ... be aware of that.
  • MinisweeperMinisweeper New
    If you could make a list of extensions which are it could be useful cause they really aught to be changed.
  • VanillaHostVanillaHost
    I'll go through the ones I have installed and post any which are hardcoded. Thanks for the heads up.
  • 130130
    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.
  • VanillaHostVanillaHost
    130, Thanks. I'll see if the $DatabaseTables['User'] setting helps any. BBInsertBar is hardcoded too. Will keep looking.
  • VanillaHostVanillaHost
    BBInsertBar, ShortStat are the only two which are hardcoded (that I'm using). The $DatabaseTables['User'] setting worked well, thanks!
  • lechlech ✭
    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.
  • VanillaHostVanillaHost
    Let's hope so. :)
  • ToivoToivo New
    mark should change install screens so user could input prefix ... ? or what about the forum hosting poject?
  • lechlech ✭
    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.
  • JazzmanJazzman
    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.