| Summary | DB schema "update" failed |
| Queue | Whups |
| Queue Version | Git develop |
| Type | Bug |
| State | Resolved |
| Priority | 1. Low |
| Owners | jan (at) horde (dot) org |
| Requester | thomas.jarosch (at) intra2net (dot) com |
| Created | 07/07/2012 (4723 days ago) |
| Due | |
| Updated | 08/29/2012 (4670 days ago) |
| Assigned | 07/07/2012 (4723 days ago) |
| Resolved | 07/17/2012 (4713 days ago) |
| Github Issue Link | |
| Github Pull Request | |
| Milestone | |
| Patch | No |
commit 831ff3cbb578a5de962ac01aefb9a13cf5641918
Author: Jan Schneider <jan@horde.org>
Date: Tue Jul 17 16:58:37 2012 +0200
Allow for nested transactions.
Fixes
bug #11245.framework/Db/lib/Horde/Db/Adapter/Base.php | 20 ++++++++++++--------
framework/Db/lib/Horde/Db/Adapter/Mysql.php | 12 +++++++-----
framework/Db/lib/Horde/Db/Adapter/Mysqli.php | 10 +++++++---
framework/Db/package.xml | 4 ++--
4 files changed, 28 insertions(+), 18 deletions(-)
http://git.horde.org/horde-git/-/commit/831ff3cbb578a5de962ac01aefb9a13cf5641918
Taken from Michael Rubinsky
State ⇒ Resolved
commit 831ff3cbb578a5de962ac01aefb9a13cf5641918
Author: Jan Schneider <jan@horde.org>
Date: Tue Jul 17 16:58:37 2012 +0200
Allow for nested transactions.
Fixes
bug #11245.framework/Db/lib/Horde/Db/Adapter/Base.php | 20 ++++++++++++--------
framework/Db/lib/Horde/Db/Adapter/Mysql.php | 12 +++++++-----
framework/Db/lib/Horde/Db/Adapter/Mysqli.php | 10 +++++++---
framework/Db/package.xml | 4 ++--
4 files changed, 28 insertions(+), 18 deletions(-)
http://git.horde.org/horde-git/-/commit/831ff3cbb578a5de962ac01aefb9a13cf5641918
one place where this table is created, the only way this can happen
is if you attempt to run the migration on a database that has the
table already but the schema data indicates that the migration was
not run.
(Took me a while to figure out
#11244as it "locked me out". So Irecreated the database, prefs and config from scratch)
I've just recreated the database and it fails with another error
during the first creation:
2012-07-09T09:24:00+02:00 ERR: HORDE [horde] SQL QUERY FAILED:
SQLSTATE[HY000]: General error: 1 no such table: whups_shares_seq
DROP TABLE "whups_shares_seq" [pid 2717 on line 812 of
"/datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Adapter/Base.php"]
After that I get the "whups_transactions" error mentioned previously.
State ⇒ Feedback
Assigned to Michael Rubinsky
place where this table is created, the only way this can happen is if
you attempt to run the migration on a database that has the table
already but the schema data indicates that the migration was not run.
Priority ⇒ 1. Low
Type ⇒ Bug
Summary ⇒ DB schema "update" failed
Queue ⇒ Whups
Milestone ⇒
Patch ⇒ No
State ⇒ Unconfirmed
I have a fresh git "develop" branch install here. I can't update the
whups DB schema with the sqlite driver. Here's the error message from
the log:
2012-07-07T19:22:27+02:00 ERR: HORDE [horde] SQL QUERY FAILED:
SQLSTATE[HY000]: General error: 1 table "whups_transactions" already
exists
CREATE TABLE "whups_transactions" ( "transaction_id" int NOT NULL,
"transaction_timestamp" int NOT NULL, "transaction_user_id"
varchar(255) NOT NULL, PRIMARY KEY("transaction_id") )
[pid 14698 on line 812 of
"/datastore/DEVEL/horde/framework/Db/lib/Horde/Db/Adapter/Base.php"]
Thomas