Support Forum

Problem after updating

GI giorgiokatr
giorgiokatr
Member

Hi

Today after updating simple press everything broke even my theme.

My mistake was that i updated together with another plugin and i did not see anywhere the upgrade database option

now i get sql errors everywhere in forum

 

 

42 Answers

New Answer

YS Yellow Swordfish
Yellow Swordfish
Member

It looks like perhaps the database upgrades did not take place. Probably the best thing to do would be to restore to a database backup and run the upgrade again. Are you able to do that?

GI giorgiokatr
giorgiokatr
Member

so i must restore to previous version of db and also update ftp with the previous version of simple press files also?

i would like to avoid i my previous backup is 2 days before and i have some submissions that i must reinstall

i forgot to say that after the update the upgrade appeared but it ended with

Upgrade Aborted
current build: 10756
{“status”:”success”,”type”:”upgrade”,”section”:10774,”response”:”Build upgrade section 10774 executing. Status: success
“,”error”:””}

 

now in my error log  i have

SELECT error_count FROM wp_sferrorlog WHERE keycheck=”1864

 

and many other

thanks!

MP Mr Papa
Mr Papa
Member

so it looks like the upgrade did not run… more than likely another plugin is interfering and hijacking the ajax request and response causing the failure…  but oddly, now you say the forum is accessible and does not have an update waiting?

 

GI giorgiokatr
giorgiokatr
Member

yes it seems thats ecerything is ok without telling me

to update but in frontend the forum is blank and a green pop up says sql error query

also many functions of my site broke…

so for now i disabled simple press

MP Mr Papa
Mr Papa
Member

well, you wont be able to fix it with it disabled…  and what do you mean it broke functions of your site?

with it running, what did you see in the admin?  is it still prompting you for an upgrade?

GI giorgiokatr
giorgiokatr
Member

 

no it does not prompt me to upgrade.

my js on my site broke like galleria in my listings and other.

 

 

MP Mr Papa
Mr Papa
Member

what version were you upgrading from? 5.3.2?

GI giorgiokatr
giorgiokatr
Member

Mr Papa said
what version were you upgrading from? 5.3.2?

No i think 5.3.3. but the previous number if i am not wrong.

I think that the only solution is to restore the previous database….

#$#%!!!!!

MP Mr Papa
Mr Papa
Member

we can try the upgrades manually if you like, but if you dont know what version, will have to ask some more questions and figure out the last upgrade that did work…

GI giorgiokatr
giorgiokatr
Member

No i have 5.3.3 10774

previous i had 5.32 10756

 

can we make a try?

MP Mr Papa
Mr Papa
Member

sure, but need to confirm  you had 5.3.2 because it doesnt look like it… at least based on the first error you reported…  it would be missing the 5.3.2 stuff…

so lets look at your database… please tell me the structure of the sferrorlog table…

and see if you have a sfspecialranks table…

both of those table names will be preceded by your db prefix (ie wp_)…

GI giorgiokatr
giorgiokatr
Member

yes there are the two tables…

what to do?

MP Mr Papa
Mr Papa
Member

good that ranks is there… but I asked for the structure of sferrorlog… what columns and type are there?

GI giorgiokatr
giorgiokatr
Member

 id error_date error_type error_text error_cat keycheck error_count

 spaErrError  174ry/sp-admin-bar-components.php

spaErrError   1864s/sp-api/sp-api-primitives.php

spaErrError   196ontent/sp-template-control.php

spaErrNotice   Notice870s/sp-api/sp-api-primitives.php

spaErrWarning  Warning114-press/sp-api/sp-api-auths.phpc

spaErrWarning   Warning114-press/sp-api/sp-api-auths.phpc

spaErrWarning Warning114-press/sp-api/sp-api-auths.phpc