|
ktatransky
|
August 14, 2015 at 6:19 am
Hi, when I try to turn on any payment method I get this message:
An error has occurred:
A database error has occurred. Turn on WP_DEBUG for more information.
I have no idea what to do with it. I can create an event but when I get to the page with the payment method it’s empty and it gives me an error message when I try to confirm.
Thanks, Lucie
|
|
Lorenzo Orlando Caum
|
August 14, 2015 at 7:29 am
Hi there Lucie,
Could you please let us know the version of Event Espresso that you are using on your site so we can share feedback?
Also, have you noticed any other errors or strange behavior other than this?
Thanks
—
Lorenzo
|
|
ktatransky
|
August 14, 2015 at 9:27 am
Hi Lorenzo,
This is what it says on my account page 🙂
Your license level: EE3 Personal License
Expires: July 09, 2016
Thanks, Lucie
|
|
ktatransky
|
August 14, 2015 at 9:27 am
Oh and no other problems so far.
|
|
Lorenzo Orlando Caum
|
August 14, 2015 at 9:49 am
Hi Lucie, that information is for your support license which provides access to both versions of Event Espresso.
Could you please login to your WP dashboard and then go to the Plugins page? You’ll see your version of Event Espresso there. Please share that information here in a reply.
—
Lorenzo
|
|
ktatransky
|
August 15, 2015 at 4:38 am
So it was 4.7.9.p and I just updated it to 4.7.10.p
|
|
Dean
|
August 17, 2015 at 3:38 am
Hi,
Did the update to 4.7.10 resolve the issue or are payment methods still causing an error?
|
|
ktatransky
|
August 24, 2015 at 4:09 am
Nope, still the same.
|
|
ktatransky
|
August 24, 2015 at 4:21 am
My version is up to date, I have successfully migrated all the data and still when I try to activate any payment method I get the same message.
|
|
ktatransky
|
August 24, 2015 at 10:35 am
I ran a debug and this is the result:
[24-Aug-2015 16:31:44 UTC] WordPress database error Table ‘classacts3.cls_esp_payment_method’ doesn’t exist for query SELECT Payment_Method.PMD_ID AS ‘Payment_Method.PMD_ID’, Payment_Method.PMD_type AS ‘Payment_Method.PMD_type’, Payment_Method.PMD_name AS ‘Payment_Method.PMD_name’, Payment_Method.PMD_desc AS ‘Payment_Method.PMD_desc’, Payment_Method.PMD_admin_name AS ‘Payment_Method.PMD_admin_name’, Payment_Method.PMD_admin_desc AS ‘Payment_Method.PMD_admin_desc’, Payment_Method.PMD_slug AS ‘Payment_Method.PMD_slug’, Payment_Method.PMD_order AS ‘Payment_Method.PMD_order’, Payment_Method.PMD_debug_mode AS ‘Payment_Method.PMD_debug_mode’, Payment_Method.PMD_wp_user AS ‘Payment_Method.PMD_wp_user’, Payment_Method.PMD_open_by_default AS ‘Payment_Method.PMD_open_by_default’, Payment_Method.PMD_button_url AS ‘Payment_Method.PMD_button_url’, Payment_Method.PMD_scope AS ‘Payment_Method.PMD_scope’ FROM cls_esp_payment_method AS Payment_Method WHERE Payment_Method.PMD_scope LIKE ‘%CART%’ AND Payment_Method.PMD_type = ‘Invoice’ LIMIT 1 made by do_action(‘event-espresso_page_espresso_about’), call_user_func_array, EE_Admin_Page_Init->initialize_admin_page, EE_Admin_Page->route_admin_request, EE_Admin_Page->_route_admin_request, call_user_func_array, Extend_About_Admin_Page->_whats_new, About_Admin_Page->_get_started_steps, EEM_Payment_Method->get_one_active, EEM_Base->get_one, EEM_Base->get_all, EEM_Base->_get_all_wpdb_results, EEM_Base->_do_wpdb_query, call_user_func_array
[24-Aug-2015 16:32:15 UTC] WordPress database error Table ‘classacts3.cls_esp_payment_method’ doesn’t exist for query SELECT Payment_Method.PMD_ID AS ‘Payment_Method.PMD_ID’, Payment_Method.PMD_type AS ‘Payment_Method.PMD_type’, Payment_Method.PMD_name AS ‘Payment_Method.PMD_name’, Payment_Method.PMD_desc AS ‘Payment_Method.PMD_desc’, Payment_Method.PMD_admin_name AS ‘Payment_Method.PMD_admin_name’, Payment_Method.PMD_admin_desc AS ‘Payment_Method.PMD_admin_desc’, Payment_Method.PMD_slug AS ‘Payment_Method.PMD_slug’, Payment_Method.PMD_order AS ‘Payment_Method.PMD_order’, Payment_Method.PMD_debug_mode AS ‘Payment_Method.PMD_debug_mode’, Payment_Method.PMD_wp_user AS ‘Payment_Method.PMD_wp_user’, Payment_Method.PMD_open_by_default AS ‘Payment_Method.PMD_open_by_default’, Payment_Method.PMD_button_url AS ‘Payment_Method.PMD_button_url’, Payment_Method.PMD_scope AS ‘Payment_Method.PMD_scope’ FROM cls_esp_payment_method AS Payment_Method WHERE Payment_Method.PMD_scope LIKE ‘%CART%’ ORDER BY Payment_Method.PMD_order ASC,Payment_Method.PMD_ID ASC made by do_action(‘event-espresso_page_espresso_payment_settings’), call_user_func_array, EE_Admin_Page_Init->initialize_admin_page, EE_Admin_Page->route_admin_request, EE_Admin_Page->_route_admin_request, call_user_func_array, Payments_Admin_Page->_payment_methods_list, EEM_Payment_Method->verify_button_urls, EEM_Payment_Method->get_all_active, EEM_Base->get_all, EEM_Base->_get_all_wpdb_results, EEM_Base->_do_wpdb_query, call_user_func_array
|
|
Tony
|
August 24, 2015 at 11:27 am
Hi there,
Do you currently have active events? I’m assuming not as you can’t activate the payment methods.
Did the payment methods work at one point or not at all?
|
|
ktatransky
|
August 24, 2015 at 1:13 pm
Well last time registrations worked we didn’t have the methods activated. We don’t need them activated but the problem is that we are getting an error message at the confirm registration page when trying to confirm an attendee. People always pay by wire transfer in the Czech Republic so we don’t need any of the methods. But the error message says An error has occurred:
: The value “” must be a string submitted for normalization, it was NULL
So we figured that one of the payment methods need to be active.
|
|
Lorenzo Orlando Caum
|
August 24, 2015 at 2:31 pm
Hi Lucie, could you try deactivating Event Espresso through your WordPress plugins screen and then reactivating it?
Then browse to Event Espresso –> General Settings –> Payment Methods and let us know if you can activate and deactivate the payment methods.
Thanks
—
Lorenzo
|
|
ktatransky
|
August 25, 2015 at 1:08 pm
Nope, still getting the same message even after reactivating it.
|
|
ktatransky
|
August 25, 2015 at 1:13 pm
Guys, I really need you to figure out what to do! We have to make the registrations live asap.
|
|
Lorenzo Orlando Caum
|
August 25, 2015 at 3:14 pm
Hi Lucie, are you aware of any new restrictions by your host on creating new database tables?
—
Lorenzo
|
|
ktatransky
|
August 25, 2015 at 3:39 pm
No, I am not.
|
|
Lorenzo Orlando Caum
|
August 25, 2015 at 5:50 pm
Hi Lucie,
Could you follow up with us here?
https://eventespresso.com/send-login-details/
Thanks
—
Lorenzo
|
|
ktatransky
|
August 26, 2015 at 7:54 am
Done, hope you guys can figure it out 🙂 Thanks!
|
|
ktatransky
|
August 26, 2015 at 8:35 am
Hi Lorenzo, as far as I know, there are no restrictions on creating DB tables. Also, there is still enough space on the DB server for new data.
|
|
Lorenzo Orlando Caum
|
August 26, 2015 at 1:04 pm
Hi Lucie, I replied earlier today to your email but have not heard back. When I attempted to activate Event Espresso 4 after deactivating it, it reported an issue with the database.
Have you had a chance to follow up with your web host to see if there are restrictions on creating new tables in your WordPress database?
Thanks
—
Lorenzo
|
|
ktatransky
|
August 26, 2015 at 1:10 pm
I did respond here. You probably didn’t see it.
August 26, 2015 at 8:35 am
Hi Lorenzo, as far as I know, there are no restrictions on creating DB tables. Also, there is still enough space on the DB server for new data.
|
|
Lorenzo Orlando Caum
|
August 26, 2015 at 1:31 pm
Hi Lucie, I did see that. Is this a server that you are running on your end or is it via a web host that you pay a monthly fee for (e.g. hostgator, siteground, web.com?)
The reason I ask is according to the error message, Event Espresso is trying to create a table but cannot. If you have a web host, then please double-check with them to see if there are any restrictions.
Once that table is there, then the error will go away because Event Espresso will be able to populate it with the payment methods information.
—
Lorenzo
|
|
ktatransky
|
August 27, 2015 at 8:48 am
Hi Lorenzo,
I have checked with my webhosting provider (savana.cz) and there are no restrictions on creating DB tables. Is is possible to create the required tables manually with phpMyAdmin?
Thanks!
|
|
Lorenzo Orlando Caum
|
August 27, 2015 at 10:19 am
Hi Lucie,
I just sent an email over. Could you go ahead and reply to that email?
—
Lorenzo
|
