Being that Ninjaboard and NinjaJournal require mysqli.php to work, I am having issues with one extension (so far) in particular. This happens to be joomlashowroom LMS Basic Edition, which is a quizzing application. It's one I hate to get rid of since the site I'm developing involves technical support to the public and this is a beneficial app to have. The developer said it does not support mysqli. Is there a work around for this so that I can implement the Ninja products? Thanks.
11 Jan 11
Hi Dalbring,
The workaround is that I patch that extension, and send both you and the developer the patch that enables it to run on mysqli configurations :)
I'll make a ticket for it.
11 Jan 11
That would be nice Stian, if they're open to that. Thanks.
Dirk
11 Jan 11
I'm sure they are when we do all the work ;)
11 Jan 11
You're the man and now I'm geeked.
11 Jan 11
I hope it's a good thing to be geeked! :D
14 Jan 11
Hi,
Just letting you know we'll start working on this next week :)
14 Jan 11
Cool! So they're hip on it then?
18 Jan 11
Havent contacted them yet, what I meant is that we'll research, contact and work on a resolution this week :)
We were too busy working on the Stable 1.0 release last week (released Friday) to get to this issue.
But it's one of our higher priority tasks this week.
Thanks
24 Jan 11
Hi,
I've now installed joomlashowroom LMS Basic Edition on my dev setup, and completed researching.
And the only part of their extension I could find that had a raw mysql call, where in their comprofiler integration.
So just to be clear, you're using Community Builder on your site, and have LMS setup to integrate with it?
Thanks
25 Jan 11
Hi Stian...no, I'm not using Community Builder; just Joomla 1.5.22. I'm not making a social networking site. I'm developing a technical help site that I'm implementing the LMS product on. I've been experimenting with other quizzing packages and so far the LMS is the nicest due to its simplicity. I'm certain some day I'll be wanting to implement a forum of some sort, so I would like to entertain using Ninjaboard. I want to use Ninjajournal for the technical guys on the site to keep records of tasks, their progress and developments. Thanks for your diligence.
Dirk
27 Jan 11
Ok,
That's strange, because I can only reproduce this problem if I install CB, otherwise the latest version of LMS Basic Edition works just fine on my machine.
What version are you using?
27 Jan 11
LMS Basic Edition Stable 1.5.6...so you're saying that you set your db server type to mysqli on Joomla 1.5.22 and you can use the LMS Basic edition? It won't work for me and they (i.e. Joomlashowroom) concur with that.
27 Jan 11
Hi,
Well I've only tried the admin section so far, and I've searched through their code for any occurrences of raw mysql calls, and I could only find one in the CB integration, which is what I tested on the frontend.
Is there any specific parts of LMS that fails for you? Or is it irrelevant where or how you use it?
27 Jan 11
Forgot to mention that I'm also testing 1.5.6.
27 Jan 11
Hi everyone,
We've resolved this issue, and sent JoomlaShowroom the patch that enable LMS to run on mysqli mode :)
27 Jan 11
I concur...works like a champ now. Thanks Stian...you're the best!
27 Jan 11
Hey Stian, thought you might like to know that I ran into a similar issue with the Joomla Tabulous module where I was getting a blank webpage when clicking on the associated menu item in my front end and so I mimicked the $dbtype variable changes you made for the LMS component in its tabulous.legacy.php script...presto...it worked! I was able to leave my db server type as mysqli and still use the Tabulous module and Ninjajournal! Sweet!
Edit: Spoke too soon Stian. The LMS component for the back end is giving me a blank screen and so I made the same changes to the script under /administrator/components/com_lms/admin.lms.legacy.php and it doesn't work. I can't imagine why unless maybe I need to make the changes in the installation script and reinstall it.
Edit: I had backed up the /administrator/components/com_lms directory last night and just copied that back a little while ago, then I changed the $dbtype script in the admin.lms.legacy.php file and it works in the backend now. However (yeah, I know...this guy's a pain) my ArtCalendar component does not work on the front end using mysqli, but it does on the backend. Go figure. I'm sure I'll have to muddle through these modules one at a time. Unlike the other guys, the art calendar doesn't use legacy mode and I can't find anything in its scripts configuring the db. Ugh.
28 Jan 11
I could schedule a code audit for ArtCalendar, like we did for LMS if that's what you want?
Sometimes it's easy to fix mysqli incompatibilities in various Joomla extensions.
Unfortunately there are some cases where the developer have used raw mysql function calls instead of the Joomla! 1.5 database API, which is db type agnostic. In those cases we have to replace each function call that looks like this "mysql_xyz" with $dbo->xyz.
It's not that simple, but I hope you get the idea.
I'm glad you figured out so many scripts on your own btw! Remember to notify the JoomlaShowroom guys about your fixes, so others may benefit from it too :)
Cheers
28 Jan 11
Looks like Art Calendar uses Jfactory and jquery commands to grab stuff out of the database. I wouldn't even know where to begin with that because there's no apparent configuration file or variable for it. I've left a post in their forum to see what they suggest. I'll let joomlashowroom know about the changes.
Edit: Thought you might like to know that the guys at artetics.com (i.e. the Art Calendar people) simply change the menu item type from their component to an external link that pointed at the calendar and it worked fine after that.
I'm geeked all over again because now I can be using Ninjaforge apps!! Let me know when the latest is out for Ninjaboard and when patches come for Ninjajournal, will you? I don't know if you have a mailing list or not. You guys are top notch in my book. Now to share that in the extensions directory :)
31 Jan 11
Wonderful news!
Yeah I'll let you know, NinjaJournal got a fresh new release last friday, Ninjaboard 1.0.4 is coming this week with a lot of bugfixes.
Cheers!
Forum Joomla Extension Support NinjaJournal Mysqli grief