Geeklog Forums

Hi Folks, I\"m a relative newbie to geeklog, but I\'m learning the ropes; I\'ve spent a good deal of time deconstructing geeklog\'s logic and must say that it is a beautiful base for your web application stew. I\'d like to throw a new app into the pot and I could use some help if anyone would be interested in this project. I\"ve installed geeklog CMS as an information news portal for a Lending Library based out of my school (CCSF) and would like to incorporate a library plugin into the geeklog framework. I\'ve found two promising library applications so far:

• koha- \"The first open source library application\"
and
• ola- Online LIbrary Application

Koha is PERL cgi and would need execution of including lib-common.php from PHP CLI, then calling COM_siteHeader(), COM_startBlock(), etc..., but I haven\'t tried this yet. Since I was unsure about trying to get PERL to call PHP, I went with ola to start with at first, since it is in PHP with MYSQL. Ola looks to be very promising. It has a simple authentication method that I think can be incorporated into geeklog\'s auth fairly simply (sort of like the Gallery plugs into geeklog), but I ran into errors when I tried to include lib-common.php into the header and footer templates of the ola application. It seems that there is this dubbled up MYSQL connection problem that I\'m bumping into. If I include lib-common.php, draw the header with COM_siteHeader(), and then try to call ola\'s functions to draw the page display, it seems that the ola mysql calls seem to inherit the connection used by geeklog and therefore makes calls to database tables that don\'t exist, hence returning no results. As of PHP 4.2, there is a an option that you can supply to the mysql_connect() funtion that makes sure you get a new connection, but alas the system I\"m building on has 4.1 PHP, so this doesn\'t work. Someone on php.net mentioned that you can work around this by using independent database users, thereby forcing a new connection but it didn\'t work. I need to upgrade PHP on my server/devel box and try it out. If it\'s working, I\'d like to clean up the code and try and make a plugin out of that library app and send the results back upstream. Ola is a GNUed app, so no problems with licensing or anything. If anyone has any interest or suggestions on this topic please feel free to post them. I should get replies in my email, right? Thanks, developers, coders, h4x0rs, and geeks for all your hard work. I hope to see geeklog reign supreme over the other content management systems out there. It is definately a cool tool. Take care, and thanks in advance for any help, thoughts, advice, Andrew

I thought I had it there for a second. I realized that rather than get it to recognize the different connections, I could just as easily import the database tables from the library into geeklog. This worked and I can use the tables out of there with the same user accross the connections but I'm still running into the same error, which makes me think my original hypothesis of dubbling up on database connections was wrong. Does anyone know what this error might mean?

Warning: Missing argument 2 for db_query() in /usr/local/apache/anarchistlibrary.org/html/ola/lib/db.inc.php on line 77

Fatal error: Call to a member function on a non-object in /usr/local/apache/anarchistlibrary.org/html/ola/lib/db.inc.php on line 92

It only pops up whence I include lib-commong.php, thereby breaking something in OLA.

the argument 2 doesnt\' seem to exist since there isn\'t any data in the database just yet, but this error doesn\'t appear until I include lib-common.php.

have you looked at the Distributed Library Project? it\'s rather cute.

---

-Adam O'Donnell