Re: [Gmod-tripal] Triple Core Enable causes "Cannot redeclare db_status_report()" Error

[Stephen F. <FI...@cl...>]

Dear Lacey,

I'm sorry for the slow response to your first email.   Somehow I missed it last Friday.

Yes, you are correct, the databases must be of the same type 'mysql' or 'postgres'.  We had incorrectly used an example similar to what you show below for database setup in Drupal in the Tripal users manual from version 0.1b, and we've corrected it in the version 0.2 users' manual.    This may have persisted in a few other tutorials.  I'll check.  I'm sorry if this caused confusion.

We appreciate the feedback!  If you have any other comments/questions please feel free to send along.

Stephen


From: Lacey Sanderson [mailto:lac...@sh...]
Sent: Monday, February 08, 2010 4:52 PM
To: gmo...@li...
Subject: Re: [Gmod-tripal] Triple Core Enable causes "Cannot redeclare db_status_report()" Error

Update,

I was doing some digging around in the Drupal Troubleshooting FAQ and found a note on
Fatal error: Cannot redeclare blah_function() in ../modules/blah.module (http://drupal.org/node/72099)
Which suggests the problem may be  due to duplicated function/module... Thus maybe it's related to the two different databases and the same functions being used to initiate each?

I then found a further post (http://old.nabble.com/using-two-different-database-type-td18728019.html) of using two different database types which confirmed my previous hypothesis:

Quote:


Re: using two different database type
[http://old.nabble.com/images/icon_unflagged.png]<javascript:%20void%20Nabble.setFlag(18728459);>[http://old.nabble.com/images/icon_star_blue.png][http://old.nabble.com/images/icon_star_blue.png][http://old.nabble.com/images/icon_star_blue.png]

by Pierre R.<http://old.nabble.com/user/UserProfile.jtp?user=1279907> Jul 30, 2008; 02:33am :: Rate this Message: [http://old.nabble.com/images/icon_blocked_gray.png] <http://old.nabble.com/using-two-different-database-type-td18728019.html> [http://old.nabble.com/images/icon_star_grey.png] <http://old.nabble.com/using-two-different-database-type-td18728019.html> [http://old.nabble.com/images/icon_star_grey.png] <http://old.nabble.com/using-two-different-database-type-td18728019.html> [http://old.nabble.com/images/icon_star_grey.png] <http://old.nabble.com/using-two-different-database-type-td18728019.html> [http://old.nabble.com/images/icon_star_grey.png] <http://old.nabble.com/using-two-different-database-type-td18728019.html> [http://old.nabble.com/images/icon_star_grey.png] <http://old.nabble.com/using-two-different-database-type-td18728019.html> [http://old.nabble.com/images/icon_clear_rating.png] <http://old.nabble.com/using-two-different-database-type-td18728019.html> - Use ratings to moderate (?<http://old.nabble.com/help/Answer.jtp?id=16>)

Reply<http://old.nabble.com/forum/Reply.jtp?post=18728459> | Reply to Author<http://old.nabble.com/user/SendEmail.jtp?type=pm&post=18728459> | Print<http://old.nabble.com/forum/PrintPost.jtp?post=18728459> | View Threaded<javascript:%20void%20Nabble.setView('newthreaded',18728459);> | Show Only this Message<http://old.nabble.com/Re%3A-using-two-different-database-type-p18728459.html>
You MUST use two same database type.

Explaination is simple, since Drupal files with pgsql support and mysql
support declare the same function's names inside, it's just impossible
to go through this situation.

Therefore I am going to switch my drupal database to postgres and see if that fixes this problem...

Lacey

On 5-Feb-10, at 9:48 AM, Lacey Sanderson wrote:


Hello,

I am using,
Drupal                         6.15
Triple               6.x-0.2
Chado             1.8
PostgreSQL    8.3.9 (server 8.3.8)
System                        Ubuntu Intrepid

Up to this point I have installed chado and loaded the example yeast data. I checked and the data seems to be loaded into chado correctly. I then installed drupal (which works fine), changed the db_url definition in settings.php to include both 'default and 'chado' and untar-ed the triple module in the module dir...

When I go to enable the core module, as soon as I press Save Configuration it takes me to a Fatal Error Page with the following text:

Fatal error: Cannot redeclare db_status_report() (previously declared in /usr/share/drupal6/includes/database.mysql.inc:20) in /usr/share/drupal6/includes/database.pgsql.inc on line 33

This is what my settings.php looks like (except I filled in pass with the correct password for each.

 * Database URL format:
 *   $db_url = 'mysql://username:password@localhost/databasename';
 *   $db_url = 'mysqli://username:password@localhost/databasename';
 *   $db_url = 'pgsql://username:password@localhost/databasename';
 */
$db_url = array(
        'default' => 'mysql://drupal6:pass@localhost/drupal6',
        'chado' => 'pgsql://chado:pass@localhost/chado-dev',
 );
$db_prefix = '';

Any idea what is going on? I double-check that the use I specified could login to the database I specified and tried to look at the file but I don't know php...

Help? Thanks in advance,

Lacey


---------------------------------
Lacey Sanderson
Bioinformaticist
Pulse Crop Breeding and Genetics
Department of Plant Sciences
University of Saskatchewan.