Support Forum
Support Forum
Add Reply
Add Topic
Offline
Quoteone 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...
Visit Cruise Talk Central and Mr Papa's World
Offline
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?
Visit Cruise Talk Central and Mr Papa's World
OfflineHi 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?
Offline
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?
Visit Cruise Talk Central and Mr Papa's World
OfflineHi,
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?
Offline
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...
Visit Cruise Talk Central and Mr Papa's World
All RSS1 Guest(s)