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
sp_Feed Topic RSS sp_TopicIcon
Language support
16 July, 2013
7:01 pm
Ben Miller
Appleton, WI, USA
Moderator
Members

Moderators
Forum Posts: 1628
Member Since:
18 June, 2009
sp_UserOfflineSmall Offline

Emyr James,

I switched my test site to Welsh, and the Bible book names in the drop-down box seem to be translating correctly on my site.  I'll take a look at the code and see if I can figure out what is happening on your site.

I need to ask one question: I see that you are currently running the latest version of SB, 0.45.9.  I know that you copied in the Welsh .po and .mo files, but have you made any other changes to any of the plugin PHP files after you updated to 0.45.9?

Ben Miller, Pathways Church, Appleton, Wisconsin, USA
Read the new FAQ, last updated 11/21/2013
Announcing version 0.45.12

16 July, 2013
7:18 pm
Ben Miller
Appleton, WI, USA
Moderator
Members

Moderators
Forum Posts: 1628
Member Since:
18 June, 2009
sp_UserOfflineSmall Offline

Emyr James,

Here is what I'd like you to do.  Your most recent sermon is titled "Galatiad 3:26 - 29".  I'd like you to edit that sermon.

To do this, in the WordPress admin panel, click on "Sermons" ("Pregethau")  Find the sermon "Galatiad 3:26 - 29", which has Sermon ID (Dynodiad) 690, and click the Edit (Golygu) link.

The Bible passage for this sermon is Galatiad 3:26-29.  Look at the Bible passage (Darn o'r Beibl) section.  Are the correct Bible books listed?  If they are not, choose "Galatiad" for both the beginning and ending reference.  Whether or not you had to select the Bible books, click the Save (Cadw) button.

After you've saved the sermon, please post back here, and I'll take another look.

Ben Miller, Pathways Church, Appleton, Wisconsin, USA
Read the new FAQ, last updated 11/21/2013
Announcing version 0.45.12

17 July, 2013
9:44 am
Emyr James
Enthusiast
Members
Forum Posts: 14
Member Since:
3 June, 2013
sp_UserOfflineSmall Offline

Not as far as I know! I may have done so while trying to get the translation to work, but don't remember changing anything sorry!

18 July, 2013
3:28 pm
Ben Miller
Appleton, WI, USA
Moderator
Members

Moderators
Forum Posts: 1628
Member Since:
18 June, 2009
sp_UserOfflineSmall Offline

Emyr,

Did you get a chance to edit the most recent sermon and hit the Save button yet?  If you don't know what I'm talking about, read my last post above.

Ben Miller, Pathways Church, Appleton, Wisconsin, USA
Read the new FAQ, last updated 11/21/2013
Announcing version 0.45.12

18 July, 2013
4:23 pm
Emyr James
Enthusiast
Members
Forum Posts: 14
Member Since:
3 June, 2013
sp_UserOfflineSmall Offline

Sorry Ben, must have missed your last post somehow.

Right, I've edited the sermon as requested. It was set for the correct passage, and all of the Bible books appear correctly in the drop-down option.

18 July, 2013
4:29 pm
Ben Miller
Appleton, WI, USA
Moderator
Members

Moderators
Forum Posts: 1628
Member Since:
18 June, 2009
sp_UserOfflineSmall Offline

Thanks.  Just to clarify, you did hit the Save button on the Edit sermon screen, even though you didn't need to change anything, right?

Ben Miller, Pathways Church, Appleton, Wisconsin, USA
Read the new FAQ, last updated 11/21/2013
Announcing version 0.45.12

18 July, 2013
4:36 pm
Emyr James
Enthusiast
Members
Forum Posts: 14
Member Since:
3 June, 2013
sp_UserOfflineSmall Offline

Yes indeed.

18 July, 2013
5:05 pm
Ben Miller
Appleton, WI, USA
Moderator
Members

Moderators
Forum Posts: 1628
Member Since:
18 June, 2009
sp_UserOfflineSmall Offline

Emyr, here is what I'd like you to do next.  There are two sermons on your site that use passages from Deuteronomy (Deuteronomium).  They are dated 20/03/2011 and 10/05/2009.  I'd like you to edit both of those sermons, reselect the Bible books for both the start and end passage, and hit the Save button.  Do this for both of those sermons, then post back here and I'll take another look.

Ben Miller, Pathways Church, Appleton, Wisconsin, USA
Read the new FAQ, last updated 11/21/2013
Announcing version 0.45.12

18 July, 2013
9:24 pm
Emyr James
Enthusiast
Members
Forum Posts: 14
Member Since:
3 June, 2013
sp_UserOfflineSmall Offline

Hi Ben,

ok, just done that. They both seemed to have lost their book, but the chapter and verses were still there. Put them in as said, and saved!

Thanks.

18 July, 2013
10:21 pm
Ben Miller
Appleton, WI, USA
Moderator
Members

Moderators
Forum Posts: 1628
Member Since:
18 June, 2009
sp_UserOfflineSmall Offline

Emyr, are you familiar with phpMyAdmin?  If so, I'd like you to look at your WordPress database for me.  You should have a database table with a name that ends with "sb_books".  I'd like you to look at that table.  To do this, find the table on the left side of the screen and click on it.  Then on the right side of the screen, click on the Browse tab.  My question is: In this table, do you see the names of the books of the Bible in English or in Welsh?

If you have any questions, let me know. 

I suspect that the names of the books are in Welsh on your site, but they are supposed to be in English, and that is what is causing the problem.  I'm going to try to come up with a fix for you, but it would be nice if you could confirm my assumption first.

If you have no idea what I'm talking about, that is okay, just let me know.

Ben Miller, Pathways Church, Appleton, Wisconsin, USA
Read the new FAQ, last updated 11/21/2013
Announcing version 0.45.12

19 July, 2013
9:23 am
Emyr James
Enthusiast
Members
Forum Posts: 14
Member Since:
3 June, 2013
sp_UserOfflineSmall Offline

Really sorry Ben, but I don't think I've not had any experience with phpMyAdmin! Is that something I should look into? Very new to all this!

19 July, 2013
3:57 pm
Ben Miller
Appleton, WI, USA
Moderator
Members

Moderators
Forum Posts: 1628
Member Since:
18 June, 2009
sp_UserOfflineSmall Offline

Emyr,

No problem.  Instead, I'd like you to install a plugin on your site called Database Browser.  (The easiest way to do this is to go to your WordPress admin panel and click on Plugins, Add New.  Type "database browser" in the search box.  Find the Database Browser plugin (probably the first in the list) and click on the Install Now link.  After the installation is successful, click on Activate Plugin.)

Once you have the plugin installed and activated, go to Tools, Database browser.  In the Select Table box, find the table that ends in "sb_books".  Click the Select table button.

The page should then show you a list of books of the Bible.

 

My question is: are those books listed in English or Welsh?

Ben Miller, Pathways Church, Appleton, Wisconsin, USA
Read the new FAQ, last updated 11/21/2013
Announcing version 0.45.12

19 July, 2013
4:37 pm
Emyr James
Enthusiast
Members
Forum Posts: 14
Member Since:
3 June, 2013
sp_UserOfflineSmall Offline

Hi Ben,

done that - yes they're all listed in Welsh.

19 July, 2013
4:52 pm
Ben Miller
Appleton, WI, USA
Moderator
Members

Moderators
Forum Posts: 1628
Member Since:
18 June, 2009
sp_UserOfflineSmall Offline

Emyr, thank you.  Another question: When you first installed Sermon Browser, do you know which version you installed?  If you don't know the version number, do you happen to know the date you installed Sermon Browser?

Ben Miller, Pathways Church, Appleton, Wisconsin, USA
Read the new FAQ, last updated 11/21/2013
Announcing version 0.45.12

19 July, 2013
5:51 pm
Emyr James
Enthusiast
Members
Forum Posts: 14
Member Since:
3 June, 2013
sp_UserOfflineSmall Offline

I can't remember the version number sorry - the date would have been either January or February 2013.

19 July, 2013
5:56 pm
Ben Miller
Appleton, WI, USA
Moderator
Members

Moderators
Forum Posts: 1628
Member Since:
18 June, 2009
sp_UserOfflineSmall Offline

Emyr, thanks.  That would have been version 0.45.4.

More questions:

1. When you go to Tools, Database browser and you choose the table that ends in "sb_books", what is the whole name of the table that you see in the dropdown box?

2. If I asked you to backup your WordPress database, would you have any idea how to do that?

Ben Miller, Pathways Church, Appleton, Wisconsin, USA
Read the new FAQ, last updated 11/21/2013
Announcing version 0.45.12

19 July, 2013
9:30 pm
Emyr James
Enthusiast
Members
Forum Posts: 14
Member Since:
3 June, 2013
sp_UserOfflineSmall Offline

Hi Ben,

1. The whole name of the table is wp_sb_books.

2. I haven't done that before, but I'm assuming that I would access the server through an ftp (I've been using filezilla), and copy and paste some of the files to my computer?

19 July, 2013
10:32 pm
Ben Miller
Appleton, WI, USA
Moderator
Members

Moderators
Forum Posts: 1628
Member Since:
18 June, 2009
sp_UserOfflineSmall Offline

Emyr,

Thanks for the information.  I have a solution for you to try, but it would be nice if you could backup your database before we do it.

The WordPress database does not exist in a file on your server; instead, it resides in a Database server on your hosting account.  There is an article on WordPress.org about backing up your database.  Probably the best way to do it is to contact your web host and ask them which way they recommend for backing up and restoring your database.  Often this can be done easily from your web hosting control panel.  Who is your web host?

One way to do it would be to install a database backup plugin.  There are lots of them, and I don't really have a recommendation for you.  You want to make sure that the backup stores all the tables in your database, not just the standard WordPress tables, because Sermon Browser uses its own custom tables.  Usually the plugin will let you choose which tables you want to back up.  The plugin will generally let you download a zipped file of your database to your local computer, and some of them will also restore the database for you; with others, you would need to use phpMyAdmin to restore your database.  Some of these will back up your database and your files, others just your database.

Other options are to use a paid service like VaultPress or a paid plugin like Backup Buddy.  (You can Google those names to find their websites.)  These make it easy for a price, and have support to help you figure out how to use it.  Both of these back up your database and files.

 

Backing up your entire WordPress installation (database and files) on a regular basis is always a good idea.  But for our immediate needs, we just need to have a backup of the database just in case a mistake is made during our tweaking of the database.

If you have any questions or need any more help on this, please let me know.  When you are ready, I'll post the commands you need to issue to change your database.

Ben Miller, Pathways Church, Appleton, Wisconsin, USA
Read the new FAQ, last updated 11/21/2013
Announcing version 0.45.12

24 July, 2013
2:01 am
Ben Miller
Appleton, WI, USA
Moderator
Members

Moderators
Forum Posts: 1628
Member Since:
18 June, 2009
sp_UserOfflineSmall Offline

Emyr, here is what I'd like you to try with your site.  (Hopefully after you've backed up your database, although I don't anticipate any problems if you follow these instructions.)  If you have any questions, please ask.

These instructions all use the Database Browser plugin that you installed earlier.

1. Go to Tools, Database browser.  Select the wp_sb_books table, and click the "Select table" button.

2. You should now see the books of the Bible.  We want them to be in English, but right now you are seeing them in Welsh.

3. At the bottom of the list, you should see some text that says "Query to be performed (click to toggle)".  Click on it.  A box will appear with some text in it.

4. Delete all the text inside the box.

5. Go to this link: Command for creating sb_books_new table.  On that page, copy the command that is in the RAW Paste Data box.

6. Paste that command into the Query box on the Database browser screen, then click the "Run query" button.

7. You should get a message that says "No data was found in this table."  If you get a message that says "Database error - You have an error in your SQL syntax," that means that you did something wrong.  Go back to step 3 and try again.

8. Click on the dropbox of database table names.  You should now have a database table in the list named "wp_sb_books_new".  This table does not yet have any data in it.  We are going to fill it with values next.

9. Go to this link: Command for adding value to sb_books_new table.  This command has 66 lines in it (one for each book of the Bible).  Copy all of the lines in the RAW Paste Data box.  (Hint: click in the box, then hit Control-A to easily select all the text in the box.)

10. Back in Database browser, click on "Query to be performed", delete the command currently in the box, and paste in the 66 line command you copied.  Click on the "Run query" button.

11. In the dropbox, select the "wp_sb_books_new" table and click the "Select table" button.  You should see 66 rows with the Bible names in English.

 

More instructions in the next post.

Ben Miller, Pathways Church, Appleton, Wisconsin, USA
Read the new FAQ, last updated 11/21/2013
Announcing version 0.45.12

24 July, 2013
2:22 am
Ben Miller
Appleton, WI, USA
Moderator
Members

Moderators
Forum Posts: 1628
Member Since:
18 June, 2009
sp_UserOfflineSmall Offline

12. Next, we will rename the table with the Welsh books.  Go to this link: Command for renaming sb_books to sb_books_old.  Copy the command (one line).  Then paste it into the query box in Database Browser and run it.

13. If you check the dropbox tables, you'll see that you no longer have a wp_sb_books table.  You currently have wp_sb_books_old with Welsh names and wp_sb_books_new with English names.

14. Last command: Go to this link: Command for renaming sb_books_new to sb_books.  It's another one line command, so copy it, paste it into the query box in Database Browser and run it.

15. At this point, you should be able to select "wp_sb_books" from the dropbox, click the "Select table" button, and you should see all the books of the Bible in English.  Your old table is now in "wp_sb_books_old", so if for some reason you need to go back, you can do it just by issuing a couple of RENAME commands.

 

After you get to this point, let me know and I'll take another look at your site.

Ben Miller, Pathways Church, Appleton, Wisconsin, USA
Read the new FAQ, last updated 11/21/2013
Announcing version 0.45.12

Forum Timezone: Europe/London
Most Users Ever Online: 381
Currently Online:
Guest(s) 6
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