Table does not exist

This topic contains 15 replies, has 3 voices, and was last updated by  Kiran 4 years, 7 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
  • Author
    Posts
  • #506914

    pinkgecko
    Free User
    Post count: 47

    Hi again,
    It’s me.

    I’ve discovered that the Countries table does not exist. Maybe that’s why I’m having so many problems with displaying the address.

    I am providing log in details next. Here is a screenshot of the error via the status page.
    Thanks
    Lucinda

    #506916

    pinkgecko
    Free User
    Post count: 47
    This reply has been marked as private.
    #506955

    Alex Rollin
    Moderator
    Post count: 27815

    Please give the user Network Admin so we can check the settings.

    If you have network activated GD, then please network deactivate and reactivate on the subsite.

    Once that is done try running the “Clear version numbers” tool in

    GD – Status – Tools

    #506974

    pinkgecko
    Free User
    Post count: 47

    Hi again Alex,

    I’ve allocated Super Admin rights to the User. (root directory pgc-dev.com). I’m just recreating the environment this will be displayed eventually.

    The plugin wasn’t network activated initially, only on that site, and I already ran all the tools and nothing repaired it.

    I’ll hand back over to you, if I may…

    Thanks!
    Lucinda

    #507234

    Alex Rollin
    Moderator
    Post count: 27815

    Please share FTP credentials so we can do some additional debugging.

    Did you mean to remove the address field from both post types?

    #507260

    pinkgecko
    Free User
    Post count: 47
    This reply has been marked as private.
    #507261

    Alex Rollin
    Moderator
    Post count: 27815
    This reply has been marked as private.
    #507262

    pinkgecko
    Free User
    Post count: 47

    In answer to your question regarding address field, my original plan was to display the country for each Exhibitor.I wanted it so the Exhibitor only had to select the country their shop was located in and so I’d deactivate city and regions. It nearly worked (with Locations add on too) but kept on giving me two country dropdown menus. It just didn’t work. In the end I had to create my own dropdown menu listing all the countries. I have called that “registered_country” and I’ve deactivated the “address” field completely. I renamed the address field label to “Country” in case you are wondering and it’s at the very bottom of the Exhibitor Listings CPT Settings.

    This is OK for now as I”ve no time to fiddle anymore and I don’t think the plugins will work how I want. I just want it fixed so when I migrate it to the real site it doesnt break.

    Hope that makes sense.
    Lucinda

    #507457

    pinkgecko
    Free User
    Post count: 47

    How long does this take? I receive responses on some subjects within hours and only this takes days and days…

    #507463

    Alex Rollin
    Moderator
    Post count: 27815
    This reply has been marked as private.
    #507598

    Kiran
    Moderator
    Post count: 7069

    Hi pinkgecko,

    We have fixed issue. Countries table created for main site and it is used within network sites.

    Kiran

    #507655

    pinkgecko
    Free User
    Post count: 47

    Awesome. Thanks so much. Everything seems to be working much better now too.

    It’s a fab plugin. Thanks for all your hard work on it.

    #508249

    pinkgecko
    Free User
    Post count: 47

    I’ve got the exact same problem again… on a new install on a different site.

    I think this is a bug.

    I also cannot uninstall the plugin from the Network admin level or the site level. So I’m stuck with all these extra tables in my DB that are just bloat.

    Can you help? I would like to get some feedback/explanation before I hand over the login details as I would like to know how this was fixed in the first place so I can fix it myself instead of waiting a week for you to fix it. Do you think you can share that info?

    #508275

    Alex Rollin
    Moderator
    Post count: 27815

    Deleting the tables and re-installing from a subsite or transfer field values in the db as needed.

    Let us know if you still need help with this.

    #508302

    pinkgecko
    Free User
    Post count: 47

    I do! I really do. The tables are a mess now.

    But I’ve had no time and had to rebuild the entire thing. I’ve left all the old tables there.

    It works so I’m going to push this back. I’m sending you another query instead.

Viewing 15 posts - 1 through 15 (of 16 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket