Support Archive (5)

Important!!!    Check actual Support Forum, if you need to ask a Questions.

  1. Where in the database does booking calendar store:

    Season Filters
    Valuation Days

    I would like to export the tables into my new booking calendar website DB

    • Hello.

      Here is general info about migrate process (in case if you will not make fully identical transfer).

      1) You need to inform us about old and new url of websites for your Booking Calendar version.

      2) You need to transfer the Booking Calendar files from the ../wp-content/plugins/{Booking Calendar Folder} of old website to new website.

      According transfer of the Booking Calendar Data.

      3) Please backup and restore to the new site the DB tables that is starting from the "wp_booking" term, for example using the phpMyAdmin tool.

      Please watch this video guide about this export: https://youtu.be/4425kRMaFso

      4) Also you will be need to backup and restore some records from the wp_options table, where option_name fields are starting from the "booking_" term.

      Please watch this video guide about this export: https://youtu.be/EZ4jxJDlTFs

      Helpful tip from video guide. In the old database you need to execute this SQL in your phpMyAdmin tool.

      SELECT * FROM `wp_options` WHERE `option_name` LIKE 'booking%'

      After this you can export SQL file for importing in your new database.

      5) You can make such migrate from one to other website only once. And of course you need to delete the Booking Calendar version at old website.

      P.S. You can check more about where is saving bookings data here: https://wpbookingcalendar.com/faq/where-is-saving-booking-data-gdpr/
      Kind Regards.

      • Hello,

        I'm using Booking Calendar 8.4.4 Large, on the old site, and the new site.

        I have properly transferred the plugin properly, to the new website design.

        I exported only the "_booking" tables and the accompanying data (with PHPMYADMIN)

        I received the following error when importing the .sql file into the new DB using PHPMYADMIN

        -- --------------------------------------------------------

        --
        -- Table structure for table `wp_booking`
        --

        CREATE TABLE `wp_booking` (
        `booking_id` bigint(20) UNSIGNED NOT NULL,
        `trash` bigint(10) NOT NULL DEFAULT '0',
        `sync_gid` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
        `is_new` bigint(10) NOT NULL DEFAULT '1',
        `status` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
        `sort_date` datetime DEFAULT NULL,
        `modification_date` datetime DEFAULT NULL,
        `form` text COLLATE utf8mb4_unicode_ci,
        `hash` text COLLATE utf8mb4_unicode_ci,
        `booking_type` bigint(10) NOT NULL DEFAULT '1',
        `remark` text COLLATE utf8mb4_unicode_ci,
        `cost` float(15,2) NOT NULL DEFAULT '0.00',
        `pay_status` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
        `pay_request` smallint(3) NOT NULL DEFAULT '0'
        ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci

        • Hello.
          I do not see here errors. It’s more like log.
          Kind Regards.

          • MySQL said: Documentation

            #1050 - Table 'wp_booking' already exists

            • Hello.
              You was note removed the tables of previous version of Booking Calendar.

              1) In case, if you have installed and activated the version of Booking Calendar at this website, so then you need to make full deactivation of the plugin (its means that booking data will be erased).
              For this open the general booking settings page and set checked option "Delete booking data during deactivation of plugin" at the right side.
              Then open the WordPress plugins menu and click on "Deactivate" link. Wait for the message that plugin is deactivated successfully.

              Now, you can follow YouTube instruction about transfer booking data.

              2) Otherwise you need to delete the Booking Calendar tables (check more here https://wpbookingcalendar.com/faq/where-is-saving-booking-data-gdpr/ ) manually by using phpMyAdmin tool. And then follow YouTube instruction about transfer booking data.
              Kind Regards.

  2. Hi
    I installed the plugin successfully and have two booking already . The dates number is ok but the days is wrong. 2 Nov 2019 is a Saturday but in the registration page it is showing that Nov 2nd is Friday!

    http://janbi.me/%D8%A7%D8%AD%D8%AC%D8%B2-%D9%85%D9%88%D8%B9%D8%AF-%D9%85%D8%B9-%D8%A7%D9%84%D8%A8%D9%88%D8%AF%D9%83%D8%A7%D8%B3%D8%AA/

    Also the Plugin is showing in Arabic language. i like to have it in English as the Arabic translation is using names that are correct but not common to all and not used much.

    • Hello.
      It seems, like issue in translation of week days. For fixing this issue, please make this customization:
      Please open this file ../\wp-content\plugins\booking\js\datepick\jquery.datepick-ar.js

      ( you can check how to edit files in WordPress menu in this article https://wpbookingcalendar.com/faq/how-edit-file-in-wp-menu/ )

      then find this code:

      dayNames: ['السبت', 'الأحد', 'الاثنين', 'الثلاثاء', 'الأربعاء', 'الخميس', 'الجمعة'], dayNamesShort: ['سبت', 'أحد', 'اثنين', 'ثلاثاء', 'أربعاء', 'خميس', 'جمعة'], dayNamesMin: ['سبت', 'أحد', 'اثنين', 'ثلاثاء', 'أربعاء', 'خميس', 'جمعة'],

      and replace it to this code:

      dayNames: [ 'الأحد', 'الاثنين', 'الثلاثاء', 'الأربعاء', 'الخميس', 'الجمعة', 'السبت'], dayNamesShort: [ 'أحد', 'اثنين', 'ثلاثاء', 'أربعاء', 'خميس', 'جمعة', 'سبت'], dayNamesMin: [ 'أحد', 'اثنين', 'ثلاثاء', 'أربعاء', 'خميس', 'جمعة', 'سبت'],

      2) In case, if you want to skip showing Arabic language there, so then please rename this file jquery.datepick-ar.js to some other, like jquery.datepick-SKIP.js

      In this case, system will load the default English file with English text.
      Kind Regards.

      • Hi
        Thanks for the prompt reply

        i gone into the Admin WP editor and did the changes i need on the days and months. Saved it but no changes will happen on the front end of the WP site

        Changes done:

        monthNames: ['يناير', 'فبراير', 'مارس', 'ابريل', 'مايو', 'يونيو',
        'يوليو', 'أغسطس', 'سبتمبر', 'أكتوبر', 'نوفمبر', 'ديسمبر'],
        monthNamesShort: ['1','2','3','4','5','6','7','8','9','10','11','12'],
        monthStatus: 'عرض شهر آخر', yearStatus: 'عرض سنة آخرى',
        weekHeader: 'أسبوع', weekStatus: 'أسبوع السنة',
        dayNames: [ 'الأحد', 'الاثنين', 'الثلاثاء', 'الأربعاء', 'الخميس', 'الجمعة', 'السبت'],
        dayNamesShort: [ 'أحد', 'اثنين', 'ثلاثاء', 'أربعاء', 'خميس', 'جمعة', 'سبت'],
        dayNamesMin: [ 'أحد', 'اثنين', 'ثلاثاء', 'أربعاء', 'خميس', 'جمعة', 'سبت'],
        dayStatus: 'اختر DD لليوم الأول من الأسبوع', dateStatus: 'اختر D, M d',

        • Hello.
          1) Please do not forget to clear browser cache before testing these changes.

          2) The week days must start from "Sunday", like this:
          dayNames: ['Sunday', 'Monday', 'Tuesday', 'Wednesday', 'Thursday', 'Friday', 'Saturday'], dayNamesShort: ['Sun', 'Mon', 'Tue', 'Wed', 'Thu', 'Fri', 'Sat'], dayNamesMin: ['Su','Mo','Tu','We','Th','Fr','Sa'],

          • i did and used deferant browser and deferant computer

            • Hello.
              In your page the 2nd of November 2019 is showing as Saturday, right now, which is correct week day.
              Kind Regards.

          • Hello.
            In your page the 2nd of November 2019 is showing as Saturday, right now, which is correct week day.
            Kind Regards.

            • English is solved thanks. Arabic not but no issue happy as it is. Nothing is perfect

  3. Hi,
    I have bought Dev multi license for 2 site, now I want to upgrade it to 5 site
    could you please explain how to do that and how much to pay for extra.

    Thanks

  4. while doing a booking a get this error

    Error during inserting into BD - Dates
    [F:/wpbc-booking-new.php| L:430|V:9.Business.Small.Developer.8.6| DB:Duplicate entry 34-2019-12-30 00:00:00 for key booking_id_dates::INSERT INTO wabk_bookingdates (booking_id, booking_date, approved) VALUES (34, 2019-12-30 00:00:00, 0 ), (34, 2019-12-30 00:00:00, 0 )]

    • Hello.

      It’s seems that you incorrectly configured times at the Booking > Settings > Form page
      or in case if you have activated change over days the Booking > Settings General page in calendar section.
      You can check this troubleshooting instruction about this issue in FAQ here http://wpbookingcalendar.com/faq/duplicate-entry-key/

      Kind Regards.

  5. my booking calendar shows a "error 0" after someone tries to book. the calendar frequently times out after an attempt to book. I have 3 different calendars on my website and all of them show different dates booked and are not syncing together to show the same bookings. Clients often complain their booking didn't go through and the day doesn't show pending.

    help.

    • Hello.
      1) Relative error 0, please check here http://wpbookingcalendar.com/faq/0-error/

      2) I do not sure that clearly understand relative sync calendar at your website. Do you need to import or export bookings from other sources ? If yes then check this.
      Booking Calendar plugin is supporting

      - import of events via .ics feeds from Google Calendar ( or Airbnb or any other calendar that support .ics format, like iCal application)

      - and export bookings to .ics feeds (files), which possible to import in Google Calendar (or Airbnb, Booking.com, HomeAway, TripAdvisor, VRBO, FlipKey and any other calendar that uses .ics format ).

      Please read more about this feature here: https://wpbookingcalendar.com/faq/#sync

      Import.
      Please check about the configuration of import events from .ics feeds in this FAQ instruction here https://wpbookingcalendar.com/faq/import-ics-feeds/
      Please note, the import process is working in that case, when some visitor is open your website page with booking import shortcode. So you can configure CRON at your server, for periodically access this page with booking import shortcode to start import process. Or you can insert the import shortcode before booking form shortcode, so firstly system will start import process and only then show booking form, when someone visit your page.
      In case if you are having some issue of not ability to import new events, then check this troubleshooting instruction: https://wpbookingcalendar.com/faq/ics-importing-issue/

      You can define CRON at your server for periodically access pages with import .ics feeds shortcodes and start import process during specific time-intervals, then check this: https://wpbookingcalendar.com/faq/cron-script/

      Export.
      Please check about the configuration of export .ics feeds in this FAQ instruction here https://wpbookingcalendar.com/faq/export-ics-feeds/
      Booking Calendar is generate .ics feed with bookings in real time. But how often some service (like airbnb, or booking.com ) access this .ics feed to import the bookings from Booking Calendar into own system, does not depend from Booking Calendar. So in other words, Booking Calendar does not force to generate import process by third party service, when some booking is created. You need to check with support of this service (like airbnb or booking.com), about how often they can access the .ics feed tor making import.

      3) If you do not see the booked dates in calendar at the front-end, please open the General Booking Settings page and in the “Advanced section”, please be sure that you have not activated this option: “Allow unlimited bookings per same day(s):”. This option must be unchecked. If its checked, please uncheck it and update the settings.

      Also this option “Use pending days as available” must be unchecked, as well. It’s located at the Booking > Settings General page in Advanced section.

      If you still will have this issue, please recheck for the any cache plugins, like “WP Super Cache” or “W3 Total Cache”. If you are using someone, please deactivate it or add the exception to the page with booking form for do not cache this page(s).

      Kind Regards.

    • Hello.
      Yes its possible.
      1) In the Booking Calendar Free version, open the Booking > Settings > Form page and select "Form at right side of calendar" option in the toolbar and then click on Save changes button.
      2) In paid versions of Booking Calendar, open the Booking > Settings > Form page and select "2 columns" form template in the toolbar and click on "Both" button to reset templaets then click on Save changes button.
      Kind Regards.

  6. I think I found a bug in your last version 8.6.
    When I make a booking, and choose to pay with Stripe V3, I am presented with a page where I can fill in my credit card information. On the upper left side of this page, I get a link. In your test page, you get the link that says: Stripe.com TEST
    When you click this link, you get the page on your demo-site that says that your payment was successful.
    On my site this also happens and if I check the booking, it says that the booking is successfully Payed with Stripe V3. However, the payment never took place.

    This is a pretty serious bug, because now I know that I have to check every booking in Stripe, if the payment really took place. Can you take a look at this?

      • And just for do not have misunderstanding, in case, if you are set the "Test" mode at the Booking > Settings > Payment > Stripe page,
        so of course the payment will not be take place. Its for test purpose only.
        You need to activate the Live payment mode at the Booking > Settings > Payment > Stripe page for receiving real payments.
        Kind Regards.

      • That is correctly configured.
        But when I click that link, it brings me to the /successful page. In your demo the same happens, check it out!

        • If you finish successfully payment, so it’s have to return to that page.
          And please recheck my previous comment.
          Kind Regards.

          • I am "live" and when I make a booking, and press the button "Pay with Stripe", I get this page from Stripe, and when I press this link on the upper left corner (just like the one in your demo), I get the page /successfully (like in your demo).
            But when I look at the admin-page, I see that the booking says: "Payment Stripe_v3:OK" and that is a "live" situation!

            Maybe other customers should test it, too?

            • Hello.
              Other customers use this integration for the start of Summer, and we have not received the similar issue like your explained.

              Just to summarize, during payment with Stripe, if you have failed payment (clicked cancel during payment with Stripe or just close page) on live mode, you have returned to the successfully paid page and update booking status with Paymrnt Ok?
              Kind Regards.

              • Look in your demo Booking Calendar business medium. Look in the admin panel at the booking that Demo Tester made on the 25th of October. It's booking number 9. What do you see? Is the Payment Paid OK?

                It happens on my site, it happens on your site. Maybe nobody noticed until now, but it's there.

                • Hello.
                  Yes, you are right. We will fix it in next update of Booking Calendar.
                  In actual versions of Booking Calendar you can fix this by making this customization.
                  Please open this file ../wp-content/plugins/{Booking Calendar Folder}/inc/gateways/stripe_v3/wpbc-gw-stripe_v3.php

                  ( you can check how to edit files in WordPress menu in this article https://wpbookingcalendar.com/faq/how-edit-file-in-wp-menu/ )

                  then find this code:

                  if ( ( 'payment' === $response_type ) && ( WPBC_STRIPE_V3_GATEWAY_ID === $response_source ) ) {

                  and replace it to this code:

                  if ( ( 'payment' === $response_type ) && ( WPBC_STRIPE_V3_GATEWAY_ID === $response_source ) ) { //FixIn: 8.6.1.23 // Get here list of all success payment sessions in Stripe ! if ( version_compare( PHP_VERSION, '5.4' ) < 0 ) { echo 'Stripe (v.3) payment require PHP version 5.4 or newer!'; return; } if ( ! class_exists( 'Stripe\Stripe' ) ) { require_once( dirname( __FILE__ ) . '/stripe-php-master/init.php' ); } $payment_options = array(); // Get Secret key $stripe_v3_account_mode = get_bk_option( 'booking_stripe_v3_account_mode' ); if ( 'test' == $stripe_v3_account_mode ) { $payment_options[ 'secret_key' ] = get_bk_option( 'booking_stripe_v3_secret_key_test' ); } else { $payment_options[ 'secret_key' ] = get_bk_option( 'booking_stripe_v3_secret_key' ); } // Check whether secret key was assigned, Otherwise -- ERROR if ( empty( $payment_options['secret_key'] ) ) { echo 'Wrong configuration in gateway settings.' . ' <em>Empty: "Secret key" option</em>'; return; } //////////////////////////////////////////////////////////////////////// // Step 1. Back-End: Create a Checkout Session on your server - https://stripe.com/docs/payments/checkout/server#integrate //////////////////////////////////////////////////////////////////////// \Stripe\Stripe::setApiKey( $payment_options[ 'secret_key' ] ); //////////////////////////////////////////////////////////////////////// // Step 2. Back-End: Create a Checkout Session on your server - https://stripe.com/docs/payments/checkout/fulfillment#polling //////////////////////////////////////////////////////////////////////// $events = \Stripe\Event::all([ 'type' => 'checkout.session.completed', 'created' => [ 'gte' => time() - 24 * 60 * 60, // Check for events created in the last 24 hours. ], ]); $is_payment_for_this_booking_exist = false; foreach ( $events->autoPagingIterator() as $event ) { $session = $event->data->object; if ( $booking_hash == $session->client_reference_id ) { $is_payment_for_this_booking_exist = true; break; } } if( false === $is_payment_for_this_booking_exist ) { // Not Paid, yet wpbc_redirect( get_home_url() ."?error=Unknown-Stripe-Payment" ); return; } //End FixIn: 8.6.1.23
                  Kind Regards.

  7. Is there a way to change color of the booking in the calendar based on location?

    • Hello.

      Unfortunately, its does not possible. Sorry.
      Kind Regards.

  8. Hi support,

    When I import HomeAway .ics-file, the last day of a period is not imported. What parameter do I have to add to the shortcode to get it right?

    Thanks.

    • Hello.
      Please open the Booking > Settings > Sync > “General” page and Set checked this option “Append check out day”.
      Kind Regards.

      • Hi,

        I have already more calendars synced. And they are synced right. When I check this option "Append check out day", will it not affect my other calendar synchonizations?

        • Hello.
          It’s apply to all calendars.
          It’s means that some of your ics feeds (some service) provide ics feeds with dates in different rule. You need to contact support of that service if it’s possible to fix in that ics feed.
          Kind Regards.

  9. Hi,

    I just upgrade to the personal version and I am a bit confused how to manage my different resources. I simply want to add my available days for each and every resource but I do not see where I can do this.

    Thank you for your support