Support Forum
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 |
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.
YELLOW
SWORDFISH
|
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 🙂
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
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
Visit Cruise Talk Central and Mr Papa's World
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 |
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...
Visit Cruise Talk Central and Mr Papa's World
this has been corrected for the next version...
Visit Cruise Talk Central and Mr Papa's World
1 Guest(s)