Posted: June 3, 2014 at 5:38 am
|
Hi, I just bought ans installed this plugin for a customer, I tested it before and it worked great. Now, not so great. When I try to add an event it says “Something went wrong with setting the date/time. Likely, either there is an invalid datetime string or an invalid timezone string being used. FLD-DTTFLD-PREFORSETWITNEWTIM-246”. Then the text edit window is locked and I can’t add dates/tickets. The first time I could actually add an event but as soon as I tried to create dates and tickets and then save, the page would go all blank. sending me to post.php. Also when I clicked preview I just got “The page could not be found”. I can see that it shows two different paths, one with http://www.sitename.com/events and one http://www.sitename.com/evenemang, using the translation from the po-file. I removed the Swedish translation and it still acts the same way. Please, I need somw quick assistance with this. I can create a login for you if you let me know where to send it. /Johan |
Hi Johan, If you go to Dashboard -> Settings -> General. Can you tell me the current Date and Time formates in use please? |
|
|
Sorry, I forgot to mention that I checked that. It’s j F, Y and H:i. |
|
Would you like to have a log in for the site? |
That Date Format is not compatible Event Espresso. When using PHP 5.2 and that time format is passed to strtotime() an invalid response is returned, which in turn causes compatibility issues within Event Espresso. Try chaning the date format to j F Y (no comma) and re-creating an Event. Does it not create as expected? |
|
|
Thank you, that solved the first problem. Now I can edit the Event, however when I hit Publish it just goes blank and goes to /wp-admin/post.php and nothing is saved. |
Can you enabled WP_Debug and see if any errors are displayed within that blank screen please? |
|
|
Thanks for helping out Tony, I turned it on for a quick second (it’s a live site) and tried to add an event. Here is what I got: Deprecated: Assigning the return value of new by reference is deprecated in \wp-content\themes\goodwork\pixelentity-theme-update\class-pixelentity-theme-update.php on line 34 Fatal error: Uncaught exception ‘EE_Error’ with message ‘Error inserting values 0,Kursstart,,2014-07-31 06:00:00,2014-08-06 15:00:00,-1,0,,1,0, for columns EVT_ID,DTT_name,DTT_description,DTT_EVT_start,DTT_EVT_end,DTT_reg_limit,DTT_sold,DTT_is_primary,DTT_order,DTT_parent,DTT_deleted, using data types %d,%s,%s,%s,%s,%d,%d,%d,%d,%d,%d, into table wp_esp_datetime. Error was Table ‘elajotec_ny.wp_esp_datetime’ doesn’t exist’ in \wp-content\plugins\event-espresso-core-reg\core\db_models\EEM_Base.model.php:1227 Stack trace: #0 \wp-content\plugins\event-espresso-core-reg\core\db_models\EEM_Base.model.php(1107): EEM_Base->_insert_into_specific_table(Object(EE_Primary_Table), Array, false) #1 \wp-content\plugins\event-espresso-core-reg\core\db_classes\EE_Base_Class.class.php(971): EEM_Base->insert(Array, true) #2 \wp-content\plugins\event-espresso-core-reg\caffeinated\admi in \wp-content\plugins\event-espresso-core-reg\core\db_models\EEM_Base.model.php on line 1227
|
|
I also have some screenshots of what the admin window looked like when I was adding the data. There were error messages there too. https://www.dropbox.com/s/hr64ga1vbpva0jt/Screen%20Shot%202014-06-04%20at%2010.35.07.png |
|
Looks like a database table is missing for some reason. Can you try deactivating the plugin and reactivating it please. Let’s see if that kicks in the missing table. |
|
Hi Dean, I tried that just now, but there was no difference. Should I totally uninstall it and then reinstall? I have no data in it so it does not matter. |
|
Hi, You could certainly give it a go. If that doesn’t work, let me know. I will probably ask for login details at that point to look at the plugin and database. |
|
Hi Dean, I used the uninstall and then reinstalled through the FTP this time. No difference, I get the same result, it just goes blank. Where can I send your login? |
|
Please send them via https://eventespresso.com/send-login-details/ NOTE: login details need to be Admin level and FTP details are appreciated. Also, I will need to add a plugin to your site temporarily (Adminer) please advise if this is not ok. |
|
Thank you! All sent. |
Hi Johan, I checked your site and it turns out that both of the issues you’re seeing are because this site is running on a Windows IIS7.5 server. The link to the event page issue could possibly be fixed by changing the site to use WordPress’s default permalink setting. The database errors you’re seeing are from tables not being created on activation. The scripts that handle this were written and tested on servers that run Apache and also nginx. They are not compatible with IIS. Our recommendation is the site gets moved to a supported server. Either Apache or nginx will be fine. If you absolutely cannot move the site to a supported server environment, you could setting the permalinks to use default. You can also manually add the missing tables by running this query from PHPmyadmin: http://cl.ly/code/3s1A0D3N472Y This may fix things for you, but please be aware there may be other issues that pop up due to the site being installed on an unsupported environment. We try to make it known which servers are supported on our requirements page, and have a free plugin that will let you know whether your server will be compatible with Event Espresso. Both of these resources are available here: |
|
|
Thank you for your help. I hate IIS-servers. They are always a problem. Thank you for the help so far! |
|
We also dislike IIS servers 🙁 Please let us know how you get on. |
|
Hi, |
|
Oh, and about running that query, I only run the second part of the code right? |
|
Hi, Reset has been done for you. Regarding the code, you should be fine to run all of it. As always, back up your database before attempting something like this. |
The support post ‘Can't create new event, and link to event page gives 404’ is closed to new replies.
Have a question about this support post? Create a new support post in our support forums and include a link to this existing support post so we can help you.