Did you try uploading this file attached to this post:
https://vborg.vbsupport.ru/showpost....&postcount=194

I get this database eror when I install everything nowe
on vb.3.0.7
Database error in vBulletin 3.0.7:

Invalid SQL: SELECT ticketid, title, postusername, dateline, lastposter, lastupdate, department FROM ticket AS ticket JOIN ticketdepartment AS ticketdepartment ON (ticketdepartment.departmentid = ticket.departmentid) WHERE open = 1 AND postuserid = 1
mysql error: You have an error in your SQL syntax near 'ON (ticketdepartment.departmentid = ticket.departmentid) WHERE open = 1 AND post' at line 1

mysql error number: 1064

Date: Sunday 06th of March 2005 08:49:34 PM
Script: http://forum.tanakawebb.com/helpdesk.php
Referer: http://forum.tanakawebb.com/

and where shld I change this????
Add a department. (www.yoursite.com/helpdesk.php?do=departments)

Start reading the past posts. I'm trying to get someone that has this problem run the script I attached in one of the past posts. Then if it works I'll update the hack.

administrater in helpdesk? i guess they probably updated mysql caz i dont get n e error

I'm very afraid.
You're right, I didn't read your post with attachment.
I upload it and now it works fine.

A very great work, thanx, again! ;)

Ok so delete problem is fixed... Now let's see about this other select problem.

Thanks, do hope you can update when this issue is fix WhSox21. Appreciate your work ;)

I'm just waiting for someone to confirm if the file I attached earlier works or not?

I uploaded the new helpdesk.php file and all seems good now - I tried all the links and looks like everything is ok now. Great hack!

I uploaded the new helpdesk script you recently posted, I no longer get the database error.

Keep up the great work, your gonna nail this one, I have no doubt.

This script has been updated. If you recieve any database errors it is recommended that you upgrade. Upgrading is as easy as any other time all you have to do is over-write the helpdesk.php file.

Bug Fixes:
PM problem with the pop-up. It now does not automatically pop-up.
Database errors on delete.
Database errors for some people.

Hi,

Upgrade is running into a SQL Error :


After removing the creation of the Phrase manually in the Install File, i am getting further errors :


could you pls check, installation File ?


gr33tz

The bugs for tickets creator has been fixed. I just tried and my users can reply without any problem.

Dont know about other bugs though. Thanks WhSox21 ;)

There's nothing wrong with it. The upgrade process is only needed to upgrade from version 1.0.x to version 1.5.x. Your HelpDesk should be running fine still even if you just did that. Just don't try to run the install anymore and you should be fine. Like in my post before yours, it says just over-write the helpdesk.php file.

With this new version. Some of the links on the left do not appear to me. Also, when attempting to view "My Tickets" as Administrator, i get no permissions, same with "New Tickets" (this is based off of the menu addon)

Is this intentional?

Is there a way to clear out all the extra PM type stuff like color selection, font size and just go with a plain box. Im sure for a ticket system this probably isnt needed and for my site I would like to make it look different then a regular PM.

You need to give yourself access in the AdminCP to the Departments and Usergroup Settings. Then you need to change the usergroup settings and you should be all set.

Not sure what you mean. Are you saying you just want a textbox where they create the ticket?

Yes, I wouldnt need a smilies, or different colored fonts and what not. Just a simple text box would be great. This way it looks nothing like sending a PM.

This may only require a template edit. I'll see if it works and if it does I'll post the edit in the addons section and provide you with a link. It may be a little bit before I get to it... Long night ahead of me.

Actually keeping the Add A Link could be good. But all other stuff I would like to get rid of.

Got It. Can I recommend that you add somewhere that "Usergroups" in "Departments" are seperated by commas, and are for viewing that paticular department.

Yea, next version I'm going to make everything a little bit easier to manage. I understand it's rather difficult to understand everything right now.

I understand the development process involved. Just make sure it stays free for us poor people. This is going to be a kickass addition, and the vB devs would be insane NOT to include this with an offical release further down the line.

I understand the free addition of this and to be honest I thought about moving it to a paid hack but decided against that for multiple reasons which I won't waste time listing. To be honest, this would be a great addition to vbulletin. For the developers it would be very easy to add. Everything I've done they could change to easily implement into vbulletin. With that said, you could use this rather than the email system and it would work way better. Reporting posts (which is also planned soon) would make life so much easier. With all that said, it would most likely increase sales from people such as hosting companies who could benefit from both a ticket system and a forum. I just think it would be a great addition to the software (maybe a little biased? :rolleyes: )! ;)

I have download this page nowe
https://vborg.vbsupport.ru/attachmen...chmentid=24527

and nowe its work very nice but howe can I se when ticket has wrigt?.
Can I setup pm or mail so they can se when some one has response for the ticket ??

No, not yet. This is planned for the next release, but I can't give a guarentee when that release will be out as I have a busy week ahead of me. The hack has been updated to version 1.53 which fixes a few bugs. If I were you I would click the install button https://vborg.vbsupport.ru/ so you get the updates when they are sent out. This will help you with a few of your problems.

Thanks for that but howe can I do so unregistered user can send ticket ??

You can't yet. Again as stated in previous posts it will be in a future release. That is why you can't change the Unregistered usergroup and it's missing. :lick:

The upgrade script doesn't like upgrading at all. It's telling me that I have a duplicate entry... As below:

Ah thankyou. I really should have read that before jumping the gun in posting. Very good addition, thanks a lot.

No problem. I really need to make an FAQ section in my initial release post to answer questions like that. :o

Just throw it in the Install readme, or you could create an individual Upgrade Readme with it in. Afterall, that's where people tend to look first (or at least where they should look!), or where they look when they occur problems.

Works fine now .. thanks! .. :)

Just upgraded. Went well, no issues.
One question though. When adding departments, the usergroup setting. . .
I guess that is for assigning departments to a specific usergroup?
For now I have set them to group 2, for registered members.

Does this sound right?

Also, a couple wishes.

1) When first submitting a ticket, and it appears in the list. The link beside the ticket says (Edit Reply) shouldn't it say "Edit Ticket" and then for replys it would say "Edit Reply".
2) Would be nice in the ticket list if bbcode, and html settings for users names were displayed. :)

no usergriups in departments is whom you want ot have access to see the help ticets that your members have posted.

Upload helpdesk.php to the forum root.

Upload admincp/helpdesk_install.php to the admin control panel directory.

Run the helpdesk_install.php file in the admin control panel directory.

If you've had this helpdesk installed before choose upgrade, otherwise choose install.

Make sure you edit the settings here:
AdminCP -> vBulletin Options -> Help Desk

Then make sure you create a department here:
helpdesk.php?do=departments

1. I uploaded the helpdesk.php to my forum root.
2. I upload admincp/helpdesk_install.php to the admin control panel directory.
-> /public_html/forums/admincp/helpdesk_install.php/
3. I ran the helpdesk_install.php file in the admin control panel directory.
4. click enter on each step
5. deleted helpdesk.php from file manager
6. ?? Then make sure you create a department here:
helpdesk.php?do=departments what or how I do this cause I do not see the button for file manager. :disappointed:

when you go to your board lok after helpdesk text puch that buttom
then lock to your left said under help desk alternativ that you can se
departments and user group setings puch departments and their you can tapy in that.

Hopefully you really deleted install_helpdesk.php and not helpdesk.php. In my next post I'll explain how to give usergroups access to the department settings. Thanks for the help trying to help other people guys! ;)