Forum OpenACS Q&A: Re: macosx and no fullquery
17/Sep/2003:14:51:52][8701.2684358124][-main-] Debug: QD=Postload files to load: /usr/local/aolserver/web/openacs/www/index-oracle.xql /usr/local/aolserver/web/openacs/www/index-postgresql.xql /usr/local/aolserver/web/openacs/www/index.xql
[17/Sep/2003:14:51:52][8701.2684358124][-main-] Warning: Query dbqd.www.index-oracle.site_nodes has rdbms info oracle 8.1.6 which is not compatible with system rdbms postgresql 7.3
i don't know if this has anything to do with the problem? because i don't really know what this means.
When I see the 'default SQL empty' error message, I think of a couple things:
- Did I restart the server after installing any new packages?
- Is the XQL file actually there? e.g. forums/www/index-postgresql.xql
- Does it contain the query in question? e.g. select_forums
- Is the XQL malformed in any way (missing brackets,etc)? Shouldn't be the case since you haven't edited anything.
- Is the XML parsing screwed up? Did ns_xml load properly, without errors?
1. I did restart the server.
2. 3. 4. Shouldn't be the any of these things as the same installation works on other os's. I'm not modifying any code.
5. I thought maybe nsxml was broken, but I ran this test from this page on fifthgate.com and everything seemed to be working. No error log entries on nsxml.
I'm going to see how much debugging I can do and then I will post the logs.
Thanks for the help everyone.
i just tried everything one more time. the only thing i did differently was download the newest versions of libxml2 (2.5.11) and libxslt (1.0.33) from ftp://xmlsoft.org to recompile nsxml-1.5. after i proved it worked with the script from fifthgate, reinstalled.
everything now seems to be working as it does on any of my installations. i've been able to enable and mount packages with no problem. i still get the "no fullquery" all over the logs, but i guess those are normal as it doesn't seem to have an effect.
i guess either i botched the original libxml/xslt/nsxml stuff, or there were version problems. on a related note, i'm not sure the /tests/ files in the nsxml source work for testing. the script above did.
thanks to everyone for your time and help.
i'm so happy that it's finally up and running, i'm going to let it sit for a while and stare at it. but soon i'll go through the process again, write everything down, and make sure there is nothing to add to the various install on xxx platform docs.