[#6804] Missing(?) MDB2 packages/support
Summary Missing(?) MDB2 packages/support
Queue Horde Groupware Webmail Edition
Queue Version 1.1
Type Bug
State Resolved
Priority 1. Low
Owners
Requester rob (dot) macgregor (at) gmail (dot) com
Created 05/31/2008 (90 days ago)
Due
Updated 06/11/2008 (79 days ago)
Assigned 05/31/2008 (90 days ago)
Resolved 06/11/2008 (79 days ago)
Attachments
Milestone
Patch No

History
06/11/2008 Michael Rubinsky State ⇒ Resolved
 
06/11/2008 dpc22 (at) cam (dot) ac (dot) uk Comment #9 Reply to this comment

I've done a parallel install of 1.1, leaving my working 1.0.6 install alone.

I followed the installation notes, installing everything that's marked
as required and almost everything that was recommended.  I've
configured it to use MySQL, like my 1.0.6 install (I'm using a
different database, horde11 instead of horde, so I can run in
parallel).  However, I'm getting the following error after trying to
login:

Fatal error: Call to undefined method MDB2_Error::execute() in
/www/webdocs/webmail/lib/Horde/Share/sql.php on line 554

I've installed MDB2 and the mysql driver (version 1.4.1), PHP 5.2.5,
Apache 2.2.8 and Horde Webmail 1.1.  It all works fine with 1.0.6.
I'm obviously missing something obvious, as I've not seen anybody else
report this.
I had the same problem. After applying the two patches in this thread 
things started to work
apart from some moaning about the Calender Database.

The problem turned out to be that I had used 
.../scripts/sql/create.mysql.sql rather than
the correct .../scripts/sql/groupware.sql, and so was missing quite a 
few of the database tables.

The MDB2_Error::execute() stuff was just a red herring.

06/02/2008 Michael Rubinsky Comment #8 Reply to this comment
hello,

I got exactly the same error with lastest rc4 version. Is there a way
to fix it?
Not until we know what the actual error is...

There have been a few more error checks and error logging added to the 
code that was producing the oringinal fatal.  If the someone can try 
this again after updating the code and report back any errors either 
displayed on in the horde log, it would be helpful.
I've tried several ways, but still have no clue why the script can
not find the MDB2 package.
What makes you thing the MDB2 package is not found?  The problem 
reported in this ticket is that an MDB2_Error is being accessed as if 
it were an MDB2_Result or similar object...


If I try to use mysql (not mysqlI)

setup.php returns also another error:

Loading database module...
[  WARN  ] Database horde exists already, skipping.
Creating database...
[ ERROR! ] Creating the tables failed. Please see the manual at docs/INSTALL
            for how to setup the database manually. Error messages:
MDB2_Schema Error: unknown error
the database was only partially created (MDB2 Error: unknown error
(_doQuery: [Error message: Could not execute statement]
[Last executed query: ALTER TABLE horde_datatree ADD PRIMARY KEY
(datatree_id)]
[Native code: 1068]
[Native message: Multiple primary key defined]
))
These are exactly what they say. You are attempting to create a 
database that already exists.
06/02/2008 mveltre82 (at) hotmail (dot) com Comment #7 Reply to this comment
hello,

I got exactly the same error with lastest rc4 version. Is there a way 
to fix it?

I've tried several ways, but still have no clue why the script can not 
find the MDB2 package.  If I try to use mysql (not mysqlI) setup.php 
returns also another error:

Loading database module...
[  WARN  ] Database horde exists already, skipping.
Creating database...
[ ERROR! ] Creating the tables failed. Please see the manual at docs/INSTALL
            for how to setup the database manually. Error messages:
MDB2_Schema Error: unknown error
the database was only partially created (MDB2 Error: unknown error 
(_doQuery: [Error message: Could not execute statement]
[Last executed query: ALTER TABLE horde_datatree ADD PRIMARY KEY 
(datatree_id)]
[Native code: 1068]
[Native message: Multiple primary key defined]
))

Thanks,
Markus
06/01/2008 privat (at) wolfgang-andreas (dot) de Comment #6 Reply to this comment

I've done a parallel install of 1.1, leaving my working 1.0.6 install alone.

I followed the installation notes, installing everything that's marked
as required and almost everything that was recommended.  I've
configured it to use MySQL, like my 1.0.6 install (I'm using a
different database, horde11 instead of horde, so I can run in
parallel).  However, I'm getting the following error after trying to
login:

Fatal error: Call to undefined method MDB2_Error::execute() in
/www/webdocs/webmail/lib/Horde/Share/sql.php on line 554

I've installed MDB2 and the mysql driver (version 1.4.1), PHP 5.2.5,
Apache 2.2.8 and Horde Webmail 1.1.  It all works fine with 1.0.6.
I'm obviously missing something obvious, as I've not seen anybody else
report this.
Hello! I've got exactly the same problem here.
I'm using PHP 5.2.0. mysql driver and mdb2 installed using pear.
05/31/2008 Michael Rubinsky Comment #5 Reply to this comment
05/31/2008 rob (dot) macgregor (at) gmail (dot) com Comment #4 Reply to this comment
After installing that patch I now see:

Call to undefined method MDB2_Error::execute() in 
/www/webdocs/webmail/lib/Horde/Share/sql.php on line 869

05/31/2008 Michael Rubinsky Comment #3 Reply to this comment
05/31/2008 Michael Rubinsky Comment #2
State ⇒ Feedback
Reply to this comment
We now at least catch and return this error.  Hopefully you'll now see 
some more useful information in the logs or notifications.
05/31/2008 rob (dot) macgregor (at) gmail (dot) com Comment #1
Patch ⇒
Milestone ⇒
Queue ⇒ Horde Groupware Webmail Edition
Summary ⇒ Missing(?) MDB2 packages/support
Type ⇒ Bug
Priority ⇒ 1. Low
State ⇒ Unconfirmed
Reply to this comment
I've done a parallel install of 1.1, leaving my working 1.0.6 install alone.

I followed the installation notes, installing everything that's marked
as required and almost everything that was recommended.  I've
configured it to use MySQL, like my 1.0.6 install (I'm using a
different database, horde11 instead of horde, so I can run in
parallel).  However, I'm getting the following error after trying to
login:

Fatal error: Call to undefined method MDB2_Error::execute() in
/www/webdocs/webmail/lib/Horde/Share/sql.php on line 554

I've installed MDB2 and the mysql driver (version 1.4.1), PHP 5.2.5,
Apache 2.2.8 and Horde Webmail 1.1.  It all works fine with 1.0.6.
I'm obviously missing something obvious, as I've not seen anybody else
report this.