Blog Documentation Book a Demo

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.