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, 7 months ago.

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

Open Support Ticket
  • Author
    Posts
  • #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

    #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.

    #480906

    Paolo
    Site Admin
    Post count: 31206

    Please provide admin credentials.
    Thanks

    #481804

    wci
    Expired Member
    Post count: 1035
    This reply has been marked as private.
    #481810

    Alex Rollin
    Moderator
    Post count: 27815

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

    Thanks

    #481817

    wci
    Expired Member
    Post count: 1035
    This reply has been marked as private.
    #482076

    Kiran
    Moderator
    Post count: 7069
    This reply has been marked as private.
    #482213

    wci
    Expired Member
    Post count: 1035
    This reply has been marked as private.
    #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

    #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

    #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

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
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount