• Resolved KoolPal

    (@koolpal007)


    Hi,

    There is a recurring PHP notice on visiting the email log – [05-Oct-2023 06:35:30 UTC] PHP Notice: Function wpdb::prepare was called incorrectly. Unsupported value type (array).

    Query monitor explains as below

    Function wpdb::prepare was called incorrectly. Unsupported value type (array). (This message was added in version 4.8.2.)PostmanEmailLogs->save()

    Additional info:

        PostmanEmailLogs->save()
        wp-content/plugins/post-smtp/Postman/PostmanEmailLogs.php:261
        PostmanEmailLogService->writeToEmailLog()
        wp-content/plugins/post-smtp/Postman/Postman-Email-Log/PostmanEmailLogService.php:186
        PostmanEmailLogService->writeSuccessLog()
        wp-content/plugins/post-smtp/Postman/Postman-Email-Log/PostmanEmailLogService.php:113
        PostmanEmailLogService->write_success_log()
        wp-content/plugins/post-smtp/Postman/Postman-Email-Log/PostmanEmailLogService.php:85
        do_action('post_smtp_on_success')
        wp-includes/plugin.php:517
        PostmanWpMail->sendMessage()
        wp-content/plugins/post-smtp/Postman/PostmanWpMail.php:262
        PostmanWpMail->send()
        wp-content/plugins/post-smtp/Postman/PostmanWpMail.php:60
        wp_mail()
        wp-content/plugins/post-smtp/Postman/PostmanWpMailBinder.php:121
        class_user_verification_emails->send_email()
        wp-content/plugins/user-verification/includes/classes/class-emails.php:76
        class_user_verification_notices->resend_verification()
        wp-content/plugins/user-verification/includes/classes/class-admin-notices.php:266
        do_action('admin_notices')
        wp-includes/plugin.php:517

    Please guide / fix.

    Thanks

Viewing 7 replies - 1 through 7 (of 7 total)
  • Plugin Support M Haseeb

    (@haseeb0001)

    Hi @koolpal007

    I hope you are doing well.

    Please navigate to the Post SMTP Dashboard and access the 4th Column. Click on the “Diagnostic test report” option and share the generated report here. This will allow us to examine it and provide a suitable solution.

    Thanks and regards,
    Support Team – WPExperts??

    Thread Starter KoolPal

    (@koolpal007)

    Hi,

    This is on my local installation.

    Hope this helps.

    Mailer: postsmtp
    HostName: pp-dev.test
    cURL Version: 7.70.0
    OpenSSL Version: OpenSSL/1.1.1l
    OS: Windows NT DESKTOP-7DTTHAQ 10.0 build 19045 (Windows 10) AMD64
    PHP: WINNT 7.4.27 C
    PHP Dependencies: iconv=Yes, spl_autoload=Yes, openssl=Yes, sockets=No, allow_url_fopen=Yes, mcrypt=No, zlib_encode=Yes
    WordPress: 6.3.1 en_US UTF-8
    WordPress Theme: Kidz-Child
    WordPress Plugins: Query Monitor, Advanced Shipment Tracking Pro, Cashfree, Honeypot for Contact Form 7, Contact Form 7, Enable Classic Editor, EWWW Image Optimizer, Flamingo, Force Regenerate Thumbnails, Kidz Core, Kidz Wishlist, Post SMTP, Regenerate Thumbnails, Rank Math SEO, User Verification, WooCommerce Failed Order Customer Email - VALS, WooCommerce Order Status Manager, PDF Invoices & Packing Slips for WooCommerce, WooCommerce, WordPress WhatsApp Support, Mailhog for WordPress, WPLoyalty
    WordPress wp_mail Owner: S:\laragon\www\PP-Dev\wp-content\plugins\post-smtp\Postman\PostmanWpMailBinder.php
    WordPress wp_mail Filter(s): wp_staticize_emoji_for_email, WPO\WC\PDF_Invoices\Main->set_phpmailer_validator, PostsmtpMailer->get_mail_args
    WordPress wp_mail_from Filter(s): user_verification_change_mail_from
    WordPress wp_mail_from_name Filter(s): user_verification_change_mail_from_name
    WordPress phpmailer_init Action(s): wpcf7_phpmailer_init, Anonymous Function, WPLoyalty\Wordpress\WlrEarnPointEmail->handle_multipart, WPLoyalty\Wordpress\WlrEarnRewardEmail->handle_multipart, WPLoyalty\Wordpress\WlrExpireEmail->handle_multipart, WPLoyalty\Wordpress\WlrPointExpireEmail->handle_multipart, WPLoyalty\Wordpress\WlrBirthdayEmail->handle_multipart, WPLoyalty\Wordpress\WlrNewLevelEmail->handle_multipart
    Postman: 2.6.1
    Postman Prevent Message Sender Override (Email|Name): No | No
    Postman Active Transport: Default (smtp:none:none://localhost:25)
    Postman Active Transport Status (Ready|Connected): No | No
    Postman Deliveries (Success|Fail): 12 | 0
    Postman File Locking (Enabled|Temp Dir): No | /tmp
    Plugin Support M Haseeb

    (@haseeb0001)

    @koolpal007

    Could you please provide a screen-recorded video or screenshot of the error? Additionally, I’d like to know if these errors are only visible on the Log page or if they also appear in the WordPress dashboard.

    Thanks

    Hey.

    We’re having the same issue, but this time it’s showing up when adding media. Which is problematic, because it breaks the progress reporting, since it appears in the response from the async uploader.

    I traced it back, and it seems to be related to staging_post_smtp_logs, when a security plugin (Sucuri) sends an e-mail about a post update. Since it happens when the media file gets added to the database – that’s when it gets triggered.

    The message appears in the media file’s entry in the async uploader, and breaks it.

    Here’s the exact backtrace:

    Backtrace:
    1: trigger_error() in wp-includes/functions.php:5905
    2: _doing_it_wrong() in wp-includes/class-wpdb.php:1782
    3: prepare() in wp-includes/class-wpdb.php:2686
    4: _insert_replace_helper() in wp-includes/class-wpdb.php:2598
    5: insert() in wp-content/plugins/post-smtp/Postman/PostmanEmailLogs.php:261
    6: save() in wp-content/plugins/post-smtp/Postman/Postman-Email-Log/PostmanEmailLogService.php:186
    7: writeToEmailLog() in wp-content/plugins/post-smtp/Postman/Postman-Email-Log/PostmanEmailLogService.php:113
    8: writeSuccessLog() in wp-content/plugins/post-smtp/Postman/Postman-Email-Log/PostmanEmailLogService.php:85
    9: write_success_log() in wp-includes/class-wp-hook.php:310
    10: apply_filters() in wp-includes/class-wp-hook.php:334
    11: do_action() in wp-includes/plugin.php:517
    12: do_action() in wp-content/plugins/post-smtp/Postman/PostmanWpMail.php:262
    13: sendMessage() in wp-content/plugins/post-smtp/Postman/PostmanWpMail.php:60
    14: send() in wp-content/plugins/post-smtp/Postman/PostmanWpMailBinder.php:121
    15: wp_mail() in wp-content/plugins/sucuri-scanner/src/mail.lib.php:103
    16: sendMail() in wp-content/plugins/sucuri-scanner/src/event.lib.php:629
    17: notifyEvent() in wp-content/plugins/sucuri-scanner/src/hook.lib.php:70
    18: hookAttachmentAdd() in wp-includes/class-wp-hook.php:310
    19: apply_filters() in wp-includes/class-wp-hook.php:334
    20: do_action() in wp-includes/plugin.php:517
    21: do_action() in wp-includes/post.php:4674
    22: wp_insert_post() in wp-includes/post.php:6204
    23: wp_insert_attachment() in wp-admin/includes/media.php:422
    24: media_handle_upload() in wp-admin/async-upload.php:114
    
    Notice: Function wpdb::prepare was called incorrectly. Unsupported value type (array).
    Please see Debugging in WordPress for more information. (This message was added in version 4.8.2.)
    in {snip}/wp-includes/functions.php on line 5905
    

    Hope this helps sort it out, because it’s starting to get annoying.

    Plugin Support M Haseeb

    (@haseeb0001)

    We are currently investigating this issue and will provide updates as soon as possible. Thank you for your patience.

    Plugin Support M Haseeb

    (@haseeb0001)

    Hi @koolpal007

    I hope you are doing well.

    Please?create a ticket on our technical support channel?so that we can connect you directly with our Technical team.

    You can also try this Beta version on your staging website and let me know if it works.

    Looking forward to getting your issue resolved.

    Thanks and regards,
    Support Team – WPExperts

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘PHP Notice’ is closed to new replies.