I have multiple external page wrapped in GL by echo-ing the header, start_block, end_block, and footer.
I'm experiencing an issue with just one of them. First let me explain that I have two different DBs, one for GL, and the other for the DVD DB. Now the page I'm having trouble with is my
DVD Review/Easter Egg page.
The footer.thtml will not be called. I moved the closing code
Text Formatted Code
echo COM_endBlock();
echo COM_siteFooter(false);
into a different file, where it could closed as well, and I got an SQL error. When I pulled it up it had this:
Fri 17 Mar 2006 19:20:55 EST - 1146: Table 'dvddbname.gl_vars' doesn't exist. SQL in question: UPDATE gl_vars SET value = value + 1 WHERE name = 'totalhits'
Which for some reason is calling my DVD DB and not GL, but only on this page. So, when I finally figured out where this was being called from I commented out this line of code
Text Formatted Code
// DB_change( $_TABLES['vars'], 'value', 'value + 1', 'name', 'totalhits', '', true );
Bam. The footer.thtml loaded just fine. I can't find any line of code that has a similiar function as GL, and it works on other DB driven pages without that error. What will happen if I disable that line of code, or can someone help me figure out why it's looking at the wrong DB?
oh BTW - I do call lib-common.php in the /dvd/index.php
Shane | www.EyeCraveDVD.com