Problem with Code page using Vincent02 template

[rudivs]

Using the Vincent02 template, I get an error when I try to use database connections in a Code type page. For example, if I use only the following code, it causes the page to display without a menu, and on a grey background.

Code:

require 'DB.php';
$db = DB::connect('mysql://root@localhost/SpmnData');

In website baker 2.6.7 it also gave the error "Call to a member function numRows() on a non-object", pointing to line 337 in framework/class.frontend.php. That line is "$if($query_menu->numRows() > 0) {" in the function show_menu().

Can anyone help me to debug this? Other templates don't seem to have the same problem. I love the vincent02 template and I'd hate to have to use another one.

[kweitzel]

Maybe give the require "DB.php" a complete path, currently the webserver is looking for it where the page is located. By checking the server logs you should see this as well.

Additionally you will need to close the database connection at the end and reopen the WB connection.

If I am not misstaken somebody posted a Database connection Module somewhere ...

cheers

Klaus

[jmarco]

I am having quite a similar problem. I traced the code and found out that adding a line

Code:

$database->connect();

at the end of my code will fix it.

It seems that only one connection can be open at a time so you need to close the one you opened and reopen WB's connection.

It seems that the crashing instruction is in file filter-routines.php line 35 which is a query to the WB db. I wonder if it would not be a good idea to ensure that the WB db keeps connected after showing some processed output by adding this line in file \wb\index.php (which is where the initial call which causes the crash is originated) at line 99:

Code:

93:    if(function_exists('filter_frontend_output')) {
94:        // store output in variable for filtering
95:        @ob_start();
96:        require(WB_PATH.'/templates/'.TEMPLATE.'/index.php');        
97:        $frontend_output = ob_get_contents();        
98:        @ob_end_clean();    
99:        // Ensure we are connected to WB's db before further processing!    
100:        $database->connect();
        // Display the filtered output on the frontend                
        echo filter_frontend_output($frontend_output);
        die;
    }

Could someone confirm this is correct?

  Thanks!

[kweitzel]

The "1 connection" is indeed right. You need to close every connection you open. I think you should even close and re-open the WB connection, at least if you are having trouble.

cheers

Klaus

[jmarco]

  Thanks, Klaus, that solves my doubts. I am managing well by now with the quick fix in index.php that I posted.

  Have a nice day!