Forum

This forum is now read-only. Support is provided at https://wordpress.org/support/plugin/sermon-browser/

Please consider registering
guest

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

No permission to create posts
sp_Feed Topic RSS sp_TopicIcon
Posting new sermons fails with WP 3.9
20 September, 2014
5:35 am
RJP
Member
Members
Forum Posts: 3
Member Since:
20 September, 2014
sp_UserOfflineSmall Offline

Can anyone post a quick navigational step by step on how to do the find and replace fix? Pleeeeaaase?

Everything was working great and now it loads everything in sermon browser, but loads the player to the site only randomly.

Thanks! 

20 September, 2014
7:53 am
Extrafino
Enthusiast
Members
Forum Posts: 43
Member Since:
5 July, 2013
sp_UserOfflineSmall Offline

We already did.

Open the file /sb-includes/admin.php using a good editor. I used Notepad++

It has a search and replace function. In search for put: mysql_real_escape_string

In replace, put: $wpdb->prepare

Then in the popup of the editor click 'replace all' and upload the changed file, replacing the old one.

20 September, 2014
9:31 pm
RJP
Member
Members
Forum Posts: 3
Member Since:
20 September, 2014
sp_UserOfflineSmall Offline

Thanks Extrafino. I apologize for my ignorance, but where does one click to find /sb-includes/admin.php? I assume this is in the WP interface somewhere but cannot find the access point.

Thanks for your help and patience... RJP

21 September, 2014
12:13 pm
Extrafino
Enthusiast
Members
Forum Posts: 43
Member Since:
5 July, 2013
sp_UserOfflineSmall Offline

Oh, sorry. Looks like you've never edited anything inside Wordpress.

You will need a FTP-Program (FileZilla for example) and connect to your webspace. Inside your wordpress-installation you will find the directory wp-content, inside of that the directory plugins and inside that the directory for sermon-browser.

Once there look for the file admin.php in the directory sb-includes. You will need to download the file to your computer, make the changes using an editor and upload it back again...

23 September, 2014
3:54 pm
Joshbaker90
Member
Members
Forum Posts: 7
Member Since:
12 September, 2014
sp_UserOfflineSmall Offline

Would it be easier if i just upload you a new zip file?

 

Extrafino are you having any problems with renaming files or deleting them? i get an error every time saying the script cant run.

23 September, 2014
7:07 pm
Extrafino
Enthusiast
Members
Forum Posts: 43
Member Since:
5 July, 2013
sp_UserOfflineSmall Offline

Depends on who you think it is easier for ;)

I think you might be able to do it yourself and learn something new on the way.

I do not remember having these problems. But since the filenames are stored in the database as empty, the problems might come from that. I know I am able to use the plugin in the modified version now running PHP 5.5 and WordPress 4.0

3 November, 2014
2:23 am
tgcreate
Enthusiast
Members
Forum Posts: 18
Member Since:
8 January, 2014
sp_UserOfflineSmall Offline

Extrafino said
...
[resolved]
To me, it appears that the function "mysql_real_escape_string" throws an error and returns an empty string, most likely because there is no open database connection at the time the function is used.
In the file /sb-includes/admin.php I replaced all occurences (should be 12) of "mysql_real_escape_string" with the wordpress-specific function "esc_sql" (http://codex.wordpress.org/Data_Validation#Database) after that uploading a file into the uploads-folder and publishing a sermon seem to work just as before.

Okay, I am befuddled. I don't seem to have a single occurrence of "mysql_real_escape_string in that file. What gives?

Edit: never mind. I was adding the extra "i" from Josh Baker's post.

3 November, 2014
2:35 am
tgcreate
Enthusiast
Members
Forum Posts: 18
Member Since:
8 January, 2014
sp_UserOfflineSmall Offline

Okay, I altered to $wpdb->prepare and that didn't work. Will try esc_sql now.

The problem I'm experiencing (two sites) is that while uploads and downloads work, the media player has disappeared. Not sure if it's the same issue.

3 November, 2014
2:38 am
tgcreate
Enthusiast
Members
Forum Posts: 18
Member Since:
8 January, 2014
sp_UserOfflineSmall Offline

tgcreate said

Okay, I altered to $wpdb->prepare and that didn't work. Will try esc_sql now.
The problem I'm experiencing (two sites) is that while uploads and downloads work, the media player has disappeared. Not sure if it's the same issue.

Actually, the problem I have is with one site running SB 1 and one site running SB 2. Neither of them are currently showing the audio player.
Meanwhile, I have another site that has not upgraded to WP 4.0, and the audio player is working fine.

3 November, 2014
4:57 am
tgcreate
Enthusiast
Members
Forum Posts: 18
Member Since:
8 January, 2014
sp_UserOfflineSmall Offline

Hm, looks like my problem is a different one. Ignoring SB altogether, the media player simply doesn't display for me using the native WordPress Add Media button directly on a page. It shows (and plays) in the WordPress backend, but not on the live page. I would think it was some sort of server issue, but then it wouldn't work in the back end would it? (And it's not a problem with my theme—the player doesn't show up when I switch to Twenty Fourteen or the WordPress Classic theme either.)

No permission to create posts
Forum Timezone: Europe/London

Most Users Ever Online: 381

Currently Online:
18 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Rich Brown: 358

Matt Schlueter: 93

Mindy: 72

Don Johnson: 65

anointed: 57

0be1: 55

Member Stats:

Guest Posters: 7

Members: 3188

Moderators: 1

Admins: 1

Forum Stats:

Groups: 1

Forums: 2

Topics: 1713

Posts: 7499

Newest Members:

marktest, deatles50, ValeriaGoodriz, dapedPup, oapedPup, Margarettoimb

Moderators: Ben Miller: 1628

Administrators: Mark Barnes: 435