6.0.0-git
2017-09-22

[#1063] Mnemo categories Column
Summary Mnemo categories Column
Queue Mnemo
Queue Version 2.0
Type Bug
State Not A Bug
Priority 1. Low
Owners
Requester g.tranelli (at) inarcassa (dot) it
Created 2005-01-04 (4644 days ago)
Due
Updated 2009-03-18 (3110 days ago)
Assigned 2005-01-07 (4641 days ago)
Resolved 2005-02-07 (4610 days ago)
Milestone
Patch No

History
2009-03-18 17:41:07 kyrian (at) ore (dot) org Comment #4 Reply to this comment
I can't reproduce this.

Do categories work for you in any other applications? Did you upgrade
from an earlier version of Mnemo? If so, are you sure you ran the
upgrade scripts? Make sure the category field in your database is a
varchar, not an integer.
I've had this problem for a long time, and only just solved it with 
the help of the hints on this ticket.



The suggestions given worked, but only when I dissected the upgrade 
script that was supposed to fix it; 
scripts/upgrades/1.1_to_2.0.mysql.sql



I checked out the mnemo_memos table structure, and the memo_category 
column was indeed still an integer, which was the cause of the 
problem, because the Horde_Categories backend changed that IIRC.



Anyway the upgrade script failed with:



ERROR 1091 (42000) at line 9: Can't DROP 'memo_modified'; check that 
column/key exists



Which of course resulted in the portions of the file which correct 
memo_category to a VARCHAR(80) were not being run.



Doing a C+P of the remainder of the file directly into a MySQL shell 
has fixed the issue.



I'll open up a separate bug about improvements to the upgrade scripts, 
because I have some ideas on that, and I think at heart this bug 
relates to the use of the upgrade scripts in the wrong order, or 
re-use of them.






2005-02-07 10:30:20 Jan Schneider Comment #3
State ⇒ Not A Bug
Reply to this comment
No feedback.
2005-01-07 14:20:15 Chuck Hagenbuch Comment #2
State ⇒ Feedback
Reply to this comment
I can't reproduce this.



Do categories work for you in any other applications? Did you upgrade 
from an earlier version of Mnemo? If so, are you sure you ran the 
upgrade scripts? Make sure the category field in your database is a 
varchar, not an integer.
2005-01-04 10:21:39 g (dot) tranelli (at) inarcassa (dot) it Comment #1
Type ⇒ Bug
State ⇒ Unconfirmed
Priority ⇒ 1. Low
Summary ⇒ Mnemo categories Column
Queue ⇒ Mnemo
Reply to this comment
If I associates a categorie with a note the column display always 
"unclassified".


Saved Queries