Welcome, Guest
Username Password: Remember me

Error while converting from SermonSpeaker
(1 viewing) (1) Guest
If you need assistance in using JBS version 7.x or above, please be as complete as possible. Also be sure to look at the documentation site first, as it is constantly growing: www.joomlabiblestudy.org/jbsdocs
  • Page:
  • 1

TOPIC: Error while converting from SermonSpeaker

Error while converting from SermonSpeaker 12 Aug 2011 17:23 #2724

Hi,

I received an error when attempting to convert my SermonSpeaker database to JBS using the official conversion plugin. It's a long error so I've attached it (as Word document because it includes hyperlinks). Could somebody help me?

I really want to change to BibleStudy as it is far superior, but it would take me SOO long to manually put everything into JBS! I've got over 100 sermons...

Thanks in advance for any help!

In case it helps, you can view my sermonspeaker sermons here.

File Attachment:

File Name: sermonspeakertoJBSerrormessage.doc
File Size: 257 KB

Re: Error while converting from SermonSpeaker 12 Aug 2011 17:46 #2725

  • Tom
  • OFFLINE
  • Moderator
  • Posts: 316
What seems to be happening is that there are double quotes in your database entries that are messing up the mysql queries. I would do a mass change of any double quotes to single quotes and see if that does it.

Not sure of the query to do that but it would be an UPDATE command.

Be sure to backup the db first, of course.

Tom
  • Page:
  • 1
Time to create page: 0.52 seconds