G
Grodan

  • Feb 12, 2015
  • Joined Jul 21, 2014
  • 0 best answers
  • Second question.Why does tickets.php?status=closed Work and tickets.php?status=CUSTOMSTATUS dont work ?Its would be great if you could just add links in the menus to tickets.php?status=CUSTOMSTATUS and automatic only show the wanted status?

  • Hello,I created 2 new statues  Lack and Extern.I would like to add them in the meny next to Open Closed new ticket etc etc so when you click on them you get all tickets with that status.in spc/ticket.phpi created thisif ($stats) {        $nav->addSubMenu(array('desc'=>$lack_name.' ('.number_format($stats).')',                               'title'=>__('Lacken'),                               'href'=>'tickets.php?advsid=67a2c1417ff87ce373ebea54adb1e2bf',                               'iconclass'=>'Ticket'),                            (!$_REQUEST || $_REQUEST=='Lack'));    }Could someone please tell me where i define $lack_name. since i dont get a meny name at all So what files do a need to edit ?cheers

  • In Git?

    nah i just wanna play around with it figured the more o test the beta the more ill learn and since i use osticket for something complete diffrent then a ticket system and mine is heavly modified to fit my needs i need to hack the code myself to get more "ticket status" option when its done.Have i understood right that the new "ticket status" will be that you can add how many ticket statuses you need by yourselfs ?

  • In Git?

    the latest beta RC is Peters last addition with more ticket statusincluded in this ? git clone https://github.com/osTicket/osTicket-1.8 . ?

  • Ok i would gladly betatest it but not sure how i sign up for getting beta or where to download betacheers

  • Clubbu did you get this to work in 1.9 ?

  • ticket.inc.php was the fileand it workedthanks Peter :)

  • Do you mean scp/ticket.php ?Couse i have no ticket.php in include/staff/?

  • Like this 112131415161718192021222324259876When i sort them why are they not beeing sorted in the correct number order 1234567etc?can it be fixed (yes i have googled and searched here but either i have no clue of what to use for search words or there is no answer yet)

  • admin -> manage - formsadmin -> manage -> listmake the list first then add it in forms

  • Vlad care to share the code you altered?

  • Someone have the code or info on making Assiged To choice required?

  • acually yes and nothe correct way was mysql> select "DATABASE-NAME";mysql> ALTER TABLE ost_ticket AUTO_INCREMENT = 0 ;Query OK, 0 rows affected (0.18 sec)Records: 0  Duplicates: 0  Warnings: 0Problem solved thanks 

  • All tickets and all info to those tickets has been deleted in the DB its just how i start over from 1 again Tested with " " and ' '  same error :/the prefix is ost_ yes 

  • root@order:~# mysql -u root -pEnter password:Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 1763Server version: 5.5.38-0ubuntu0.14.04.1 (Ubuntu)Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> select osten    -> ALTER TABLE ost_ticket AUTO_INCREMENT = '0';ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALTER TABLE ost_ticket AUTO_INCREMENT = '0'' at line 2mysql>

  • uhu.... i copy pasted what you wrote yourself in the first link you provided CommentsQuotentozier April 2013 Flag1. Are you going to or have you deleted all the tickets in your database? If you have already emptied the tickets then you could use the following MySQL statement to reset the ticket id to 0.ALTER TABLE ost_ticket AUTO_INCREMENT = '0';

  • Yea i searched...but that line gives this error 1064 - You have an error in your SQL syntax; check the manual that

    corresponds to your MySQL server version for the right syntax to use

    near 'ALTER TABLE ost_ticket AUTO_INCREMENT = '0'

    LIMIT 0, 30' at line 2

  • So i beta tested osticket and created a like 50 tickets just to test on diffrent teams groups etc etcand now i would like to put it "online"  i deleted all tickets from ost_ticket in phpmyadmin, but it continues to add from ticket 50 so when i create a new ticket it gets ticket 51.. instead of 1what table controls the ticket ID so i can start over ?I already added all staff groups etc and i dont wanna do it all over again :)Version the latest osticket.

  • Yes if i had the knowhow i would write one however i do not have that knowhow sorry.