GDv2 Upgrade Problem – Database error: [Unknown column 'country' in 'field list'

This topic contains 10 replies, has 5 voices, and was last updated by  Kiran 5 years ago.

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

Open Support Ticket

Tagged: ,

  • Author
    Posts
  • April 14, 2019 at 2:40 pm #480632

    wci
    Expired Member
    Post count: 1035

    Hi support team,

    after upgrade from GDv1 ot GDv2 I am getting the following failure displayed while add listings process.

    WordPress database error: [Unknown column ‘country’ in ‘field list’]
    INSERT INTO 

    ms_1_geodir_gd_accommodation_detail

    (

    post_title

    , 

    post_id

    , 

    post_status

    , 

    submit_ip

    , 

    city

    , 

    region

    , 

    country

    ) VALUES (‘Auto Draft’, ‘116927’, ‘auto-draft’, ‘24.134.1.125’, ‘New York City’, ‘New York’, ‘United States’)

    Notice: Undefined property: stdClass::$ID in /home/worldcheckin/public_html/wci.dev_2/wp-content/plugins/geodirectory/includes/custom-fields/functions.php on line 174

    Notice: Undefined property: stdClass::$post_status in /home/worldcheckin/public_html/wci.dev_2/wp-content/plugins/geodirectory/includes/custom-fields/functions.php on line 178

    URL: https://dev2.worldcheckin.com/add-listing/?listing_type=gd_accommodation&package_id=20

    Screenshot: https://nimb.ws/8PXRSw

    Please help me to solve the problem.

    Best, Alex

    April 15, 2019 at 2:10 pm #480854

    Kor
    Moderator
    Post count: 16516

    Hi Alex,

    Thanks for your post. I will forward this to a developer for a second look. In the meantime, please share both WP and FTP access here in private reply.

    April 15, 2019 at 5:46 pm #480906

    Paolo
    Site Admin
    Post count: 31206

    Please provide admin credentials.
    Thanks

    April 19, 2019 at 3:02 pm #481804

    wci
    Expired Member
    Post count: 1035
    This reply has been marked as private.
    April 19, 2019 at 3:44 pm #481810

    Alex Rollin
    Moderator
    Post count: 27815

    Login page is blank
    wp-login gives password error.
    Please reset, validate and repost

    Thanks

    April 19, 2019 at 5:31 pm #481817

    wci
    Expired Member
    Post count: 1035
    This reply has been marked as private.
    April 22, 2019 at 7:27 am #482076

    Kiran
    Moderator
    Post count: 7069
    This reply has been marked as private.
    April 23, 2019 at 6:03 am #482213

    wci
    Expired Member
    Post count: 1035
    This reply has been marked as private.
    April 23, 2019 at 8:22 am #482241

    Kiran
    Moderator
    Post count: 7069

    Hello,

    After upgrade from GDv1 ot GDv2 I am getting the following failure displayed while add listings process.

    Please check now.

    Just be informed we are also on the process of working at the dev site to establish the further usage of GT-Vouchers plugin for GDv2.

    Some functions are no longer available/depreciated in GeoDirectory v2, so please take of it.

    Kiran

    April 23, 2019 at 5:51 pm #482374

    wci
    Expired Member
    Post count: 1035

    Hi Kiran,

    thank you very much for solving.
    Can you please specify what you have done to solve this issue?

    1. Are you also able to give more info about
    “Some functions are no longer available/depreciated in GeoDirectory v2, so please take of it”

    2. Where can I get more info to pass those to my developer that he will be aware and is able to replicate or arrange the upgrade for the GT-Vouchers plugin.

    Best, Alex

    April 24, 2019 at 5:08 am #482455

    Kiran
    Moderator
    Post count: 7069

    Can you please specify what you have done to solve this issue?

    There was some fields are missing in gd_accommodation detail table(may be broken conversion due to conflict). I have debugged and fixed missing fields.

    —

    1. Are you also able to give more info about
    “Some functions are no longer available/depreciated in GeoDirectory v2, so please take of it”

    This is only required to know if you have done customization.
    Some functions like geodir_get_currency_sym(), geodir_get_currency_type(), geodir_get_package_info(), geodir_get_package_info_by_id() are depreciated(means no longer supported in v2). So if in your customization you have used these functions then you have to use relative function that supported in v2.
    You can find more functions in file /includes/deprecated-functions.php in each plugin.

    Let us know.

    Kiran

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

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

Open Support Ticket