+ Post New Thread
Page 2 of 83 FirstFirst 1234561252 ... LastLast
Results 16 to 30 of 1237
Scripts Thread, FITS Compliant Web Based Helpdesk - ** RELEASED ** in Coding and Web Development; Small bug - the Mysql file has the 4 'INSERT INTO `tblstaff`' lines - but they don't run due to ...
  1. #16

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,941
    Thank Post
    519
    Thanked 2,499 Times in 1,940 Posts
    Blog Entries
    24
    Rep Power
    840

    Re: FITS Compliant Web Based Helpdesk - ** RELEASED **

    Small bug - the Mysql file has the 4 'INSERT INTO `tblstaff`' lines - but they don't run due to the list of fieldnames being short by one. Adding ',`createdDate`' after accountKey fixes it.

  2. #17
    ICTNUT's Avatar
    Join Date
    Jul 2005
    Location
    Hereford
    Posts
    1,419
    Thank Post
    196
    Thanked 249 Times in 122 Posts
    Rep Power
    62

    Re: FITS Compliant Web Based Helpdesk - ** RELEASED **

    @localzuk: Thanks for this, I will update the script and post an update shortly.

  3. #18

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,941
    Thank Post
    519
    Thanked 2,499 Times in 1,940 Posts
    Blog Entries
    24
    Rep Power
    840

    Re: FITS Compliant Web Based Helpdesk - ** RELEASED **

    Also, there doesn't seem to be any mention of what the default admin/tech/user password actually is...

  4. #19
    ICTNUT's Avatar
    Join Date
    Jul 2005
    Location
    Hereford
    Posts
    1,419
    Thank Post
    196
    Thanked 249 Times in 122 Posts
    Rep Power
    62

    Re: FITS Compliant Web Based Helpdesk - ** RELEASED **

    ooohhhhhhh, I forgot that bit ;-)

    The default admin details are as follows:

    Username: admin
    Password: password

    I'll update the install docs now with that, cheers mate

  5. #20

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,941
    Thank Post
    519
    Thanked 2,499 Times in 1,940 Posts
    Blog Entries
    24
    Rep Power
    840

    Re: FITS Compliant Web Based Helpdesk - ** RELEASED **

    Another one, you have to have the ODBC/Mysql connector from http://dev.mysql.com/downloads/connector/odbc/3.51.html installed as a requirement if you are using Mysql.

    And now I've hit a wall. When logging in it is giving me the message

    Code:
    Microsoft OLE DB Provider for ODBC Drivers error '80040e21'
    
    ODBC driver does not support the requested properties.
    
    /helpdesk/support_summary.asp, line 68

  6. #21
    ICTNUT's Avatar
    Join Date
    Jul 2005
    Location
    Hereford
    Posts
    1,419
    Thank Post
    196
    Thanked 249 Times in 122 Posts
    Rep Power
    62

    Re: FITS Compliant Web Based Helpdesk - ** RELEASED **

    @Localzuk: Found the problem, it is MySQL specific, sorting it now and will post an update in about 10 mins.

  7. #22

    webman's Avatar
    Join Date
    Nov 2005
    Location
    North East England
    Posts
    8,412
    Thank Post
    642
    Thanked 963 Times in 663 Posts
    Blog Entries
    2
    Rep Power
    326

    Re: FITS Compliant Web Based Helpdesk - ** RELEASED **

    I think this is to do with the case of the table names is it?

  8. #23
    ICTNUT's Avatar
    Join Date
    Jul 2005
    Location
    Hereford
    Posts
    1,419
    Thank Post
    196
    Thanked 249 Times in 122 Posts
    Rep Power
    62

    Re: FITS Compliant Web Based Helpdesk - ** RELEASED **

    @webman: It is just that MySQL has a slightly different syntax when it comes to CASE statements.

    @localzuk: If I PM you the updated file can you try it out for me as I am not anywhere near a MySQL database at the moment (I use MSSQL)

  9. #24

    localzuk's Avatar
    Join Date
    Dec 2006
    Location
    Minehead
    Posts
    17,941
    Thank Post
    519
    Thanked 2,499 Times in 1,940 Posts
    Blog Entries
    24
    Rep Power
    840

    Re: FITS Compliant Web Based Helpdesk - ** RELEASED **

    @ICTNUT - sure.

  10. #25
    ICTNUT's Avatar
    Join Date
    Jul 2005
    Location
    Hereford
    Posts
    1,419
    Thank Post
    196
    Thanked 249 Times in 122 Posts
    Rep Power
    62

    Re: FITS Compliant Web Based Helpdesk - ** RELEASED **

    @localzuk: can you PMme your email address as I can not attach any files to a PM.

  11. #26
    ICTNUT's Avatar
    Join Date
    Jul 2005
    Location
    Hereford
    Posts
    1,419
    Thank Post
    196
    Thanked 249 Times in 122 Posts
    Rep Power
    62

    Re: FITS Compliant Web Based Helpdesk - ** RELEASED **

    OK have worked out the MySQL problem and sorted it, seems like the Migration tool MySQL supplies did not migrate everything across.

    Have posted up a new update v0.9.1b, so anyone who has downloaded the previous version please update.

    See this post for full list of changes --> http://www.opsoftware.co.uk/forum/in...opic,24.0.html

  12. #27
    ICTNUT's Avatar
    Join Date
    Jul 2005
    Location
    Hereford
    Posts
    1,419
    Thank Post
    196
    Thanked 249 Times in 122 Posts
    Rep Power
    62

    Re: FITS Compliant Web Based Helpdesk - ** RELEASED **

    New release is out v0.9.2b.

    This has a number of fixes in it mainly to do with the helpdesk logic and cosmetic looks over IE and Firefox.

    A full changelog can be found here --> http://www.opsoftware.co.uk/forum/in...g40.html#msg40

    You can download the helpdesk from here --> http://www.opsoftware.co.uk/pages/download.php

    If you are using the helpdesk it is well worth sigining up to the forum and provide some feedback, without this I don't have any idea if to carry one with development or not, let me know what you think and if ther is anything you want included.

  13. #28

    plexer's Avatar
    Join Date
    Dec 2005
    Location
    Norfolk
    Posts
    13,317
    Thank Post
    681
    Thanked 1,650 Times in 1,471 Posts
    Rep Power
    425

    Re: FITS Compliant Web Based Helpdesk - ** RELEASED **

    Will be trying it out later.

    Ben

  14. #29
    Jake's Avatar
    Join Date
    Jan 2006
    Location
    Sunny South Coast
    Posts
    954
    Thank Post
    11
    Thanked 12 Times in 10 Posts
    Rep Power
    21

    Re: FITS Compliant Web Based Helpdesk - ** RELEASED **

    Loving it, got it all installed. It whined abit about the connector not working in 64bit windows, but got round that. I seem to have some gifs missing (small_tick and calendar), and the blue footer bar on some pages seems to move from the bottom to half way up, but all easily corrected.

    Will definately be replacing our existing Liberum setup with this one.

  15. #30
    ICTNUT's Avatar
    Join Date
    Jul 2005
    Location
    Hereford
    Posts
    1,419
    Thank Post
    196
    Thanked 249 Times in 122 Posts
    Rep Power
    62

    Re: FITS Compliant Web Based Helpdesk - ** RELEASED **

    @Jake: if you could provide me with some screen shots for the missing images and the footer problem I can make sure it gets fixed in the next release.

    I have yet to test this on 64Bit windows of any type as I do not have access to it but if you could let me know what you did to correct the problem you had I will post the solution on my forum so others can benefit from it also.

SHARE:
+ Post New Thread
Page 2 of 83 FirstFirst 1234561252 ... LastLast

Similar Threads

  1. Framework for ICT Technical Support (FITS)
    By FITS in forum School ICT Policies
    Replies: 32
    Last Post: 3rd March 2009, 09:38 AM
  2. very very urgent: FITS Your Experiences
    By russdev in forum General EduGeek News/Announcements
    Replies: 16
    Last Post: 23rd October 2007, 11:21 PM
  3. Is your school website DDA compliant?
    By bishopsgarthstockton in forum Web Development
    Replies: 5
    Last Post: 10th July 2007, 03:34 PM
  4. dda compliant website
    By Uraken in forum Web Development
    Replies: 5
    Last Post: 8th June 2007, 09:23 AM
  5. PHP based Helpdesk with IMAP or POP3 authentication?
    By wesleyw in forum How do you do....it?
    Replies: 5
    Last Post: 18th October 2006, 01:08 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •