|
stevestaso
|
November 25, 2015 at 5:04 pm
I updated to current EE4 from a prior version – not sure which prior version.
It went through 2 database updates – all successful.
Everything seems to work fine except the ability to edit prior events.
They show up in the list of events. But if I try to edit them, I get an error on the page. See http://cryocooler.org/wp-content/uploads/ICC19-EE4-error.jpg.
I checked 2 other threads on a similar error, but wasn’t able to resolve this.
My page for Taxes is http://cryocooler.org/wp-content/uploads/ICC19-EE4-taxes.png
I disabled all plugins, and enabled EE4 only.
I switched to basic theme.
I uploaded site specific plugin from http://take.ms/ruFjE
Thanks for any help.
|
|
Josh
|
November 25, 2015 at 6:24 pm
Hi there,
The error you are seeing would happen if the base price in the wp_esp_price_type database table were deleted. You could restore your database to a prior backup, or check the wp_esp_price_type table if you’re familiar with phpmyadmin. It should look like this:
https://www.evernote.com/shard/s4/sh/89deec63-3d9c-4c81-ae19-c59e6838ee4e/8927e875bdc18d5cca21dca7f7a0e3b1
|
|
Josh
|
November 25, 2015 at 6:24 pm
Hi there,
The error you are seeing would happen if the base price in the wp_esp_price_type database table were deleted. You could restore your database to a prior backup, or check the wp_esp_price_type table if you’re familiar with phpmyadmin. It should look like this:
https://www.evernote.com/shard/s4/sh/89deec63-3d9c-4c81-ae19-c59e6838ee4e/8927e875bdc18d5cca21dca7f7a0e3b1
|
|
stevestaso
|
November 25, 2015 at 9:02 pm
Thanks Josh.
I checked the database Seems like it should be. Screenshot here. http://cryocooler.org/wp-content/uploads/ICC19-EE4-pricetype.png
|
|
stevestaso
|
November 25, 2015 at 10:52 pm
It could be related to the tickets and/or price tables.?.
Here is the List of my 3 events – the old ones say “no tickets have been setup for this event”
http://cryocooler.org/wp-content/uploads/ICC19-EE4-events.png
Here are snaps of the 2 tables
esp_ticket – it lists only a few tickets from the old events but all the ones that I created for the new event
esp_price – it lists both old and new. The new ones are 1, 18, 20, 21
http://cryocooler.org/wp-content/uploads/ICC19-EE4-esp_ticket.png
http://cryocooler.org/wp-content/uploads/ICC19-EE4-esp_price.png
|
|
Josh
|
November 26, 2015 at 9:00 am
That last screenshot shows two rows that have 0 for PRT_ID. Somewhere along the way something was deleted that should not have been. Can you try changing the PRT_ID for rows 16 and 17 to 1? It shouldn’t be 0.
|
|
stevestaso
|
November 26, 2015 at 11:51 am
Josh, That’s better. the rest of the page now loads
Tickets are still not 100% accurate for these old events.
But don’t need them anyway.
I can work with this.
Thank you.
I’ll Consider this resolved.
|
|
Josh
|
November 26, 2015 at 1:13 pm
That’s likely from some price types getting deleted somewhere along the way. There’s been some changes to EE4 core since the version you updated from (looks like you updated from 4.6.16) where EE4 has more error proofing to prevent prices from being deleted. Even with that, if a price type that sets a tax gets deleted, you’ll find that the tickets that were once taxable no longer are taxable. This is because the tax price was deleted.
|
