Support Forum
Support Forum
Offline
Hi all,
may be I'm unlucky because I made a search with "sferrorlog" and only one result with similar issue.
My sferrorlog table is filled with a rhythm of 10/20 records per second, so I ask a hand.
I attach a shortened part of content (made a dump and cut) so you can see records, time and type, at least part of them, I hope that this helps to find a solution.
When this log was filled only two users were on forum, me and another admin.
What I'd like, apart understand and repair what is wrong, is to avoid that this table be filled.
My hoster put in stand by the db if across 100k queries per hour so I have to avoid, even if one or more errors are present, to write so many queries in any case, error or not because I prefer to maintain the forum active instead to fill db with so many queries and Mb.
How can I block this process or, at least, limit queries to a defined number? (let say 100 per hour)
I had to deactivate the forum until this problem is solved.
Thanks in advance for assistance
Marco
Hakuna Matata
Offline
You are getting a lot of Object not found messages. You must be running php 5.4. That is something they just changed/added. It doesn't cause any issues except note it in. Do you have a choice of which php version you can run? Maybe go back to 5.3 until a new SP update comes out?
Custom Simple Press Themes
Offline
Hi Brandon,
if is that simple, of course I can 
You're right, I run PHP 5.4 and for sure can switch to 5.3 and wait.
Thanks a lot for so quick assistance
Marco
Hakuna Matata
Offline
I did, I had to wait that PHP downgrade but now when reactivate SP it breaks all and shows me only a white page, no administration at all.
Can access to admin only renaming via FTP the SP folder so this deactivate the plugin and admin panel can work.
I tried three time and the same behavior.
Any idea?
Hakuna Matata
Offline
sounds like a problem downgrading?? sp and wp only needs 5.1..
If you would rather make a few simple code changes to the 5.1.4 you have, you can fix the majority of the stupid php 5.4 warning chagne... from : to format... basically, adding $var = new stdClass(); to init object... few others, but this is key ones and you would know how to make the others... 
| /trunk/forum/content/sp-common-view-functions.php |
|---|
| 413,7 → 413,7 |
| # make sure we are displaying avatars |
| $spAvatars = sp_get_option('sfavatars'); |
| if ($spAvatars['sfshowavatars'] == true) { |
| $avatarData = ''; |
| $avatarData = new stdClass(); |
| $avatarData->object = false; |
| $avatarData->userId = 0; # need user id OR email |
| $avatarData->email = ''; |
| /trunk/forum/content/classes/sp-topic-view-class.php |
|---|
| 238,6 → 238,7 |
| $this->topicViewStatus = 'data'; |
| # construct the parent topic object |
| $t[$tidx] = new stdClass(); |
| $t[$tidx]->topic_id = $r->topic_id; |
| $t[$tidx]->forum_id = $r->forum_id; |
| $t[$tidx]->topic_name = sp_filter_title_display($r->topic_name); |
| 276,6 → 277,7 |
| $pinned = 0; |
| foreach ($records as $r) { |
| $pidx = $r->post_id; |
| $t[$tidx]->posts[$pidx] = new stdClass(); |
| $t[$tidx]->posts[$pidx]->post_id = $r->post_id; |
| $t[$tidx]->posts[$pidx]->post_date = $r->post_date; |
| $t[$tidx]->posts[$pidx]->user_id = $r->user_id; |
| 360,6 → 362,7 |
| $edits = unserialize($r->post_edit); |
| $eidx = 0; |
| foreach ($edits as $e) { |
| $t[$tidx]->posts[$pidx]->edits[$eidx] = new stdClass(); |
| $t[$tidx]->posts[$pidx]->edits[$eidx]->by = $e['by']; |
| $t[$tidx]->posts[$pidx]->edits[$eidx]->at = $e['at']; |
| $eidx++; |
| /trunk/forum/content/classes/sp-list-topic-class.php |
|---|
| 205,6 → 205,7 |
| if ($show) { |
| $t = $r->topic_id; |
| $list[$t] = new stdClass(); |
| $list[$t]->forum_id = $r->forum_id; |
| $list[$t]->forum_name = sp_filter_title_display($r->forum_name); |
| $list[$t]->forum_permalink = sp_build_url($r->forum_slug, '', 1, 0); |
| 324,6 → 325,7 |
| foreach ($postrecords as $p) { |
| if ($p->topic_id != $cTopic) { |
| $cTopic = $p->topic_id; |
| $newList[$cTopic] = new stdClass(); |
| $newList[$cTopic]->topic_id = $cTopic; |
| $newList[$cTopic]->new_post_count = $p->new_post_count; |
| $newList[$cTopic]->new_post_post_id = $p->post_id; |
| 359,6 → 361,7 |
| if($postrecords) { |
| foreach ($postrecords as $p) { |
| $cTopic = $p->topic_id; |
| $first[$cTopic] = new stdClass(); |
| $first[$cTopic]->topic_id = $cTopic; |
| $first[$cTopic]->post_id = $p->post_id; |
| $first[$cTopic]->post_date = $p->post_date; |
| /trunk/forum/content/classes/sp-forum-view-class.php |
|---|
| 318,6 → 318,7 |
| # construct the parent forum object |
| $r = current($records); |
| $f[$fidx] = new stdClass(); |
| $f[$fidx]->forum_id = $r->forum_id; |
| $f[$fidx]->forum_slug = $r->forum_slug; |
| $f[$fidx]->forum_name = sp_filter_title_display($r->forum_name); |
| 347,6 → 348,7 |
| foreach ($records as $r) { |
| $tidx = $r->topic_id; |
| $t[] = $tidx; |
| $f[$fidx]->topics[$tidx] = new stdClass(); |
| $f[$fidx]->topics[$tidx]->topic_id = $r->topic_id; |
| $f[$fidx]->topics[$tidx]->topic_slug = $r->topic_slug; |
| $f[$fidx]->topics[$tidx]->topic_name = sp_filter_title_display($r->topic_name); |
| /trunk/forum/content/classes/sp-group-view-class.php |
|---|
| 265,6 → 265,7 |
| $this->groupViewStatus = 'data'; |
| $gidx = $groupid; |
| $fidx = 0; |
| $g[$gidx] = new stdClass(); |
| $g[$gidx]->group_id = $r->group_id; |
| $g[$gidx]->group_name = sp_filter_title_display($r->group_name); |
| $g[$gidx]->group_desc = sp_filter_title_display($r->group_desc); |
| 311,6 → 312,7 |
| # it's a top level forum |
| $subPostId=0; |
| $fidx = $forumid; |
| $g[$gidx]->forums[$fidx] = new stdClass(); |
| $g[$gidx]->forums[$fidx]->forum_id = $r->forum_id; |
| $g[$gidx]->forums[$fidx]->forum_id_sub = 0; |
| $g[$gidx]->forums[$fidx]->forum_name = sp_filter_title_display($r->forum_name); |
Visit Cruise Talk Central and Mr Papa's World
Offline
Hi Steve,
what is this? have to change the code in 5 files? and after SP will work with PHP 5.3 or 5.4? by now it's running 5.3 as per Brandon advice. What I have to do?
Actually, I don't need to experiment, need a quick solution as site is online now.
Please, explain me steps and, if should be possible, as I'm abroad and out of office, could you, please, attach the whole file to substitute, as I have problem to make modifies in this moment,
Thanks in advance
Marco
Hakuna Matata
Offline
those are the code changes coming in the next version of SP to handle the new php 5.4 way of dealing with objects... if you made those code changes, you could go back to php 5.4...
I am afraid not much I can do to help debug php 5.3 on your server - you would need to talk to your host...
experiment??? who said anything about an experiment?? Those code changes are already in the next development version of simple press which is already running on our site here... so definitely not experimental...
but I cannot just send you the files either as they may have additional changes for the next version that wont work with the other files you have in the current simple press version... If I get a chance tonight, perhaps I can create a new file from the current release version... sorry, from the discussions I had just thought you might be up to a handful of code changes...
Visit Cruise Talk Central and Mr Papa's World
Offline
Hi Steve,
may be I didn't express myself well, with experiments I mean that on my case I'll test code that isn't shared, yet.
Anyway, I cannot make these changes now, I'm in a Starbucks coffee I'll do tomorrow and if before that time you'll have a public fix will be welcome, if not, I modify, go back to 5.4 and test, hope all goes well.
Anyway, just in case, there is a method to avoid to register all errors log?
Thanks
Marco
Hakuna Matata
Offline
http://stackoverflow.com/quest.....-reporting
you want to turn off the php option in your php.ini to log errors...
Visit Cruise Talk Central and Mr Papa's World
Offline
Hi Steve,
we are almost there...
I made all your modifies and almost all errors are disappeareds, need only some finetune to be complete, I think.
These are what reported in sferrorlog after modified files:
(1261, '2012-10-18 15:14:55', 'php', 'file: /simple-press/forum/database/sp-db-statistics.php<br />line: 163<br />function: sp_get_stats_counts<br />Warning | Creating default object from empty value'),
(1262, '2012-10-18 15:14:56', 'database', 'file: /path/to/wp/installation/wp-content/plugins/simple-press/sp-api/sp-api-primitives.php<br />line: 312<br />function: sp_update_sfmeta<br />error: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''s birthdays and upcoming birthdays.</p>n <p>Just download, install and ac'' at line 4<br /><br />UPDATE sim_sfmeta SETrn meta_type=''news'',rn meta_key=''news'',rn meta_value=''a:3:{s:2:"id";s:1:"4";s:4:"show";i:1;s:4:"news";s:639:"n n <h4><b>New - Post Thanks and Birthdays Plugins Released</b></problem-with-post-edit-button4>n <p>Now available to download - the Birthdays plugin for your Simple:Press forum.</p>n <p><b>Post Thanks</b>: Allows your users to give thanks to post authors for good post and includes a points/reputation system.</p>n <p><b>Birthdays</b>: Allows your users to enter birtdate info in their profile and for you forum to show Today''s birthdays and upcoming birthdays.</p>n <p>Just download, install and activate. Available on our <a href="https://simple-press.com/download-plugins/">Plugins Download Page</a>.</p>n n ";}'',rn autoload=0rn WHERE meta_id=15'),
(1263, '2012-10-18 15:52:29', 'php', 'file: /simple-press/forum/database/sp-db-statistics.php<br />line: 163<br />function: sp_get_stats_counts<br />Warning | Creating default object from empty value'),
(1264, '2012-10-18 15:52:29', 'php', 'file: /simple-press/forum/database/sp-db-statistics.php<br />line: 163<br />function: Unavailable<br />Warning | Creating default object from empty value');
what to do in this case?
Thanks in advance
Marco
Hakuna Matata
All RSS1 Guest(s)