6.0.0-beta1
7/5/25

[#9402] automatic upgrade of webmail edition tries to create a whups table which failed
Summary automatic upgrade of webmail edition tries to create a whups table which failed
Queue Whups
Queue Version 1.0.1
Type Bug
State Resolved
Priority 1. Low
Owners jan (at) horde (dot) org
Requester michael (at) bigmichi1 (dot) de
Created 11/23/2010 (5338 days ago)
Due
Updated 11/25/2010 (5336 days ago)
Assigned
Resolved 11/25/2010 (5336 days ago)
Github Issue Link
Github Pull Request
Milestone 1.0.2
Patch No

History
11/25/2010 08:23:58 PM Jan Schneider Assigned to Jan Schneider
State ⇒ Resolved
Milestone ⇒ 1.0.2
 
11/25/2010 08:23:36 PM CVS Commit Comment #2 Reply to this comment
Changes have been made in CVS for this ticket:

Remove unused table (Bug #9402).
http://cvs.horde.org/diff.php/whups/scripts/sql/whups.xml?rt=horde&r1=1.3.2.1&r2=1.3.2.2&ty=u
11/23/2010 07:34:50 AM michael (at) bigmichi1 (dot) de Comment #1
Priority ⇒ 1. Low
Patch ⇒ No
Milestone ⇒
Queue ⇒ Whups
Summary ⇒ automatic upgrade of webmail edition tries to create a whups table which failed
Type ⇒ Bug
State ⇒ Unconfirmed
Reply to this comment
when i run the setup.php to upgrade from 1.2.8 to 1.2.9 the upgrade 
process tries to create a whups table which failed. error message:
Updating database...
[   OK   ] Successfully updated the global tables.
[   OK   ] Successfully updated the tables for Mail (imp).
[   OK   ] Successfully updated the tables for Filters (ingo).
[   OK   ] Successfully updated the tables for Address Book (turba).
[   OK   ] Successfully updated the tables for Calendar (kronolith).
[   OK   ] Successfully updated the tables for Tasks (nag).
[   OK   ] Successfully updated the tables for Notes (mnemo).
[ ERROR! ] Updating the tables for Tickets (whups) failed. Error messages:
MDB2 Error: unknown error
_doQuery: [Error message: Could not execute statement]
[Last executed query: CREATE  TABLE whups_users_queries (user_uid 
VARCHAR(255) DEFAULT ' ' NOT NULL, query_name VARCHAR(255) DEFAULT 
NULL, query_object VARCHAR(65532) DEFAULT NULL)]
[Native code: 1118]
[Native message: Row size too large. The maximum row size for the used 
table type, not counting BLOBs, is 65535. You have to change some 
columns to TEXT or BLOBs]


Running post-update scripts...

i looked in the whups.sql which i used to create the tables and there 
is no table named whups_users_queries

Saved Queries