6.0.0-beta1
8/7/25

[#5314] Unable to set queue
Summary Unable to set queue
Queue Whups
Type Bug
State Resolved
Priority 1. Low
Owners
Requester Ewan.McDowall (at) hgu (dot) mrc (dot) ac (dot) uk
Created 04/26/2007 (6678 days ago)
Due
Updated 05/03/2007 (6671 days ago)
Assigned 04/29/2007 (6675 days ago)
Resolved 05/03/2007 (6671 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
05/03/2007 04:07:18 AM Chuck Hagenbuch Deleted Original Message
 
05/03/2007 04:06:51 AM Chuck Hagenbuch Comment #6
State ⇒ Resolved
Reply to this comment
Yes, that's just fine and is a good idea in general. I've committed 
it, thanks!
05/02/2007 09:12:59 AM Ewan (dot) McDowall (at) hgu (dot) mrc (dot) ac (dot) uk Comment #5 Reply to this comment
I found the source of the problem; I had no groups set up on our horde 
system.  Once I added the user to a group, with the correct 
permissions, the system worked fine.



Another way round my problem was to make a slight change to the code. 
Lines 61 and 96 of horde/whups/ticket/queue.php state that the group 
hidden variable is required:

$this->addHidden('', 'group', 'int', true, true);



Do you know if I can change those lines to:

$this->addHidden('', 'group', 'int', false, true);

(i.e. not required) without breaking the rest if the system?



Thanks,



Ewan
04/30/2007 02:42:21 PM Chuck Hagenbuch Comment #4 Reply to this comment
None of that information points to any error messages or problems.
04/30/2007 11:46:14 AM webperson (at) hgu (dot) mrc (dot) ac (dot) uk Comment #3
New Attachment: debug.log
Reply to this comment
Here is a step-by-step guide to how I set my system up:



# Get horde

hostname> cd /sys1

hostname> export CVSROOT=:pserver:cvsread@anoncvs.horde.org:/repository

hostname> cvs login

Logging in to :pserver:cvsread@anoncvs.horde.org:2401/repository

CVS password:

hostname> cvs co horde

cvs checkout: Updating horde

...



# Configure horde



hostname> cd horde

hostname> cd scripts/sql

hostname> vi create.mysql.sql

hostname> mysql -p <create.mysql.sql

Enter password:

cd ../upgrades

hostname> mysql -p horde <3 .0_to_3.1.sql

Enter password:

ERROR 1060 (42S21) at line 3: Duplicate column name 
'user_soft_expiration_date'

hostname> mysql -p horde < 3.0_to_3.1.mysql.sql

Enter password:

ERROR 1060 (42S21) at line 9: Duplicate column name 
'user_soft_expiration_date'

hostname> mysql -p horde < 2006-06-29_horde_prefs_indexes.sql

Enter password:

ERROR 1061 (42000) at line 6: Duplicate key name 'pref_uid_idx'

hostname> mysql -p horde < 2007-02-21_horde_alarms_primary.sql

Enter password:

hostname> mysql -p horde < 2007-04-25_horde_alarms_drop_primary.sql

Enter password:

hostname> ./migrate_user_categories.php

hostname> ./move_history_out_of_datatree.php

Beginning migration. This may take a very long time to complete.



Fetching all history objects from the data tree.

Found 0 history objects.



hostname> cd ../../config/

hostname> for f in *.dist ; do cp $f `basename $f .dist`; done

hostname> chown daemon * .

hostname> cd ..



# Get whups and framework



hostname> cvs co whups framework

cvs checkout: Updating whups

...

hostname> ./install-packages.php

hostname> cd ../whups/scripts/sql

hostname> mysql -p horde < whups.sql

Enter password:



# Install upgrades



hostname> cd ../upgrades/

hostname> for f in *.sql ; do echo $f; mysql -pPASSWORD horde < $f ; done

# They all seem to be installed...



# Configure whups



hostname> cd ../../config/

hostname> for f in *.dist ; do cp $f `basename $f .dist`; done

hostname> chown daemon * .





# Go to the web browser and generate configuration files



# Development->Tickets->Administration

Edit Types

        Create a type with standard states and priorities



Edit Queues

        Create two queues and associate the type with both of them



# Submit a ticket to Queue 1

# Jump to ticket #1



Set Queue

        Change Queue 1 -> Queue 2 (Step 1)

        Set type (Step 2)

        Set Status (Step 3)

        Click submit returns me to step 3





I've attached my debug log as it may make more sense to you.



Thanks again,



Ewan
I can't reproduce this. You sure that you're up to date, latest
Horde, all sql updates run, etc? No error messages in the logs or
suppressed somewhere?
04/29/2007 08:37:32 PM Chuck Hagenbuch Comment #2
State ⇒ Feedback
Reply to this comment
I can't reproduce this. You sure that you're up to date, latest Horde, 
all sql updates run, etc? No error messages in the logs or suppressed 
somewhere?
04/26/2007 01:35:36 PM Ewan (dot) McDowall (at) hgu (dot) mrc (dot) ac (dot) uk Comment #1
Priority ⇒ 1. Low
Type ⇒ Bug
Summary ⇒ Unable to set queue
Queue ⇒ Whups
State ⇒ Unconfirmed
Reply to this comment
I'm setting up Whups and have a very basic setup at the moment:

2 queues

1 type

Default priorities

After submitting a ticket of queue  1, I can't change it to queue 2.   
The set queue option lets me select a queue (step 1), select a type 
(step 2) setting a priority (step 3) never sets.  Clciking submit does 
nothing.  I was logged in as the system administrator.



I'm probably just missing something obvious....

Saved Queries