Hi All , Ok so we decided to build a secondary OTRS system , sort of as a reference archive to our production system. I basically did a clean install of 2.1.6 on FC5 , copied over the 2.0.4 database and article data , followed the instructions of the UPGRADE.txt document to upgrade the database. All went fine , could log in but as soon as I click on a queue to view the tickets I get an error message : Can't use an undefined value as a HASH reference at /opt/otrs//Kernel/System/Ticket/Article.pm line 1363. I searched the otrs archives but to no avail , I think the ticket data in the database can't find the actual article reference? Also I did run the Setpermissions.sh script as well.. Any help will be appreciated. Daniel
Hi All , Anyone have ANY ideas ? I am at my wits end... Danie wrote:
Hi All ,
Ok so we decided to build a secondary OTRS system , sort of as a reference archive to our production system. I basically did a clean install of 2.1.6 on FC5 , copied over the 2.0.4 database and article data , followed the instructions of the UPGRADE.txt document to upgrade the database. All went fine , could log in but as soon as I click on a queue to view the tickets I get an error message :
Can't use an undefined value as a HASH reference at /opt/otrs//Kernel/System/Ticket/Article.pm line 1363.
I searched the otrs archives but to no avail , I think the ticket data in the database can't find the actual article reference? Also I did run the Setpermissions.sh script as well..
Any help will be appreciated.
Daniel
_______________________________________________ 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 orr consulting for your OTRS system? => http://www.otrs.com/
Hi Danie, Danie schrieb:
Hi All ,
Anyone have ANY ideas ? I am at my wits end...
Danie wrote:
Hi All ,
Ok so we decided to build a secondary OTRS system , sort of as a reference archive to our production system. I basically did a clean install of 2.1.6 on FC5 , copied over the 2.0.4 database and article data , followed the instructions of the UPGRADE.txt document to upgrade the database. All went fine , could log in but as soon as I click on a queue to view the tickets I get an error message :
Can't use an undefined value as a HASH reference at /opt/otrs//Kernel/System/Ticket/Article.pm line 1363.
I searched the otrs archives but to no avail , I think the ticket data in the database can't find the actual article reference? Also I did run the Setpermissions.sh script as well..
Any help will be appreciated.
I'm not known with your case, I think something went wrong or was missed during update. Perhaps bin/UnitTest.pl coudl help you. The "Names" for the necessary option "-n" can be found in scripts/test
Daniel
Bye, Alex
On Thu, Mar 29, 2007 at 10:36:12AM +0200, Danie wrote:
Ok so we decided to build a secondary OTRS system , sort of as a reference archive to our production system. I basically did a clean install of 2.1.6 on FC5 , copied over the 2.0.4 database and article data , followed the instructions of the UPGRADE.txt document to upgrade the database. All went fine , could log in but as soon as I click on a queue to view the tickets I get an error message :
Can't use an undefined value as a HASH reference at /opt/otrs//Kernel/System/Ticket/Article.pm line 1363.
I searched the otrs archives but to no avail , I think the ticket data in the database can't find the actual article reference? Also I did run the Setpermissions.sh script as well..
Please check the permissions of the articles stored in your file system. You can find them in /opt/otrs/var/article and its subdirs.
Daniel
-- Christian ((otrs)) :: OTRS GmbH :: Norsk-Data-Strasse 1 :: 61352 Bad Homburg Fon: +49 (0) 9421 56818 0 :: Fax: +49 (0) 9421 56818 18 http://www.otrs.com/ :: Communication with success! Geschäftsführer: André Mindermann, Martin Edenhofer Handelsregister: HRB 9452 Bad Homburg Steuernummer: 003/240/97521
Hi Christian , Ran the DBUpdate script , as well as the SetPermissons script , is as follows: Setting file permissions... chown -R apache:nogroup /opt/otrs/ chown: `apache:nogroup': invalid group chown: `apache:nogroup': invalid group chmod -R og+rw /opt/otrs/ chown otrs:nogroup /opt/otrs/ chown: `otrs:nogroup': invalid group chown otrs:nogroup /opt/otrs//.fetchmailrc chown: `otrs:nogroup': invalid group chmod 0710 /opt/otrs//.fetchmailrc chown otrs:nogroup /opt/otrs//.procmailrc chown: `otrs:nogroup': invalid group chmod 0644 /opt/otrs//.procmailrc chown otrs:nogroup /opt/otrs//.mailfilter chown: `otrs:nogroup': invalid group chmod 0600 /opt/otrs//.mailfilter chown -R otrs:nogroup /opt/otrs//var/ chown: `otrs:nogroup': invalid group chown -R apache:nogroup /opt/otrs//var/sessions/ chown: `apache:nogroup': invalid group touch && chown otrs:nogroup /opt/otrs//var/log/TicketCounter.log chown: `otrs:nogroup': invalid group chmod -R 775 /opt/otrs//bin/ (chown && chmod 700) otrs:0 /opt/otrs//bin/DeleteSessionIDs.pl (chown && chmod 700) otrs:0 /opt/otrs//bin/UnlockTickets.pl (chown && chmod 700) otrs:0 /opt/otrs//bin/otrs.getConfig You have new mail in /var/spool/mail/root Not sure what the "nogroup" should be... I get a few of these errors when running the DBupdate script... can this maybe have an effect ERROR 1194 (HY000) at line 27: Table 'ticket' is marked as crashed and should be repaired ERROR 1194 (HY000) at line 28: Table 'ticket' is marked as crashed and should be repaired ERROR 1194 (HY000) at line 29: Table 'ticket' is marked as crashed and should be repaired ERROR 1194 (HY000) at line 30: Table 'ticket' is marked as crashed and should be repaired ERROR 1194 (HY000) at line 31: Table 'ticket' is marked as crashed and should be repaired Also when i do a ls i get : [root@otrs1 ~]# ls -lht /opt/otrs/var/article/2007/ total 48K drwxrwsr-x 33 apache apache 4.0K Mar 23 17:01 03 drwxrwsr-x 33 apache apache 4.0K Dec 1 10:41 01 drwxrwsr-x 33 apache apache 4.0K Dec 1 10:41 02 drwxrwsr-x 33 apache apache 4.0K Dec 1 10:41 04 drwxrwsr-x 33 apache apache 4.0K Dec 1 10:41 05 drwxrwsr-x 33 apache apache 4.0K Dec 1 10:41 06 drwxrwsr-x 33 apache apache 4.0K Dec 1 10:41 07 drwxrwsr-x 33 apache apache 4.0K Dec 1 10:40 08 drwxrwsr-x 33 apache apache 4.0K Dec 1 10:40 09 drwxrwsr-x 33 apache apache 4.0K Dec 1 10:40 10 drwxrwsr-x 33 apache apache 4.0K Dec 1 10:40 11 drwxrwsr-x 33 apache apache 4.0K Dec 1 10:40 12 I actually edited the Article.pm script to see what is on line 1363 and it seems it has something to do with the ArticleID and "Content" variables... which leads me to believe the reference in the MySQL DB does not correspond to the article directory? This might be a shot in the dark , but I'm really baffled by this. Christian Schoepplein wrote:
On Thu, Mar 29, 2007 at 10:36:12AM +0200, Danie wrote:
Ok so we decided to build a secondary OTRS system , sort of as a reference archive to our production system. I basically did a clean install of 2.1.6 on FC5 , copied over the 2.0.4 database and article data , followed the instructions of the UPGRADE.txt document to upgrade the database. All went fine , could log in but as soon as I click on a queue to view the tickets I get an error message :
Can't use an undefined value as a HASH reference at /opt/otrs//Kernel/System/Ticket/Article.pm line 1363.
I searched the otrs archives but to no avail , I think the ticket data in the database can't find the actual article reference? Also I did run the Setpermissions.sh script as well..
Please check the permissions of the articles stored in your file system. You can find them in
/opt/otrs/var/article
and its subdirs.
Daniel
-- Christian
((otrs)) :: OTRS GmbH :: Norsk-Data-Strasse 1 :: 61352 Bad Homburg Fon: +49 (0) 9421 56818 0 :: Fax: +49 (0) 9421 56818 18 http://www.otrs.com/ :: Communication with success!
Geschäftsführer: André Mindermann, Martin Edenhofer Handelsregister: HRB 9452 Bad Homburg Steuernummer: 003/240/97521
------------------------------------------------------------------------
_______________________________________________ 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 orr consulting for your OTRS system? => http://www.otrs.com/
Danie wrote:
Ran the DBUpdate script , as well as the SetPermissons script , is as follows:
<snip>
Not sure what the "nogroup" should be...
Depends on your OS. What OS are you running?
I get a few of these errors when running the DBupdate script... can this maybe have an effect
ERROR 1194 (HY000) at line 27: Table 'ticket' is marked as crashed and should be repaired ERROR 1194 (HY000) at line 28: Table 'ticket' is marked as crashed and should be repaired ERROR 1194 (HY000) at line 29: Table 'ticket' is marked as crashed and should be repaired ERROR 1194 (HY000) at line 30: Table 'ticket' is marked as crashed and should be repaired ERROR 1194 (HY000) at line 31: Table 'ticket' is marked as crashed and should be repaired
Have you tried repairing the ticket table? Nils Breunese.
Hi Nils , I am running Fedora 5 , so i would assume the nogroup would refer to the "nobody" group user? Will run a repair on the DB and let you know Nils Breunese (Lemonbit) wrote:
Danie wrote:
Ran the DBUpdate script , as well as the SetPermissons script , is as follows:
<snip>
Not sure what the "nogroup" should be...
Depends on your OS. What OS are you running?
I get a few of these errors when running the DBupdate script... can this maybe have an effect
ERROR 1194 (HY000) at line 27: Table 'ticket' is marked as crashed and should be repaired ERROR 1194 (HY000) at line 28: Table 'ticket' is marked as crashed and should be repaired ERROR 1194 (HY000) at line 29: Table 'ticket' is marked as crashed and should be repaired ERROR 1194 (HY000) at line 30: Table 'ticket' is marked as crashed and should be repaired ERROR 1194 (HY000) at line 31: Table 'ticket' is marked as crashed and should be repaired
Have you tried repairing the ticket table?
Nils Breunese.
------------------------------------------------------------------------
_______________________________________________ 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 orr consulting for your OTRS system? => http://www.otrs.com/
Okay so I screwed up and put the wrong ticket number in to merge a ticket, how do I undo that? Thank you for your time. David.
Hi David, On Wed, Apr 11, 2007 at 07:56:58AM -0600, David Benjamin wrote:
Okay so I screwed up and put the wrong ticket number in to merge a ticket, how do I undo that?
That is not possible at present :(. It only can be done directly by changing the database :(. -- Christian ((otrs)) :: OTRS GmbH :: Norsk-Data-Strasse 1 :: 61352 Bad Homburg Fon: +49 (0) 9421 56818 0 :: Fax: +49 (0) 9421 56818 18 http://www.otrs.com/ :: Communication with success! Geschäftsführer: André Mindermann, Martin Edenhofer Handelsregister: HRB 9452 Bad Homburg Steuernummer: 003/240/97521
participants (5)
-
Alexander Scholler -
Christian Schoepplein -
Danie -
David Benjamin -
Nils Breunese (Lemonbit)