Daily Bible Verse - Bible Gateway

ChineseGuy - August 13, 2007 - 22:38

Alright... I got this module originally from Brad Landis, so he deserve the credits.

His module was developed for 4.7, and he has no plan on making it 5.x compatible.

I am having problem with the serializing.. it seems like when the module tries to cache the Bible verse on the SQL, it gives error.

Anyways, you can see the errors if you visit my site.

http://cru.koish.com

    * user warning: Incorrect table name 'a4s5titles18Ephesians210as3urls73httpwwwbiblegatewaycompassageversion31ampsearchEphesians210s4bodys1' query: LOCK TABLES a4s5titles18Ephesians210as3urls73httpwwwbiblegatewaycompassageversion31ampsearchEphesians210s4bodys129ldquoForweareGodsworkmanshipcreatedinChristJesustodogoodworkswhichGodpreparedinadvanceforustodordquos6notices70PoweredbyahrefhttpwwwbiblegatewaycomBibleGatewaycoma WRITE in /var/www/virtual/koish/cru.koish.com/includes/database.mysql.inc on line 172.
    * user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ':4:s:5:"title";s:18:"Ephesians 2:10</a>";s:3:"url";s:73:"http://www.biblegateway' at line 1 query: UPDATE a:4:s:5:"title";s:18:"Ephesians 2:10</a>";s:3:"url";s:73:"http://www.biblegateway.com/passage/?version=31&amp;search=Ephesians 2:10";s:4:"body";s:129:"&ldquo;For we are God's workmanship, created in Christ Jesus to do good works, which God prepared in advance for us to do.&rdquo;";s:6:"notice";s:70:"Powered by <a href="http://www.biblegateway.com/">BibleGateway.com</a>"; SET data = '-1', created = 1187038145, expire = 0, headers = '' WHERE cid = 'biblegateway votd' in /var/www/virtual/koish/cru.koish.com/includes/database.mysql.inc on line 172.

I'll include a copy of the module here
http://cru.koish.com/files/biblegateway.zip

Anyone have any idea on how to fix this? I ran this through Code Review, and doesn't appear to have any critical errors.

Thanks

» Login or register to post comments