PDA

View Full Version : Add-On Releases - PS - HelpCenter


Pages : [1] 2 3 4

PaulSonny
16 Apr 2008, 22:34
HelpCenter is the ultimate ticket support system for your vBulletin!

Click Here for vBulletin 3.6 Version (http://www.vbulletin.org/forum/showthread.php?t=176968)

HelpCenter is a support ticket system made for vBulletin. It allows you to manage your members questions much easier, saving you the hassle of going through emails and private messages.

Visit PaulSonny for news, demos, screenshots, and more!

Demo: PaulSonny HelpCenter (http://www.paulsonny.com/forum/helpcenter.php)

Features

If you have any feature requests please make them known at PaulSonny.

* Automatic Template Edits
* Turn HelpCenter ON/OFF and display a custom message.
* Disallow New Tickets to be created and display a custom message.
* Give your Ticket ID's a Prefix.
* Auto Open closed tickets when a new reply is made. (Now an Admin Option)
* Add, Edit and Delete departments via AdminCP, view Tickets within a Department.
* Open/Closed ticket AdminCP Management.
* Make tickets public/private.
* Ticket Priorities. (Low/Medium/High)
* WOL: HelpCenter.
* View Statistics about HelpCenter in the AdminCP.

Installation Instructions

[] Upload all the files from the Upload folder.
[] Import product-helpcenter.xml via the AdminCP.
[] Set Permissions for each usergroup via the AdminCP for HelpCenter.
[] Set Departments up via the AdminCP for HelpCenter.

Footnotes

Please report all bugs, feature requests and comments here (http://www.paulsonny.com/forum/project.php?projectid=1).

Version History:

Version 1.00 Beta 1:

Initial version for vBulletin 3.7.

Version 1.00 Beta 2:

Bug Fixes.

Version 1.00 Beta 3:

Database Errors Fixed.
Added Extra Usergroup Permissions.
Ticket Priority Added.
Ticket Number Prefix Added.
Plus Much More...

Version 1.00 Beta 4:

Added Some extra Admin Features.
Fixed some bugs.
Other small features added.

Version 1.00 Beta 4 Security Fix

Cross Site Request Forgery (CSRF) Fixed.

Version 1.00 Beta 5:

Further Enchanged Some Admin Functions.
Enhanced My Tickets Interface.
Paginated Results.
Fixed More bugs, such as Guest Tickets Problem. (Temporary Measure!)
Other small features added.

Version 1.00 Beta 6:

Make tickets public/private.
Tidied up Admin Interface.
Fixed Phrases.
Tidied Up the Code.
It now parses smilies in your tickets. so you get :)!
Other small features added.

Version 1.00 Release Candidate 1:

Fixed SQL Vunerabilities
Fixed Phrases.
Tidied Up the Code.
Implemented Delete Confirmation Screens.
Improved CSRF Security.

Version 1.00:

Can View HelpCenter Permission Added.
Updated Delete Confirmations.
Fixed No Title Error.
Tidied Up the Code.

Version 1.01:

Minor Template Change for Version.
Standard Editor Error Fixed.
Improved Code Structure for Editors.

Please remember to click Mark As Installed (http://www.vbulletin.org/forum/vborg_miscactions.php?do=installhack&threadid=176367) if you use this modification.
If you use this plug-in, and find it useful, please support us by nominating us for Mod Of The Month (MOTM) in the top right corner of this thread, or feel free to donate.

You will get an email when a new version is released.

Thanks, PaulSonny & The Development Team.

Lizard King
16 Apr 2008, 22:45
Your demo page requires registration.

John3971
16 Apr 2008, 22:55
I was the first one to download this at the forum :)

Its a great modification.

ChampTyler
16 Apr 2008, 23:01
Hey there,

I will be testing this on my forum now - Thanks for this!

Jase2
16 Apr 2008, 23:19
Already confirmed a few bugs. Were working for an updated release. Please continue to report all bugs. :)

auctionguy
16 Apr 2008, 23:34
This is badly needed I think! I am going to wait until it is tested a bit because I am running 3.7 RC3 on a live board as it is but I can't wait to use this mod!

Excellent!

TTG
17 Apr 2008, 01:19
Demo database error .. obviously needs a little work 'eh !?
Think I'll wait for a stable release :D

Jase2
17 Apr 2008, 01:28
I aren't getting a database error. However, a few bugs have been fixed and we could see 'beta' 2 pretty soon.

PaulSonny
17 Apr 2008, 02:48
Released Beta 2.

Loads of fixes done, many thanks to John9371.

Keep them coming, bug reports, feature request, comments?

Thanks, Paul.

PoetJA-1975
17 Apr 2008, 02:58
Um - the demo link is not working...
Do you have screenshots? ALSO - can work on vB 3.6.8 PL2?

Thanx,

Jacquii.

PaulSonny
17 Apr 2008, 03:03
Um - the demo link is not working...
Do you have screenshots? ALSO - can work on vB 3.6.8 PL2?

Thanx,

Jacquii.

Sorry about the demo link, i've just been editing a template. Anyway its working now.

I am just in the middle of taking screenshots.

With regards to vBulletin 3.6.8 PL2, I believe it should work, although I have not tested.

Thanks, Paul.

PaulSonny
17 Apr 2008, 03:10
Screenshots Added.

Thanks, Paul.

rob30UK
17 Apr 2008, 03:10
paul, please dont require people to register to see the demo.... either make the demo public or post up screenshots - either one will make for a much more received mod and more downloads.

rob30UK
17 Apr 2008, 03:11
lol,you just posted as i did. thanks for the screenshots

rob30UK
17 Apr 2008, 03:11
Actually... where are the screenshots?

PaulSonny
17 Apr 2008, 03:13
They should be in the original modification post rob.

Thanks, Paul.

rob30UK
17 Apr 2008, 03:14
got them, cheers

edit: nice mod.... looks useful ;)

DarkSorrowz
17 Apr 2008, 04:05
Parse error: syntax error, unexpected $end in /home/tibiabid/wareznova/helpcenter.php on line 358


Helpp!! I uploaded everything.

Stromba
17 Apr 2008, 06:34
Parse error: syntax error, unexpected $end in /home/fxxxxx/public_html/forum/helpcenter.php on line 358

Same error here run the latest version Vb

youradhere4222
17 Apr 2008, 06:54
Are you planning on removing the requirement to register to view the demo?

jerx
17 Apr 2008, 08:31
Very useful mod!

Do you have to register to submit a ticket? Is it possible to let guests submit tickets and requiring them to input capture and email address (twice, to avoid typos). Some people might have problems with registration, so allowing guests to submit tickets would be helpful.

Thank you!

PaulSonny
17 Apr 2008, 10:59
Are you planning on removing the requirement to register to view the demo?

Sorry about the requirement to register, I have removed it and it should be ok now.

Thanks, Paul.

Hornstar
17 Apr 2008, 11:02
There IS a bLANK Option....

as the description of this thread says:

THIS IS BETA SOFTWARE.
WE STRONGLY RECOMMEND YOU DON'T INSTALL THIS ON A LIVE BOARD.


I suggest you just wait until it goes more stable

PaulSonny
17 Apr 2008, 11:08
There IS a bLANK Option....

Have sorted this error, it was a typo error with regards to a phrase.

Thanks, Paul.

Subah
17 Apr 2008, 11:36
Cool i like it , Thanks :)

PaulSonny
17 Apr 2008, 12:18
Updated the Download to fix the Department Database error when creating more than one department.

Thanks, Paul.

PaulSonny
17 Apr 2008, 12:36
Now fixed Bosco, sorry about that I forgot to update the product file, can happen when someone is sending 10 messages on msn a second.

Thanks, Paul.

Paradigm
17 Apr 2008, 12:45
This is exactly what I have been looking for. I will be watching the development of this one VERY closely. Great job and good luck in exterminating the bugs.

PaulSonny
17 Apr 2008, 12:48
Right, Bosco Wong if you give me chance to sort things out instead of bombarding me with MSN Messages I might be able to get a working product rather than error after error.

I have once again, updated the download, so please download and re-install.

Thanks, Paul.

KURTZ
17 Apr 2008, 12:52
Paul just wondering is possible to redirect a ticket to a different user which isn't an Admin?

PaulSonny
17 Apr 2008, 12:56
I dont understand what you mean Kurtz, do you mean can other users reply to tickets rather just admin usergroup?

Under usergroup options you are able to define who can manage tickets, if allowed, any usergroup can manage tickets.

Thanks, Paul.

powerful_rogue
17 Apr 2008, 13:01
Hi,

Thank you for this mod! Its a lifesaver! Up until now ive been using a shabby 3rd party script.

One problem ive got is I cant see the text in the Navigation or Administration section. Ive attached a screenshot.

Which template will I need to edit to change this?

Many Thanks

PaulSonny
17 Apr 2008, 13:03
The template is HCENTER_SHELL, I believe it is something to do with the style you are using.

Might just be a case of changing the id field of the links.

Thanks, Paul.

powerful_rogue
17 Apr 2008, 13:08
Thanks for the quick reply.

Im looking in the template but a bit stuck! Which part of the template refers to the css of the text colour in the navigation/Admin section

Thanks

PaulSonny
17 Apr 2008, 13:13
I am just guessing here because I cant replicate the bug, but in the HCENTER_SHELL template find class="$navclass[mytickets]" and remove it and see if the link appears?

Only do it for one link and test it, then you can update the rest if it works.

Thanks, Paul.

powerful_rogue
17 Apr 2008, 13:22
I am just guessing here because I cant replicate the bug, but in the HCENTER_SHELL template find class="$navclass[mytickets]" and remove it and see if the link appears?

Only do it for one link and test it, then you can update the rest if it works.

Thanks, Paul.

Thank you :)

I gave that a try but it didnt work. I did however change $navclass[mytickets] to vbmenu_option and it now shows up a treat :)

PaulSonny
17 Apr 2008, 13:32
Ok thanks for the reply powerful_rogue. I will update the templates now to avoid any future issues with other installations.

Edit: Updated for Next Release.

Thanks, Paul.

KURTZ
17 Apr 2008, 13:59
I dont understand what you mean Kurtz, do you mean can other users reply to tickets rather just admin usergroup?

Under usergroup options you are able to define who can manage tickets, if allowed, any usergroup can manage tickets.

Thanks, Paul.

i mean exactly this :)

anyway Paul, is possible to improve this hack with the possibility to give at a specific user(s) which can manage the tickets?

PaulSonny
17 Apr 2008, 14:13
Bosco Wong, if you read announcements and notifications, not all features are working, such as notifications.

Kurtz, I will try and work on a solution.

Thanks, Paul.

KURTZ
17 Apr 2008, 14:15
thanks mate :)

mkinnov8
17 Apr 2008, 14:26
Paul...

Thank you so much :), this helps a lot.

Cheers

John3971
17 Apr 2008, 14:29
i wOULD lIKE tO Add feature Close Ticket Open Ticket

Ticket Numbers

Auto Pm About Your Ticket

Automatic Ticket On The Thread Forum

Close Ticket and Open Tickets is already implented. but the names are Resolved and Unresolved

PaulSonny
17 Apr 2008, 14:40
I have added Ticket Number to the 'My Tickets' page, available in the next release.

Thanks, Paul.

PaulSonny
17 Apr 2008, 15:11
I have sorted out the Automatic New Thread Upon New Ticket feature and will be available in the next release.

Thanks, Paul.

powerful_rogue
17 Apr 2008, 16:20
Hi Paul.

the new additions sound great. When do you reckon the next release will be?

Jase2
17 Apr 2008, 16:27
Hello powerful_rogue,

At this moment in time, we cannot predict when a new 'beta' will be released. It depends on how many bug reports we receive ect. So, if you have a test board, please test and report any bugs you may find at: www.paulsonny.com

fragumz.com
17 Apr 2008, 16:45
Hello powerful_rogue,

At this moment in time, we cannot predict when a new 'beta' will be released. It depends on how many bug reports we receive ect. So, if you have a test board, please test and report any bugs you may find at: www.paulsonny.com

Jesse, Im going to be helping you guys out with this easy project here. I just got my vB Board back and my hours at work worked out so I can continue creating mods, styles and shell out some vBSupport. Check my profile for the web link.

fragumz.com
17 Apr 2008, 16:45
Check out the latest release here and grabe the beta 2 version. http://www.paulsonny.com/forum/showthread.php?p=68#post68

Jase2
17 Apr 2008, 16:47
fragumz.com, who is that directed too? Me I presume?

Jase2
17 Apr 2008, 16:55
I am aware that the notification option isn't working. As I said, it will be fixed for next release. In the meantime, hold tight why we fix current bugs, and report any new bugs if found. :)

thunder_sti
17 Apr 2008, 16:59
Does it work for: vb3.6.x ?

Jase2
17 Apr 2008, 17:01
It's made for 3.7, however it may work with 3.6 -- not counting on it. The best thing you can do, is try it on a test board running 3.6 and report back and let us know the outcome. :)

PaulSonny
17 Apr 2008, 18:11
Hi Paul.

the new additions sound great. When do you reckon the next release will be?

I have just updated the download to include these new features, feel free to test them out.

What the Update For This Now????

Ticket number Or Sort Thread???

Why Is There One HelpCenter Rar In The Folder Of uplaod What IS tHAT??? fOR

I really wish you would be patient, and as Jason said, stop posting post after post about the same thing. To avoid confusion, I have removed the secondary helpcenter file for you.

Does it work for: vb3.6.x ?

There is no real reason why this modification should not work with 3.6, although it has not been tested. Feel free to test and report back.

Thanks, Paul.

DDolphins
17 Apr 2008, 18:24
Really nice addon, my only request is if there's a way to do it, can you add an attachment area so people can attach a file or something to go along with their ticket?

Jase2
17 Apr 2008, 18:30
Really nice addon, my only request is if there's a way to do it, can you add an attachment area so people can attach a file or something to go along with their ticket?

I like that idea. Me and Paul will look into it.

EDIT: Although this will probably be in the 'paid' version, and not the 'lite' (free) version. :)

RC Attacker
17 Apr 2008, 20:06
I haven't had a chance to find any bugs yet but this is definitely one of my favorite hacks of all time.

John3971
17 Apr 2008, 20:12
Yea this is a great mod even if its a beta i nominated it for the mod of the month :)

SuperDave71
17 Apr 2008, 20:14
Is there a way to edit the Title of the ticket to be empty instead of "Social Groups"?

Every time I create a new ticket, the title automatically defaults to Social Groups.


Excellent Mod!



-Dave

PaulSonny
17 Apr 2008, 20:57
I haven't had a chance to find any bugs yet but this is definitely one of my favorite hacks of all time.

Thanks RC Attacker, further developments are already being made. For example we have updated it to use the vBulletin editor. (WYSIWYG).

Yea this is a great mod even if its a beta i nominated it for the mod of the month :)

Thanks John, very much appreciated.

Is there a way to edit the Title of the ticket to be empty instead of "Social Groups"?

Every time I create a new ticket, the title automatically defaults to Social Groups.

Excellent Mod!

-Dave

I cant replicate this error/bug. What actually happens, can you product a screenshot?

Thanks, Paul.

fragumz.com
17 Apr 2008, 22:21
fragumz.com, who is that directed too? Me I presume?
Yea sorry I spelled your name wrong fro mthe previous thread. But it was for you yes. :):rolleyes:

SuperDave71
17 Apr 2008, 23:37
Here is my screen Shot.


All I did was add the plug-in and add the appropriate permissions. When I click the Add ticket button...I get the title "Social Group" in the title field by default.


I just deleted the install and reinstalled it and got the same thing.



Hope this helps.



-Dave

PaulSonny
18 Apr 2008, 01:10
Ok SuperDave,

I am releasing a 3rd beta tomorrow, which includes loads of updates and some major bug fixes.

Once I release the beta, if this problem still occurs, I will try my best to find it.

Thanks, Paul.

ZomgStuff
18 Apr 2008, 02:28
I ran into problems running into changing usergroup permissions.
It looks like your install code did not run properly as I had to create the proper tables/columns manually.
Database error in vBulletin 3.7.0 Release Candidate 3:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '<font color=\"#DF7E4E\">',
`closetag` = '</font>',
`passwordexpires` = '180',
`passwordhistory` = '360',
`ugphelpcenter` = '1983',
`forumpermissions` = '8380415',
`genericpermissions` = '2147483583',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '7',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions2` = '1',
`genericoptions` = '55',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '120',
`avatarmaxheight` = '120',
`avatarmaxsize` = '40000',
`signaturepermissions` = '237567',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '0',
`sigmaxchars` = '0',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '0',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '100000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '31',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '511',
`mgc_cb_evo_permissions` = '255',
`mgc_cb_evo_nbmsg_show` = '0',
`mgc_cb_evo_nbmsg_perday_show` = '0',
`mgc_cb_evo_default_color` = '000000'
WHERE usergroupid=6;

MySQL Error : Unknown column 'ugphelpcenter' in 'field list'
Error Number : 1054
Date : Thursday, April 17th 2008 @ 07:26:07 PM
Script : http://www.xxxxxx.net/forum/admincp/usergroup.php?do=update
Referrer : http://www.xxxxx.net/forum/admincp/usergroup.php?do=edit&usergroupid=6
IP Address : xxxxxx
Username : Hasselhoff
Classname : vB_Database
MySQL Version : 5.0.45-community-log

PoetJA-1975
18 Apr 2008, 02:34
You Did Not get WhAT I Mean What is the updated Folder What have paul Updated Is It Ticket Numbers Or New Automatic Thread And tHE Notificitaion System Not Working It Doesent Send Email Or Pm...

Oh GODDAMN! Please stop getting on everyone's LAST nerve = ERG!
ALSO - can you please stop the capitalization of each word in the sentence - This is so horridly annoying!

Jacquii.

SuperDave71
18 Apr 2008, 02:36
Thank you Paul....


I really appreciate it!



-Dave :)

ZomgStuff
18 Apr 2008, 02:44
Also the department display order does not work - it does not matter what you use, the system is still in alphabetical order.

ZomgStuff
18 Apr 2008, 02:45
Ticket number also isn't displaying in"my tickets" which is throwing off the entire row.

ZomgStuff
18 Apr 2008, 03:05
To fix the ticket display problem change your hcenter_ticket template to
<tr>
<td class="$bgcolor" align="center">$ticket[ticketid]</td>
<td class="$bgclass" align="left"><a href="helpcenter.php?$session[sessionurl]do=ticket&tid=$ticket[ticketid]">$ticket[title]</a></td>
<td class="$bgclass" align="center">$ticket[postusername]</td>
<td class="$bgclass" align="center">$ticket[dateline]</td>
<td class="$bgclass" align="center"><phrase 1="$ticket[lastupdate]" 2="$ticket[lastposter]">$vbphrase[last_update_by]</phrase></td>
</tr>

ZomgStuff
18 Apr 2008, 03:52
Users cannot see resolved tickets via "my tickets"

I get a SQL error when I try to delete a ticket and when i try to edit a ticket reply.

ZomgStuff
18 Apr 2008, 04:25
This is extremely buggy...


You need to force a title, because at this point you can create a ticket without one.
You should display what departtment a ticket is under "unresolved tickets"
Make unresolved tickets and resolved tickets viewable to the public so you don't have a bunch of duplicates.

jerx
18 Apr 2008, 08:24
Erm What the Feature Not Working And What the featured On this Updates Someone Tell Me Pls????

Hey, what' s wrong with you? Can' t you read? I know English is not your native tongue, but I am sure you have understood that everyone told you to stop spamming in this thread. It is freaking annoying. This is beta software and you should not use it on a live site. Therefore there is no need to rush things, especially not by posting every 3 minutes, private messaging other users and even contacting the developer on msn! This is just rude of you.

I have never ever ignored any user on any site till now, but I am about to use it to stop seeing your annoying posts.

You can see the latest version of this mod here:
http://www.paulsonny.com/forum/helpcenter.php

There you can test drive the mod and see what features the mod has. If you find any bugs on the development demo, you can post them in this thread, so that they can be fixed.

I advise you not to install this mod on your site yet. There seem to be too many bugs and you make the impression of being too inexperienced to handle it. Let more experienced users bug test on their own sites until this mod is classified as stable.

Jase2
18 Apr 2008, 08:48
As the desciption says, this is beta software. Unfortunately it will be buggy. However, we working as fast as we can to fix the bugs. Were releasing beta 3 later this evening, which fixes a lot of bugs reported, and some new features -- such as the WYSIWYG editor. Please remember, we cannot add every feature, since there will be a paid version, with more features. ;)

On the dev board, we haven't run into any problems with beta 3 -- however, as you and I both know, bugs can just popup. I suggest you all wait for beta 3 later this evening.

Jase2
18 Apr 2008, 08:50
This is extremely buggy...


You need to force a title, because at this point you can create a ticket without one.
You should display what departtment a ticket is under "unresolved tickets"
Make unresolved tickets and resolved tickets viewable to the public so you don't have a bunch of duplicates.

Were working to fix that ;)

mat64
18 Apr 2008, 16:19
This looks very interesting, I will be interested in watching this grow :).

youradhere4222
18 Apr 2008, 17:26
I wish a moderator would do something about Bosco - it's getting beyond ridiculous.

DarkSorrowz
18 Apr 2008, 23:31
Is beta 3 coming out this evening, because I mean its nearly 7pm.... Im pretty sure its this evening.

Jase2
18 Apr 2008, 23:35
DarkSorrowz, it has now been decided that it will be released tomorrow. There are just a few more things we need to do. However, I have no doubt that you're going to like beta 3 ;)

Jase2
19 Apr 2008, 00:26
Bosco, read my post above. I said it has been decided to be released tomorrow. It seems you are just posting for posts sake.

DarkSorrowz
19 Apr 2008, 03:14
Atleast release a beta 2.5, You don't know how bad I need this thing to work.. Come on!

John3971
19 Apr 2008, 10:36
DarkSorrowz they canīt just release a beta 2.5 because we have worked on beta 3 and it will be released today and its just a beta and should not be used on live sites.

ZomgStuff
19 Apr 2008, 15:42
I can help you develop this if you want, I think this is a great idea.

Jase2
19 Apr 2008, 16:37
Unfortunately, we are not looking for any developers at this moment in time.

Marco van Herwaarden
19 Apr 2008, 17:21
Thread cleaned.

Jase2
19 Apr 2008, 17:25
Thanks, Marco!

lstintxs100
19 Apr 2008, 17:34
I am looking forward to seeing where this goes.

I clicked install to be updated on your progress. This seems like what my members have been asking for in the next update.

good job so far.

PaulSonny
19 Apr 2008, 17:35
Thanks Marco, it is very much appreciated by me and i'm pretty sure many others.

Good news, Beta 3 has been released and the original post has been modified.

I must ask that for this release you uninstall any previous installations and do a clean install with this release. The reason being that this version has had a total database restructure.

Thanks, Paul.

Jase2
19 Apr 2008, 17:40
Please continue to report bugs over at: www.paulsonny.com

Thanks!

GoTTi
19 Apr 2008, 17:58
UGHHHHHHHHHH ITS ABOUT DAMN TIME SOME1 MADE A SUPPORT MOD!!!!

/me is happy now

PaulSonny
19 Apr 2008, 17:59
UGHHHHHHHHHH ITS ABOUT DAMN TIME SOME1 MADE A SUPPORT MOD!!!!

* GoTTi is happy now

Glad your happy bud, I hope you like it.

Thanks, Paul.

GoTTi
19 Apr 2008, 18:01
im about to check it out now. i am VERY excited about this, cuz i have asked OVER and OVER and OVER again for some1 to please make this since the 1 fell off in the 3.0 days, i dont remember which one it was, but we havent had one in a while that works with the forum....my goal is to have my users use a ticket system instead of posting problems with the site in threads in my problem forum...so ya im diggin this one. hoping it works the way i would like it to :)

if i think of ideas, be ready cuz i might come up with a sh!tstorm of em to add onto this thing.

PaulSonny
19 Apr 2008, 18:04
Thats what I like to here GoTTi, although we would appreciate it if you could please post any features requests or bug reports at PaulSonny, makes it easier for us to manage.

Thanks, Paul.

GoTTi
19 Apr 2008, 18:08
aww its easier for us as vb.org users to post problems with mods here. damn it :)

GoTTi
19 Apr 2008, 18:09
problem i see. when i post a reply to a ticket created as admin, i am getting wrap codes from the quick reply...

<P>closing ticket</P>

looks like that in the message.

please add in your readme file that the user needs to set usergroup permissions for using the help center per usergroup.

idea:

when logged in as admin, and we goto the main helpcenter.php page, we can see some tables/information if there are new tickets or ones being worked on, instead of having to click on Closed/Open tickets, it will auto be displayed to us on that page and inside the admincp pages

ok i am making some post on your bug tracker page :)

Jase2
19 Apr 2008, 18:17
problem i see. when i post a reply to a ticket created as admin, i am getting wrap codes from the quick reply...

<P>closing ticket</P>

looks like that in the message.

I cannot reproduce that. Please could you attach a screenshot?

please add in your readme file that the user needs to set usergroup permissions for using the help center per usergroup.

I'll add that in now.

when logged in as admin, and we goto the main helpcenter.php page, we can see some tables/information if there are new tickets or ones being worked on, instead of having to click on Closed/Open tickets, it will auto be displayed to us on that page and inside the admincp pages

Don't see the point in that. You only need to click either "Open Tickets" or "Closed Tickets" -- it really isn't that hard. :)

GoTTi
19 Apr 2008, 18:21
ya but u know how lazy us admins area :) we want everything as simple as possible, and the less clicks, the better.

SuperDave71
19 Apr 2008, 18:27
Thanks for all your had work. I just updated a fresh install and I am STILL getting the "Social Groups" in the title field by default when I create (add) a ticket.

I know you can find the issue. I appreciate this mod and hope we can get this resolved soon.


Take care and thanks again,


Dave

Jase2
19 Apr 2008, 18:54
Hi SuperDave,

I cannot reproduce that. Did you uninstall the previous product, before importing the new one?

djlotus
19 Apr 2008, 19:11
Thanks for all your hard work on this Mod. This hack will be a great add to my board. No longer do I need to answer quesions posted all over my board, I can use this feature. Many thanks for this, and future releases. I look forward to installing tomorrow, and helping to test for you.

INSTALLED

JVSP
19 Apr 2008, 19:16
Thanks for the great mod.

Also as for that Bisco wing kid, thanks for cleaning up the thread of his posts.....he does the same thing on vbulletin.com :mad:

Jase2
19 Apr 2008, 19:21
Thanks guys. The quicker you guys report bugs; the quicker we can release a 'stable' (gold) version. Please do check our bug tracker here (http://www.paulsonny.com/forum/project.php) before posting any bugs. It would be better if you could report bugs in our bug tracker, too.

SuperDave71
19 Apr 2008, 20:17
Hey Jase2,

Thank you for the response. Yes, I did an overwrite of the files and uninstalled the old and installed the new. Do you have any other reccomendations?

I will be happy to try them if you do. Thank you so much. I know this is got to be something easy to remedy.



Take care,

Dave

Jase2
19 Apr 2008, 20:22
Very strange. Not happening here.

Any chance you can set me an account at your board with admin privileges so that I can take a look? Other that, I can't suggest much more...

SuperDave71
19 Apr 2008, 21:06
Jase2,


This is what is conflicting with the title field. The reason I know this is I just added a new announcement with this product and it was called "Articles". Now the title field defaults to "Articles" instead of "Social Groups".


Just thought it might help with my issue.


Thanks in advance,


Dave



http://www.vbulletin.org/forum/showthread.php?t=172773&highlight=SmnLikQuick <---the plug in that is conflicts.

Jase2
19 Apr 2008, 21:16
Yes, that seems to be the issue. Me and paul will have to take a look at that hack, and see why it is conflicting. Thanks for reporting it.

SuperDave71
19 Apr 2008, 21:25
Thanks Jase!

I appreciate it!



-Dave

PoetJA-1975
20 Apr 2008, 01:02
Thanx so much PAULSONNY for this HelpCenter modification - Once it becomes stable it will be a winner no doubt! As others have stated - this has been very much need for a while! I certainly look forward to a gold version and will like to say thank you so much for you hard work and thanx to those who are beta testing to make this the best modification introduced on vB.org since the NoSpam! and/or Living Avatars modificaton!

Excellent work GUYS = Keep it up ;)

Jacquii.

Jase2
20 Apr 2008, 01:21
Thanks PoetJA-1975! That is a really nice comment, and makes the effort more worthwhile. :)

I'm sure Paul will be just as happy as I'm feeling right now :)

macc
20 Apr 2008, 02:53
hello!

i just installed your hack...very useful and thanks!

have two problem ... can not delete ticket (seen not that possibility), and when will write new ticket comes in title some like that "<b>NOVI SADRZAJI LIBRA</b>" (in every new ticket) "novi sadrzaji libra" is name of one of my forums (threads)??

have vbulletin 3.7 rc-3

some help or solutins?

regards

macc

PaulSonny
20 Apr 2008, 03:02
Thanx so much PAULSONNY for this HelpCenter modification - Once it becomes stable it will be a winner no doubt! As others have stated - this has been very much need for a while! I certainly look forward to a gold version and will like to say thank you so much for you hard work and thanx to those who are beta testing to make this the best modification introduced on vB.org since the NoSpam! and/or Living Avatars modificaton!

Excellent work GUYS = Keep it up ;)

Jacquii.

I agree with Jason, comments like these definately make it worth while and are very much appreciated. Thanks Jacquii.

hello!

i just installed your hack...very useful and thanks!

have two problem ... can not delete ticket (seen not that possibility), and when will write new ticket comes in title some like that "<b>NOVI SADRZAJI LIBRA</b>" (in every new ticket) "novi sadrzaji libra" is name of one of my forums (threads)??

have vbulletin 3.7 rc-3

some help or solutins?

regards

macc

Sorry Macc, im afraid I dont understand. With regards to cannot delete a ticket, are you sure you have set the correct Usergroup Permissions?

With regards to the second problem, are you able to produce a screenshot so we can identify the problem?

Thanks, Paul.

macc
20 Apr 2008, 03:08
link to my page www.belaplay.com/vb/libar (http://www.belaplay.com/vb/libar)

you can come ... to my page ... i will give you admin premissions... no problem ..


reg

macc

edit: now guests have prem. to use help desk ... you can use bosss username and pass you can read on chat

have upload picture

PaulSonny
20 Apr 2008, 11:23
From that screenshot it looks as though you are trying to make the title bold and the title field is not set to accept text formatting.

Thanks, Paul.

macc
20 Apr 2008, 11:49
that is problem ...that comes automaticly <b> and notice name "novi sadrzaji libra"... i did not do anything ... just come up in title box? can you explane how to delete tickets?


reg

macc

edit: now guest have possibility make tickets and full premisions ... just try... please..

macc

PaulSonny
20 Apr 2008, 11:54
ok I will look into that.

With regards to deleting a ticket, if you have set the usergroup permissions correctly then when you view a ticket, under the Ticket Options menu, select Delete Ticket.

Thanks, Paul.

macc
20 Apr 2008, 11:58
i set all premisions to yes ... for guests and admins ... you can use my another admin nik - bosss and will write pass on evo chat ... please ...

reg

macc

Jase2
20 Apr 2008, 13:19
Mac, you need to set the permissions in your ACP:

ACP --> Usergroups --> Usergroup Manager --> Your usergroup (GO) --> HelpCenter Usergroup Permissions

If that doesn't work, try re-uploading all files (overwriting the ones on your sever already) and re-importing the product. Just uninstall the product you have in, before re-importing.

If it's still the same, then you may have a conflicting hack/mod. Therefore, I would like you to disable the plugin/hook system, and see if the problem persists. Edit config.php and add this line right under <?php

define('DISABLE_HOOKS', true);

Do you still have the same problem?

Jase2
20 Apr 2008, 14:26
Hi Mac,

I see you have this hack installed: http://www.vbulletin.org/forum/showthread.php?t=172773&highlight=SmnLikQuick

There is a compatibility issue, and we are working to fix this.

Thank you for your patience.

macc
20 Apr 2008, 14:29
yes from this hack comes in title box name of notice with bold codes ... and i can not see delete options in helpcenter ...


regards

macc

futureye
20 Apr 2008, 15:53
I use it in my 3-7 RC2
but it didn't show me the option of departments

King Kovifor
20 Apr 2008, 16:05
Hi Mac,

I see you have this hack installed: http://www.vbulletin.org/forum/showthread.php?t=172773&highlight=SmnLikQuick

There is a compatibility issue, and we are working to fix this.

Thank you for your patience.

What does the hack do that conflicts with this mod? I might be able to help fix it in the next release.

macc
20 Apr 2008, 16:12
that is some conflict..because i get in title box for helpcenter - bolded name of one of names in notices from another hack ... and can not delete tickets ...come not up in menu -delete !


reg

macc

www.belaplay.com/vb/libar (http://www.belaplay.com/vb/libar)

Jase2
20 Apr 2008, 16:20
What does the hack do that conflicts with this mod? I might be able to help fix it in the next release.

Hi King Kovifor,

It seems when you're using that hack, and go for a create a ticket in HelpCenter, it gives the title of whatever you did last with that hack. At least that is what has been reported.

JVSP
20 Apr 2008, 18:05
Any way to attach an image in a ticket, just in case a member wants to post an image of a problem?

Jase2
20 Apr 2008, 18:11
fxlr8, the attachment feature will be included into the paid' version.

macc
20 Apr 2008, 18:46
Jase2 have you some tips for my problem or i will wait next realese?

regards

macc

PaulSonny
20 Apr 2008, 18:46
Macc, I am currently working on a solution now.

Once I have one, I will add an updated version to this thread, but please try and be patient.

Thanks, Paul.

macc
20 Apr 2008, 18:55
Thanks ...no problem ... will wait!

regards

macc

PaulSonny
20 Apr 2008, 20:04
SuperDave and Macc, I have added an updated version for you to try and see whether this fixes your error.

I have no idea at the moment why this error is being caused and I have taken a total stab in the dark in the hope that it will sort it out.

Anyway, I ask that everyone else downloads the original helpcenter file and not the files meant for SuperDave and Macc.

Let me know how you guys get on please so I can update the original helpcenter release.

Thanks, Paul.

macc
20 Apr 2008, 20:51
hello!

just upload new files and product file but now get database error when should submit new ticket! in title box is ok ... no text and no bold codes!

Database error in vBulletin 3.7.0 Release Candidate 3:
Invalid SQL:
INSERT INTO vb_helpcenter_ticket(departmentid, tickettitle, message, priority, ownerid, ownerusername, lastreplyusername, lastreplyuserid, datelogged, datelastupdate, ipaddress) VALUES ('0','test','test test test','3','1','Admin','Admin','1','1208720898','1208720898','81.235.161.10');
MySQL Error : Unknown column 'tickettitle' in 'field list'
Error Number : 1054
Date : Sunday, April 20th 2008 @ 03:48:18 PM
Script : http://belaplay.com/vb/libar/helpcenter.php
Referrer : http://belaplay.com/vb/libar/helpcenter.php?do=newticket
IP Address :Username : Admin
Classname : vB_Database
MySQL Version : 4.1.22-standard

reg
maccc

and thanks for your works

edit: no possibility to delete ticket!

PaulSonny
20 Apr 2008, 21:21
Macc I have just received your PM and logged into your website with the details given and was able to see the Delete Link from the Drop down menu Ticket Options.

With regards to the above error, I will sort it out now, it seems I have used invalida SQL syntax for changing one of the DB structures.

Thanks, Paul.

PaulSonny
20 Apr 2008, 21:25
Macc, Sorry about that, I have updated the download and would appreciate it if you could please re-download it and install it.

To make sure it works, please uninstall any previous versions and do a clean install.

Thanks, Paul.

macc
20 Apr 2008, 22:04
Hello!

i reinstall and update with zip file for mac and dave and get this database error

Database error in vBulletin 3.7.0 Release Candidate 3:
Invalid SQL:
SELECT * FROM vb_helpcenter_ticket WHERE ownerid='1' ORDER BY datelastupdate DESC LIMIT 0,;
MySQL Error : 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 '' at line 1
Error Number : 1064
Date : Sunday, April 20th 2008 @ 05:01:08 PM
Script : http://belaplay.com/vb/libar/helpcenter.php
Referrer : http://belaplay.com/vb/libar/index.php
IP Address :
Username : Admin
Classname : vB_Database
MySQL Version : 4.1.22-standard


on the top error page is Warning: Division by zero in [path]/includes/functions.php on line 2212


shoud i use another zip file ?

regards

macc

PaulSonny
20 Apr 2008, 22:06
I suggest you overwrite all files again because the actual files themselves havent had any SQL changed, just a field title.

Thanks, Paul.

SuperDave71
20 Apr 2008, 22:08
I get the exact same error when I did a clean install as well.


I just overwrote the old files myself and I still got this error.



"Warning: Division by zero in [path]/includes/functions.php on line 2212"


Database error in vBulletin 3.7.0 Release Candidate 3:

Invalid SQL:
SELECT * FROM helpcenter_ticket WHERE ownerid='1' ORDER BY datelastupdate DESC LIMIT 0,;

MySQL Error : 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 '' at line 1
Error Number : 1064
Date : Sunday, April 20th 2008 @ 02:05:13 PM
Script : http://www.thelovelogic.com/forum/helpcenter.php
MySQL Version : 5.0.45-log


Thank you for all your hard work...



-Dave

macc
20 Apr 2008, 22:13
i do that - overwrote files again and get same error !

used dave and mac zip file!

imported product again ..and error comes up (same error like before)

reg

macc

PaulSonny
20 Apr 2008, 22:15
Sorry about this guys, it was a mistake on my part.

Please try again.

Thanks, Paul.

macc
20 Apr 2008, 22:24
Uraaaaaaaaa works perfect !!!!!!

Thanks Thanks


regards

macc

edit: no errors ..have submited tickets ..works perfect!
thanks again
macc

PaulSonny
20 Apr 2008, 22:28
Thanks Macc, so I can assume that you no longer get the <b></b> tags around your title?

Thanks, Paul.

macc
20 Apr 2008, 22:30
Yes ... title box is clean ...no text and no codes!

works great- thanks for help

regards

macc

SuperDave71
20 Apr 2008, 23:05
PaulSonny and Jase2,


Mine works perfectly as well. You guys, THANK YOU SOOO MUCH for all your hard work. My forum, like so many out there, certainly needs this particular mod and I want to personally thank you both for your dedication in make this work Macc and I.

You guys have been nominated!



Sincerely,


Dave

PaulSonny
20 Apr 2008, 23:07
Thanks ever so much to both you guys for actually co-operating with us and allowing us to test this product for bugs and other issues.

I'm just glad you managed to both get this sorted and i'm sure Jason will agree with me, thank you for your kind words.

Thanks, Paul.

Jase2
20 Apr 2008, 23:10
Thank you very much, Dave. It's the comments like that, that put a smile on my face! :)

PaulSonny
20 Apr 2008, 23:15
Update

Just to let everyone know, I have just released Beta 4. We have predicted this to be the final Beta, although it is not set in stone.

Thanks, Paul.

PoetJA-1975
21 Apr 2008, 03:04
Wow! I've been following this thread - getting a little excited ((blush))
Great work YAWL - I'm looking forward to installing this ;)

Jacquii.

ZomgStuff
21 Apr 2008, 14:23
Do you guys mind if I edit this modification a bit on my board? I shall keep it to myself and not distribute it.

SuperDave71
21 Apr 2008, 14:27
I certainly appreciate your hard work. I just had a quick question.

On the notification options, Where are those set? ( Meaning Who to notify ) If it isn't available yet, just say the word. I don't mean to be a bother.


Thanks in advance!


-Dave

Jase2
21 Apr 2008, 17:08
Do you guys mind if I edit this modification a bit on my board? I shall keep it to myself and not distribute it.

You are free to modify the code. However, we cannot support modified code. Once HelpCenter lite goes 'stable', we will open a hacks/mods forum -- where members can post their modfications for HelpCenter. :)

Jase2
21 Apr 2008, 17:09
I certainly appreciate your hard work. I just had a quick question.

On the notification options, Where are those set? ( Meaning Who to notify ) If it isn't available yet, just say the word. I don't mean to be a bother.


Thanks in advance!


-Dave

That is for the admin. The paid version will have a notification system for users; similar to vBulletin's.

macc
21 Apr 2008, 17:15
Hello!

just one questions .. should i update helcenter hack or not, because it shows me that is update possible?

just overwrite files or unistall first if i need or can update?(mean conflict with another hack before)
regards and thanks again

macc

KURTZ
21 Apr 2008, 17:27
Jason/Paul, when the final release is planned?

futureye
21 Apr 2008, 17:44
Database error in vBulletin 3.7.0 Release Candidate 3:

Invalid SQL:
SELECT * FROM helpcenter_ticket WHERE ticketstatus=1;

MySQL Error : Unknown column 'ticketstatus' in 'where clause'
Error Number : 1054
Date : Monday, April 21st 2008 @ 11:42:32 AM
Script : http://www.surcity.net/forums/Muap/helpcenter_admin.php?do=openticketmanage
Referrer : http://www.surcity.net/forums/admincp/index.php?do=nav
MySQL Version : 4.1.22-standard-

Jase2
21 Apr 2008, 17:46
Jason/Paul, when the final release is planned?

At this moment in time, we do not know. We will however make an announcement at paulsonny.com when we predict to release a 'stable', gold release.

Jase2
21 Apr 2008, 17:48
Database error in vBulletin 3.7.0 Release Candidate 3:

Invalid SQL:
SELECT * FROM helpcenter_ticket WHERE ticketstatus=1;

MySQL Error : Unknown column 'ticketstatus' in 'where clause'
Error Number : 1054
Date : Monday, April 21st 2008 @ 11:42:32 AM
Script : http://www.surcity.net/forums/Muap/helpcenter_admin.php?do=openticketmanage
Referrer : http://www.surcity.net/forums/admincp/index.php?do=nav
MySQL Version : 4.1.22-standard-

I'm afraid this isn't much help too me. What are the steps to reproduce this error?

macc
21 Apr 2008, 18:02
Just one question more .. why is message box for guest users so small? can we make this message box biger ? that is relplay message box - guest user

will attach picture

reg

macc

JVSP
21 Apr 2008, 18:09
When viewing the ticket reply window in IE I notice that the reply window is not fully open. In firefox it is fine.

http://i85.photobucket.com/albums/k46/FXLR8/Hcreply.jpg



Edit:::: didnt even see that someone just posted the same question..hehe

Jase2
21 Apr 2008, 18:10
Hi Macc,

It definitely isn't that small on our dev board. Do you have ads down FORUMHOME? Is your forums width shortened in anyway?

macc
21 Apr 2008, 18:51
no adds in forumhome ...and can just say that in firefox is ok (just what fxlr8 wrote before...)mean message box.. but in IE is so small!

edit: have IE 7 and windows vista SP1

regards

macc

Jase2
21 Apr 2008, 19:03
Please provide me a link to your HelpCenter installation.

SuperDave71
21 Apr 2008, 19:08
Hey Guys..


I created a test ticket and I was never notified that there was a ticket.


I set the admin to email and PM. Am I doing something wrong? I just want to make sure it's not on my end. I so love this mod!


Thanks Guys!



-Dave

macc
21 Apr 2008, 19:12
you can visit link www.belaplay.com/vb/libar (http://www.belaplay.com/vb/libar)


and like guest you can replay and see ...

installation link? what you mean with that? you can come and use admin account ... you know password and username!

reg

macc

Jase2
21 Apr 2008, 19:25
Hey Guys..


I created a test ticket and I was never notified that there was a ticket.


I set the admin to email and PM. Am I doing something wrong? I just want to make sure it's not on my end. I so love this mod!


Thanks Guys!



-Dave

I'm pretty sure Paul fixed that. He may have not, however. I'll have a word with him.

Jase2
21 Apr 2008, 19:32
Macc, by a link to your HelpCenter installation, I just meant a link to where HelpCenter is installed on your website :)

I have however confirmed the small text box in Internet Explorer 7. Will see what's wrong.

macc
21 Apr 2008, 19:42
ok ... www.belaplay.com/vb/libar/helpcenter (http://www.belaplay.com/vb/libar/helpcenter) is link (libar is my board)


reg macc

DssCrazy
21 Apr 2008, 19:45
Nice work i love this mod. 1 problem i found thow! i am using explorer as my browser and the ticket reply box is REALLY small can it be fixed this happend on your site when i tested the demo.

Here is the screen shot.

DssCrazy
21 Apr 2008, 19:46
Also for the paid version how much will it be? and what futures will it have that the free version does not have?

Thanks

SuperDave71
21 Apr 2008, 19:48
Thanks Jase...


I have NOT upgraded to the Updated one yet.

I knew you had Macc and me with a separate download so I was afraid I would mess up what you already fixed.


Let me know if it is ok to install the NEWEST one..


Thank you so much!



-Dave

Jase2
21 Apr 2008, 19:50
Also for the paid version how much will it be? and what futures will it have that the free version does not have?

Thanks

We haven't decided a price, yet. Once we release a 'stable', gold release of the lite version, we will get to work on the paid version. I have to balance my developing at the moment (other hacks and the paulsonny.com website), but HelpCenter paid version has my full priority.

We have decided some features, such as: Attachments, flagging to other department or person, ect. I think we will have some beta testers for it, however it will be encoded to stop functioning at a certain date.

macc
21 Apr 2008, 19:55
superdave i ask same before...i have not updated yet ..have "our" version...

reg

macc

Jase2
21 Apr 2008, 19:59
Thanks Jase...


I have NOT upgraded to the Updated one yet.

I knew you had Macc and me with a separate download so I was afraid I would mess up what you already fixed.


Let me know if it is ok to install the NEWEST one..


Thank you so much!



-Dave

Dave, please upgrade to the latest version - currently beta 4. This should fix your current problem.

Jase2
21 Apr 2008, 20:00
Nice work i love this mod. 1 problem i found thow! i am using explorer as my browser and the ticket reply box is REALLY small can it be fixed this happend on your site when i tested the demo.

Here is the screen shot.

Yes, this happens in Internet Explorer 7 for guests. We will see what can be done to correct this.

macc
21 Apr 2008, 20:14
i updated and now is replay message box ok (was before update also ok.. maybe jase2 done something ...!

regards and thanks for all help!

have nominated yesterday

macc

DssCrazy
21 Apr 2008, 20:19
Problem found!

When i tried to edit the usergroups to make the ticket system work i got an error

this happend with beta 4

Thanks

Jase2
21 Apr 2008, 20:34
DssCrazy, what error? I don't get any errors when editing the usergroups. I suggest you try re-installing.

DssCrazy
21 Apr 2008, 20:40
This error

Database error in vBulletin 3.7.0 Release Candidate 3:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'Administrators',
`description` = '',
`usertitle` = 'Administrator',
`opentag` = '<font color=\"#DF7E4E\">',
`closetag` = '</font>',
`passwordexpires` = '180',
`passwordhistory` = '360',
`ugphelpcenter` = '1983',
`forumpermissions` = '8380415',
`genericpermissions` = '2147483583',
`attachlimit` = '0',
`pmquota` = '50',
`pmpermissions` = '7',
`pmsendmax` = '5',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericpermissions2` = '1',
`genericoptions` = '55',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '120',
`avatarmaxheight` = '120',
`avatarmaxsize` = '40000',
`signaturepermissions` = '237567',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '0',
`sigmaxchars` = '0',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '0',
`albumpermissions` = '255',
`albumpicmaxwidth` = '600',
`albumpicmaxheight` = '600',
`albumpicmaxsize` = '100000',
`albummaxpics` = '100',
`albummaxsize` = '0',
`usercsspermissions` = '31',
`visitormessagepermissions` = '63',
`socialgrouppermissions` = '511',
`mgc_cb_evo_permissions` = '255',
`mgc_cb_evo_nbmsg_show` = '0',
`mgc_cb_evo_nbmsg_perday_show` = '0',
`mgc_cb_evo_default_color` = '000000'
WHERE usergroupid=6;

MySQL Error : Unknown column 'ugphelpcenter' in 'field list'
Error Number : 1054
Date : Thursday, April 17th 2008 @ 07:26:07 PM
Script : http://www.xxxxxx.net/forum/admincp/....php?do=update
Referrer : http://www.xxxxx.net/forum/admincp/u...&usergroupid=6
IP Address : xxxxxx
Username : Hasselhoff
Classname : vB_Database
MySQL Version : 5.0.45-community-log

Jase2
21 Apr 2008, 20:47
DssCrazy, that was fixed in beta 3. Are you uninstalling the .xml product, then re-importing it, as overwriting will not work? If you still receive this error; download the package at our website and see if it corrects your problem: http://www.paulsonny.com/forum/showthread.php?p=172

DssCrazy
21 Apr 2008, 20:54
just tirend downloading from here and over at your site still get the saem error. i am doing everything right

DssCrazy
21 Apr 2008, 20:57
Here is the xml file i am using

DssCrazy
21 Apr 2008, 21:09
Do you think you will beable to fix this today so i can giver a try?

Thanks

DssCrazy
21 Apr 2008, 21:44
i also tried beta 3 and did the same thing

Jase2
21 Apr 2008, 22:22
Hi DSSCrazy,

I have to go soon; so Paul will be with you shortly. I still cannot reproduce that error.

Try the attached product. Remember to uninstall your previous one, before importing this. Although I don't think it will work, as they should both be the same. Are re-upload all files (overwriting the ones on your server) ?

DssCrazy
21 Apr 2008, 22:25
Here is what i did. i uploaded all files to ftp and inported the xml then when i go to set usergroup rights i get that error

Jase2
21 Apr 2008, 22:33
But that was fixed in beta 3. I may sound like I'm repeating myself, but are you uninstalling the old .xml and not doing an overwrite? This simply isn't happening for me; although I don't have the time to go over the product - as I've got too go.

King Kovifor
21 Apr 2008, 22:38
Hi King Kovifor,

It seems when you're using that hack, and go for a create a ticket in HelpCenter, it gives the title of whatever you did last with that hack. At least that is what has been reported.

Hm... That is definitely an odd conflict. Do you have any more details? Code, tables... etc.

DssCrazy
21 Apr 2008, 22:39
well i will repeat what i did. i tried both version beta3 and beta4 and uploaded all files to ftp and imported xml. i am not overwriting xml over xml i uninstall old and place new.

Jase2
21 Apr 2008, 22:44
Hm... That is definitely an odd conflict. Do you have any more details? Code, tables... etc.

Hi King,

This has now been corrected. Seems we were using the same fieldname. Thanks for showing an interest in helping us, though :)

Jase2
21 Apr 2008, 22:45
Is anyone else running beta 4 having the same problem has DssCrazy? We will then know whether it is user error, or a problem in the code :)

ZomgStuff
21 Apr 2008, 23:37
Are the majority of the bugs worked out? Is it safe on a live site?

DssCrazy
22 Apr 2008, 00:15
ZomgStuff i seen that you were having the saem problem as i. can you please share with me how you fixed the problem?

Thanks buddy

ZomgStuff
22 Apr 2008, 01:55
ZomgStuff i seen that you were having the saem problem as i. can you please share with me how you fixed the problem?

Thanks buddy

Run the install queries located in the xml by hand via phpmyadmin.

DssCrazy
22 Apr 2008, 03:14
Run the install queries located in the xml by hand via phpmyadmin.You lost me lol

abrecher
22 Apr 2008, 06:58
This is a great mod! I really needed this since my forums have been growing. I can't wait until you have a stable version out.

Jase2
22 Apr 2008, 09:58
Are the majority of the bugs worked out? Is it safe on a live site?

Most bugs have been fixed. Although there are still one or two things we need to do, as well as to fix a few bugs. I don't recommend having this installed on a production site; you can if you want, but we cannot be held responsible for problems that may arise. I suggest you wait for a 'stable', gold release, or at the very least a release candidate.

PaulSonny
22 Apr 2008, 10:37
Sorry about not replying sooner guys, I have had some problems with my ISP.

DSSCrazy, can you please confirm you are running vBulletin 3.7? Just the install code for HelpCenter relies on a fieldname only available in 3.7.

If you are running 3.7, then can you please confirm that before you import the product, you have already uninstalled the previous installation, and have not just overwritten the product, if you are still having trouble after this, send me a PM with your msn address and I will try my best to help.

As it says in the original post, for Beta 4 to function properly, you have to uninstall any previous versions and re-install Beta 4, almost like a new installation.

Macc & Superdave, I would recommend upgrading to the latest version. The seperate files I created for you both were to just confirm it worked before I went ahead and edited the original code. After you confirmed it work I went ahead and updated the original code and fixed/added one or two extra things so I would recommend upgrading.

With regards to the notification system via the Admin CP, that is still yet to be implemented, working on it in the next release. I originally planned to put it in sooner but time got away from me.

With regards to the paid version, features, prices and such things nothing has been decided, once information is available, I shall let you know.

Thanks everyone for your kind comments and supporting this product, Paul.

regitbull
22 Apr 2008, 18:26
Im getting this error to and it seems like ZomgStuff said the mod diddint add a table and that makes the error.

I think thoose 2 querys are the problem of the error:
$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "usergroup` ADD `ugphelpcenter` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `socialgrouppermissions`");
and
$db->query_write("ALTER TABLE `" . TABLE_PREFIX . "usergroup` DROP `ugphelpcenter`");

I cant find that ugphelpcenter in my usergroup table so i think thats the problem.
And if you check the error log then it says this:
MySQL Error : Unknown column 'ugphelpcenter' in 'field list'


So i think thats the whole problem.
Well i dont know much about mysql so could you guys post the manual query commands so we can manual add thoose querys because i dont know how to run thoose querys :)

Thanks and i hope this will fix the problem for me,DssCrazy and any others who get or will get this error.


Edit:
Ok i fixt the problem my self and i think it will help you to DssCrazy.
Go to phpmyadmin and run this query:
ALTER TABLE `usergroup` ADD `ugphelpcenter` INT( 10 ) UNSIGNED NOT NULL DEFAULT '0' AFTER `forumpermissions`

Now try to update the usergoups in the vbulletin admin panel again.
If its right then it will just update the info now without showing a error :)

DssCrazy
23 Apr 2008, 04:18
Sorry about not replying sooner guys, I have had some problems with my ISP.

DSSCrazy, can you please confirm you are running vBulletin 3.7? Just the install code for HelpCenter relies on a fieldname only available in 3.7.

If you are running 3.7, then can you please confirm that before you import the product, you have already uninstalled the previous installation, and have not just overwritten the product, if you are still having trouble after this, send me a PM with your msn address and I will try my best to help.

As it says in the original post, for Beta 4 to function properly, you have to uninstall any previous versions and re-install Beta 4, almost like a new installation.

Macc & Superdave, I would recommend upgrading to the latest version. The seperate files I created for you both were to just confirm it worked before I went ahead and edited the original code. After you confirmed it work I went ahead and updated the original code and fixed/added one or two extra things so I would recommend upgrading.

With regards to the notification system via the Admin CP, that is still yet to be implemented, working on it in the next release. I originally planned to put it in sooner but time got away from me.

With regards to the paid version, features, prices and such things nothing has been decided, once information is available, I shall let you know.

Thanks everyone for your kind comments and supporting this product, Paul.I am doing all things right. here is what i am doing.

1 uploaded all files to ftp
2 installed xml did not overwright.
Running 3.6.8

Tom_S
23 Apr 2008, 10:25
Installed. Very nice but it has a lot of rough edges in it yet though.

John3971
23 Apr 2008, 10:38
I am doing all things right. here is what i am doing.

1 uploaded all files to ftp
2 installed xml did not overwright.
Running 3.6.8

Well like PaulSonny said you must use 3.7 to have this work like it should because this mod is made for vB 3.7

regitbull
23 Apr 2008, 15:45
Well like PaulSonny said you must use 3.7 to have this work like it should because this mod is made for vB 3.7

Like i said in my other post i got the same error as him and im also running 3.6.8 level 2.
I run the query i posted and everything worked fine after that.

So its running perfect on a 3.6.8 level 2 forum.

Jase2
23 Apr 2008, 16:06
As Paul has already mentioned too you, the code relies on a fieldname that is only available in 3.7. This is in the 3.7 forum, so unless you're running 3.7 -- you shouldn't be using this.

PaulSonny
23 Apr 2008, 19:54
I have realised how to make this work on vBulletin 3.6 and will release it once I have a stable internet connection in the 3.6 mod forum.

Thanks, Paul.

DssCrazy
23 Apr 2008, 20:08
I have realised how to make this work on vBulletin 3.6 and will release it once I have a stable internet connection in the 3.6 mod forum.

Thanks, Paul.Ok cool.

Thanks so much

Jase2
23 Apr 2008, 20:10
Below, I have attached the updated helpcenter.php file. No changes, just added protection for the Cross Site Request Forgery (CSRF) -- recent security risk in vBulletin.

IanW-GC8
23 Apr 2008, 21:36
Thanks for that Jase :)

PoetJA-1975
24 Apr 2008, 04:05
I have realised how to make this work on vBulletin 3.6 and will release it once I have a stable internet connection in the 3.6 mod forum.

Thanks, Paul.

WONDERFUL!

Thanx so much PAUL, as I don't think I'll be upgrading to 3.7 anytime soon - we have waaaaay to many customizations on JPiC Forum to even consider it at the moment it goes gold - BUT at the same time - could really use the Help Center - so thanx for the 3.6.x version ;)

Jacquii.

DubaiHost
24 Apr 2008, 04:09
And now .. it's the best .. ;)
thank's for the great Mod.
Sure it's Installed .. :)

Jase2
24 Apr 2008, 13:57
Please report any bugs you find so we can make HelpCenter as bug free as possible! :)

reifegerste
24 Apr 2008, 14:42
Hi,

i have installed 3.7.0 RC4 and i get the following error:

Your submission could not be processed because a security token was missing or mismatched.

If this occurred unexpectedly, please inform the administrator and describe the action you performed before you received this error.

Can anyone help me, please? Sorry my english is not so good :/

Jase2
24 Apr 2008, 14:52
Ok, try the following product file. Remember to uninstall your previous product file, before installing this one. Let me know how it goes.

reifegerste
24 Apr 2008, 15:06
Ahhh!!! great it works perfectly!

Jase2
24 Apr 2008, 15:12
That's great! I'll get Paul renew the product file.

pow6713
24 Apr 2008, 15:38
Ok, try the following product file. Remember to uninstall your previous product file, before installing this one. Let me know how it goes.


:up::up:
great thanks

DubaiHost
25 Apr 2008, 10:35
There is something wrong ..

all the words written in the support ticket apears in one line ..
( I mean when you write your post and press Enter ) ..

Exp :

Usual .. the result of ( Blah ,, Enter key ,, Blah ) :
Blah
Blah

But in the support system , the result of ( Blah ,, Enter key ,, Blah ) :
Blah Blah

Hope that this problem can be support ..

PaulSonny
25 Apr 2008, 10:44
I have updated the download to include Jason's latest product file, thanks Jason.

DubaiHost, I will try and replicate the bug now, if I am able to, I will try and find a solution.

Thanks, Paul.

Edit: I have just tried to re-create the problem and everything was ok, it displayed as it should, basically if you press the Enter key it display on the next line as it should.

Thanks, Paul.

DubaiHost
25 Apr 2008, 11:37
Edit: I have just tried to re-create the problem and everything was ok, it displayed as it should, basically if you press the Enter key it display on the next line as it should.
Thanks, Paul.

hmmm .. maybe because im using a toolbox ,
can you please allow users in your forum to submit tickets .. so i can try there .

and on which version you made your test , because im working on RC4 now .. and i uploaded the file posted by Jase2 ..

thanks in advance for your support .. :)

PaulSonny
25 Apr 2008, 13:54
Updated settings on PaulSonny so you should not be able to create a ticket.

Thanks, Paul.

DubaiHost
25 Apr 2008, 14:11
It's the same ..
check this ticket .. http://www.paulsonny.com/forum/helpcenter.php?do=ticket&tid=2
you will find all the words in the same line ..

PaulSonny
25 Apr 2008, 14:27
I dont understand, i've just edited one of the replies to that ticket above and pressed enter and hit save and its saved correctly.

I will ask Jason to see what he thinks. Is anybody else having this problem?

Thanks, Paul.

DubaiHost
25 Apr 2008, 14:54
I dont understand, i've just edited one of the replies to that ticket above and pressed enter and hit save and its saved correctly.

I will ask Jason to see what he thinks. Is anybody else having this problem?

Thanks, Paul.

Actually ,, i did the same thing but not with the same way .. i used the phpmyadmin , and it gave me a good result ..

so i think the problem is from the copy of helpcenter.php that i got .

Thanks for everything Paul.

PaulSonny
25 Apr 2008, 15:13
Try overwriting your existing helpcenter.php file with the one I have.

Thanks, Paul.

DubaiHost
25 Apr 2008, 15:21
Try overwriting your existing helpcenter.php file with the one I have.

Thanks, Paul.

I did, it's with the same result ,, nothing new ..

PaulSonny
25 Apr 2008, 15:23
very strange in deed.

Like I said, will see what Jason thinks.

Thanks, Paul.

Jase2
25 Apr 2008, 16:04
Hello,

I can confirm this. I noticed this a few betas back, but couldn't understand why the text wasn't formating correctly. If you make a space, it automatically puts the text onto the same line. Trying to find a fix for this in the next release.

DubaiHost
25 Apr 2008, 16:08
very strange in deed.

Like I said, will see what Jason thinks.

Thanks, Paul.

Hello,

I can confirm this. I noticed this a few betas back, but couldn't understand why the text wasn't formating correctly. If you make a space, it automatically puts the text onto the same line. Trying to find a fix for this in the next release.

Ok ,, then i will wait for the new release.
Even if it couldn't fixed, you did a great job with this Mod.
Really thanks for it and for the great support ..

thanks again.
IT TECH

bahisyeri
26 Apr 2008, 00:50
Dude its cool but if you can add attachment support it will be best...
PS: If you can add support for can not reply to closed tickets too.

Jase2
26 Apr 2008, 00:54
bahisyeri, the attachment feature will be included into the paid' version. :)

bahisyeri
26 Apr 2008, 01:27
bahisyeri, the attachment feature will be included into the paid' version. :)

Ah ok ty, i updated my reply:), btw how can we buy that pro/paid version and do we allowed to write our own addons for this free version?

Jase2
26 Apr 2008, 11:45
Paul is setting up the members area, where you will be able to download our software. Once HelpCenter goes gold, we'll start work on the 'paid version. Also, we will open a hacks/modfications forum, where members can submit their hacks/mods for HelpCenter. However, we will not be able to support modified code, in the event something goes wrong.

sbarbz
26 Apr 2008, 18:45
Database error in vBulletin 3.6.10:

Invalid SQL:
UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
`title` = 'מנהלי אתר',
`description` = '<b>מנהל ומייסד האתר</b>',
`usertitle` = '<b>מנהל ומייסד האתר !</b>',
`opentag` = '<b><font color=\"#ff9933\">',
`closetag` = '</b></font>',
`passwordexpires` = '180',
`passwordhistory` = '360',
`creditpermissions` = '628',
`credit_induction` = '21',
`credit_referral` = '0',
`credit_refbonus` = '0',
`credit_paycheck` = '0',
`credit_active` = '0',
`credit_birthday` = '0',
`credit_repgive` = '0',
`credit_reputation` = '0',
`credit_infraction` = '0',
`credit_thread` = '4',
`credit_threadrate` = '0',
`credit_post` = '0',
`credit_ownthreadpost` = '0',
`credit_postsize` = '0',
`credit_ownthreadview` = '0',
`credit_ownthreadrate` = '0',
`credit_ownthreadreply` = '0',
`credit_ownprofileview` = '0',
`credit_pollmake` = '0',
`credit_pollvote` = '0',
`credit_attachment` = '0',
`credit_sendpm` = '0',
`credit_addevent` = '0',
`credit_addprofpic` = '0',
`credit_profile` = '0',
`credit_donmaxuser` = '-1',
`credit_pastotpost` = '-1',
`credit_pastotuser` = '-1',
`credit_pasawuser` = '-1',
`credit_pasawthread` = '-1',
`credit_saveint` = '0.2',
`credit_maxsave` = '-1',
`credit_loanint` = '0.2',
`credit_maxloan` = '100',
`credit_totloan` = '5000',
`credit_goodgroup` = '0',
`credit_midgroup` = '0',
`credit_badgroup` = '0',
`credit_maxtickets` = '0',
`credit_lotdiscount` = '0',
`ugphelpcenter` = '1',
`forumpermissions` = '1048575',
`genericpermissions` = '503840447',
`solvedthreadpermissions` = '1',
`attachlimit` = '0',
`pmquota` = '65535',
`pmpermissions` = '7',
`pmsendmax` = '65535',
`calendarpermissions` = '63',
`wolpermissions` = '31',
`adminpermissions` = '3',
`genericoptions` = '55',
`profilepicmaxwidth` = '100',
`profilepicmaxheight` = '100',
`profilepicmaxsize` = '65535',
`avatarmaxwidth` = '100',
`avatarmaxheight` = '100',
`avatarmaxsize` = '20000',
`signaturepermissions` = '245759',
`sigpicmaxwidth` = '500',
`sigpicmaxheight` = '100',
`sigpicmaxsize` = '10000',
`sigmaxrawchars` = '0',
`sigmaxchars` = '0',
`sigmaxlines` = '0',
`sigmaxsizebbcode` = '7',
`sigmaximages` = '0',
`awspermissions` = '15'
WHERE usergroupid=6;

MySQL Error : Unknown column 'ugphelpcenter' in 'field list'
Error Number : 1054
Date : Saturday, April 26th 2008 @ 08:35:33 PM
Script : http://****.co.il/admincp/usergroup.php?do=update
Referrer : http://****.co.il/admincp/usergroup.php?do=edit&usergroupid=6
IP Address : ***
Username : ***
Classname : vb_database
in two Version

PaulSonny
27 Apr 2008, 13:59
It seems you are trying to use the package above on a vBulletin 3.6 Installation, when it is meant for 3.7.

I may suggest uninstalling and reinstalling with the 3.6 version.

Thanks, Paul.

PaulSonny
28 Apr 2008, 00:44
Beta 5 Released. We hope this to be the last beta.

With regards to the guests being able to view other guests ticket, I have made it so that it depends on IP address for the time being until I can come up with a more long term solution.

Thanks, Paul.

powerful_rogue
28 Apr 2008, 10:59
Hi,

I reuploaded all the new files, uinstalled the previous helpdesk and then imported the new one - however it looks like this :confused:

Boosted Panda
28 Apr 2008, 17:15
Same issue here as Powerful_Rogue

PaulSonny
28 Apr 2008, 20:09
Seems when I started another project I wasnt as careful as I thought I was and it mucked up a lot of phrases. (Transferred them to another product) Meaning the phrases did not export within the product.

Anyway, I'm not entirely sure whether I have caught all the phrases, so if anyone would be willing to try this product and tell if any further phrases are still missing and I will do my best to get everything back to normal.

I appreciate your patience.

Thanks, Paul.

IR15H
28 Apr 2008, 20:35
Thanks, that seems to have fixed most of them, but I found a couple;

ADMIN CP > HelpCenter> Department Management > Add New Department/Edit > Update returns Can not find phrase helpcenter_acp_redirect. It still works fine though.

Additionally, ADMIN CP > Usergroups > Usergroups manager > Edit user Group X

Can Manage Tickets
*BLANK*
Can Close Any Ticket

EDIT:

Also, when adding a new ticket, there is no Priority before the : Low/Medium/High.


EDIT 2:

I also now get a db error when I try to create a new ticket. it says the table helpcenter_department doesn't exist, it does. I have prefixes on my tables, so maybe that's causing the issue. Also, when I deleted all my departments, there is still a blank drop down box when adding a new ticket

mikexxx
28 Apr 2008, 20:43
vBulletin Options > [Also a blank line in the menu]

PaulSonny
28 Apr 2008, 22:20
Further update, try this one guys and let me know.

With regards to the DB error, remove previous version and import this as fresh.

Thanks, Paul.

IR15H
28 Apr 2008, 22:31
The phrases are fixed, but the DB error is still occurring for me.

I uninstalled the old product and checked the tables were dropped, they were. I installed the new product and the tables are back, but it still comes up saying it doesn't exist. The table it says doesn't exist, doesn't exist, as it doesn't have the prefix I've assigned it (it's databasename.helpcenter_department instead of databasename.prefix_helpcenter_department). If anyone else with table prefixes could post saying if they're getting errors too, or even if it's working for them that would help.

PaulSonny
28 Apr 2008, 22:34
Is it possible for me to test on your website?

Thanks, Paul.

Hostboard
28 Apr 2008, 23:08
Fresh install and was surprised to find everything is disaray. Read through and see there were some small complications. Will wait until things are back in sorts.

Thanx for a great modification.

PaulSonny
29 Apr 2008, 00:12
I have updated the original download to include the latest product file to fix a few errors I made.

With regards to your problem Irish, I have uninstall and re-install the HelpCenter product on PaulSonny.com and it worked without any Database Errors so i'm wondering if its something your doing. Can you provide me with a link?

Thanks, Paul.

Hostboard
29 Apr 2008, 01:37
In ACP > HelpCenter Main Settings I do not see any options to set up any departments. Maybe some place else?

NM see there is also a Help Center in the left menu. Can you possibly make all the configuration options in 1 location?

Hostboard
29 Apr 2008, 02:02
Auto close after X amount of days of in activity as defined in the ACP? This would then generate a PM to the user...


Title: Your Support Ticket XXX is Now Closed
Body: AUTOMATED NOTICE: Your support ticket has been closed due to X days of inactivity. However, if you require any further assistance, please:

Open a "link to new ticket", OR
"Link to Re-open" your ticket.
Your Support Team:
Link to Profiles of Admin | Link to Profiles of Admin | And so on...

Links support team could also be a new user group "support team" or one defined in the ACP

mikexxx
29 Apr 2008, 07:22
Further update, try this one guys and let me know.

With regards to the DB error, remove previous version and import this as fresh.

Thanks, Paul.Better ;)
In usergroep manger the name of the table is still missing.

And when i submit a new ticket i get a database error.

-----------------------

Database error in vBulletin 3.7.0 Release Candidate 4:

Invalid SQL:
INSERT INTO helpcenter_ticket(departmentid, tickettitle, message, priority, ownerid, ownerusername, lastreplyusername, lastreplyuserid, datelogged, datelastupdate, ipaddress, threadnum) VALUES ('1','test','test test test','3','1','Mike','Mike','1','1209449977','1209449977','0.0.0.0','0');

MySQL Error : Unknown column 'threadnum' in 'field list'
Error Number : 1054
Request Date : Tuesday, April 29th 2008 @ 08:19:37 AM
Error Date : Tuesday, April 29th 2008 @ 08:19:38 AM
Script : http://www.xxxxxxxnl/helpcenter.php?do=newticket
Username : Mike
Classname : vB_Database
MySQL Version : 5.0.45-enterprise-gpl

GoTTi
29 Apr 2008, 08:11
i just upgraded to beta 5 due to a error, so i uninstalled and reinstalled the mod, and looking in the usergroup under admin, there is no title on the help center area of options, its blank. but the radio buttons and options are there.

GoTTi
29 Apr 2008, 08:13
i had this same error. i uninstalled the mod, and reinstalled it and the error is gone. i think if u upgrade to the current version you will get the error...

as far as the title bar in the usergroup missing, mine is missing also.

Better ;)
In usergroep manger the name of the table is still missing.

And when i submit a new ticket i get a database error.

-----------------------

Database error in vBulletin 3.7.0 Release Candidate 4:

Invalid SQL:
INSERT INTO helpcenter_ticket(departmentid, tickettitle, message, priority, ownerid, ownerusername, lastreplyusername, lastreplyuserid, datelogged, datelastupdate, ipaddress, threadnum) VALUES ('1','test','test test test','3','1','Mike','Mike','1','1209449977','1209449977','0.0.0.0','0');

MySQL Error : Unknown column 'threadnum' in 'field list'
Error Number : 1054
Request Date : Tuesday, April 29th 2008 @ 08:19:37 AM
Error Date : Tuesday, April 29th 2008 @ 08:19:38 AM
Script : http://www.xxxxxxxnl/helpcenter.php?do=newticket
Username : Mike
Classname : vB_Database
MySQL Version : 5.0.45-enterprise-gpl

PaulSonny
29 Apr 2008, 14:25
I will sort the HelpCenter table phrase when I get home, with regards to the "MySQL Error : Unknown column 'threadnum' in 'field list'" I think there is something wrong within the product file for altering the table.

I will update the product so that it creates the table with the new field name, but it may mean everyone has to uninstall and re-install to get it working correctly.

If anyone could have a look at the product file and check the SQL Query (version 0.5) then i'd be grateful.

Thanks, Paul.

GoTTi
29 Apr 2008, 15:27
paul that error is only duplicating itself on upgrade. i tested it on 2 forums. must uninstall and reinstall mod to not have errory.

PaulSonny
29 Apr 2008, 18:03
ah right I understand now GoTTi and thanks for letting me know, I will fix the Usergroup phrase now.

Thanks, Paul.

IR15H
29 Apr 2008, 20:47
I figured out the DB error. The problem occurred with reading the table, rather than creating it, so the problem wasn't in the product file. Once I realised that I stopped looking in the wrong place and had a quick look in helpcenter.php. I figured out the error, and managed to fix it myself :D. If anyone else has prefixes on their SQL tables then do the following in helpcenter.php

SEARCH FOR;
$departmenttitle = $vbulletin->db->query_read("SELECT department FROM helpcenter_department WHERE departmentid = '" . intval($_REQUEST['departmentid']) . "'");

REPLACE WITH;
$departmenttitle = $vbulletin->db->query_read("SELECT department FROM " . TABLE_PREFIX . "helpcenter_department WHERE departmentid = '" . intval($_REQUEST['departmentid']) . "'");

...or just wait for Paul to update the zip :).

PaulSonny
29 Apr 2008, 23:19
Thanks Irish I have fixed this for the next release.

Thanks, Paul.

MikeHolohan
30 Apr 2008, 17:45
I figured out the DB error. The problem occurred with reading the table, rather than creating it, so the problem wasn't in the product file. Once I realised that I stopped looking in the wrong place and had a quick look in helpcenter.php. I figured out the error, and managed to fix it myself :D. If anyone else has prefixes on their SQL tables then do the following in helpcenter.php

SEARCH FOR;
$departmenttitle = $vbulletin->db->query_read("SELECT department FROM helpcenter_department WHERE departmentid = '" . intval($_REQUEST['departmentid']) . "'");

REPLACE WITH;
$departmenttitle = $vbulletin->db->query_read("SELECT department FROM " . TABLE_PREFIX . "helpcenter_department WHERE departmentid = '" . intval($_REQUEST['departmentid']) . "'");

...or just wait for Paul to update the zip :).

Well done, works well... Mike.