[Tickets #5314] Re: Unable to set queue

bugs at bugs.horde.org bugs at bugs.horde.org
Mon Apr 30 11:46:14 UTC 2007


Ticket URL: http://bugs.horde.org/ticket/?id=5314
 Ticket             | 5314
 Updated By         | webperson at hgu.mrc.ac.uk
 Summary            | Unable to set queue
 Queue              | Whups
 Type               | Bug
 State              | Feedback
 Priority           | 1. Low
 Owners             | 
+New Attachment     | debug.log

webperson at hgu.mrc.ac.uk (2007-04-30 04:46) wrote:

Here is a step-by-step guide to how I set my system up:

# Get horde
hostname> cd /sys1
hostname> export CVSROOT=:pserver:cvsread at anoncvs.horde.org:/repository
hostname> cvs login
Logging in to :pserver:cvsread at 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
hostname> mysql -p horde < 3.0_to_3.1.mysql.sql
Enter password: 
ERROR 1060 (42S21) at line 9: Duplicate column name
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,


> 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?

More information about the bugs mailing list