40% OFF EVERYTHING
BLACK FRIDAY SALE
Buy Now

Cant set default location

This topic contains 14 replies, has 4 voices, and was last updated by  Paolo 8 years, 8 months ago.

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

Open Support Ticket

Tagged: 

  • Author
    Posts
  • March 8, 2016 at 10:18 pm #136174

    Geoff Cox
    Free User
    Post count: 9

    I am so sorry to bother you but having installed this plug-in, I have tried the pain to the desired location to set the “default location”. However when I tried to save this it is insisting that I enter a “country”.

    When I select the drop down for “country”, there are no entries available except the prompt “select a country”. I’m not sure why I am not seeing any country to select.

    Your help would be greatly appreciated.

    My sincere thanks

    Geoff Cox

    March 8, 2016 at 10:22 pm #136176

    Guust
    Moderator
    Post count: 29970

    That suggests either a plugin conflict or the installation gone wrong a little and not installing the country list.
    If you de-activate other plugins, does it fix itself?
    Can you post your WP admin details and URL in a private reply, then we can start there.

    March 8, 2016 at 11:15 pm #136218

    Geoff Cox
    Free User
    Post count: 9
    This reply has been marked as private.
    March 9, 2016 at 3:27 pm #136686

    Paolo
    Site Admin
    Post count: 31206

    Hi,

    sorry about this, it appears that a database table is missing. Please provide FTP and phpmyadmin credentials and we will fix that.

    Let us know,

    Thanks

    March 10, 2016 at 1:11 pm #137228

    Geoff Cox
    Free User
    Post count: 9
    This reply has been marked as private.
    March 10, 2016 at 1:12 pm #137229

    Geoff Cox
    Free User
    Post count: 9
    This reply has been marked as private.
    March 10, 2016 at 10:12 pm #137602

    Guust
    Moderator
    Post count: 29970
    This reply has been marked as private.
    March 11, 2016 at 8:29 am #137683

    Geoff Cox
    Free User
    Post count: 9
    This reply has been marked as private.
    March 11, 2016 at 10:55 am #137698

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    HI Geoff,

    All the create tabel queries are failing, i guess the user does not have the correct permissions for the table, if you can give him create and modify permissions great or if you have some sort of hosting control panel i can take a look.

    Thanks,

    Stiofan

    March 16, 2016 at 1:00 pm #140934

    Geoff Cox
    Free User
    Post count: 9

    We have spoken with the web hosting company and they say that full permissions would have been given when the account was created. We don’t want to buy additional add-ons until the plug-in is working correctly so please please help us out.

    We can’t give you access to any other Control Panel as it would also give access to numerous other customer accounts. If you’re sure that it is a table issue then could you send the tables or even a complete database over to me and I can import it?

    Geoff

    March 16, 2016 at 2:29 pm #140962

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Hi Geoff,

    I managed to find the exact error being thrown “Unknown character set: ‘utf8mb4′” and it seems to be because your MySQL version is too old, you are running version: 5.0.83 WordPress recommends 5.6 https://wordpress.org/about/requirements/

    Once you upgrade your server then please go to GD>GT Tools>clear all version numbers, this will make the script install the missing databases.

    Thanks,

    Stiofan

    March 21, 2016 at 5:08 pm #143914

    Geoff Cox
    Free User
    Post count: 9

    Stiofan utf8mb4 is the newer character set used by WordPress.
    I tried changing to UTF8 and it broke the website.
    Why can we not use Geodirectory with the current utf8mb4 character set?

    Its really important.

    Geoff

    March 21, 2016 at 5:11 pm #143916

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Hi Geoff,

    What you said did not make sense… Did you update the server MySQL version?

    Stiofan

    March 21, 2016 at 9:06 pm #143999

    Geoff Cox
    Free User
    Post count: 9

    We dont have any ability to update the MySQL version. We either have to use V4 or V5 and we are using V5.

    Geoff

    March 21, 2016 at 9:16 pm #144001

    Paolo
    Site Admin
    Post count: 31206

    Hi,

    WordPress recommends 5.6 or newer. Your hosting provider is running version: 5.0.83.

    Either you ask to your hosting provider to update to a version that is recommended for WP to work well or in case they refuse to do so, the only option will be to move to a better hosting provider.

    We can’t make GD word with that version of MySQL.

    Thanks

  • Author
    Posts
Viewing 15 posts - 1 through 15 (of 15 total)

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

Open Support Ticket
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount