Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
public-topic
Completely Random Error Started Happening causing a error 500 site-wide
Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
May 18, 2017 - 7:09 pm
sp_QuotePost Quote

one thing I am confused about..  is this happening on all page loads? or just when upgrading simple press??   not clear...

if the latter, could you download the software from here and upload via ftp?  see if we can get past this current issue...

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
May 19, 2017 - 7:34 am
sp_QuotePost Quote

looked into this a bit more this morning...

this is the error you said you receiving:

[18-May-2017 06:51:59 UTC] PHP Fatal error: Uncaught Error: Class 'SimpleXMLElement' not found in /home/WEBHOSTACC/public_html/MAINSITE/wp-content/plugins/simple-press/sp-startup/site/sp-site-support-functions.php:694

like I have said in recent posts, this really doesnt have anything to do with communication with our server...  here is the line of code throwing the error:

$xml = new SimpleXMLElement($body);

its a php error that the class for the instantiation cannot be found... no comms, just a php error... but just an attempt to use a built in php class (http://php.net/manual/en/class.simplexmlelement.php)... but it cannot find it... why??

its built into php 5 and 7... what version do you run?  are you sure that php simplexml is compiled into your php???

I still think something awry on your server...  can you talk to your host?

Avatar
Ryan
Member
sp_UserOfflineSmall Offline
May 19, 2017 - 1:28 pm
sp_QuotePost Quote

Hi Papa,

I spoke with the hosts and they too were a little confused as simplexml was installed, they ran a cPanel re-install and it fixed the issue so think the issue was that SimpleXML had somehow become corrupted which they are looking into finding out how/why but either way it fixed the issue! 🙂

On a side note, I checked the mysql slow log and found one for simple:press forums  in there, not sure where this is being called or why it's slow (I assume because of the number of rows?):

# Time: 170518 2:01:47
# User@Host: root[root] @ localhost [] Id: 53282
# Query_time: 5.703360 Lock_time: 0.000051 Rows_sent: 57615 Rows_examined: 57615
use WEBHOSTACC_MYDATABASE;
SET timestamp=1495069307;
SELECT /*!40001 SQL_NO_CACHE */ * FROM `MYDATABASE_sfposts`;

# Time: 170518 18:42:08
# User@Host: root[root] @ localhost [] Id: 8818
# Query_time: 3.361169 Lock_time: 0.000027 Rows_sent: 57736 Rows_examined: 57736
use WEBHOSTACC_MYDATABASE;
SET timestamp=1495129328;
SELECT /*!40001 SQL_NO_CACHE */ * FROM `MYDATABASE_sfposts`;

Anything my end that can be done to help that?

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
May 19, 2017 - 2:53 pm
sp_QuotePost Quote

good news on the simple xml...  thanks for the update...

those are some weird queries and not one that we do...  yes, its our tables, but we dont execute use statements or timestamping like that...  nor do we out any queries with comments in it like that and typically dont use the backticks either...  do you use a non traditional db engine/frontend?

so leads me to believe you are perhaps running some sort of caching plugin that also does db caching?

Avatar
Ryan
Member
sp_UserOfflineSmall Offline
May 19, 2017 - 4:14 pm
sp_QuotePost Quote

Hi,

The only plugins we run that I could see potentially doing anything like that could be with the Simple:Press tables is...

We run "Redis Object Cache" but surely that should effect other tables if this was the cause.

We also run "GWP Widget Cache (Cached!)" but that's for widgets only, there is no SP widget.

We also use the SP API but are only using the functions:

$memberships = sp_get_user_memberships($member_id);
sp_remove_membership($level, $member_id);
sp_add_membership($level, $member_id);

So it shouldn't be them either...

We're using MySQL with default table type (MyISAM) and cPanel

do you use a non traditional db engine/frontend?

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
May 19, 2017 - 8:03 pm
sp_QuotePost Quote

how often do you see those?  the two shown are quite a long time between...  it wont be slowing down your site if its extremely infrequent like that...  In normal forum usage, I dont even see any queries that just grab all rows in sfposts...  certainly, not something regular... 

even did a quick search (not exhaustive) in the codebase and didnt see anywhere that we do a query like that...  will try looking deeper...

Forum Timezone: Europe/Stockholm
Most Users Ever Online: 1170
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Mr Papa: 19448
Ike: 2086
Brandon: 864
kvr28: 804
jim: 650
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 619
Members: 17364
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10127
Posts: 79625