I am having difficulty with this mod. I use cpanel on my website with myphpadmin and i cannot get the new reports table in the ost_ticket database. I am new to this and would appreciate any help on adding this through myphpadmin. step by step for newbie please:) and thank you
1. open PHP My admin
2. click on the osticket DB on the left
3. click the SQL button
4. copy the following and paste it into the REALLY BIG text box:
CREATE TABLE `ost_reports` (
`3d` TINYINT NOT NULL ,
`graphWidth` INT NOT NULL ,
`graphHeight` INT NOT NULL ,
`resolution` VARCHAR( 255 ) NOT NULL ,
`viewable` VARCHAR( 255 ) NOT NULL
) ENGINE = MYISAM ;
5. at the very bottom of the window there should be a 'go' button click it.
I usually just re-click the SQL button because I only like adding one thing at a time.
Copy the code below: (again paste it into the REALLY BIG text box)
INSERT INTO `ost_reports` (`3d`, `graphWidth`, `graphHeight`, `resolution`, `viewable`) VALUES ('1', '400', '240', 'hours', 'admins');
And click go.
I am assuming the MOD you were having troubles with was Reports 5.0. The code above was lifted from the documentation for 5.0.