6.0.0-alpha12
6/12/25

[#10233] Migration errors
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

History
06/14/2011 02:53:03 PM Jan Schneider Comment #7
State ⇒ Not A Bug
Reply to this comment
Who knows how many database updates this db has seen :) I'd just add 
that key, but I have tons of duplicate entries. This is just a test 
install of whups, I guess I better start from scratch.
06/14/2011 02:40:14 PM Michael Rubinsky Comment #6 Reply to this comment
Hm. Your table doesn't have the log_id field defined as a primary key. 
Not sure why though. The level 1 migration defines it,  as does the 
creation script from H3.

06/14/2011 02:14:36 PM Jan Schneider Comment #5 Reply to this comment
I probably should change that to check for the tables' existence first.
No, that's fine, we don't check this in other migration scripts 
either. Of course we could add the check everywhere, to avoid 
confusion on the admin's end.
Can you post a DESCRIBE whups_logs?
+----------------+--------------+------+-----+---------+-------+
| 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    |       |
+----------------+--------------+------+-----+---------+-------+

06/14/2011 01:50:57 PM Michael Rubinsky Comment #4 Reply to this comment
I probably should change that to check for the tables' existence 
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?
06/14/2011 12:33:43 PM Jan Schneider Comment #3 Reply to this comment
Yes, you are right, most of the entries are from catched dropping of 
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.
06/14/2011 03:59:16 AM Michael Rubinsky Comment #2
State ⇒ Feedback
Reply to this comment
I can't reproduce any of these errors. Tested on both existing H3 data 
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?
06/13/2011 02:22:22 PM Jan Schneider Comment #1
Priority ⇒ 2. Medium
Type ⇒ Bug
Summary ⇒ Migration errors
Queue ⇒ Whups
Assigned to Michael Rubinsky
Milestone ⇒
Patch ⇒ No
State ⇒ Assigned
Reply to this comment
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_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"]

Saved Queries