|
Rodney Cruce
|
July 17, 2013 at 7:07 am
I’ve imported the data and the events are populating inside the events overview, but when I click on an event, it only shows me one section that relates to registration times. None of the full event options are available. Any idea what this could be caused by?
|
|
Dean
|
July 17, 2013 at 7:18 am
Never come across that before. Are events created inside the dashboard showing ok? Can you provide access to the spreadsheet you used? Were there any single quote marks or non basic Latin characters used?
|
|
Rodney Cruce
|
July 17, 2013 at 5:07 pm
I can send the spreadsheet if you’d like, but even the events I make using the add event button are displaying the same page after they have been saved.
|
|
Josh
|
July 17, 2013 at 5:21 pm
Hi Rodney,
It sounds like there is an error being thrown before the Event Options box gets displayed. I’ve seen something like this happen in cases where a plugin didn’t get installed correctly. If you click the Add New Event button does it display the event options?
One thing that you can try is setting wp_debug to true and check for any errors in the event edit screen.
You can use an [FTP client][1] and [a text editor][2] to access and change the line that defines “WP_DEBUG” in the site’s wp-config.php file:
define(‘WP_DEBUG’, true); // enable debugging mode
[1]: http://codex.wordpress.org/FTP_Clients
[2]: http://codex.wordpress.org/Editing_Files#Acceptable_External_Editors
|
|
Rodney Cruce
|
July 17, 2013 at 5:30 pm
I tried uninstalling EE, clearing my DB of all tables related to EE, and reinstalling it. Upon reinstallation, it does not make the tables again, and will not allow me to add a new event because there’s no table to put it in.
Essentially, I made lat/long coordinates in the event meta section, and to do that I broke apart that section in a spreadsheet and added those values to every event. That appears to have screwed up the event options page. How, I’m not sure.
|
|
Rodney Cruce
|
July 17, 2013 at 5:42 pm
It’s crunch time at this point, is there something about my wp-install that is telling EE not to create the tables necessary?
|
|
Josh
|
July 17, 2013 at 5:44 pm
Hi Rodney,
The event import tool does not have support for columns for the event meta section, so that’s probably why it broke. It will only correctly import a file that uses the same format as the sample template.
To get the database tables to re-install you can deactivate Event Espresso, then rev the version number in espresso.php on lines 9 and 35. You can add one more .1 or something like that. Then when you reactivate Event Espresso it will run the database install script.
|
|
Rodney Cruce
|
July 17, 2013 at 5:53 pm
That works for the EE reinstall. As for the import, I didn’t use the import tool in WP. I tried that first, and even used the template, however it tells me 350 events have been created, but none show up in the DB. After that didn’t work, I created an event using the add event button, went into wp_event_detail and literally re-created every single column in google docs. I put in every piece of data exactly as EE stored it, and replicated it for all 350 events in my DB. I then split apart the actual event metadata to include the lat/long that I have stored for every event. Again, I stress that I re-created the data exactly. Down to creating random num/char strings with the same format as the properly created original event through EE. I uploaded it using the Import function in phpmyadmin, which then shows all events in the Event Overview.. but after that upload, I could not access the event info any longer. I don’t get it…
|
|
Rodney Cruce
|
July 17, 2013 at 7:43 pm
Notice: date_default_timezone_set(): Timezone ID ‘UTC-4’ is invalid in /Users/prototype/Server/freelance/OCRMag/wp-content/plugins/event-espresso/includes/functions/time_date.php on line 523
This timezone is currently in standard time.
Fatal error: Uncaught exception ‘Exception’ with message ‘DateTimeZone::__construct(): Unknown or bad timezone (UTC-4)’ in /Users/prototype/Server/freelance/OCRMag/wp-content/plugins/event-espresso/includes/functions/time_date.php:534 Stack trace: #0 /Users/prototype/Server/freelance/OCRMag/wp-content/plugins/event-espresso/includes/functions/time_date.php(534): DateTimeZone->__construct(‘UTC-4’) #1 /Users/prototype/Server/freelance/OCRMag/wp-content/plugins/event-espresso/includes/event-management/edit_event.php(500): eventespresso_ddtimezone(‘2’) #2 /Users/prototype/Server/freelance/OCRMag/wp-content/plugins/event-espresso/includes/event-management/index.php(95): edit_event(‘2’) #3 [internal function]: event_espresso_manage_events(”) #4 /Users/prototype/Server/freelance/OCRMag/wp-includes/plugin.php(406): call_user_func_array(‘event_espresso_…’, Array) #5 /Users/prototype/Server/freelance/OCRMag/wp-admin/admin.php(151): do_action(‘event-espresso_…’) #6 {main} thrown in /Users/prototype/Server/freelance/OCRMag/wp-content/plugins/event-espresso/includes/functions/time_date.php on line 534
|
|
Rodney Cruce
|
July 17, 2013 at 7:46 pm
After changing to UTC vs UTC-4, all was well. However, that was the default setting I believe. Is that supposed to happen?
|
|
Rodney Cruce
|
July 17, 2013 at 7:56 pm
I guess it isn’t the default setting. Got it working though. All seems to be in working order. Thanks for your support!
|
