Hi Shawn, I did run all db update scripts. I also had to convert the old database from latin1 to utf8 by performing the following steps to convert the dump file:
# sed -r 's/latin1/utf8/g' otrs_dump.sql > otrs_dump_utf.sql And iconv -f iso-8859-1 -t utf-8 otrs_dump_utf.sql > otrs_dump_utf_pro.sql Afterwards I run all the update scripts and loaded this dump into a new created utf8 database. (The database is on a different server then otrs is) Now all data is imported correctly but it seems to me that the performance is very bad. A Test with the benchmark module shows: Ergebnis: SQL Schlüssel Wert Zeit Insert Time: 30000 42 s :-( Update Time: 30000 73 s :-( Select Time: 30000 97 s :-( Delete Time: 1 0 s :-) Multiplier: * 3 I just saw that there are scripts to do the database converting (charset-convert.pl and convert_db_to_utf8.pl). I'll try these. Hope the database works better then. Does any one have experience with these scripts? Best Regards, Manuel -----Ursprüngliche Nachricht----- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Shawn Beasley Gesendet: Dienstag, 31. Juli 2007 11:00 An: [email protected] Betreff: [otrs] Re: AW: Users missing after 2.1.7 to 2.2.1 Upgrade... Manuel Ernst schrieb: > Hello, > > As this is my first post in this list, I shortly want to introduce myself. > > My name is Manuel Ernst and I work in Switzerland near Basel. At the moment > we use OTRS 1.3 and I am now about to update it on a new SuSE Server 10.2 to > version 2.2.1. > > It seems that I have the same problem as you have, but when I search for * > all users are displayed. For other views such as "Customer User <-> Services" > this search seems to be set as default. > > Maybe there is a possibility to change this setting? > > Best regards, > Manuel > > > > > > -----Ursprüngliche Nachricht----- > Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Im Auftrag von Jeff Shepherd > Gesendet: Dienstag, 24. Juli 2007 19:19 > An: User questions and discussions about OTRS.org > Betreff: Re: [otrs] Users missing after 2.1.7 to 2.2.1 Upgrade... > > Has anyone else seen the same problem? > > -Jeff > > Jeff Shepherd wrote: >> Actually, there are a lot of things missing (email addresses, >> signature, salutation, roles, and groups - in addition to users). >> After I did the upgrade, I ran (from /opt/otrs/scripts/): >> >> cat DBUpdate-to-2.2.mysql.sql | mysql -f -u root otrs >> >> This made all of the tickets appear correctly. Is there another >> update script that I'm supposed to run? >> >> Thank you again! >> >> -Jeff >> >> >> Jeff Shepherd wrote: >>> I've just updated my OTRS installation on Fedora 3 and now under >>> Admin -> Users, nothing is listed. I see the users listed when I go >>> to "Admin Notification" and a few other places, however, I cannot >>> modify the users under the actual "Users" control. >>> >>> Any thoughts? >>> >>> Thanks! >>> >>> -Jeff >>> >>> _______________________________________________ >>> OTRS mailing list: otrs - Webpage: http://otrs.org/ >>> Archive: http://lists.otrs.org/pipermail/otrs >>> To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs >>> Support or consulting for your OTRS system? >>> => http://www.otrs.com/ >> _______________________________________________ >> OTRS mailing list: otrs - Webpage: http://otrs.org/ >> Archive: http://lists.otrs.org/pipermail/otrs >> To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs >> Support or consulting for your OTRS system? >> => http://www.otrs.com/ > > _______________________________________________ > OTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/otrs > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs > Support or consulting for your OTRS system? > => http://www.otrs.com/ > > ----------------------------------------------------------------------------- > CAUTION - This message may contain privileged and confidential information > intended only for the use of the addressee named above. > If you are not the intended recipient of this message you are hereby notified > that any use, dissemination, distribution or reproduction of this message is > prohibited. > If you have received this message in error please notify AMCOR Rentsch > immediately. > Any views expressed in this message are those of the individual sender and > may not necessarily reflect the views of AMCOR Rentsch. > ----------------------------------------------------------------------------- > > _______________________________________________ > OTRS mailing list: otrs - Webpage: http://otrs.org/ > Archive: http://lists.otrs.org/pipermail/otrs > To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs > Support or consulting for your OTRS system? > =http://www.otrs.com/ > Hello Manuel, Did you say you upgraded from 1.3 to 2.2? If am not mistaken, you must do each and every upgrade script for the full versions between 1.3 and 2.2. Just the last one (I think) will not do. --Shawn _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support or consulting for your OTRS system? => http://www.otrs.com/ _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support or consulting for your OTRS system? => http://www.otrs.com/
