Summary | Migration errors |
Queue | Whups |
Queue Version | Git master |
Type | Bug |
State | Not A Bug |
Priority | 2. Medium |
Owners | mrubinsk (at) horde (dot) org |
Requester | jan (at) horde (dot) org |
Created | 06/13/2011 (5113 days ago) |
Due | |
Updated | 06/14/2011 (5112 days ago) |
Assigned | 06/14/2011 (5112 days ago) |
Resolved | 06/14/2011 (5112 days ago) |
Github Issue Link | |
Github Pull Request | |
Milestone | |
Patch | No |
State ⇒ Not A Bug
that key, but I have tons of duplicate entries. This is just a test
install of whups, I guess I better start from scratch.
Not sure why though. The level 1 migration defines it, as does the
creation script from H3.
either. Of course we could add the check everywhere, to avoid
confusion on the admin's end.
| Field | Type | Null | Key | Default | Extra |
+----------------+--------------+------+-----+---------+-------+
| ticket_id | int(11) | NO | MUL | 0 | |
| log_timestamp | int(11) | NO | MUL | 0 | |
| user_id | varchar(255) | NO | | | |
| log_type | varchar(255) | YES | | NULL | |
| log_value | varchar(255) | YES | | NULL | |
| log_id | int(11) | YES | | NULL | |
| transaction_id | int(11) | YES | | NULL | |
| log_value_num | int(11) | YES | | NULL | |
+----------------+--------------+------+-----+---------+-------+
first. Though I wonder why I'mnot seeing the logged errors...probably
some configuration issues on my end.
The last error I was also unable to reproduce on both a new or
existing database. Can you post a DESCRIBE whups_logs?
sequence tables. They are still logged by Horde_Db.
The last log entry is the one that's causing migration for me to stop,
I get the same error message in a UI notification.
State ⇒ Feedback
as well as a fresh database. They DROP statements in the 7 migration
are wrapped in try/catch blocks so I'm not sure why you would be
seeing errors when they don't exist?
Priority ⇒ 2. Medium
Type ⇒ Bug
Summary ⇒ Migration errors
Queue ⇒ Whups
Assigned to Michael Rubinsky
Milestone ⇒
Patch ⇒ No
State ⇒ Assigned
SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table
'whups_tickets_seq'
DROP TABLE `whups_tickets_seq` [pid 31138 on line 792 of
"/home/jan/horde-git/framework/Db/lib/Horde/Db/Adapter/Base.php"]
2011-06-13T16:21:18+02:00 ERR: HEADHORDE [horde] SQL QUERY FAILED:
SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table
'whups_queues_seq'
DROP TABLE `whups_queues_seq` [pid 31138 on line 792 of
"/home/jan/horde-git/framework/Db/lib/Horde/Db/Adapter/Base.php"]
2011-06-13T16:21:18+02:00 ERR: HEADHORDE [horde] SQL QUERY FAILED:
SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table
'whups_types_seq'
DROP TABLE `whups_types_seq` [pid 31138 on line 792 of
"/home/jan/horde-git/framework/Db/lib/Horde/Db/Adapter/Base.php"]
2011-06-13T16:21:18+02:00 ERR: HEADHORDE [horde] SQL QUERY FAILED:
SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table
'whups_states_seq'
DROP TABLE `whups_states_seq` [pid 31138 on line 792 of
"/home/jan/horde-git/framework/Db/lib/Horde/Db/Adapter/Base.php"]
2011-06-13T16:21:18+02:00 ERR: HEADHORDE [horde] SQL QUERY FAILED:
SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table
'whups_replies_seq'
DROP TABLE `whups_replies_seq` [pid 31138 on line 792 of
"/home/jan/horde-git/framework/Db/lib/Horde/Db/Adapter/Base.php"]
2011-06-13T16:21:18+02:00 ERR: HEADHORDE [horde] SQL QUERY FAILED:
SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table
'whups_attributes_desc_seq'
DROP TABLE `whups_attributes_desc_seq` [pid 31138 on line 792
of "/home/jan/horde-git/framework/Db/lib/Horde/Db/Adapter/Base.php"]
2011-06-13T16:21:18+02:00 ERR: HEADHORDE [horde] SQL QUERY FAILED:
SQLSTATE[42S02]: Base table or view not found: 1051 Unknown table
'whups_comments_seq'
DROP TABLE `whups_comments_seq` [pid 31138 on line 792 of
"/home/jan/horde-git/framework/Db/lib/Horde/Db/Adapter/Base.php"]
2011-06-13T16:21:18+02:00 ERR: HEADHORDE [horde] SQL QUERY FAILED:
SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP
'PRIMARY'; check that column/key exists
ALTER TABLE `whups_logs` DROP PRIMARY KEY, CHANGE `log_id` `log_id`
int(10) UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY [pid
31138 on line 792 of
"/home/jan/horde-git/framework/Db/lib/Horde/Db/Adapter/Base.php"]