|
kcray
|
December 4, 2013 at 2:23 pm
Hi Guys, When I try to modify an event title, I get a database error.
Here is the error. Is this a conflicting plugin?
UPDATE wp_events_detail SET event_name = ‘Snowbirds Workshop Sponsored by Garrett & Kellyco’, event_desc = ‘Treasure Coast Snowbirds Workshop\r\nThis is an introduction to Treasure Hunting with hands on experience with some of the best detectors in the industry from Garrett Metal Detectors.\r\n\r\nWhere: Kiwanis-Hobart Park\r\n5350 77th St Vero Beach, FL 32967\r\n\r\nWhen: Friday March 7th 2014\r\n11:00 – Welcome. – Richard Hart\r\n11:10 – 11:30am Introduction to metal Detecting – Kellyco Rep\r\n11:30 – 12:00pm What type of detector to buy – Garrett rep\r\n12:00 – 12:30pm lunch\r\n12:30 – 2:30pm Buddy-up hands-on detector use.\r\n2:30 – 3:00pm Introduction to your 1st hunt.\r\n\r\n ‘, display_desc = ‘Y’, display_reg_form = ‘Y’, address = ”, address2 = ”, city = ”, state = ”, zip = ”, country = ”, phone = ‘321-276-4211’, virtual_url = ”, virtual_phone = ”, venue_title = ”, venue_url = ”, venue_phone = ”, venue_image = ”, registration_start = ”, registration_end = ”, start_date = ‘2014-03-07’, end_date = ‘2014-03-07’, allow_multiple = ‘N’, send_mail = ‘Y’, is_active = ‘Y’, event_status = ‘R’, conf_mail = ‘***This is an automated response – Do Not Reply***\r\n\r\nThank you [fname] [lname] for registering for [event]. We hope that you will find this event both informative and enjoyable. Should have any questions, please contact [contact].\r\n\r\nTicket type: [ticket_type]\r\n\r\nPrint Tickets: [ticket_link] (A link Your Customized Ticket if the ticketing addon is installed.)\r\n\r\n[qr_code] (generated by the QR Code addon, if installed)\r\n\r\nIf you have not done so already, please submit your payment in the amount of [cost].\r\n\r\nClick here to review your payment information [payment_url].\r\n\r\nYour questions: [custom_questions].’, use_coupon_code = ‘N’, member_only = ‘N’, externalURL = ”, early_disc = ’50’, early_disc_date = ”, early_disc_percentage = ‘Y’, alt_email = ”, question_groups = ‘a:1:{i:1;s:1:\”1\”;}’, allow_overflow = ‘N’, overflow_event_id = 0, additional_limit = 5, reg_limit = 999, email_id = 0, registration_startT = ”, registration_endT = ”, event_meta = ‘a:9:{s:22:\”default_payment_status\”;s:0:\”\”;s:8:\”venue_id\”;i:4;s:28:\”additional_attendee_reg_info\”;s:1:\”1\”;s:28:\”add_attendee_question_groups\”;a:1:{i:1;s:1:\”1\”;}s:14:\”date_submitted\”;s:16:\”December 2, 2013\”;s:13:\”event_hashtag\”;s:0:\”\”;s:12:\”event_format\”;s:0:\”\”;s:18:\”event_livestreamed\”;s:0:\”\”;s:0:\”\”;s:0:\”\”;}’, require_pre_approval = ‘0’, timezone_string = ”, ticket_id = 0 WHERE id = 5
|
|
Josh
|
December 4, 2013 at 5:47 pm
Does it print an actual error message? This looks like it’s outputting what it’s trying to do without printing an actual error.
It may help to know whether this is a WordPress multisite installation or a single site installation. If it’s multisite, is the Event Espresso plugin network activated or activated on a per site basis? It should be activated only on the sites that use it, not network activated.
|
|
kcray
|
December 5, 2013 at 6:46 am
Hi Josh,
I deactivated and reactivated.
It prompted me for the license, so entered the license, even though I’m really testing at this point.
Its a single site wp implementation.
Tried to change the Title of one of the events, and got the following error.
UPDATEwp_events_detailSETevent_name= 'Snowbirds Workshop - Friday March 7th 2014',event_desc= '<strong>Treasure Coast Snowbirds Workshop</strong>\r\nThis is an introduction to Treasure Hunting with hands on experience with some of the best detectors in the industry from Garrett Metal Detectors.\r\n\r\n<strong>Where:</strong> Kiwanis-Hobart Park\r\n5350 77th St Vero Beach, FL 32967\r\n\r\n<strong>When:</strong> Friday March 7th 2014\r\n11:00 - Welcome. – Richard Hart\r\n11:10 – 11:30am Introduction to metal Detecting – Kellyco Rep\r\n11:30 – 12:00pm What type of detector to buy – Garrett rep\r\n12:00 – 12:30pm lunch\r\n12:30 – 2:30pm Buddy-up hands-on detector use.\r\n2:30 – 3:00pm Introduction to your 1st hunt.\r\n\r\n ',display_desc= 'Y',display_reg_form= 'Y',address= '',address2= '',city= '',state= '',zip= '',country= '',phone= '321-276-4211',virtual_url= '',virtual_phone= '',venue_title= '',venue_url= '',venue_phone= '',venue_image= '',registration_start= '',registration_end= '',start_date= '2014-03-07',end_date= '2014-03-07',allow_multiple= 'N',send_mail= 'Y',is_active= 'Y',event_status= 'R',conf_mail= '***This is an automated response - Do Not Reply***\r\n\r\nThank you [fname] [lname] for registering for [event]. We hope that you will find this event both informative and enjoyable. Should have any questions, please contact [contact].\r\n\r\n<strong>Ticket type:</strong> [ticket_type]\r\n\r\n<strong>Print Tickets:</strong> [ticket_link] (A link <a href=\\"http://staging.eventespresso.com/?p=3754\\" target=\\"_blank\\">Your Customized Ticket</a> if the ticketing addon is installed.)\r\n\r\n[qr_code] (generated by the QR Code addon, if installed)\r\n\r\nIf you have not done so already, please submit your payment in the amount of [cost].\r\n\r\nClick here to review your payment information [payment_url].\r\n\r\nYour questions: [custom_questions].',use_coupon_code= 'N',member_only= 'N',externalURL= '',early_disc= '50',early_disc_date= '',early_disc_percentage= 'Y',alt_email= '',question_groups= 'a:1:{i:1;s:1:\"1\";}',allow_overflow= 'N',overflow_event_id= 0,additional_limit= 5,reg_limit= 999,email_id= 0,registration_startT= '',registration_endT= '',event_meta= 'a:9:{s:22:\"default_payment_status\";s:0:\"\";s:8:\"venue_id\";i:4;s:28:\"additional_attendee_reg_info\";s:1:\"1\";s:28:\"add_attendee_question_groups\";a:1:{i:1;s:1:\"1\";}s:14:\"date_submitted\";s:16:\"December 2, 2013\";s:13:\"event_hashtag\";s:0:\"\";s:12:\"event_format\";s:0:\"\";s:18:\"event_livestreamed\";s:0:\"\";s:0:\"\";s:0:\"\";}',require_pre_approval= '0',timezone_string= '',ticket_id= 0 WHEREid= 5
|
|
kcray
|
December 5, 2013 at 6:49 am
<pre class=”brush: sql; gutter: true; first-line: 1; highlight: []; html-script: false”>WordPress database error: [Unknown column 'ticket_id' in 'field list']
UPDATE wp_events_detail SET event_name = 'Snowbirds Workshop – Friday March 7th 2014', event_desc = 'Treasure Coast Snowbirds Workshop\r\nThis is an introduction to Treasure Hunting with hands on experience with some of the best detectors in the industry from Garrett Metal Detectors.\r\n\r\nWhere: Kiwanis-Hobart Park\r\n5350 77th St Vero Beach, FL 32967\r\n\r\nWhen: Friday March 7th 2014\r\n11:00 – Welcome. – Richard Hart\r\n11:10 – 11:30am Introduction to metal Detecting – Kellyco Rep\r\n11:30 – 12:00pm What type of detector to buy – Garrett rep\r\n12:00 – 12:30pm lunch\r\n12:30 – 2:30pm Buddy-up hands-on detector use.\r\n2:30 – 3:00pm Introduction to your 1st hunt.\r\n\r\n ', display_desc = 'Y', display_reg_form = 'Y', address = '', address2 = '', city = '', state = '', zip = '', country = '', phone = '321-276-4211', virtual_url = '', virtual_phone = '', venue_title = '', venue_url = '', venue_phone = '', venue_image = '', registration_start = '', registration_end = '', start_date = '2014-03-07', end_date = '2014-03-07', allow_multiple = 'N', send_mail = 'Y', is_active = 'Y', event_status = 'R', conf_mail = '***This is an automated response – Do Not Reply***\r\n\r\nThank you [fname] [lname] for registering for [event]. We hope that you will find this event both informative and enjoyable. Should have any questions, please contact [contact].\r\n\r\nTicket type: [ticket_type]\r\n\r\nPrint Tickets: [ticket_link] (A link Your Customized Ticket if the ticketing addon is installed.)\r\n\r\n[qr_code] (generated by the QR Code addon, if installed)\r\n\r\nIf you have not done so already, please submit your payment in the amount of [cost].\r\n\r\nClick here to review your payment information [payment_url].\r\n\r\nYour questions: [custom_questions].', use_coupon_code = 'N', member_only = 'N', externalURL = '', early_disc = '50', early_disc_date = '', early_disc_percentage = 'Y', alt_email = '', question_groups = 'a:1:{i:1;s:1:\"1\";}', allow_overflow = 'N', overflow_event_id = 0, additional_limit = 5, reg_limit = 999, email_id = 0, registration_startT = '', registration_endT = '', event_meta = 'a:9:{s:22:\"default_payment_status\";s:0:\"\";s:8:\"venue_id\";i:4;s:28:\"additional_attendee_reg_info\";s:1:\"1\";s:28:\"add_attendee_question_groups\";a:1:{i:1;s:1:\"1\";}s:14:\"date_submitted\";s:16:\"December 2, 2013\";s:13:\"event_hashtag\";s:0:\"\";s:12:\"event_format\";s:0:\"\";s:18:\"event_livestreamed\";s:0:\"\";s:0:\"\";s:0:\"\";}', require_pre_approval = '0', timezone_string = '', ticket_id = 0 WHERE id = 5
|
|
kcray
|
December 5, 2013 at 6:53 am
Hi Again Josh,
It looks like an error. Txt at the top says:
<pre class=”brush: text; gutter: true; first-line: 1; highlight: []; html-script: false”>WordPress database error: [Unknown column 'ticket_id' in 'field list']
Do you want me to reinstall the plugin? and deactivate all add-on plugins?
Cheerz
Ray
|
|
Anonymous
|
December 5, 2013 at 6:56 am
Hi Kcray,
The license wont make any difference at this point.
The odd thing is, both those ‘errors’ posted, arn’t actual error’s they are the update SQL string that it is trying to run, so doesn’t actually show us anything.
Is that the full message seen?
Is WP_DEBUG enabled?
|
|
kcray
|
December 5, 2013 at 7:11 am
Hi Tony,
I’m not sure how to test if debug is set, but was working with previous version prior to upgrade.
I do see the following license error:
<pre class=”brush: text; gutter: true; first-line: 1; highlight: []; html-script: false”>You have the correct Site License Key for Event Espresso but your current membership access only allows for automatic upgrades on one domain. Please log into your account to manage your Site License Keys or purchase a support license now.
Not sure if this is relevant.
|
|
kcray
|
December 5, 2013 at 7:18 am
I checked my online account, and it says that the license is active, and that i have support, so not sure what the message about site license keys is about.
Anyway, I think this may be a side issue as you suggested, lets stay focused on the upgrade and database errors. Would you like me to deactivate all plugins and reinstall the main plugin, eventespresso?
|
|
Anonymous
|
December 5, 2013 at 7:27 am
Licensing errors will not make any difference currently :)
Just to confirm the site is NOT part of a multisite network at all? (just strange that the license has error’d this quickly – usually caused by Multisite)
Would you mind downloading a fresh copy of Event Espresso from the site and installing it manually?
We have a guide posted here http://staging.eventespresso.com/wiki/updating-event-espresso/#update_manually which will guide you through.
|
|
kcray
|
December 5, 2013 at 7:29 am
No Not multisite. Will download and reinstall.
|
|
kcray
|
December 5, 2013 at 8:00 am
Interesting.
Left current add-ons active.
Deleted previous version of main plugin.
Downloaded from my account, looks like a slightly newer version.3.1.36.1.P
WP reported installed successfully.
Activated plugin.
Went to blank screen.
Went to main site. register.kellycodetectors.com
tried to register.
Get the following error.
An error occured while attempting to update the attendee meta.
An error occured. No Attendee was received.
Not sure if this is a function of the draft status of the event?
Went back to plugins, showed it activated ok.
Went to change an event title name again, same type of error.
Perhaps I should delete all plugins, start again from scratch.
Thoughts?
Cheerz
Ray
|
|
Josh
|
December 5, 2013 at 8:04 am
There is this error though:
[Unknown column ‘ticket_id’ in ‘field list’]
Which could mean that the ticket_id column wasn’t created when the database setup scripts were run. Forcing a version number change (eg. updating from Event Espresso 3.1.36.P to 3.1.36.1.P) may help because the database scripts will run right after you update.
When you update, please be sure to let the update scripts finish running. So if you notice that right after you update it takes a longer than usual amount of time to load up the admin, let it keep loading up. If you try to navigate to another page in the admin or try to refresh the page the database scripts may not be able to finish the job.
|
|
Josh
|
December 5, 2013 at 8:07 am
update: deleting the plugins and reinstalling will not help in this case because the issue is within the database. Someone from support staff may need to trouble shoot this further. Can you send FTP credentials and temp admin WordPress credentials via this form so we can investigate further?
http://staging.eventespresso.com/send-login-details/
|
|
kcray
|
December 5, 2013 at 8:12 am
Thanks.
Could have been my impatience. So will delete main plugin, and renstall and leave for period of time after I hit activate.
Will report back.
Cheerz
Ray
|
|
kcray
|
December 5, 2013 at 8:44 am
Successful reinstall.
Activated straight away.
Still same missing field error.
Cheerz
Ray
|
|
kcray
|
December 5, 2013 at 8:54 am
Hey guys, Not a great idea to return login credientials in the clear by public email. This creates a opportunity for a security breach. You might want to consider turning off the email Auto Reply.
|
|
Josh
|
December 5, 2013 at 9:27 am
Sorry about that. I changed the notification settings for that form.
|
|
Josh
|
December 5, 2013 at 10:02 am
I’m afraid I do not have what I need in order to force a database update. This is something that you will need to do:
If you SSH in you go into the wp-content/plugins/event-espresso directory and open up espresso.php and change the version number on lines 9 and 34 so it becomes a slightly new version:
3.1.36.11.P
Then save the file. You will trigger a database script run when you load up another page in the admin after that. You’ll know the script updater is running when that admin page takes a little longer to load up.
|
|
kcray
|
December 5, 2013 at 1:44 pm
Ok, I don’t have permissions at the moment, so will update as soon as I have.
Thanks
|
|
kcray
|
December 5, 2013 at 2:16 pm
Hi Josh,
I got the permissions, made the changes, re-saved the file.
Can you be a little clearer re: ” load up another page in the admin after that.”
Did you mean create a new page in the wp admin ”
I thought I did it, but still get the same error.
Is there any possibility that I’m missing some interim revisions that stop this from working?
Thanks
Ray
321-276-4211
|
|
Josh
|
December 5, 2013 at 2:31 pm
I mean load up a page by visiting another page in the admin in your browser.
I don’t think it’s a case of missing an interim revision. The way Event Espresso updates its tables is if there is a table column that’s missing, it adds it.
It seems that something on your server is preventing the necessary database columns from being added. It almost seems like there was an older version of Event Espresso installed at one time and the way the server is configured now, Event Espresso isn’t able to add any new columns to what is already there. Is this a newer installation of Event Espresso, or was an older version of Event Espresso installed on there before?
Can you check with your server admin and see if they might know a reason why PHP code that runs MySQL commands to create new table rows isn’t being executed? It may help to take a look at the server’s error logs.
If you can make a backup of the wp_options table and the Event Espresso tables (they all have the word _events_ in their name) and email it to us we take take a look at the data for any additional clues. Our email address is support@eventespresso.com
|
|
kcray
|
December 5, 2013 at 2:54 pm
To answer your question, there was a previous version installed on the server before. It was a personal version with ticketing. You should have records of that. So some of the content has carried forward to the new version.
the original email address was dgerrell@kellycodetectors.com
Would this have caused the problem?
|
|
Josh
|
December 5, 2013 at 3:33 pm
I don’t think it would cause the problem, it’s more like another symptom.
Another thing you might try is make a back up of the database, then delete all of the _events_ tables, and drop any options in the wp_options table that have the term “espresso” in the option name. This will in effect give you a clean slate to start with. However, if something else is preventing Event Espresso from creating any new tables, you’ll need to check with the server admin as to why it’s not allowing PHP to create new tables. Or check the server’s error logs.
|
|
kcray
|
December 12, 2013 at 1:29 pm
Hi Josh, After deleting the tables, I was able to successfully update the tables for the current version, so all appears to be working fine now. Thanks for your assistance, This ticket can now be closed!
|
