Support Forum

Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
plugins-topic
Blog Post Linking Plugin Throwing Error for Some Pages /Posts
Avatar
Alton Hardin
Member
Free Members
sp_UserOfflineSmall Offline
Jan 29, 2015 - 4:01 am

I have linked several WP pages and posts to my SP forum. 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.

On the WP page/post edit, it shows as if it created the link where you can click to "View Topic in Forum" or "Break Forum Link" but it doesn't create anything in the forum.

I checked the SP Toolbox Error log and it is throwing this error:

http://gyazo.com/4c296262caa17.....09c9b1a7021-29-2015-12-58-49-AM.pngImage Enlarger

I tried checking the database and looking for transient database table entries, but couldn't find anything.

I also tried creating a new WP page with the exact same information and permalink and linking it to a different forum, but it still doesn't work.

But for WP posts and pages that I have not linked to the forum yet at all, it works fine...very weird.

Any help would be greatly appreciated.

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

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

  1. I clicked the link in the WP page to for the plugin "Break Forum Link" to break the link.
  2. I deleted the forum post.
  3. 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.
  4. 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.

  1. 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).
  2. Tried to use the plugin, but keeps throwing error.
  3. 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.
Avatar
Yellow Swordfish
Glinton, England
SP Master
sp_UserOfflineSmall Offline
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:

  1. Create a blog linked post
  2. On WP Edit Post page, break the link.
  3. Delete the forum topic (which will also remove the post)
  4. 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,.

andy-signature.png
YELLOW
SWORDFISH
Avatar
Alton Hardin
Member
Free Members
sp_UserOfflineSmall Offline
Jan 29, 2015 - 5:13 am

That is pretty much it in a nutshell:

  1. Create the link.
  2. Break the link
  3. 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.)
  4. 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?

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

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

  1. There is a column in the 'sftopics' table named 'blog_post_id' which holds - easy really smile - the ID of the blog post or page.
  2. 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.

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

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

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

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: 643
FidoSysop: 577
Conrad_Farlow: 531
fiddlerman: 358
Stefano Prete: 325
Member Stats:
Guest Posters: 616
Members: 17343
Moderators: 0
Admins: 4
Forum Stats:
Groups: 7
Forums: 17
Topics: 10117
Posts: 79590