OK, after migrating my site to a new environment I am now experiencing something really weird with any of my custom blocks that are .php files using an include function. Here is a snippet of one of the files (they all start out this way):
Quote:

The problem seems to be with the
Quote: with it there (which it has to be) I get a blank page. If I comment that single line out, XOOPS works normally, but I am not connecting to my DB to pull any data... There are no errors being shown, if I turn on debugging I don't get anything besides the normal Notices.

I am using XOOPS 2.2.3 Final. The block is set to PHP Script and has a single line of:
Quote: and the template is:
Quote:

I assume you defined your SQL connection constants.

e.g define ("SQL_USER", "USER1");

Otherwise you'll need "$" symbols in front of those variable names.

Another thing, try changing this line from



finally, try specifying the absolute path for:



HIH

Yes, the constants are being controlled from the config.php file.

Changing the DB select to
Quote:
creates the same problem.

I did not mention in my original post that there is one error that I am getting that changes based upon the module I have assigned to the start page. Currently I have News assigned as that module and am getting the following error:
Quote:

Now this module works fine on its own, it works fine as the start page module when my custom blocks are not set to visible, and it worked fine on the old server with the custom blocks, so I am pretty sure it isn't the modules fault.

The blocks work fine on their own, and they work find on the start page if I have no modules set for the front page. It is only when combining modules with these blocks that I am getting a problem.

Specifying the absolute path made no difference either. I have checked to verify that all the constants are being loaded and they are.

OK, I figured out the problem and am documenting it here in the hopes that it may help others out in the future. When I moved to my new server I thought I would make things cleaner by simply having a single user that would have access to my XOOPS DB and my statistics DB. On my old server these were two seperate users.

So I created a new user for the statistics DB, updated my config.php to reflect the new user and password. Everything is working fine! No changes to any of my PHP code were needed.

So why was this a problem? My best guess has to do with when you create a new DB select it maintains that select for all future queries and there must be a query after the blocks that was not able to execute properly since I had a new DB selection. If anyone can better explain this, I would love to understand it better.