Dorgman

Hi Stephanieliy – I just followed the other steps you suggested for Advanced Database Updates. I then cleared cache and ran another test donation and this time it worked!

There were quite a number of errors in the log from all the previous test donations and other people trying to donate. The errors were all similar:

{     "Query": "\n\t\t\tSELECT DISTINCT r.form_id\n\t\t\tFROM wp_give_revenue as r\n\t\t\t\tINNER JOIN wp_give_donationmeta as dm ON r.donation_id = dm.donation_id\n\t\t\tWHERE dm.meta_key='_give_payment_mode'\n\t\t\t\tAND dm.meta_value='live'\n\t\t\t",     "Query Errors": {         "db_delta_error": [             "Table 'u539594664_migration1.wp_give_revenue' doesn't exist"         ]     } }

Greetings Stephanieliy – thank you for your assistance. Last night I tried doing a fresh install of the plugin using Filezilla (renaming the old version, just in case anything went wrong) Nothing changed, so I deleted the old version and kept the new install.

To begin with here is the system report:

WordPress Environment

Home URL: https://llamasanctuary.com
Site URL: https://llamasanctuary.com
WP Version: 6.1.1
WP Multisite: –
WP Memory Limit: 512 MB
WP Debug Mode: –
WP Cron: ?
Language: en_US
Permalink Structure: /%postname%/
Show on Front: page
Page on Front: Home (#2614)
Page for Posts: Llama Sanctuary Magazine (#2643)
Table Prefix Length: wp_
Table Prefix Length: 3
Table Prefix Status: Acceptable
Admin AJAX: Accessible
Registered Post Statuses: publish, future, draft, pending, private, trash, auto-draft, inherit, request-pending, request-confirmed, request-failed, request-completed, wc-pending, wc-processing, wc-on-hold, wc-completed, wc-cancelled, wc-refunded, wc-failed, wc-checkout-draft, refunded, failed, revoked, cancelled, abandoned, processing, preapproval

Server Environment

Hosting Provider: DBH: localhost, SRV: llamasanctuary.com
TLS Connection: Connection uses TLS 1.3
TLS Connection: Probably Okay
Server Info: LiteSpeed
PHP Version: 7.4.32
PHP Post Max Size: 512 MB
PHP Time Limit: 240
PHP Max Input Vars: 5000
PHP Max Upload Size: 512 MB
cURL Version: 7.71.0, OpenSSL/1.1.1d
SUHOSIN Installed: –
Default Timezone is UTC: ?
fsockopen/cURL: ?
SoapClient: ?
DOMDocument: ?
gzip: ?
GD Graphics Library: ?
Multibyte String: ?
Remote Post: ?
Remote Get: ?

GiveWP Configuration

GiveWP Version: 2.25.0
GiveWP Cache: Enabled
Database Updates: All DB Updates Completed.
Database Updates: All Database Migrations Completed.
Database Tables: ? wp_give_donors? wp_give_donormeta? wp_give_comments? wp_give_commentmeta? wp_give_sessions? wp_give_formmeta? wp_give_sequential_ordering? wp_give_donationmeta? wp_give_revenue? wp_give_migrations? wp_give_log
GiveWP Cache: Enabled
GiveWP Cache: ?New Donation?Donation Receipt?Donation Processing Receipt?New Offline Donation?Offline Donation Instructions?New User Registration?User Registration Information?Donation Note?Email access
Upgraded From: 2.25.0
Test Mode: Disabled
Currency Code: CAD
Currency Position: Before
Decimal Separator: .
Thousands Separator: ,
Success Page: https://llamasanctuary.com/donation-confirmation/
Failure Page: https://llamasanctuary.com/transaction-failed/
Donation History Page: https://llamasanctuary.com/donor-dashboard/
GiveWP Forms Slug: /donations/
Enabled Payment Gateways: Test Donation, Offline Donation, Stripe - Credit Card, Stripe - Checkout, PayPal Standard
Default Payment Gateway: Stripe - Credit Card
PayPal IPN Notifications: IPN received for #5675 ( 2EU44209FK2072607 ) on 12/25/2019 at 07:34. Status VERIFIED
Donor Email Access: Disabled
Stripe Webhook Notifications: N/A

Active GiveWP Add-ons

Other Active Plugins

Additional Variation Images Gallery for WooCommerce: by Emran Ahmed – 1.3.13
Canada Post Shipping For WooCommerce: by Small Fish Analytics Inc. – 2.9.11
Classic Editor: by WordPress Contributors – 1.6.2
Complete Central Backup: by Dash10 Digital – 2.1.3
Contact Form 7: by Takayuki Miyoshi – 5.7.4
Contact Form 7 Extension For Mailchimp: by Renzo Johnson – 0.5.64
Divi Shortcode Enabler: by Divi Booster – 1.3.7
eCards: by Ciprian Popescu – 4.0.5
Elegant Themes Updater: by Elegant Themes – 1.2
Facebook Likes You!: by Piotr Sochalewski – 1.5.4
Heartbeat Control by WP Rocket: by WP Rocket – 2.0
PeachPay Checkout and Payments for WooCommerce: Stripe, PayPal, Square: by PeachPay, Inc. – 1.87.2
Supreme Modules Lite - Divi Theme, Extra Theme and Divi Builder: by Supreme Modules – 2.4.2
WooCommerce: by Automattic – 7.4.0
Wordfence Security: by Wordfence – 7.9.0

Inactive Plugins

Better Find and Replace: by CodeSolz – 1.4.6
Broken Link Checker: by WPMU DEV – 1.11.21
Event Booking Pro: by Moe Haydar – 3.99
EventON: by AshanJay – 3.0.2
Google Listings and Ads: by WooCommerce – 2.0.1
Jetpack: by Automattic – 11.8.4
LiteSpeed Cache: by LiteSpeed Technologies – 5.3.3
MailPoet: by MailPoet – 4.7.0
Newsletter: by Stefano Lissa & The Newsletter Team – 7.5.9
WP Simple Shopping cart: by Tips and Tricks HQ, Ruhul Amin, mra13 – 4.6.3

Theme

Name: Divi
Version: 4.5.6
Author URL: https://www.elegantthemes.com
Child Theme: No – If you're modifying GiveWP on a parent theme you didn't build personally, then we recommend using a child theme. See: How to Create a Child Theme

Thank you baldguy – I’ll go back in and make the necessary changes.

Well I fixed my problems by changing the relevant files listed in the error messages with ones that I had backed up some time ago (probably the originals). They were not configured files in any case.

Wherever I saw an error message, I replaced the file in error with the original. There is still a problem with the update somewhere, but for now at least, the store is functioning once more.

Files replaced:
general.php
header.php
product_info.php

Hope that helps someone else.

I have the same problem – the store is currently out of action https://www.fabinbc.com

OK – I’m finally back in the admin area.

I cannot even properly identify the problem. I had to delete and reinstall the store plugin and then restore from the back up.

After reinstalling, the admin area was still not accessible, so there was a mismatch between the plugin and the setup of the new server, since it was fine on the old server. I am going to assume that there was an errant space or spook in the root path, since I cannot see any difference between the configuration files before and after. I simply typed the absolute url into a text file and pasted it into each line in configuration.

Unfortunately, some of the demo products were showing, so I had to remove those individually. Also, some of the images were missing or confused, so I have had to go through the entire store and check each page. Thankfully, there are only about thirty products!

Thank you for your help baldguy. Hopefully, this might give a clue to someone else in the future who experiences a similar problem.

I did look at the article and install the phpinfo file

https://fabinbc.com/phpinfo.php

The doc_root entry says ‘no value’ – I don’t know what that means, but I know the document root in cPanel is home/fabinb5/public_html

I also followed the instructions for file permissions and checked with my host if they had any suggestions. Since they are promoted as being wordpress hosting specialists, my guess is that logger should work.

I tried deleting line 91 from the application_top file, but it it just changed the error to line 94.

I thought of reinstalling the wp-online-store plugin, but that would remove all of the stock entries. Not sure I want to go down that root. I suppose I do have the database back-up of products.

Thank you for the reply baldguy

I have checked and triple-checked the paths and they are correct and the files: logger.php and application_top.php are both in place.

I tried wrapping line 91 which calls logger in application_top as suggested:

// initialize the logger class
// require(DIR_WS_CLASSES . 'logger.php');

Doing this simply changed the error to line 94

I copy here the admin configure file, in case you or anyone else can see a problem with it:

<?php
  define('HTTP_SERVER', 'https://www.fabinbc.com');
  define('HTTP_CATALOG_SERVER', 'https://www.fabinbc.com');
  define('HTTPS_CATALOG_SERVER', 'https://www.fabinbc.com');
  define('ENABLE_SSL_CATALOG', false);
  define('DIR_FS_DOCUMENT_ROOT', 'home/fabinb5/public_html/wp-content/plugins/wp-

online-store');
  define('DIR_WS_ADMIN', 'https://www.fabinbc.com/wp-admin/');
  define('DIR_FS_ADMIN', 'home/fabinb5/public_html/wp-content/plugins/wp-online-

store/admin/');
  define('DIR_WS_CATALOG', '/wp-content/plugins/wp-online-store/');
  define('DIR_FS_CATALOG', 'home/fabinb5/public_html/wp-content/plugins/wp-online-

store/');
  define('DIR_WS_IMAGES', 'images/');
  define('DIR_WS_ICONS', DIR_WS_IMAGES . 'icons/');
  define('DIR_WS_CATALOG_IMAGES', '/wp-content/plugins/WP-online-store-product-

images/images/');
  define('DIR_WS_INCLUDES', 'includes/');
  define('DIR_WS_BOXES',   'boxes/');
  define('DIR_WS_FUNCTIONS',   'functions/');
  define('DIR_WS_CLASSES',  DIR_FS_ADMIN.DIR_WS_INCLUDES. 'classes/');
  define('DIR_WS_MODULES',   'modules/');
  define('DIR_WS_LANGUAGES',  'languages/');
  define('DIR_WS_CATALOG_LANGUAGES', DIR_WS_CATALOG . 'includes/languages/');
  define('DIR_FS_CATALOG_LANGUAGES', DIR_FS_CATALOG . '/includes/languages/');
  define('DIR_FS_CATALOG_IMAGES', 'home/fabinb5/public_html/wp-content/plugins/WP-

online-store-product-images/images/');
  define('DIR_FS_CATALOG_MODULES', DIR_FS_CATALOG . '/includes/modules/');
  define('DIR_FS_BACKUP', DIR_FS_ADMIN . 'backups/');

  define('DB_SERVER', 'localhost');
  define('DB_SERVER_USERNAME', '******_******');
  define('DB_SERVER_PASSWORD', '*********');
  define('DB_DATABASE', '*****_*******');
  define('USE_PCONNECT', 'false');
  define('STORE_SESSIONS', 'mysql');
?>

I tried placing / in front of /home where the absolute path is given, since it was not there in my old site, but it made no difference.

I have not changed the domain name, only the server.

I have updated file permissions to 777 for the relevant files that I found in the wp-online-store help documentation.

It’s going to be something silly, but I’m going code-crazy looking for it.

Kindly