Thread

I am getting this error when trying to access some pages on my site:

MySQL ERROR:

Error Number: 1146

Description: Table 'db38661_bert.exp_actions' doesn't exist

Query: SELECT action_id, class, method FROM exp_actions WHERE (class= 'Search' AND method = 'do_search') OR (class= 'Trackback_CP' AND method = 'receive_trackback')

I’m running version 1.66 and build 20081114

Does this only happen on specific pages or is it random?

Also, is it always the search class or do the error details vary?

It is always happening on the Photo Gallery page and it happens sometimes on the home page of the entire site.

Yes, it’s always the same error message, referencing the Search.

Can you go to:  CP Home ›  Admin ›  Utilities ›  SQL Manager ›  Manage Database Tables and make sure you have a table called “exp_actions”

Yes, that table does exist

Can you try to uninstalling & reinstalling the search module?

Uninstalled and re-installed the search module, and still no change.  FYI - blog.php results in this error, as does the gallery page (blog.php/gallery).  But the forums page (blog.php/forums) works fine.

The odd thing is that the database I use for EE on the site is _tbp not _bert ... It’s like blog.php is looking at _bert for something or it’s interfering somehow.

That database (_bert) is used on the site for other non-CMS content) ... where do i look to see if the db is being called by blog.php somehow?

I figured this out ...

In my default template for the home page, I had placed a connection to another database (not EE) to pull content.  Apparently, EE doesn’t like that.  I thought that if I had PHP enabled in templates, I’d be fine.  But the template seems to think it’s connected to the other DB.  Maybe I need to close my connection to the other DB?

Any advice would be appreciated.

That certainly sounds unusual, and potentially troublesome. How are you connecting to that secondary database?

I am using a simple MySQL connection:

//Connect to DB
$con = mysql_connect('DBSERVER', $username, $password);
mysql_select_db('DBNAME', $con) or die('Could not open database');
?>

Can you do this within EE?  Connect to another db and still use the EE query tags on the same template?

I am using the same user to connect to that database as I use to connect to the EE database, could that be the problem?

Does that code alone cause a problem? Or what is only the combination that is causing it? Can you reduce your template to the minimal code that is causing this erratic behavior?

hofboone, I can confirm now that if you select a separate database, you have to switch back to your EE database when your code is done.

Another alternative would be to have both sets of tables in the same MySQL database. I do that a lot if I need to query another program’s tables for some reason.

I’m surprised that EE doesn’t support connecting to another database. I make my connection, close it, and then go right back to the EE connection, and the template still breaks.

I will put the content into the same database and see how that works.

Using the same database is certainly the easier solution. I have used it a number of times; just put your data in tables of their own and you should be fine.