Support

Home Forums Event Espresso Premium Can't create new event, and link to event page gives 404

Can't create new event, and link to event page gives 404

Posted: June 3, 2014 at 5:38 am


Johan Mauritzson

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


Tony

  • Support Staff

June 3, 2014 at 5:41 am

Hi Johan,

If you go to Dashboard -> Settings -> General.

Can you tell me the current Date and Time formates in use please?


Johan Mauritzson

June 3, 2014 at 5:44 am

Sorry, I forgot to mention that I checked that. It’s j F, Y and H:i.


Johan Mauritzson

June 3, 2014 at 6:02 am

Would you like to have a log in for the site?


Tony

  • Support Staff

June 3, 2014 at 6:07 am

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?


Johan Mauritzson

June 3, 2014 at 7:01 am

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.


Tony

  • Support Staff

June 3, 2014 at 2:24 pm

Can you enabled WP_Debug and see if any errors are displayed within that blank screen please?


Johan Mauritzson

June 4, 2014 at 2:46 am

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

  • This reply was modified 9 years, 11 months ago by  Tony. Reason: Removed server details


Johan Mauritzson

June 4, 2014 at 2:49 am

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/x9wqgroqghkodiz/Screen%20Shot%202014-06-04%20at%2010.35.00.png

https://www.dropbox.com/s/hr64ga1vbpva0jt/Screen%20Shot%202014-06-04%20at%2010.35.07.png


Dean

June 4, 2014 at 3:22 am

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.


Johan Mauritzson

June 4, 2014 at 3:29 am

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.


Dean

June 4, 2014 at 4:26 am

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.


Johan Mauritzson

June 4, 2014 at 5:13 am

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?


Dean

June 4, 2014 at 5:50 am

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.


Johan Mauritzson

June 4, 2014 at 6:26 am

Thank you! All sent.


Josh

  • Support Staff

June 4, 2014 at 9:23 am

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:

https://eventespresso.com/requirements/


Johan Mauritzson

June 5, 2014 at 1:23 am

Thank you for your help. I hate IIS-servers. They are always a problem.
I’m gonna look into what can be done and then I will contact you again. I will also try to write directly to the database like you suggested.

Thank you for the help so far!


Dean

June 5, 2014 at 1:25 am

We also dislike IIS servers 🙁

Please let us know how you get on.


Johan Mauritzson

June 16, 2014 at 1:53 am

Hi,
since I removed it and installed the plugin again, and now it does not work, it gives med the red key, I guess that means I need a reset? Would you help me with that?


Johan Mauritzson

June 16, 2014 at 2:15 am

Oh, and about running that query, I only run the second part of the code right?


Dean

June 16, 2014 at 2:43 am

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.

Event Espresso