Results 1 to 7 of 7

Thread: Which tables does vBa use specifically ?

  1. #1
    Junior Member
    Join Date
    Jul 2005
    Posts
    10

    Default Which tables does vBa use specifically ?

    Hi,

    I've added a load of pages to my site on my dev machine at home, and I want to add them to my real website without having to manually set them all up. I don't really want to export the whole database as it huge, just the tables with the page and module info. Both my installations and databases are identical, the only difference being the one at home has the extra pages and modules installed. Vba is installed on both sites, so the tables are all setup.

    What tables do I need to export and then import ? I tried exporting all the tables with an adv_ prefix, ie

    adv_modules
    adv_pages
    adv_setting
    adv_setting group

    But it didn't work for some reason, my index page looks exactly the same, although in the admincp the modules and pages are there...

    Am I missing a table somewhere ?

    Any help or info would be much appreciated, useful for anyone else who wants to backup their cmps only files without backing up the whole forum database.

    Cheers

  2. #2
    Administrator Brian's Avatar
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,460

    Default Re: Which tables does vBa use specifically ?

    That would be all of the tables. Though you probably need to save one of your modules and pages to update the cache for those.

  3. #3
    Junior Member
    Join Date
    Jul 2005
    Posts
    10

    Default Re: Which tables does vBa use specifically ?

    Thanks Brian, I tried that and it didn't work unfortunately In particular, I have added a 'welcome message' type bb module that displays on the index.php page, it works on my home PC but not my website. I can still see the module and edit it using the vbacmps on the website, but it mysteriously wont show on the front page

    Does anyone else have this problem when they develop at home and then install onto a website ? I can't be the only person in the world that does this

    P.s, the pages work fine now, its the modules that won't show.

  4. #4
    Administrator Brian's Avatar
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,460

    Default Re: Which tables does vBa use specifically ?

    Admin CP => vBa CMPS => Edit Pages => Default / Homepage => Modules Enabled

    Have you made sure that the module is active on that page?

  5. #5
    Junior Member
    Join Date
    Jul 2005
    Posts
    10

    Default Re: Which tables does vBa use specifically ?

    yep, I checked that. I also did a line by line comparison of the adv_ tables and they were identical.

    When the index is displayed, what table does it look up to see which modules are displayed ? I assume it adv_modules ?

  6. #6
    Administrator Brian's Avatar
    Join Date
    Jan 2004
    Location
    Georgia, USA
    Posts
    34,460

    Default Re: Which tables does vBa use specifically ?

    The modules are stored in the datastore table to help cut down on the number of queries. As long as you've saved a module through the admin cp though that should update the cache for them.

  7. #7
    Junior Member
    Join Date
    Jul 2005
    Posts
    10

    Default Re: Which tables does vBa use specifically ?

    I had a look at the datastore previously and tried exporting / importing it whole but it crashed the database ( it was worth a try ). I think thats where the problem lies anyway. I'll have another look at the datastore and see if I've messed it up in some way, as the cache isn't updating.

    Cheers !

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Messed up tables
    By dmbooth0310 in forum Troubleshooting & Problems
    Replies: 2
    Last Post: 08-12-2005, 06:13 PM
  2. Broken tables
    By Gmrx in forum Troubleshooting / "How do I..." Questions
    Replies: 1
    Last Post: 07-06-2005, 11:20 AM
  3. Tables Widths
    By dieselpowered in forum Troubleshooting / "How do I..." Questions
    Replies: 4
    Last Post: 01-10-2005, 01:39 AM
  4. Broken Tables?
    By BruceWest in forum Troubleshooting / "How do I..." Questions
    Replies: 1
    Last Post: 01-02-2005, 09:49 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •