Support Forum

a couple of error logs after upgrading 4.4.5 to 5.0

OV ovizii
ovizii
Member
Member since Jan 2007
63 posts
Feb 22, 2012 · 3:33 am · Edited

anyone able to help out with these? anything to be done?

 

Date Type Description
20.02.12
14:51		 database file: /var/www/clients/client1/web6/web/wp-content/plugins/simple-press/forum/content/classes/sp-list-topic-class.php
line: 165
function: select
error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘:1:{i:0;s:56:”a:1:{i:0;s:38:”a:1:{i:0;s:20:”a:1:{i:0;s:3:”101″;}”;}”;}”;},215,44’ at line 3

SELECT wpwp_sftopics.forum_id, forum_name, forum_slug, wpwp_sftopics.topic_id, topic_name, topic_slug, wpwp_sftopics.post_count, wpwp_sftopics.post_id, post_status, post_index, post_date, guest_name, wpwp_sfposts.user_id, post_content, display_name FROM wpwp_sftopics JOIN wpwp_sfforums ON wpwp_sfforums.forum_id = wpwp_sftopics.forum_id JOIN wpwp_sfgroups ON wpwp_sfgroups.group_id = wpwp_sfforums.group_id JOIN wpwp_sfposts ON wpwp_sfposts.post_id = wpwp_sftopics.post_id LEFT JOIN wpwp_sfmembers ON wpwp_sfmembers.user_id = wpwp_sfposts.user_id WHERE wpwp_sftopics.topic_id IN (a:1:{i:0;s:56:”a:1:{i:0;s:38:”a:1:{i:0;s:20:”a:1:{i:0;s:3:”101″;}”;}”;}”;},215,44,273,319,370,387,392,405,415) ORDER BY group_seq, forum_seq, wpwp_sftopics.post_id DESC
20.02.12
14:21		 php file: /clients/client1/web6/web/wp-content/sp-resources/forum-plugins/subscriptions/library/sp-subscriptions-components.php
line: 322
function: Unavailable
Notice | Trying to get property of non-object
20.02.12
14:21		 php file: /clients/client1/web6/web/wp-content/sp-resources/forum-plugins/subscriptions/library/sp-subscriptions-components.php
line: 322
function: sp_subscriptions_render_user_subscriptions
Notice | Trying to get property of non-object
20.02.12
14:21		 php file: /clients/client1/web6/web/wp-content/sp-resources/forum-plugins/subscriptions/library/sp-subscriptions-components.php
line: 322
function: sp_subscriptions_render_user_subscriptions
Notice | Trying to get property of non-object
20.02.12
14:21		 php file: /clients/client1/web6/web/wp-content/sp-resources/forum-plugins/subscriptions/library/sp-subscriptions-components.php
line: 321
function: sp_subscriptions_render_user_subscriptions
Notice | Trying to get property of non-object
20.02.12
14:21		 php file: /clients/client1/web6/web/wp-content/sp-resources/forum-plugins/subscriptions/library/sp-subscriptions-components.php
line: 321
function: sp_subscriptions_render_user_subscriptions
Notice | Trying to get property of non-object
20.02.12
14:21		 database file: /var/www/clients/client1/web6/web/wp-content/sp-resources/forum-plugins/subscriptions/admin/sp-subscriptions-admin-users.php
line: 18
function: sp_subscriptions_render_user_subscriptions
error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘:1:{i:0;s:56:”a:1:{i:0;s:38:”a:1:{i:0;s:20:”a:1:{i:0;s:3:”101″;}”;}”;}”;}’ at line 4

SELECT topic_id, topic_slug, topic_name, forum_slug FROM wpwp_sftopics JOIN wpwp_sfforums ON wpwp_sftopics.forum_id = wpwp_sfforums.forum_id WHERE topic_id = a:1:{i:0;s:56:”a:1:{i:0;s:38:”a:1:{i:0;s:20:”a:1:{i:0;s:3:”101″;}”;}”;}”;}
20.02.12
14:21		 php file: /clients/client1/web6/web/wp-content/sp-resources/forum-plugins/subscriptions/library/sp-subscriptions-components.php
line: 322
function: sp_subscriptions_render_user_subscriptions
Notice | Trying to get property of non-object
20.02.12
14:21		 php file: /clients/client1/web6/web/wp-content/sp-resources/forum-plugins/subscriptions/library/sp-subscriptions-components.php
line: 322
function: sp_subscriptions_render_user_subscriptions
Notice | Trying to get property of non-object
20.02.12
14:21		 php file: /clients/client1/web6/web/wp-content/sp-resources/forum-plugins/subscriptions/library/sp-subscriptions-components.php
line: 321
function: sp_subscriptions_render_user_subscriptions
Notice | Trying to get property of non-object
20.02.12
14:21		 php file: /clients/client1/web6/web/wp-content/sp-resources/forum-plugins/subscriptions/library/sp-subscriptions-components.php
line: 321
function: sp_subscriptions_render_user_subscriptions
Notice | Trying to get property of non-object
20.02.12
14:21		 database file: /var/www/clients/client1/web6/web/wp-content/sp-resources/forum-plugins/subscriptions/admin/sp-subscriptions-admin-users.php
line: 18
function: sp_subscriptions_render_user_subscriptions
error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘:1:{i:0;s:66:”a:1:{i:0;s:48:”a:1:{i:0;s:30:”a:2:{i:0;s:1:”7″;i:1;s:1:”6″;}”;}”;}’ at line 4

SELECT topic_id, topic_slug, topic_name, forum_slug FROM wpwp_sftopics JOIN wpwp_sfforums ON wpwp_sftopics.forum_id = wpwp_sfforums.forum_id WHERE topic_id = a:1:{i:0;s:66:”a:1:{i:0;s:48:”a:1:{i:0;s:30:”a:2:{i:0;s:1:”7″;i:1;s:1:”6″;}”;}”;}”;}
20.02.12
13:47		 database file: /var/www/clients/client1/web6/web/wp-content/sp-resources/forum-plugins/watches/sp-watches-plugin.php
line: 108
function: sp_watches_do_install
error: Duplicate column name ‘watches’

ALTER TABLE wpwp_sfmembers ADD (watches longtext)
20.02.12
13:47		 database file: /var/www/clients/client1/web6/web/wp-content/sp-resources/forum-plugins/watches/sp-watches-plugin.php
line: 108
function: sp_watches_do_install
error: Duplicate column name ‘topic_watches’

ALTER TABLE wpwp_sftopics ADD (topic_watches longtext)
20.02.12
13:47		 database file: /var/www/clients/client1/web6/web/wp-content/sp-resources/forum-plugins/subscriptions/sp-subscriptions-plugin.php
line: 125
function: sp_subscriptions_do_install
error: Duplicate column name ‘subscribe’

ALTER TABLE wpwp_sfmembers ADD (subscribe longtext)
20.02.12
13:47		 database file: /var/www/clients/client1/web6/web/wp-content/sp-resources/forum-plugins/subscriptions/sp-subscriptions-plugin.php
line: 125
function: sp_subscriptions_do_install
error: Duplicate column name ‘topic_subs’

ALTER TABLE wpwp_sftopics ADD (topic_subs longtext)
20.02.12
13:05		 php file: /simple-press/admin/panel-themes/support/spa-themes-prepare.php
line: 101
function: Unavailable
Warning | opendir(/var/www/clients/client1/web6/web/wp-content/sp-resources/forum-themes): failed to open dir: No such file or directory
20.02.12
13:05		 php file: /simple-press/admin/panel-themes/support/spa-themes-prepare.php
line: 101
function: opendir
Warning | opendir(/var/www/clients/client1/web6/web/wp-content/sp-resources/forum-themes): failed to open dir: No such file or directory
20.02.12
13:05		 php file: /simple-press/sp-api/sp-api-plugins.php
line: 57
function: Unavailable
Warning | opendir(/var/www/clients/client1/web6/web/wp-content/sp-resources/forum-plugins): failed to open dir: No such file or directory
20.02.12
13:05		 php file: /simple-press/sp-api/sp-api-plugins.php
line: 57
function: opendir
Warning | opendir(/var/www/clients/client1/web6/web/wp-content/sp-resources/forum-plugins): failed to open dir: No such file or directory
20.02.12
13:03		 php file: /simple-press/admin/panel-themes/support/spa-themes-prepare.php
line: 101
function: Unavailable
Warning | opendir(/var/www/clients/client1/web6/web/wp-content/sp-resources/forum-themes): failed to open dir: No such file or directory
20.02.12
13:03		 php file: /simple-press/admin/panel-themes/support/spa-themes-prepare.php
line: 101
function: opendir
Warning | opendir(/var/www/clients/client1/web6/web/wp-content/sp-resources/forum-themes): failed to open dir: No such file or directory

9 Answers

New Answer
YS Yellow Swordfish
Yellow Swordfish
Member
Member since Nov 2008
16,437 posts
Feb 22, 2012 · 6:08 am

At first glance I would say there is something wrong with the SP subscriptions plugin though those ‘opendir’ errors at the bottom are also worrying.

I would check, if you would, the sp-resources folder and it’s sub-folders, for permissions and ownership. We have had one or two that seemed to get that wrong (usually a server issue creating folders with the wrong user). After that I would suggest you re-upload the subscriptions plugin as there is clearly something amiss with that.

You don’t seem to be having an easy ride of this and I am sorry about that.

OV ovizii
ovizii
Member
Member since Jan 2007
63 posts
Feb 22, 2012 · 9:05 am

checked all perms and ownership, deleted the subscription plugin, deleted the log file, uploaded again, will report back if other issues arise.

 

Don’t worry about these issues, I have backups and your support is always great. after all I’ve stuck to Simple:Press for a few years now 🙂

OV ovizii
ovizii
Member
Member since Jan 2007
63 posts
Feb 22, 2012 · 10:51 am

anything this tells you:

 

[Wed Feb 22 17:24:00 2012] [warn] [client 196.210.184.173] mod_fcgid: stderr: PHP Warning:  closedir() expects parameter 1 to be resource, boolean given, referer: http://www.die-kellerkinder.eu/wp-admin/admin.php?page=simple-press/admin/panel-themes/spa-themes.php

MP Mr Papa
Mr Papa
Member
Member since Dec 2006
19,448 posts
Feb 22, 2012 · 8:48 pm

so you did verify the owners of the sp-resources directory?? looks like they cannot be read…  not the parent, but the unix (assuming that is your server os) user that owns the dir… of the form name:name

OV ovizii
ovizii
Member
Member since Jan 2007
63 posts
Feb 23, 2012 · 4:01 am

jepp, all done before hand:

 

chown -R web6:client1 web/ 

chmod -R 755 web/

 

everything in the web folder now has the proper perms.

 

Some of the errors are weird:

file: /simple-press/admin/panel-themes/forms/spa-themes-editor-form.php
line: 115
function: opendir
Warning | opendir(/var/www/clients/client1/web6/web/wp-content/sp-resources/forum-themes/kk/styles/overlays): failed to open dir: No such file or directory

 

Now you need to know that I copied everything in the css-only theme folder into a folder called kk and changed the theme name and am currently customizing that theme. BUT the css-only theme never had a overlays folder so why is it looking for kk/styles/overlays !?

 

Do you think uploading Simple:Press itself will help? Maybe I managed to break some Files during the upload?

 

some more error logs after setting the permissions and ownership again and emptying the error log:

Date Type Description
23.02.12
10:42		 php file: /simple-press/admin/panel-themes/forms/spa-themes-editor-form.php
line: 122
function: Unavailable
Warning | closedir() expects parameter 1 to be resource, boolean given
23.02.12
10:42		 php file: /simple-press/admin/panel-themes/forms/spa-themes-editor-form.php
line: 122
function: closedir
Warning | closedir() expects parameter 1 to be resource, boolean given
23.02.12
10:42		 php file: /simple-press/admin/panel-themes/forms/spa-themes-editor-form.php
line: 115
function: opendir
Warning | opendir(/var/www/clients/client1/web6/web/wp-content/sp-resources/forum-themes/kk/styles/overlays): failed to open dir: No such file or directory
23.02.12
10:37		 php file: /simple-press/admin/panel-themes/forms/spa-themes-editor-form.php
line: 122
function: Unavailable
Warning | closedir() expects parameter 1 to be resource, boolean given
23.02.12
10:37		 php file: /simple-press/admin/panel-themes/forms/spa-themes-editor-form.php
line: 122
function: closedir
Warning | closedir() expects parameter 1 to be resource, boolean given
23.02.12
10:37		 php file: /simple-press/admin/panel-themes/forms/spa-themes-editor-form.php
line: 115
function: opendir
Warning | opendir(/var/www/clients/client1/web6/web/wp-content/sp-resources/forum-themes/kk/styles/overlays): failed to open dir: No such file or directory
23.02.12
10:37		 php file: /simple-press/admin/panel-themes/forms/spa-themes-editor-form.php
line: 122
function: Unavailable
Warning | closedir() expects parameter 1 to be resource, boolean given
23.02.12
10:37		 php file: /simple-press/admin/panel-themes/forms/spa-themes-editor-form.php
line: 122
function: closedir
Warning | closedir() expects parameter 1 to be resource, boolean given
23.02.12
10:37		 php file: /simple-press/admin/panel-themes/forms/spa-themes-editor-form.php
line: 115
function: opendir
Warning | opendir(/var/www/clients/client1/web6/web/wp-content/sp-resources/forum-themes/kk/styles/overlays): failed to open dir: No such file or directory
MP Mr Papa
Mr Papa
Member
Member since Dec 2006
19,448 posts
Feb 23, 2012 · 5:48 pm

no, the css only theme does not have overlays… and if we are checking for them, that might be the reason for those…

will open a ticket to see if we missed check for overlays before opening…  thanks…

OV ovizii
ovizii
Member
Member since Jan 2007
63 posts
Feb 24, 2012 · 4:02 am

Thanks.

just wanted to add that when editing the new theme, based on css-only I didn’t add anything. All I did s far was go through and comment lines I don’t want/need as in taking out the moderator function showing new/unread posts etc.

MP Mr Papa
Mr Papa
Member
Member since Dec 2006
19,448 posts
Feb 24, 2012 · 8:54 am

this has been corrected for the next version…