Blog Post Linking Plugin Throwing Error for Some Pages /Posts

YS

Yellow Swordfish

Member

Member since Nov 2008

16,437 posts

Jan 29, 2015 · 4:25 am

I think I need to work through this one step at a time to get a handle on what you are doing. So.

There are now some WP pages where I added the link, then removed it and now it won’t re-add the page and link to the forum.

Not quite sure of what you are saying here…

‘Removed it’: How? Did you remove the forum post as well? Did you remove the original blog post/page?
‘Re-add the page’: Not sure what you mean by this? Unless you did remove the page as asked above.

Can you explain those two first in a little more detail. The actual steps you took…

AH

Alton Hardin

Member

Member since Jan 2015

21 posts

Jan 29, 2015 · 4:36 am

‘Removed it’: How? Did you remove the forum post as well? Did you remove the original blog post/page?

I clicked the link in the WP page to for the plugin “Break Forum Link” to break the link.
I deleted the forum post.
I later tried to have the plugin create a new forum post linked to the WP page via the plugin in the WP page edit area.
No forum post created and error log as show in original post.

‘Re-add the page’: Not sure what you mean by this? Unless you did remove the page as asked above.

I then preceded to re-create the entire WordPress page by creating a new WordPress (WP) page with all the same details (name, permalink, etc).
Tried to use the plugin, but keeps throwing error.
Created a new WP Post and WP Page with all the same information except different title and plugin works one time, then if I delete the forum post and break the link, it doesn’t work anymore.

YS

Yellow Swordfish

Member

Member since Nov 2008

16,437 posts

Jan 29, 2015 · 4:52 am

OK. Sorry to be real pedantic here but I am sure you understand that if I am going to set up a test it needs to be exactly the same as the issue being tested or I might miss something.

So let me just double-check:

Create a blog linked post
On WP Edit Post page, break the link.
Delete the forum topic (which will also remove the post)
Re-create the linked forum post from the same blog post

Does that cover it?

I am disappointed in the warning that was logged as it should have a descriptive message of the condition that failed. But I can tell you that the part of the process that failed was in the validation of permission to continue. I will need to look into the missing message text as a separate issue.

I can set up some tests as above to see if i can replicate any problems,.

AH

Alton Hardin

Member

Member since Jan 2015

21 posts

Jan 29, 2015 · 5:13 am

That is pretty much it in a nutshell:

Create the link.
Break the link
Delete the forum topic. (However there were times when I did not complete this step and when I re-created the link, the WordPress page details showed up as another topic post in the thread until I deleted the forum topic.)
Re-create the link. At this point it may or may not have created the forum topic.

Here is the other oddity. I created two new WordPress pages with different titles, but the same page details and the plugin doesn’t work. If I create new WordPress pages with completely different information, I can create the link to the forum, delete the forum topic, delete the link and re-create it as many times as I want and it works.

Is there anyway I can look in specific tables in the database for transient data being left behind?

AH

Alton Hardin

Member

Member since Jan 2015

21 posts

Jan 29, 2015 · 5:25 am

Here are all of the logs, if that helps:

January 29, 2015 1:10 am | spaErrNotice | 1 | php

file: /simple-press/admin/panel-permissions/forms/spa-permissions-edit-permission-form.php

line: 110

function: spa_permissions_edit_permission_form

Notice | Undefined index: post_as_user

January 29, 2015 2:15 am | spaErrWarning | 26 | php

file: crogri/public_html/wp-content/sp-resources/forum-plugins/blog-linking/library/sp-linking-blog.php

line: 156

function: trigger_error

Warning | Invalid error type specified

January 29, 2015 12:12 am | spaErrNotice | 11 | php

file: /simple-press/forum/content/sp-forum-view-functions.php

line: 2020

function: sp_TopicIndexFirstPost

Notice | Undefined property: stdClass::$first_post_date

January 29, 2015 12:12 am | spaErrNotice | 11 | php

file: /simple-press/forum/content/sp-forum-view-functions.php

line: 2004

function: sp_TopicIndexFirstPost

Notice | Undefined property: stdClass::$first_guest_name

January 29, 2015 12:12 am | spaErrNotice | 22 | php

file: /simple-press/forum/content/sp-forum-view-functions.php

line: 2003

function: sp_TopicIndexFirstPost

Notice | Undefined property: stdClass::$first_user_id

January 29, 2015 12:12 am | spaErrNotice | 11 | php

file: /simple-press/forum/content/sp-forum-view-functions.php

line: 1998

function: sp_TopicIndexFirstPost

Notice | Undefined property: stdClass::$first_post_permalink

January 28, 2015 11:44 pm | spaErrNotice | 3 | php

file: crogri/public_html/wp-content/sp-resources/forum-plugins/blog-linking/library/sp-linking-support.php

line: 37

function: sp_do_move_post

Notice | Undefined index: blogpostid

January 29, 2015 2:15 am | spaErrNotice | 505 | php

file: crogri/public_html/wp-content/sp-resources/forum-plugins/rank-info/template-tags/sp-rank-info-tag.php

line: 41

function: sp_RankInfoTag

Notice | Undefined variable: tagClasss

January 28, 2015 9:07 pm | spaErrNotice | 62 | php

file: crogri/public_html/wp-content/sp-resources/forum-plugins/post-multiple/admin/sp-post-multiple-admin-options.php

line: 25

function: sp_post_multiple_admin_options_form

Notice | Undefined variable: spThisForum

January 29, 2015 12:12 am | spaErrNotice | 13 | php

file: /simple-press/forum/content/sp-forum-view-functions.php

line: 2130

function: sp_TopicIndexLastPost

Notice | Undefined property: stdClass::$last_guest_name

January 29, 2015 12:12 am | spaErrNotice | 26 | php

file: /simple-press/forum/content/sp-forum-view-functions.php

line: 2129

function: sp_TopicIndexLastPost

Notice | Undefined property: stdClass::$last_user_id

January 29, 2015 12:12 am | spaErrNotice | 13 | php

file: /simple-press/forum/content/sp-forum-view-functions.php

line: 2124

function: sp_TopicIndexLastPost

Notice | Undefined property: stdClass::$last_post_permalink

January 28, 2015 8:56 pm | spaErrNotice | 1 | php

file: crogri/public_html/wp-content/sp-resources/forum-plugins/report-post/library/sp-report-post-components.php

line: 142

function: spReportPostSendEmail

Notice | Undefined variable: posted

January 28, 2015 2:24 pm | spaErrNotice | 1 | php

file: crogri/public_html/wp-content/sp-resources/forum-plugins/admin-bar/library/sp-admin-bar-components.php

line: 15

function: sp_admin_bar_do_new_post_list

Notice | Undefined property: spUser::$sfadminbar

January 28, 2015 1:35 pm | spaErrNotice | 1 | php

file: /simple-press/admin/panel-permissions/support/spa-permissions-save.php

line: 48

function: spa_save_permissions_new_role

Notice | Undefined variable: role_id

January 29, 2015 2:15 am | spaErrNotice | 5 | php

file: crogri/public_html/wp-content/sp-resources/forum-plugins/blog-linking/library/sp-linking-blog.php

line: 35

function: sp_save_blog_link

Notice | Undefined index: sfedit

January 28, 2015 12:11 am | spaErrError | 1 | database

file: /problem-with-post-edit-buttonome/microgri/public_html/wp-content/sp-resources/forum-plugins/blog-linking/sp-linking-plugin.php

line: 148

function: sp_update_blog_link

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 ‘AND post_index=1’ at line 1

UPDATE wp_sfposts SET post_content=’By Alton Hardin | Published August 21, 2014 There are numerous odds and probabilities to learn in the game of Texas Holdem. Below are some basic and essential preflop and flop odds and probabilities to learn. Preflop Odds

Hand	Probability
Two Suited Cards	3.25:1 (24%)
Any Pair	16:1 (6%)
Pocket Aces or Pocket Kings	109.5:1 (0.9%)
Ace King Offsuit	109.5:1 (0.9%)
Pocket Aces	220:1 (0.45%)
Ace King Suited	330.5:1 (0.3%)

Flop Odds

Pocket Pairs	Probability
Pocket Pair Flopping a Set	8.28:1 (10.8%)
Pocket Pair Flopping a Full House	135:1 (0.73%)
Pocket Pair Flopping Quads	407.33:1 (0.25%)

2 Suited Cards	Probability
2 Suited Cards Flopping a Flush Draw	8:1 (11%)
2 Unsuited Cards Flopping a Flush Draw	44:1 (2%)
2 Suited Cards Flopping a Flush	118:1 (0.85%)

2 Non-Pair Cards	Probability
2 Non-Pair Cards Flopping One Pair	2.5:1 (29%)
2 Non-Pair Cards Flopping Two Pair	49:1 (2%)
2 Non-Pair Cards Flopping a Straight	76:1 (1.3%)
2 Non-Pair Cards Flopping Trips	73:1 (1.3%)
2 Non-Pair Cards Flopping a Full House	1088:1 (0.9%)
2 Non-Pair Cards Flopping Quads	9800:1 (0.01%)

‘ WHERE topic_id= AND post_index=1

January 28, 2015 12:11 am | spaErrNotice | 1 | php

file: crogri/public_html/wp-content/sp-resources/forum-plugins/blog-linking/library/sp-linking-blog.php

line: 221

function: sp_update_blog_link

Notice | Trying to get property of non-object

January 29, 2015 1:16 am | spaErrNotice | 7 | php

file: crogri/public_html/wp-content/sp-resources/forum-plugins/blog-linking/sp-linking-upgrade.php

line: 16

function: sp_linking_do_upgrade_check

Notice | Undefined index: dbversion

January 28, 2015 1:53 pm | spaErrNotice | 3 | php

file: /simple-press/forum/database/sp-db-management.php

line: 129

function: sp_save_edited_post

Notice | Undefined index: notify-edited

January 29, 2015 1:23 am | spaErrNotice | 10 | php

file: crogri/public_html/wp-content/sp-resources/forum-plugins/blog-linking/library/sp-linking-blog.php

line: 360

function: sp_transform_bloglink_label

Notice | Undefined variable: content

January 29, 2015 2:16 am | spaErrNotice | 36 | php

file: crogri/public_html/wp-content/sp-resources/forum-plugins/blog-linking/forms/sp-linking-form.php

line: 64

function: sp_populate_post_form

Notice | Undefined variable: links

January 28, 2015 11:11 pm | spaErrNotice | 6 | php

file: /simple-press/admin/panel-options/support/spa-options-prepare.php

line: 30

function: spa_get_global_data

Notice | Undefined index: blockroles

January 28, 2015 11:11 pm | spaErrNotice | 3 | php

file: /simple-press/admin/panel-options/support/spa-options-save.php

line: 37

function: spa_save_global_data

Notice | Undefined index: blockredirect

January 29, 2015 2:09 am | spaErrNotice | 216 | php

file: crogri/public_html/wp-content/sp-resources/forum-plugins/warnings-suspensions/library/sp-warnings-suspensions-components.php

line: 122

function: sp_warnings_suspensions_do_load_js

Notice | Undefined variable: footer

January 27, 2015 10:30 pm | spaErrNotice | 1 | php

file: crogri/public_html/wp-content/sp-resources/forum-plugins/captcha/sp-captcha-upgrade.php

line: 16

function: sp_captcha_do_upgrade_check

Notice | Undefined index: dbversion

January 27, 2015 10:29 pm | spaErrNotice | 1 | php

file: /simple-press/admin/panel-admins/forms/spa-admins-your-options-form.php

line: 33

function: spa_admins_your_options_form

Notice | Undefined index: bypasslogout

January 27, 2015 10:29 pm | spaErrNotice | 1 | php

file: crogri/public_html/wp-content/sp-resources/forum-plugins/warnings-suspensions/admin/sp-warnings-suspensions-admin-options.php

line: 18

function: sp_warnings_suspensions_admin_options_form

Notice | Undefined index: profile

January 27, 2015 10:28 pm | spaErrNotice | 1 | php

file: crogri/public_html/wp-content/sp-resources/forum-plugins/private-messaging/library/sp-pm-components.php

line: 149

function: sp_pm_do_profile_options

Notice | Undefined property: spUser::$pmemail

January 27, 2015 10:28 pm | spaErrNotice | 1 | php

file: /simple-press/forum/profile/forms/sp-form-profile.php

line: 109

function: include_once

Notice | Undefined property: spUser::$location

January 27, 2015 10:27 pm | spaErrNotice | 1 | php

file: /simple-press/admin/panel-profiles/forms/spa-profiles-avatars-form.php

line: 102

function: spa_profiles_avatars_form

Notice | Undefined index: sfavatarreplace

January 28, 2015 9:05 pm | spaErrNotice | 2 | php

file: crogri/public_html/wp-content/sp-resources/forum-plugins/subscriptions/admin/sp-subscriptions-admin-members.php

line: 28

function: sp_subscriptions_admin_members_form

Notice | Undefined index: includepost

January 27, 2015 10:25 pm | spaErrNotice | 9 | php

file: crogri/public_html/wp-content/sp-resources/forum-plugins/share-this/admin/sp-share-this-admin-options.php

line: 65

function: sp_share_this_admin_options_form

Notice | Undefined index: enable

January 27, 2015 10:25 pm | spaErrNotice | 9 | php

file: crogri/public_html/wp-content/sp-resources/forum-plugins/share-this/admin/sp-share-this-admin-options.php

line: 57

function: sp_share_this_admin_options_form

Notice | Undefined index: enable

January 27, 2015 11:22 pm | spaErrNotice | 8 | php

file: crogri/public_html/wp-content/sp-resources/forum-plugins/blog-linking/admin/spa-components-linking-form.php

line: 111

function: spa_get_links_data

Notice | Undefined index: flowplayer5

January 27, 2015 10:22 pm | spaErrNotice | 1 | php

file: /simple-press/admin/panel-components/support/spa-components-prepare.php

line: 95

function: spa_get_messages_data

Notice | Undefined index: sfsneakredirect

January 28, 2015 8:54 pm | spaErrNotice | 6 | php

file: /simple-press/sp-startup/site/credentials/sp-credentials.php

line: 46

function: sp_logout_redirect

Notice | Undefined index: bypasslogout

January 29, 2015 2:15 am | spaErrNotice | 304 | php

file: crogri/public_html/wp-content/sp-resources/forum-plugins/ban/library/sp-ban-components.php

line: 18

function: sp_ban_do_check_bans

Notice | Undefined index: pageview

January 28, 2015 8:55 pm | spaErrNotice | 3 | php

file: crogri/public_html/wp-content/sp-resources/forum-plugins/private-messaging/ahah/sp-pm-ahah-post.php

line: 200

function: sp_pm_save_message

Notice | Undefined index: pmemail

January 29, 2015 2:15 am | spaErrNotice | 32429 | php

file: crogri/public_html/wp-content/sp-resources/forum-plugins/share-this/library/sp-share-this-components.php

line: 36

function: sp_share_this_do_sharing

Notice | Undefined index: enable

January 29, 2015 2:16 am | spaErrNotice | 3920 | php

file: /simple-press/sp-api/sp-api-auths.php

line: 29

function: sp_get_auth

Notice | Undefined index: watch

January 27, 2015 9:46 pm | spaErrWarning | 2 | php

file: /simple-press/sp-api/sp-api-plugins.php

line: 82

function: closedir

Warning | closedir() expects parameter 1 to be resource, null given

January 27, 2015 9:46 pm | spaErrNotice | 2 | php

file: /simple-press/sp-api/sp-api-plugins.php

line: 82

function: sp_get_plugins

Notice | Undefined variable: plugins_subdir

January 27, 2015 9:46 pm | spaErrNotice | 1 | php

file: /simple-press/admin/panel-options/support/spa-options-prepare.php

line: 73

function: spa_get_display_data

Notice | Undefined index: editor

January 27, 2015 9:44 pm | spaErrNotice | 1 | php

file: /simple-press/admin/panel-themes/forms/spa-themes-list-form.php

line: 82

function: spa_themes_list_form

Notice | Undefined index: parent

January 27, 2015 9:18 pm | spaErrNotice | 3 | php

file: /simple-press/forum/content/forms/sp-form-topic.php

line: 16

function: sp_render_add_topic_form

Notice | Undefined index: editor

January 27, 2015 9:19 pm | spaErrNotice | 24 | php

file: /simple-press/forum/content/classes/sp-group-view-class.php

line: 463

function: sp_groupview_query

Notice | Undefined variable: s

January 27, 2015 6:41 pm | spaErrNotice | 1 | php

file: /simple-press/forum/content/sp-common-view-functions.php

line: 2723

function: sp_ForumStats

Notice | Trying to get property of non-object

January 27, 2015 6:41 pm | spaErrNotice | 1 | php

file: /simple-press/forum/content/sp-common-view-functions.php

line: 2722

function: sp_ForumStats

Notice | Trying to get property of non-object

January 27, 2015 6:41 pm | spaErrNotice | 1 | php

file: /simple-press/forum/content/sp-common-view-functions.php

line: 2721

function: sp_ForumStats

Notice | Trying to get property of non-object

January 27, 2015 6:41 pm | spaErrNotice | 1 | php

file: /simple-press/forum/content/sp-common-view-functions.php

line: 2720

function: sp_ForumStats

Notice | Trying to get property of non-object

YS

Yellow Swordfish

Member

Member since Nov 2008

16,437 posts

Jan 29, 2015 · 5:28 am

I will set up some tests this morning. It is not something we have had reported before but then I suspect not many people would break a link and then try and recreate it. Although I see no reason why that should not work just fine. So I wil ltry it.

For reference there are two aspects to the database handling of links.

There is a column in the ‘sftopics‘ table named ‘blog_post_id‘ which holds – easy really – the ID of the blog post or page.
There is a table named ‘sflinks‘ which controls and records all of the linking in the database. One look at that and the required columns are completely obvious!

I will let you know if I find anything of course.

One quick thought however. In the forum admin > Options > Content Settings there is an option to disallow a duplicate post. Basically this looks at the content of the last post the user made and if it is identical to the one being saved it gets rejected. Could his possibly be the reason for your last comment above? Might be worth checking to see if that option is turned on and if so turn it off for a test.

AH

Alton Hardin

Member

Member since Jan 2015

21 posts

Jan 29, 2015 · 5:36 am

I’ll take a look at the sflinks table in the morning; that might be the issue. I did not look at that table. I’ll also look at the duplicate posts issue.

So you can visually see the error and how to happens for only some pages, I’ll throw together a quick YouTube video too because I think it might be difficult to duplicate the issue.

Thanks!

YS

Yellow Swordfish

Member

Member since Nov 2008

16,437 posts

Jan 29, 2015 · 5:39 am

Certainly my first quick set of tests have proven to be undramatically working as expected. But will keep digging.

AH

Alton Hardin

Member

Member since Jan 2015

21 posts

Jan 29, 2015 · 12:22 pm

I figured it out. The issue was SP permissions. I modified the permissions is specific forums so only the SP admin can add topics and even moderators cannot add topics; however, even though I was logged in with my SP and WP admin account, it wouldn’t let me link the WP page to the forum. So I reverted the forum permissions to standard settings so anyone could post and it fixed the problem.

So lesson learned on my end is to lock down my specific forums after I have already linked the WP pages / posts to it.

YS

Yellow Swordfish

Member

Member since Nov 2008

16,437 posts

Jan 29, 2015 · 12:45 pm

Well yes – it sounds promising. But if you are the forum admin then you should be able to do anything!
Global permissions all set to yes!

Or were you not logged in as a forum admin at the time.

AH

Alton Hardin

Member

Member since Jan 2015

21 posts

Jan 29, 2015 · 1:52 pm

Yeah, I’m not 100% sure. But the WP pages I were trying to link were authored by my moderators. I changed the page author back to myself. So maybe it was looking at the WP page author’s permissions?

YS

Yellow Swordfish

Member

Member since Nov 2008

16,437 posts

Jan 29, 2015 · 3:48 pm

SP (and as far as I am aware WP) permissions and capabilities will always be retrieved for the user logged in at the time.

Support Forum

12 Answers