Appointments+ Plugin, Cannot add Providers, Default content missing

Hello, recently installed the plugin. No issues on installation, all features seem to work but one.

I cannot add providers. When i click the add a provider button a new row appears in the table. But When i click save it does add the record, and instead clears the table completely.

Additionally the notes and tutorial say that there will be a default provider and services, non of these things are here. Also It seems a few of the buddy press components may not be active because of the the missing provider.

Please let me know how i can trouble shoot this. I did not see any java errors. and no log files have been created.

  • Hakan
    • The Incredible Smush

    Hi,

    The default service not being there indicates that there is a database installation problem, in other words, database tables could not be created.

    Try to deactivate and reactive the plugin.

    Examine the error.log files on the server (Not that of the plugin).

    I have also noted that I cannot reach your website. Did you create this domain recently? If DNS records did not propagate yet and your mySQL server is on another domain (e.g. if you are hosted on dreamhost or similar) this may be the problem.

    If none of the above helps,

    Can I ask you to send your FTP and login credentials using our contact form?

    https://premium.wpmudev.org/contact/

    Cheers,

    Hakan

  • pcioadmins2
    • Flash Drive

    @hakan, Thanks for your input on this. There are the Javascript Errors I am recieving

    Use of getAttributeNode() is deprecated. Use getAttribute() instead.

    Use of attributes’ specified attribute is deprecated. It always returns true.

    Both Errors are taking place here

    /wp-admin/load-scripts.php?c=0&load=jquery,utils&ver=3.4.1

    What tables should i see in the DB?

  • pcioadmins2
    • Flash Drive

    New Info on this error.

    in appointments.php I did the following

    //added to track hooks and filters
    add_action( 'all', create_function( '', 'var_dump( current_filter() );' ) );
    //Removed to See if it is an AJAX ERROR
    //add_action( 'admin_print_scripts', array(&$this, 'admin_scripts') );

    I then moved the wp_enqueue_script into the theme functions file

    After doing this I was able to find AJAX errors.

    SyntaxError: unterminated string literal
    [Break On This Error]

    $('#services-table').append('string(24) "app_selectable_durations"

    TypeError: $("#" + id).ColorPicker is not a function
    (?)()admin....ettings (line 484)
    f(a=

    [input#free_color.colorpicker_input 48c048, input#busy_color.colorpicker_input ff822e, input#notpossible_color.colorpicker_input ffffff]

    , c=function(), d=

    undefined

    )load-s...r=3.4.1 (line 2)
    f(a=function(), b=

    undefined

    )load-s...r=3.4.1 (line 2)
    (?)($=function())admin....ettings (line 474)
    f(b=Document admin.php?page=app_settings, f=

    [function()]

    )load-s...r=3.4.1 (line 2)
    f(b=Document admin.php?page=app_settings, c=

    [function()]

    )load-s...r=3.4.1 (line 2)
    f(a=

    undefined

    )load-s...r=3.4.1 (line 2)
    f()load-s...r=3.4.1 (line 2)
    [Break On This Error]

    onChange: function (hsb, hex, rgb) {

    AJAX LOG REPORTED THIS

    [September 27, 2012 6:47 am] Javascript error on : https://elephant.pci-online.net/wp-admin/admin.php?page=appointments

    [September 27, 2012 6:48 am] Javascript error on : https://elephant.pci-online.net/make-an-appointment

  • pcioadmins2
    • Flash Drive

    On the page https://elephant.pci-online.net/make-an-appointment

    once i select the Show all times under the blank provider page.

    WordPress database error: [Unknown column 'undefined' in 'where clause']
    SELECT * FROM wp_app_working_hours WHERE worker=undefined AND location=0

    WordPress database error: [Unknown column 'undefined' in 'where clause']
    SELECT * FROM wp_app_exceptions WHERE worker=undefined AND location=0

    I have also tried deactivating, deleting, and installing the latest version of appointments plus.

    I looked at the code in appointments.php and I do not see any INSERT statements that would insert default content.

  • pcioadmins2
    • Flash Drive

    After deactivating i all other plugins, i was able to see this new error.

    H()load-s...r=3.4.1 (line 3)
    H()load-s...r=3.4.1 (line 3)
    f()load-s...r=3.4.1 (line 3)
    a = Window admin.php?page=app_settings&tab=workers
    b =

    undefined

    load-scripts.php?c=0&load=jquery,utils&ver=3.4.1()load-s...r=3.4.1 (line 4)
    [Break On This Error]

    $('#workers-table').append('

    load-s...r=3.4.1 (line 3, col 31)

    As a note, one of the first things i found was that if the user “display_name” contains a (‘:wink: single quote it will terminate the workers list query. You might consider adding a strip html wild card.

    After fixing the DB record, I am stumped as to why the functionality does not work.

Thank NAME, for their help.

Let NAME know exactly why they deserved these points.

Gift a custom amount of points.