|
ws4a
|
February 8, 2017 at 1:29 pm
I was change my hosting and setup the old database and files on new hosting. All things are working fine except the registration is approved even the user cancel the payment.
I process an registration from http://stahlhouse.com/tours, after completion of registration form I am redirected to paypal for payment, then I click on Cancel Payment and move back to site link on paypal page. I redirected back to site and get get the cancellation notice on site. But after an hour later I got two emails “Event Registration Details” and “Your Stahl House Tickets”. I am still seeing pending payment in transactions on site, but approved in registrations.
I am on wordpress 4.2.12
Event Espresso : 4.6.25.p
Event Espresso – Barcode Scanner (EE 4.6.0+): 1.0.2.p
Event Espresso – Calendar (EE 4.3+): 3.2.2.p
Event Espresso – Events Table View Template (EE 4.4.9+): 1.3.3.p
Event Espresso – Grid View Template (EE 4.4.9+): 1.2.3.p
Event Espresso – iDeal/Mollie Gateway: 1.1.1.p
Event Espresso – MailChimp (EE4.4.5+): 2.2.2.p
Event Espresso – People Addon (EE4.5+): 1.0.0.p
Event Espresso – Sage Pay Gateway: 1.1.1.p
Event Espresso – Social Sharing (EE4.4.4+): 1.0.p
Event Espresso – Ticketing (EE4+): 1.0.1.p
Event Espresso – WP Users (EE4.6+): 1.1.2.p
|
|
Josh
|
February 8, 2017 at 2:13 pm
Hi there,
It looks like you need to update to a current version of WordPress, Event Espresso, and the Event Espresso add-ons. The ones you’ve listed here are out of date. We really can only support current versions of the software.
|
|
ws4a
|
February 8, 2017 at 2:38 pm
Yes I agree you Josh, but the site was working fine on my old hosting.
|
|
Josh
|
February 8, 2017 at 5:49 pm
You’re asking for support and we only support recent versions of the software.
|
|
ws4a
|
February 13, 2017 at 7:08 pm
Hello Josh, we have updated the EE core and EE_Tickting plugins to current version and also updated wordpress to current version. But we are facing same issue. Tickets are sent even on cancellation of payment. It happens about an hour later the test.
|
|
Josh
|
February 14, 2017 at 9:40 am
Can you deactivate PayPal and use PayPal Express instead? The PayPal Express gateway will work with your PayPal account, and you can follow this guide to get your PayPal Express API credentials:
https://eventespresso.com/wiki/paypal-express-payment-gateway/#locate
|
|
ws4a
|
February 15, 2017 at 11:27 am
Hello Josh, I changed the payment method from paypal standard to paypal express checkout, but nothing updated, the issue is same.
The big problem with this is that now the number of tickets sold is not correct. Currently, even if it states “pending payment”, those tickets are now being counted as actual tickets sold. This creates our tours to show “sold out” even when they are not. It also creates more work for me.
Please suggest solution, we are losing business this way, get buy to do much manual work.
|
|
Tony
|
February 15, 2017 at 11:37 am
First lets check your events default registration status.
If you edit the event and look within ‘Event Registration Options’ what is set for the ‘Default Registration Status’ – http://take.ms/vDYz6 (the bottom setting)
|
|
ws4a
|
February 27, 2017 at 8:40 am
Thanks Tony, it works for us, this is the right answer. We are now facing another problem, we activate the paypal express checkout only but on each weekend its disabled and pay with check is enabled. Can you help us on this, how it is deactivated automatically?
|
|
Lorenzo Orlando Caum
|
February 27, 2017 at 10:21 am
Hi there,
I have a couple questions so we can try to help you pinpoint the cause of this issue.
1) Are you working with multiple team members on the site?
2) Is the live site connected to a testing/staging area?
—
Lorenzo
|
|
ws4a
|
February 27, 2017 at 2:28 pm
No we are not working with multiple team members on this. It isn’t connected to any staging area
|
|
Tony
|
February 27, 2017 at 4:09 pm
So to be clear, your activating the PayPal Express payment method, with the Check payment method de-activated?
Then after X amount of days the PayPal Express payment method is de-activated and the Check payment method activated?
What (if any) other payment methods are activated/changing with this?
|
|
ws4a
|
February 27, 2017 at 5:38 pm
Yes, it happening the same.
No, other payment options are activated. I think Check is default in event esspresso, its shifted to default.
|
|
Tony
|
February 27, 2017 at 6:22 pm
I think Check is default in event esspresso, its shifted to default.
Check is not the default in Event Espresso, Invoice is.
So can you confirm the other 2 questions in the the above please.
This:
So to be clear, your activating the PayPal Express payment method, with the Check payment method de-activated?
And
Then after X amount of days the PayPal Express payment method is de-activated and the Check payment method activated?
|
|
ws4a
|
March 1, 2017 at 2:45 pm
Yes @tony, its happening same as you ask in you questions.
|
|
Tony
|
March 3, 2017 at 4:12 am
Hmm, that’s strange. We don’t have any code in place to activate the check payment method.
If somehow the PayPal Express payment method was de-activated and no other payment method was activated then the Invoice payment method would automatically activate, but not the check payment method.
So can you double check if it is the Check payment method, or the Invoice payment method that is activating please?
|
|
ws4a
|
March 6, 2017 at 11:03 am
Hi Tony, you are right, its changing to invoice, we got update from client, this time we capture some screenshots. Please find it Here
|
|
Lorenzo Orlando Caum
|
March 6, 2017 at 11:50 am
Hi,
Are you using any database clean up tools that run periodically on their own?
If you are not sure, then could you share a list of plugins on the site?
I can see some by looking at the sidebar and it would help to know all of them that are in use.
—
Lorenzo
|
|
ws4a
|
March 6, 2017 at 12:57 pm
Below are the active plugins:
All In One SEO Pack
Allow PHP in Posts and Pages
amr shortcode any widget
Autoptimize
Contact Form 7
Contact Form 7 Datepicker
Event Espresso
Event Espresso – Barcode Scanner (EE 4.6.0+)
Event Espresso – Calendar (EE 4.3+)
Event Espresso – Events Table View Template (EE 4.4.9+)
Event Espresso – Grid View Template (EE 4.4.9+)
Event Espresso – MailChimp (EE4.4.5+)
Event Espresso – People Addon (EE4.5+)
Event Espresso – Social Sharing (EE4.4.4+)
Event Espresso – Ticketing (EE 4+)
Event Espresso – WP Users (EE4.6+)
Image Widget
Lockdown WP Admin
Meta Slider
NextGEN Gallery
Really Simple CAPTCHA
Regenerate Thumbnails
WooCommerce
Wordfence Security
WP Google Map Plugin
|
|
ws4a
|
March 6, 2017 at 1:01 pm
I dump all the wp crons, these are max to daily scheduled or scheduled for a less time then a day, but the issue occurs weekly. Is any cron make such issue?
|
|
Lorenzo Orlando Caum
|
March 6, 2017 at 2:30 pm
Hello,
Once a payment method is enabled, then the PMD_Scope column in the wp_esp_payment_method table is updated.
For example, this serialized entry from PMD_Scope shows that it is enabled for registration checkout:
a:1:{i:0;s:4:”CART”;}
When a payment option is deactivated, then that is cleared until is it re-enabled.
There isn’t a cron that changes the status so it should remain enabled without you needing to re-enable it.
I previously asked about a team member working on the site along with a staging area to make sure that changes were not being moved over.
I looked at the Autoptimize and Lockdown WP Admin plugins and those do not appear to run any regular optimization changes to the database. I’m going to ask a team member to look this over as I can’t see a specific reason why the payment options are shutting off and keeping just the invoice option enabled.
—
Lorenzo
|
|
ws4a
|
March 6, 2017 at 4:45 pm
Hello
I just update to 4.9.31, as I activate I got an error:
An error has occurred:
WordPress database error: [Duplicate entry ‘629’ for key ‘PRIMARY’]
ALTER TABLE 4wp_esp_event_message_template ADD PRIMARY KEY (EMT_ID)
Stack Trace:#0 /home/stahlhouse/public_html/wp-content/plugins/event-espresso-core-reg/core/helpers/EEH_Activation.helper.php(745): EventEspresso\core\services\database\TableManager->createTable(‘esp_event_messa…’, ‘EMT_ID bigint(2…’, ‘InnoDB’) #1 /home/stahlhouse/public_html/wp-content/plugins/event-espresso-core-reg/core/data_migration_scripts/EE_Data_Migration_Script_Base.core.php(557): EEH_Activation::create_table(‘esp_event_messa…’, ‘EMT_ID bigint(2…’, ‘ENGINE=InnoDB’, false) #2 /home/stahlhouse/public_html/wp-content/plugins/event-espresso-core-reg/core/data_migration_scripts/EE_Data_Migration_Script_Base.core.php(511): EE_Data_Migration_Script_Base->_create_table_and_catch_errors(‘esp_event_messa…’, ‘EMT_ID bigint(2…’, ‘ENGINE=InnoDB’, false) #3 /home/stahlhouse/public_html/wp-content/plugins/event-espresso-core-reg/core/data_migration_scripts/EE_DMS_Core_4_9_0.dms.php(193): EE_Data_Migration_Script_Base->_table_has_not_changed_since_previous(‘esp_event_messa…’, ‘EMT_ID bigint(2…’, ‘ENGINE=InnoDB’) #4 /home/stahlhouse/public_html/wp-content/plugins/event-espresso-core-reg/core/helpers/EEH_Activation.helper.php(868): EE_DMS_Core_4_9_0->schema_changes_before_migration() #5 /home/stahlhouse/public_html/wp-content/plugins/event-espresso-core-reg/core/helpers/EEH_Activation.helper.php(125): EEH_Activation::create_database_tables() #6 /home/stahlhouse/public_html/wp-content/plugins/event-espresso-core-reg/core/EE_System.core.php(374): EEH_Activation::initialize_db_and_folders() #7 [internal function]: EE_System->initialize_db_if_no_migrations_required(”) #8 /home/stahlhouse/public_html/wp-includes/class-wp-hook.php(298): call_user_func_array(Array, Array) #9 /home/stahlhouse/public_html/wp-includes/class-wp-hook.php(323): WP_Hook->apply_filters(”, Array) #10 /home/stahlhouse/public_html/wp-includes/plugin.php(453): WP_Hook->do_action(Array) #11 /home/stahlhouse/public_html/wp-content/plugins/event-espresso-core-reg/core/EE_System.core.php(856): do_action(‘AHEE__EE_System…’) #12 [internal function]: EE_System->perform_activations_upgrades_and_migrations(”) #13 /home/stahlhouse/public_html/wp-includes/class-wp-hook.php(298): call_user_func_array(Array, Array) #14 /home/stahlhouse/public_html/wp-includes/class-wp-hook.php(323): WP_Hook->apply_filters(”, Array) #15 /home/stahlhouse/public_html/wp-includes/plugin.php(453): WP_Hook->do_action(Array) #16 /home/stahlhouse/public_html/wp-settings.php(449): do_action(‘init’) #17 /home/stahlhouse/public_html/wp-config.php(86): require_once(‘/home/stahlhous…’) #18 /home/stahlhouse/public_html/wp-load.php(37): require_once(‘/home/stahlhous…’) #19 /home/stahlhouse/public_html/wp-admin/admin.php(31): require_once(‘/home/stahlhous…’) #20 /home/stahlhouse/public_html/wp-admin/plugins.php(10): require_once(‘/home/stahlhous…’) #21 {main}
EEH_Activation – create_database_tables – 873
|
|
Josh
|
March 7, 2017 at 11:09 am
Hi there,
It sounds like somehow that table lost it’s primary key, so many rows from the messages table might have the same ID. And so while upgrading Event Espresso, it seems the primary key is missing on that table, so it’s trying to add it, but it can’t because there are duplicates.
Can you restore the site to a backup of the database? The backup should have a primary key on the message template table, and should not have any rows with dupliate IDs on the table.
|
|
ws4a
|
March 7, 2017 at 1:58 pm
I fixed this with remove duplicate entries. Any update on auto change of payment method?
FYI, I also notice the Ticket message type also become inactive in last 2-3 days.
Messages->Settings->Html->Ticket this was inactive.
Why these things are happening with our sites again and again?
|
|
Josh
|
March 7, 2017 at 2:20 pm
The answer to your question is not known because these things are not happening on other sites. Are you able to stop dumping the crons and maybe even deactivate some of the other plugins on the website? That may help.
|
|
ws4a
|
March 22, 2017 at 8:45 am
We got this message again “The payment method PayPal Express was automatically deactivated because it appears its associated Event Espresso Addon was recently deactivated. It can be reactivated on the Plugins admin page, then you can reactivate the payment method.”, its again changed to invoice, but this time it occurs after more the a week.
|
|
Josh
|
March 22, 2017 at 10:12 am
Are you able to stop dumping the crons and deactivate some of the other plugins on the website? This may help.
|
|
ws4a
|
March 23, 2017 at 12:52 pm
We don’t setup any cron job from the server, only the wp cron are working. If you are saying to stop these, how can we stop these?
If we provide access you, can you look into our site, which plugin can harm this and how can I give you access privately?
|
|
Josh
|
March 23, 2017 at 2:18 pm
If you prefer someone from Event Espresso staff to troubleshoot your other plugins we ask that you purchase a support token. If you purchase a support token there will be a Redeem a support token form that you can send the access information securely.
|
