40% OFF EVERYTHING
Our 10th BIRTHDAY SALE
Buy Now

Adding a place is not working

This topic contains 40 replies, has 3 voices, and was last updated by  Stiofan O’Connor 6 years, 1 month ago.

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

Open Support Ticket
  • Author
    Posts
  • March 21, 2018 at 11:47 am #422522

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    I got to the bottom of this, i’ll fix it today:
    https://github.com/AyeCode/geodirectory/issues/144

    Thanks,

    Stiofan

    March 21, 2018 at 11:48 am #422524

    Dirk
    Full Member
    Post count: 390

    WOW… I found the problem!!!!!!!!!!!!!!

    It is not working because GeoDir is not IPv6 compliant.

    Your try to save in the autodraft of the gd_place_detail also the IP address. But the IP address in the table is VARCHAR(20). An IPv6 address has 45 characters! So to be save I suggest to change to VARCHAR(50)!

    Now I’m dead.

    March 21, 2018 at 11:55 am #422527

    Dirk
    Full Member
    Post count: 390

    @stiofan,

    on this test server I still have a lot of outputs. Let me show you one 🙂

    These are the post arguments of the insert to the …gd_place_detail in file class-geodir-post-data function save_post.

    You can see that my IP is a IPv6 one and longer than 20 characters. This is why the insert is failing with IP set to VARCHAR(20).

    March 21, 2018 at 2:15 pm #422553

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Nice work man 🙂

    I have set it to varchar 100 (like WP uses)..
    So does it work if u manually set the column to 50 or above?

    Thanks,

    Stiofan

    March 21, 2018 at 3:43 pm #422571

    Dirk
    Full Member
    Post count: 390

    Yes, it worked in that moment I changed the scheme to VARCHAR(50).

    Could you please tell me in what release it will be. I will verify this again also with the sample data. I did 5 different WP/GDv2 installation and can do this again.

    Best,
    Dirk

    March 21, 2018 at 3:59 pm #422581

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Hi Dirk,

    Thanks for confirming 🙂
    This will be released in about 2-4 hours.

    Thanks,

    Stiofan

    March 21, 2018 at 4:08 pm #422585

    Dirk
    Full Member
    Post count: 390

    Cool. I will confirm.

    I have to verify, but at the moment I have the feeling that you create the auto-draft too early. I will check this once the new release is available (and of course this would be a new topic).

    Best,
    Dirk

    March 21, 2018 at 4:17 pm #422590

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    as with WP the auto-draft is created as soon as u visit the page.

    Stiofan

    March 21, 2018 at 4:23 pm #422593

    Dirk
    Full Member
    Post count: 390

    I will check and let you know. Also: “Auto-drafts are automatically deleted after 7 days of going unused. They’re self-cleaning, basically. No need to worry about them.”. Otherwise you get orphaned data.

    March 21, 2018 at 8:55 pm #422621

    Dirk
    Full Member
    Post count: 390

    🙂 Okay. It is working with V2.0.0.2 on a clean IPv6 installation! Thanks a lot!

    March 22, 2018 at 8:01 pm #422790

    Stiofan O’Connor
    Site Admin
    Post count: 22956

    Great, thank you very much for reporting and helping fix this 🙂

  • Author
    Posts
Viewing 11 posts - 31 through 41 (of 41 total)

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

Open Support Ticket