Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
general-topic
a couple of error logs after upgrading 4.4.5 to 5.0
Avatar
ovizii
Member
Free Members
sp_UserOfflineSmall Offline
Feb 22, 2012 - 3:33 am

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
Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
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.

andy-signature.png
YELLOW
SWORDFISH
Avatar
ovizii
Member
Free Members
sp_UserOfflineSmall Offline
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 🙂

Avatar
ovizii
Member
Free Members
sp_UserOfflineSmall Offline
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

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
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

Avatar
ovizii
Member
Free Members
sp_UserOfflineSmall Offline
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
Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
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...

Avatar
ovizii
Member
Free Members
sp_UserOfflineSmall Offline
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.

Avatar
Mr Papa
Simi Valley, CA
SP Master
Free Members
sp_UserOfflineSmall Offline
Feb 24, 2012 - 8:54 am

this has been corrected for the next version...

Avatar
ovizii
Member
Free Members
sp_UserOfflineSmall Offline
Feb 24, 2012 - 9:36 am

much appreciated.

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: 620
Members: 17365
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10128
Posts: 79626