microSUPPORT for vB4

[MaryTheG(r)eek]

*** Link Removed ***

[jaytech]

upload it then lol..

[garretbyrne]

Hi I've installed it, I've created the departments but nothing shows up.. then I start to get the following problem..

Warning: Division by zero in [path]/includes/functions.php on line 2498
Database error

[MaryTheG(r)eek]

upload it then lol..

...lol... It was there, but instead to upload photos I removed the file:rolleyes:

[MaryTheG(r)eek]

Hi I've installed it, I've created the departments but nothing shows up.. then I start to get the following problem..

Warning: Division by zero in [path]/includes/functions.php on line 2498
Database error


At admicp->Options have you setup to use Departments and/or Products?

[garretbyrne]

I've setup two Departments... No products

[MaryTheG(r)eek]

I've setup two Departments... No products

Seems that there is a bug there. If you turn both ON, it will work. I wrote it down for correction.

Maria

[garretbyrne]

I enabled the product and thats fine.... but now I'm having an issue with checking the tickets... when I click my tickets for example I get..

support.php?do=mytickets

Warning: Division by zero in [path]/includes/functions.php on line 2498
Database error

[RamisK]

Very nice komsu

[MaryTheG(r)eek]

I enabled the product and thats fine.... but now I'm having an issue with checking the tickets... when I click my tickets for example I get..

support.php?do=mytickets

Warning: Division by zero in [path]/includes/functions.php on line 2498
Database error

I'm working on it, but it's already late in Greece I believe that I post the update tomorrow morning. If you want add a dammy product to avoid getting this errror.

Maria

[Charlie98902]

Thank you for this tagged for when VB goes gold.

Question though: Is it going to have the old VB3 look or the new VB4 look? It appears to use the VB3 look.

[Kolbi]

Nice product :)

[MaryTheG(r)eek]

Thank you for this tagged for when VB goes gold.


Question though: Is it going to have the old VB3 look or the new VB4 look? It appears to use the VB3 look.

Your eyesight is perfect:-)) It uses the new deafult VB template. You can see it on the first screenshoots. All other screenshoot are for the vb3 version. I haven't time to get new screenshoots:D

[Charlie98902]

Okay thanks for the update to my questions. Now get some rest :D

[Mythotical]

Just so you know, you have an uncached template:
microsupport_support_navbar

[Mythotical]

Found a database error:
Database error in vBulletin 4.0.0 Beta 5:

Invalid SQL:
SELECT * FROM microsupport_departments WHERE id= LIMIT 1;

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 'LIMIT 1' at line 1
Error Number : 1064
Request Date : Sunday, December 13th 2009 @ 06:37:59 PM
Error Date : Sunday, December 13th 2009 @ 06:37:59 PM
Script : support.php?do=replyticket&ticketid=
Referrer : support.php?do=tickets
Classname : vB_Database
MySQL Version : 5.0.85-community

[g00gl3r]

Brilliant Maria, thanks. Saved for future use. :)

[MaryTheG(r)eek]

Found a database error:
Database error in vBulletin 4.0.0 Beta 5:

Invalid SQL:
SELECT * FROM microsupport_departments WHERE id= LIMIT 1;

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 'LIMIT 1' at line 1
Error Number : 1064
Request Date : Sunday, December 13th 2009 @ 06:37:59 PM
Error Date : Sunday, December 13th 2009 @ 06:37:59 PM
Script : support.php?do=replyticket&ticketid=
Referrer : support.php?do=tickets
Classname : vB_Database
MySQL Version : 5.0.85-community

Yes, there is a post for it before. Maybe I forgot an "if" or "elseif" when any of departments/products is turned off.

Maria

[bart6767]

Thanks very much and cant wait for the fix tomorro .

[Charlie98902]

Another quick question. I assume that if one user posts a ticket that another user can not see it? Meaning the ticket poster can't see other tickets and such. Also is there a way for this to notify you when a ticket poster post replies as a notification? Is that even possible if not current? By notifying I mean like you get a PM it lets you know. Also in the ticket system is there like a auto prefix? To use an example....A person posts a ticket. The ticket automatically says pending or something till a staff member replies then when a staff member replies it have a prefix like awaiting for more info from user or like that if you get my drift. Kind of like when you would post a support ticket to your server people. I'll post a screenie on that. I hope the screenie helps you understand what I am asking. Now this is using some sort of portal but is used as an example only.

[taffy056]

This will be a great product once you sort out the database problem that I am having like the ones above, look forward to the fix and using this - thanks!

[taffy056]

Can I just add, there doesn't appear to be usergroup control, I want certain usergroups to answer certain questions, is that possible? thanks

[shadowedsoul]

Am I missing a place to change the priority of a ticket? Other than that awesome addon.

[garretbyrne]

Hi I added the department and product, I also created a ticket.. but when I click my tickets is when i got the last error...

[Mythotical]

If you got the error I listed above, please upload this file and overwrite the existing one, it will fix the error.

Maria, god bless her hard work, forgot to add the variable to the template register.

[MaryTheG(r)eek]

Am I missing a place to change the priority of a ticket? Other than that awesome addon.

I'm using a different approach for ticket priority. Instead to let the user choose priority (99% always choose "Highest"), the priority goes according to usergroup permissions. So if you've a paid usergroup it's normal to assign them highest priority than another free usergroup.

Maria

[MaryTheG(r)eek]

If you got the error I listed above, please upload this file and overwrite the existing one, it will fix the error.

Maria, god bless her hard work, forgot to add the variable to the template register.

...lol... THANK you Steve!! Do you believe in telepathy? When I was enoying my morning coffee before, I was thinking for this bug, and then came to my mind that you most probably didn't liked seeing a bug without to try to fix it:D

Once more thank you for your valuable help.
Maria

[Mythotical]

...lol... THANK you Steve!! Do you believe in telepathy? When I was enoying my morning coffee before, I was thinking for this bug, and then came to my mind that you most probably didn't liked seeing a bug without to try to fix it:D

Once more thank you for your valuable help.
Maria

LOL, your welcome. Yes I believe in telepathy. I hate seeing bugs and it eats me up if I don't attempt to fix it. I usually don't post fixes but here lately I found that if I provide fixes for other's stuff then good fortune will come my way eventually, no rush for it though. Plus no matter what, without fixing it and at least providing a fellow coder help, when I need help I may not get any.

Again you're welcome, it is now early morning, time for me to go to bed.

[MaryTheG(r)eek]

Can I just add, there doesn't appear to be usergroup control, I want certain usergroups to answer certain questions, is that possible? thanks

Currently not. Maybe in the future I'll setup option to assign technicians per category.
For now you can assign technician permissions to any usergroup you want to reply tickets.

Maria

[MaryTheG(r)eek]

Another quick question. I assume that if one user posts a ticket that another user can not see it? Meaning the ticket poster can't see other tickets and such.
Correct. Tickets are private and not public.

Also is there a way for this to notify you when a ticket poster post replies as a notification? Is that even possible if not current? By notifying I mean like you get a PM it lets you know.
User is notifying by email. The email is configurable at General Options.

Also in the ticket system is there like a auto prefix? To use an example....A person posts a ticket. The ticket automatically says pending or something till a staff member replies then when a staff member replies it have a prefix like awaiting for more info from user or like that if you get my drift. Kind of like when you would post a support ticket to your server people. I'll post a screenie on that. I hope the screenie helps you understand what I am asking. Now this is using some sort of portal but is used as an example only.

There are 4 predefinied statuses: Open, Hold (means awaiting response), Closed. User can reopen a closed ticket.

Maria

[bart6767]

I have tryed the fix and i still get this when i click tickets to do .

Database error in vBulletin 4.0.0 Release Candidate 2:

Invalid SQL:

SELECT *
FROM microsupport_tickets
WHERE needaction=1 AND status<>3
ORDER BY priority ASC, updated ASC
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 5
Error Number : 1064
Request Date : Monday, December 14th 2009 @ 10:15:16 AM
Error Date : Monday, December 14th 2009 @ 10:15:16 AM
Script : http://www.randalstowncsc.net/support.php?do=tickets
Referrer : http://www.randalstowncsc.net/support.php?do=main
IP Address : 86.131.168.108
Username : Paul67
Classname : vB_Database
MySQL Version : 5.0.85-community-log

[Harley D]

Seems that there is a bug there. If you turn both ON, it will work. I wrote it down for correction.

Maria
Your 3.8 version does this as well.

[MaryTheG(r)eek]

LIMIT 0,;


The error comes after ','. Normally there should be the number of tickets per page. I need to check what new has added in construction page navigation.

Maria

[bart6767]

The error comes after ','. Normally there should be the number of tickets per page. I need to check what new has added in construction page navigation.

Maria

How do i fix this then ?

[MaryTheG(r)eek]

Your 3.8 version does this as well.

Yes I seen it. It's a typo on file support.php line 466.
Instead of:

if($vbulletin->options["microsupport_products"])
{
$products = getProducts($ticket["productid"]);
}
if($vbulletin->options["microsupport_products"])
{
$departments = getDepartments($ticket["departmentid"]);
}

Must be:

if($vbulletin->options["microsupport_products"])
{
$products = getProducts($ticket["productid"]);
}
if($vbulletin->options["microsupport_departments"])
{
$departments = getDepartments($ticket["departmentid"]);
}


I've wrote again microsupport_products in 2nd condition instead the correct microsupport_departments

Maria

[MaryTheG(r)eek]

How do i fix this then ?

I need to fix it, not you:). First I need to check if all listings have the same problem (in case that I forgot a variable), and if not I'll try to find the solution checking the native vb files.

Maria

[Charlie98902]

Maria, Thanks for the response, but what I was wondering I see it isn't right now but is it possible to get a forum home notification when there was a reply so one wouldn't have to sit there and wait. They may reply but if I was out how would I know without manually go there looking? Is this possible in future releases or is that something that would be too hard to add? Even a email showing it has been replied to would be nice.

[bart6767]

I need to fix it, not you:). First I need to check if all listings have the same problem (in case that I forgot a variable), and if not I'll try to find the solution checking the native vb files.

Maria

Thanks very much for your help .

[Giangy94]

Hi MicroHellas,

I find this prodct very interesting So I decided to try it. Thanks for sharing :)


However I have had two database errors, here: support.php?do=tickets
Database error in vBulletin 4.0.0 Release Candidate 2:

Invalid SQL:

SELECT *
FROM microsupport_tickets
WHERE needaction=1 AND status<>3
ORDER BY priority ASC, updated ASC
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 5
Error Number : 1064

And the second here: support.php?do=mytickets
Database error in vBulletin 4.0.0 Release Candidate 2:

Invalid SQL:

SELECT *
FROM microsupport_tickets
WHERE userid=2
ORDER BY updated 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 5
Error Number : 1064

[MaryTheG(r)eek]

Hi MicroHellas,

I find this prodct very interesting So I decided to try it. Thanks for sharing :)


However I have had two database errors, here: support.php?do=tickets
Database error in vBulletin 4.0.0 Release Candidate 2:

Invalid SQL:

SELECT *
FROM microsupport_tickets
WHERE needaction=1 AND status<>3
ORDER BY priority ASC, updated ASC
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 5
Error Number : 1064

And the second here: support.php?do=mytickets
Database error in vBulletin 4.0.0 Release Candidate 2:

Invalid SQL:

SELECT *
FROM microsupport_tickets
WHERE userid=2
ORDER BY updated 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 5
Error Number : 1064

Hello,

On the same page here (Posts 33 & 36), you'll find the answer. I'm working on it.

Maria

[MaryTheG(r)eek]

@ bart6767
@ Giangy94
--------------------------------

Could you please tell me your which beta version are you using? I can't duplicate your errors on my site using Beta 5. There was a native vB bug on pagination but fixed (?) at Beta 5.

Maria

[bart6767]

@ bart6767
@ Giangy94
--------------------------------

Could you please tell me your which beta version are you using? I can't duplicate your errors on my site using Beta 5. There was a native vB bug on pagination but fixed (?) at Beta 5.

Maria

vBulletin? Version 4.0.0 Release Candidate 2

[MaryTheG(r)eek]

vBulletin? Version 4.0.0 Release Candidate 2

Please try the attached file. Overwrite the old one.

Maria

[TheLastSuperman]

If I install this today will it be gone tomorrow?

Removed by the Author because:

Removed by S-MAN, thanks for clearing that up.

Maria

Otherwise it seems odd to even attempt installing it tbo. I like you and our mods just not the way you have handled them here in the past so before I even go through the trouble I'm simply asking you nicely is this worth my time?

Thanks

Mike

[MaryTheG(r)eek]

If I install this today will it be gone tomorrow?

Otherwise it seems odd to even attempt installing it tbo. I like you and our mods just not the way you have handled them here in the past so before I even go through the trouble I'm simply asking you nicely is this worth my time?

Thanks
Mike

Hello Mike,

Last days of October I had got a shock by wakingup in the middle of the night blonding from my mouth and my back and with an increadible pain in my stomach. Thanks to God I was early to the Hospital where I had a emergency surgery lasting 5 1/2 trying to clear my inside from food and liquid that my exploded stomach droped around. I stayed hospitalization for 35 days.

After that, I decided to make my life easier. In other words to not care of anything. As you can see I didn't even placed a copyright to avoid fight with those who are removing it. So, as from me, they'll stay here.

Maria

[TheLastSuperman]

Hello Mike,

Last days of October I had got a shock by wakingup in the middle of the night blonding from my mouth and my back and with an increadible pain in my stomach. Thanks to God I was early to the Hospital where I had a emergency surgery lasting 5 1/2 trying to clear my inside from food and liquid that my exploded stomach droped around. I stayed hospitalization for 35 days.

After that, I decided to make my life easier. In other words to not care of anything. As you can see I didn't even placed a copyright to avoid fight with those who are removing it. So, as from me, they'll stay here.

Maria

Wow... very sad to hear that and glad to see your doing good... I reckon we all took it the wrong way how you just pulled the mods and the message you left in them lead us to believe otherwise but such is life when your sick and sometimes it's similar to the plain ole' version of being sick... well the so sick you just don't care... want the fan, a cold rag, and a trashcan nearby maybe with a coke to sip on or in your case that same feeling but 1000x worse :(.

Again, sorry to hear that and I'll put this mod to good use... next time you have troubles contact another good coder and maybe *cough *cough they'll temporarily support your mods while your gone :p

Mike

[bart6767]

Please try the attached file. Overwrite the old one.

Maria

Tryed that and still get this .

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


Database error in vBulletin 4.0.0 Release Candidate 2:

Invalid SQL:

SELECT *
FROM microsupport_tickets
WHERE needaction=1 AND status<>3
ORDER BY priority ASC, updated ASC
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 5
Error Number : 1064
Request Date : Monday, December 14th 2009 @ 02:07:54 PM
Error Date : Monday, December 14th 2009 @ 02:07:54 PM
Script : http://www.randalstowncsc.net/support.php?do=tickets
Referrer : http://www.randalstowncsc.net/support.php
IP Address : 86.131.168.108
Username : paul44
Classname : vB_Database
MySQL Version : 5.0.85-community-log

[Giangy94]

Please try the attached file. Overwrite the old one.

Maria

Tried without to resolve the problem, I have had the same errors as before :(

[shadowedsoul]

I'm using a different approach for ticket priority. Instead to let the user choose priority (99% always choose "Highest"), the priority goes according to usergroup permissions. So if you've a paid usergroup it's normal to assign them highest priority than another free usergroup.

Maria

Gotcha, I was more thinking a priority that the techs could set, like as a drop down on the ticket when you are putting replies on it would be very cool. I would never think of allowing users to set the priority.

[MaryTheG(r)eek]

Sorry to see that my instructions haven't fixed your problem. Unfortunatelly I can't duplicate your issue. If you login with: demouser/demopass at:
http://www.microhellas.com/main/support.php
you'll see that there is no error. I'm also sure that if you add some dammy tickets, after the 5th you'll see the page navigation too.

So, the last common reason is a coflist with another 3nd party mod.

Maria

[Giangy94]

youll see that there is no error.

You are using beta 5, we're using Rc2 :erm:


the last common reason is a coflist with another 3nd party mod.


No, I disinstalled the others two mods withous to resolve the problem :rolleyes:

[MaryTheG(r)eek]

You are using beta 5, we're using Rc2 :erm:


Yes, I know. But this version must be max 2 days old, because when I downloaded my bete (on Friday evening), this one (Beta 5) was the newest version.

Maybe is better to wait for a fix. Is common with any new release, some new features to conflist with something else. Especially with pagination which was a problem from the early betas, as it was accepting only hard coding "20" records.

Maria

[Mythotical]

Maria, I can confirm the error. I just upgraded to RC2 and it does exist. I can only assume something changed between Beta 5 and RC2 as I tested this on RC1 and it worked but now it doesn't on RC2. Very very odd.

EDIT: Forgot they skipped RC1 basically.

[Giangy94]

Maybe is better to wait for a fix.

Yes, I agree with you :)


Maybe in vb 4 gold there will be other changes which will create others conflicts :D:D

[taffy056]

Nope still getting an error even after uploading the new updated files to the server

Database error in vBulletin 4.0.0 Release Candidate 2:

Invalid SQL:

SELECT *
FROM microsupport_tickets
WHERE userid=1
ORDER BY updated 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 5
Error Number : 1064
Request Date : Monday, December 14th 2009 @ 05:50:27 PM
Error Date : Monday, December 14th 2009 @ 05:50:27 PM
Script : http://www.test.net/forums/support.php?do=mytickets

[bart6767]

This is really a good Mod and its a pitty its not working on RC2.

Maybe there will be a fix soon .

[Charlie98902]

Why rush a fix for RC2 we may get to install RC3. It would be nice but I just have this mod tagged for gold as I knew updates in betas/RC's would break it.

[MaryTheG(r)eek]

Nope still getting an error even after uploading the new updated files to the server

Database error in vBulletin 4.0.0 Release Candidate 2:


As you can read above your post, its a bug of RC2. Worked fine with Beta 5.

Maria

[MaryTheG(r)eek]

I want to remind all my friends here, who're feeling uncomfortable getting that dammit database errors, that even if we don't like them, they're normal. vB4 is still unstable. But like me, you also like to try anything new. So, please have patience. As you can see I'm here, and always trying to solve the issues as sooner as I can. But only issue coming from my side (eg when I've forgot to register a variable, or when I've wrote products instead departments).

But to try to find what's wrong when something don't works with RC2, while it was working with previous version (Beta 5), means that I've to compare many vB files, something not so easy.

Be sure that I'll do my best, and if I'll see that this mod gets some popularity (eg 50 installations), I've many ideas to improve it, with first coming "Predefinied replies".

Thank you
Maria

[Charlie98902]

Thanks Maria and I hope everyone can have patients now.

[taffy056]

Maria,

Sorry didn't mean to sound as if I pressuring you, its on a testing site so its not urgent or anything, just thought i'd tell you the error message so you can work on it. As I said previously this is going to be a great hack once things are sorted. - Thanks :)

[Harley D]

Yes I seen it. It's a typo on file support.php line 466.
Instead of:

if($vbulletin->options["microsupport_products"])
{
$products = getProducts($ticket["productid"]);
}
if($vbulletin->options["microsupport_products"])
{
$departments = getDepartments($ticket["departmentid"]);
}

Must be:

if($vbulletin->options["microsupport_products"])
{
$products = getProducts($ticket["productid"]);
}
if($vbulletin->options["microsupport_departments"])
{
$departments = getDepartments($ticket["departmentid"]);
}


I've wrote again microsupport_products in 2nd condition instead the correct microsupport_departments

Maria

Thank You. :)
That did the trick. :up:

[Vaupell]

nice, thank you.. Tagged, but waiting until its out its beta.. :D

[MaryTheG(r)eek]

Maria,

Sorry didn't mean to sound as if I pressuring you, its on a testing site so its not urgent or anything, just thought i'd tell you the error message so you can work on it. As I said previously this is going to be a great hack once things are sorted. - Thanks :)

No, don't worry. Honestly I was talking in general, not meaning someone.

Maria

[Varsh]

Tagged and will most definitely be using this in the near future. :)

[bart6767]

Not working on vBulletin 4.0.0 Release Candidate 4:

[Trek]

Yeah, I'll check it out when it's gold. Doesn't matter to me if it works on Beta 5... It's gotta work on gold. ;) Looks good though and I'd like to use it when it's ready.

[Edrondol]

I want to remind all my friends here, who're feeling uncomfortable getting that dammit database errors, that even if we don't like them, they're normal. vB4 is still unstable. But like me, you also like to try anything new. So, please have patience. As you can see I'm here, and always trying to solve the issues as sooner as I can. But only issue coming from my side (eg when I've forgot to register a variable, or when I've wrote products instead departments).

But to try to find what's wrong when something don't works with RC2, while it was working with previous version (Beta 5), means that I've to compare many vB files, something not so easy.

Be sure that I'll do my best, and if I'll see that this mod gets some popularity (eg 50 installations), I've many ideas to improve it, with first coming "Predefinied replies".

Thank you
Maria

Most people - myself included - won't mark installed on a test site and are waiting for v4 Gold before upgrading our site. Don't look at the number of marked installs as an indication of popularity. This is an awesome mod and will be VERY popular once the bugs get worked out.

[adusei]

Most people - myself included - won't mark installed on a test site and are waiting for v4 Gold before upgrading our site. Don't look at the number of marked installs as an indication of popularity. This is an awesome mod and will be VERY popular once the bugs get worked out.

Yes, I totally agree to this! Hope, it will work soon. So far: Good job, awesome!

[VonDoom]

I am also eying this mod with great enthusiasm. looking forward to gold. vB is releasing RC's so fast i didn't even realize until a few hrs ago RC4 was available. This mod looks very promising and cant wait for gold to try it out. Keep up the great work Maria..

PS, its good to see your work back on .org

[MaryTheG(r)eek]

I am also eying this mod with great enthusiasm. looking forward to gold. vB is releasing RC's so fast i didn't even realize until a few hrs ago RC4 was available. This mod looks very promising and cant wait for gold to try it out. Keep up the great work Maria..

PS, its good to see your work back on .org

Yes, that's true about RC's. Last Friday I downloaded Beta 5, on Sunday someone was talking for RC2, yesterday for RC4 and some hours ago, I got email from vB.com that they'll release Gold on Monday. So, I prefer to wait till Monday. Meanwhile I'm writting down some improvments. So, except predefinied replies, I think that I must add a choice to Technicians to change priority, plus to auto generate FAQ from a Ticket. Also I'm working on a Auctions mod. Didn't found anything here, so I thought that maybe should be helpfull.

Maria

[Nadeemjp]

hi there, i would like to install the micromembers, do you plan on releasing it for vb4?

[Dr.osamA]

Database error in vBulletin 4.0.0 Release Candidate 4:

Invalid SQL:

SELECT *
FROM microsupport_tickets
WHERE userid=1
ORDER BY updated 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 5
Error Number : 1064
Request Date : Saturday, December 19th 2009 @ 02:06:54 AM
Error Date : Saturday, December 19th 2009 @ 02:06:54 AM
Script : http://www.alra7ba.net/forums/support.php?do=mytickets
Referrer : http://www.alra7ba.net/forums/support.php?do=main&catid=1
IP Address : 91.144.44.68
Username : Dr.osamA
Classname : vB_Database
MySQL Version : 5.0.85-community

any help ??

[Charlie98902]

Yea we are awaiting for an update. Probably after gold.

[M_Portiss]

Installed on RC4. Thanks! This is perfect for the users to help me track down bugs! I can wait for the issues to be fixed.

Your hacks are great! Thanks!

[MaryTheG(r)eek]

[php]Database error in vBulletin 4.0.0 Release Candidate 4:
any help ??

Check previous posts. It's a bug in pagination, which appeared at RC2 while it was working fine till Beta 5. I'm waiting the Gold release on Monday to fix it.

Maria

[MaryTheG(r)eek]

hi there, i would like to install the micromembers, do you plan on releasing it for vb4?

This version is for vB4.

Maria

[steven s]

Does anyone have a live demo of the FAQ system?
This might just be what I'm looking for.

[iamspookysdaddy]

Hi Maria,

Very awesome mod indeed! Thanks for your great work here. Just as an FYI I did an install on Gold and got the following error...

Brian

Warning: Division by zero in [path]/includes/functions.php on line 2503
Database error
The Victorious Christians Forums database has encountered a problem.

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

Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the 208.43.23.140 home page, then try to open another page.
Click the Back button to try another link.

The 208.43.23.140 forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.

[Charlie98902]

She's aware of this and I am sure she is working on it.

[Mrquarter2]

Well gold is out now. Hopefully this will be fixed.

[MaryTheG(r)eek]

Hello,

Sorry for the delay on posting the bug fixes, but I spent my day yesterday to code some toys (widgets) for CMS. I just uploaded the new version which fixes the reported bug in pagination, plus 2 others that I found.


In "All FAQ" listing the droplist action was wrong.
The Average Responce Time, was showing wrong time.All the above bugs fixed. Please note that from now I'll discontinue supporting vB3.x versions, and I'll continue only with vB4. As these versions are totally different in coding and templating, should be a waste of time to work on both.

Now I'm working in a Auction Classifieds mod, so keep an eye here.

Take care
Maria

[Vaupell]

Gonna try it right away :D - brb with a response.

installed, testet a little, plugin tab disabled, using another link in a dropdown menu..
so rated 5 stars, marked installed..

Abselutely great software..

[Naxon]

I'm getting these errors on the top of the page when I enter the HelpDest:

Deprecated: Assigning the return value of new by reference is deprecated in C:\wamp\www\vb\support.php on line 363

Deprecated: Assigning the return value of new by reference is deprecated in C:\wamp\www\vb\support.php on line 405

vB 4.0 PL 1

[MaryTheG(r)eek]

I'm getting these errors on the top of the page when I enter the HelpDest:


vB 4.0 PL 1

I'm using the same version and I'm not getting any errors
http://www.microhellas.com/dev4/support.php

Have you setup categories etc?

Maria

[bart6767]

Every thing works fine now other than when you go to support.php?do=tickets and click on the Title i get the below error. but it works fine if i click the Action .

Database error in vBulletin 4.0.0:

Invalid SQL:
SELECT * FROM microsupport_departments WHERE id= LIMIT 1;

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 'LIMIT 1' at line 1
Error Number : 1064
Request Date : Wednesday, December 23rd 2009 @ 12:55:50 PM
Error Date : Wednesday, December 23rd 2009 @ 12:55:50 PM
Script : http://www.randalstowncsc.net/support.php?do=replyticket&ticketid=
Referrer : http://www.randalstowncsc.net/support.php?do=tickets
IP Address : 86.173.109.148
Username : The Voice of champions
Classname : vB_Database
MySQL Version : 5.0.85-community-log

[LbR]

I guess, this is a thing that my forum requires thanks maria :)

[Naxon]

I'm using the same version and I'm not getting any errors
http://www.microhellas.com/dev4/support.php

Have you setup categories etc?

Maria
I haven't done anything yet. I just installed my vBulletin forum (fresh install, not an upgrade) and right after I installed microSUPPORT...

[MaryTheG(r)eek]

I haven't done anything yet. I just installed my vBulletin forum (fresh install, not an upgrade) and right after I installed microSUPPORT...

You need to go throught the setup (microSUPPORT at admincp) and then to assign usergroup permissions.

Maria

[taffy056]

Maria,

Just so you'll know I am getting a database error as well like Bart above, its on Tickets ToDo and when you click on a ticket

Best wishes for the season if you don't have the time right now to do anything

Craig

[Naxon]

You need to go throught the setup (microSUPPORT at admincp) and then to assign usergroup permissions.

Maria

Already done...

[tyfoon]

Maria,

Just so you'll know I am getting a database error as well like Bart above, its on Tickets ToDo and when you click on a ticket

Best wishes for the season if you don't have the time right now to do anything

Craig


Solution , change

<?php
// Setup PHP Enviropment
error_reporting(E_ALL & ~E_NOTICE);
// Define Contants
define('THIS_SCRIPT', 'support');
// Cache Templates & Variables
// get special phrase groups
$phrasegroups = array(
'microsupport',
'postbit',
'posting'
);
$specialtemplates = array(
'smiliecache',
'bbcodecache',
'attachmentcache',
);

in

<?php
// Setup PHP Enviropment
error_reporting(E_ALL & ~E_NOTICE);
// Define Contants
define('THIS_SCRIPT', 'support');
// Cache Templates & Variables
// get special phrase groups
$phrasegroups = array(
'microsupport',
'postbit',
'posting'
);
$specialtemplates = array(
'smiliecache',
'bbcodecache',
'attachmentcache'
);

[MikalMirkas]

I'll just use Projects, good mod anyway!

[taffy056]

Nope didn't work for, here is the error I am getting if that helps, thanks anyway :)

Database error in vBulletin 4.0.0:

Invalid SQL:
SELECT * FROM microsupport_departments WHERE id= LIMIT 1;

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 'LIMIT 1' at line 1
Error Number : 1064
Request Date : Wednesday, December 23rd 2009 @ 06:45:20 PM
Error Date : Wednesday, December 23rd 2009 @ 06:45:20 PM
Script : http://www.website.net/forums/support.php?do=replyticket&ticketid=
Referrer : http://www.website.net/forums/support.php?do=tickets
IP Address : 0.0.152.18
Username : name
Classname : vB_Database
MySQL Version : 5.0.88-community

[tyfoon]

@taffy did you turn departments on in the admincp ?

and specified them there ?

[MaryTheG(r)eek]

Hello,

A bug reported for database error when clicking on ticket's title (Tickets ToDo). My apologies, a var declaration has left out there. Just upload support.php from the new ziped file.

Again sorry
Maria

[MaryTheG(r)eek]

Nope didn't work for, here is the error I am getting if that helps, thanks anyway :)

Database error in vBulletin 4.0.0:

Invalid SQL:
SELECT * FROM microsupport_departments WHERE id= LIMIT 1;

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 'LIMIT 1' at line 1
Error Number : 1064
Request Date : Wednesday, December 23rd 2009 @ 06:45:20 PM
Error Date : Wednesday, December 23rd 2009 @ 06:45:20 PM
Script : http://www.website.net/forums/support.php?do=replyticket&ticketid=
Referrer : http://www.website.net/forums/support.php?do=tickets
IP Address : 0.0.152.18
Username : name
Classname : vB_Database
MySQL Version : 5.0.88-community

Fixed. Sorry for troubles.

Maria

[bart6767]

Fixed. Sorry for troubles.

Maria

Nice one that works .

[taffy056]

Okay Maria that fixed that problem - thanks :)

But have another now, you know when you go to the ticket in the todo section, when you reply to the ticket I get a

500 Internal Server Error

when I refresh the message it is there

[bart6767]

Okay Maria that fixed that problem - thanks :)

But have another now, you know when you go to the ticket in the todo section, when you reply to the ticket I get a

500 Internal Server Error

when I refresh the message it is there

I just tryed that and it works for me .

[taffy056]

I just tryed that and it works for me .

Well I completely uninstalled the hack, downloaded the new version and updated everything, but the 501 error still happens

[valendono]

Database error in vBulletin 4.0.0:

Invalid SQL:

SELECT *
FROM microsupport_tickets
WHERE needaction=1 AND status<>3
ORDER BY priority ASC, updated ASC
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 5
Error Number : 1064
Request Date : Thursday, December 24th 2009 @ 03:16:49 AM
Error Date : Thursday, December 24th 2009 @ 03:16:49 AM
Script : http://localhost/support.php?do=tickets
IP Address : 192.168.1.100
Username : valendono
Classname : vB_Database
MySQL Version : 5.1.37

also I got problem on

Database error in vBulletin 4.0.0:

Invalid SQL:

SELECT *
FROM microsupport_tickets
WHERE userid=29275
ORDER BY updated 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 5
Error Number : 1064
Request Date : Thursday, December 24th 2009 @ 03:19:06 AM
Error Date : Thursday, December 24th 2009 @ 03:19:06 AM
Script : http://localhost/support.php?do=mytickets
Referrer : http://localhost/support.php?do=newticket
IP Address : 192.168.1.100
Username : valendono
Classname : vB_Database
MySQL Version : 5.1.37

What is the problem ?

[valendono]

sorry my bad.. forgot to update the files.. its work.. check installed.. tq

[bart6767]

Why is it when you post a Photo that it only shows the link ?

Should the pic not show in the Ticket or FAQ ?

[valendono]

report again when u put FAQ, I cannt use WYSIWYG from forum, its html only.. there way to use forum form ?

[Mrquarter2]

Great job! it works :)

[valendono]

I got this problem

Database error in vBulletin 4.0.0:

Invalid SQL:
SELECT * FROM microsupport_departments WHERE id= LIMIT 1;

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 'LIMIT 1' at line 1
Error Number : 1064
Request Date : Thursday, December 24th 2009 @ 05:08:50 AM
Error Date : Thursday, December 24th 2009 @ 05:08:51 AM
Script : http://localhost/support.php?do=replyticket&ticketid=
Referrer : http://localhost/support.php
IP Address : 192.168.1.100
Username : valendono
Classname : vB_Database
MySQL Version : 5.1.37



when ticket already closed and admin wanna see again in Techmenu >> Tickets ToDo >> Closed Filter and click on Title ticket and that happen...

[KozmoK]

Is this fully working on 4.0 Gold PL1? I installed on RC4 but received many SQL exceptions.

[MaryTheG(r)eek]

Is this fully working on 4.0 Gold PL1? I installed on RC4 but received many SQL exceptions.

Current zip file works fine on my 4.0.1 PL. The only bug that still exists, is that one just over your post.

Maria

[taffy056]

Maria can you tell me what could be causing the 500 Internal Server Error I am getting in post 99, its still happening - thanks

[KozmoK]

This installed Great! Thank you very much for your hard work!

Koz


Edit:

Getting sql errors when adding FAQ's... seems like when I make them long and have links in them it acts up.

Also when I click on Help Desk support nav link, it shows the page, but has a error in the status bar below:

Shows Done, but with errors:

Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.1; WOW64; Trident/4.0; GTB6.3; SLCC2; .NET CLR 2.0.50727; .NET CLR 3.5.30729; .NET CLR 3.0.30729; Media Center PC 6.0)
Timestamp: Sat, 26 Dec 2009 01:32:25 UTC


Message: 'vB_XHTML_Ready' is undefined
Line: 11
Char: 1
Code: 0
URI: http://xxxxxxx/forums/clientscript/vbulletin-editor.js?v=400

[kf4eok]

I love the idea, will install when beta is complete.

[KozmoK]

I noticed people are allowed to enter tickets without selecting a product, is there a way to force them? I have been doing direct sql edits to fix them.

[wildweaselmi]

I just re-downloaded this great mod (in the event the fix has been applied) and I still get the following error on my VB4 PL1

Database error in vBulletin 4.0.0:

Invalid SQL:
INSERT INTO vb_microsupport_faq
SET categoryid='11',
question='Does my Blue Screen during bootup mean I lost my data?',
answer='No you haven't lost your data but without some help it may not be very easily accessible. We have a few different tricks up our sleeves to help get your data backed up and then see if we can make that blue screen go away which may include re-loading windows an restoring your data, but that's a last resort.',
important = '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 't lost your data but without some help it may not be very easily accessible. We' at line 4
Error Number : 1064
Request Date : Monday, December 28th 2009 @ 02:45:00 PM
Error Date : Monday, December 28th 2009 @ 02:45:00 PM
Script : http://www.mywiseguys.com/forums/support.php?do=saveupdatefaq
Referrer : http://www.mywiseguys.com/forums/support.php?do=addeditfaq
IP Address : 24.11.27.21
Username : wildweaselmi
Classname : vB_Database
MySQL Version : 5.1.41

I read in your previous post that you are unable to reproduce the issue so this is what I found out.

Use Departments = No
Use Products = Yes

I get the above error message

Use Departments = Yes
Use Products = Yes

No error message

(When I turn on Departments then I am able to enter a FAQ without the error)

[wildweaselmi]

Disregard... It appears that DB error popped back up. I am wondering if it is something to do with special characters or length of question and/or answer. I was able to create a FAQ with just a few characters and nothing special.

So I was on a mission... I found out that if your answer has ' in it anywhere, you will get the below database error, but just hit back and remove any sign of ' and it works.

Database error in vBulletin 4.0.0:

Invalid SQL:
INSERT INTO vb_microsupport_faq
SET categoryid='11',
question='My machine is displaying a Blue Screen during bootup, did I loose all my data?',
answer='No you haven't lost it but when you get a Blue Screen it's difficult to get past it. MyWiseGuys has a few tricks up its sleeve to backup your data and see if we can repair that Blue Screen so you can continue working. In the event it's beyond repair, we can re-load Windows on your machine and then restore your data so you are back in business.',
important = '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 't lost it but when you get a Blue Screen it's difficult to get past it. MyWiseG' at line 4
Error Number : 1064
Request Date : Monday, December 28th 2009 @ 02:55:55 PM
Error Date : Monday, December 28th 2009 @ 02:55:55 PM
Script : http://www.mywiseguys.com/forums/support.php?do=saveupdatefaq
Referrer : http://www.mywiseguys.com/forums/support.php?do=addeditfaq
IP Address : 24.11.27.21
Username : wildweaselmi
Classname : vB_Database
MySQL Version : 5.1.41

[Edrondol]

Disregard... It appears that DB error popped back up. I am wondering if it is something to do with special characters or length of question and/or answer. I was able to create a FAQ with just a few characters and nothing special.

So I was on a mission... I found out that if your answer has ' in it anywhere, you will get the below database error, but just hit back and remove any sign of ' and it works.

Database error in vBulletin 4.0.0:

Invalid SQL:
INSERT INTO vb_microsupport_faq
SET categoryid='11',
question='My machine is displaying a Blue Screen during bootup, did I loose all my data?',
answer='No you haven't lost it but when you get a Blue Screen it's difficult to get past it. MyWiseGuys has a few tricks up its sleeve to backup your data and see if we can repair that Blue Screen so you can continue working. In the event it's beyond repair, we can re-load Windows on your machine and then restore your data so you are back in business.',
important = '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 't lost it but when you get a Blue Screen it's difficult to get past it. MyWiseG' at line 4
Error Number : 1064
Request Date : Monday, December 28th 2009 @ 02:55:55 PM
Error Date : Monday, December 28th 2009 @ 02:55:55 PM
Script : http://www.mywiseguys.com/forums/support.php?do=saveupdatefaq
Referrer : http://www.mywiseguys.com/forums/support.php?do=addeditfaq
IP Address : 24.11.27.21
Username : wildweaselmi
Classname : vB_Database
MySQL Version : 5.1.41


I got the same thing and tested without a ' in the answer and it worked. So is there a quick way to fix this or do I just have to relearn how to type things?

[KozmoK]

Again, this is a great product - and I'm only trying to point out some things I've came accross.

Errors so Far:

1) Must have a Deparments defined even though you have them shut off, or sometimes you will get a sql error.
2) must use SQL Safe strings on insertions/updates.

Things that should be addressed:

1) Force to Pick a department if Deparments are enabled.
2) Force to Pick a Product.

If these forces are not there, they show up blank, and it doesnt work right.

[MaryTheG(r)eek]

I got the same thing and tested without a ' in the answer and it worked. So is there a quick way to fix this or do I just have to relearn how to type things?

I've double checked the file support.php and is correct, according to vB's style for clearing the inputs. If you see at lines 355-365, you'll find:


$vbulletin->input->clean_array_gpc('p', array(
'wysiwyg' => TYPE_BOOL,
'message' => TYPE_STR,
'question' => TYPE_NOHTML,
'categoryid' => TYPE_UINT,
'important' => TYPE_UINT
));
// Get Values
$title = $db->escape_string($vbulletin->GPC['question']);
$answer = convert_wysiwyg_html_to_bbcode($vbulletin->GPC['message']);


Could you please try, by changing:

'question' => TYPE_NOHTML,

to

'question' => TYPE_STR,



Maria

[MaryTheG(r)eek]

Errors so Far:
1) Must have a Deparments defined even though you have them shut off, or sometimes you will get a sql error.
I'll check it


2) must use SQL Safe strings on insertions/updates.
In all inputs I'm using input->clean_array_gpc to clean the inputs. Seems that there is a confusinion between TYPE_STR and TYPE_NOHTML. I thought that TYPE_NOHTML adds also slashes before ' which causes SQL errors. I'll check it.


Things that should be addressed:

1) Force to Pick a department if Deparments are enabled.
2) Force to Pick a Product.

Even if I remove the option "Please select", I do believe that users who don't like to "waste" their time, will let the default value. I must try to find a way (with javascript) to use with "onchange".

Maria

If these forces are not there, they show up blank, and it doesnt work right.[/quote]

[FreeResellers]

This looks like a vbulletin 3.8.x. product, are you sure it works on 4.0?

[MaryTheG(r)eek]

This looks like a vbulletin 3.8.x. product, are you sure it works on 4.0?

The screenshoot (except the first one) are from the 3.x version. The product itself has upgraded to vb4.0.0 PL1.

Maria

[taffy056]

Unfortunately had to uninstall this on my forum as its just about going live and I cannot have something that is not working on my forum.

[Mythotical]

Okay Maria that fixed that problem - thanks :)

But have another now, you know when you go to the ticket in the todo section, when you reply to the ticket I get a

500 Internal Server Error

when I refresh the message it is there

Is this only happening when you reply to a ticket?

[taffy056]

Is this only happening when you reply to a ticket?

yes it is mate

[Mythotical]

yes it is mate

Ok I will try to duplicate and find a fix since Marie is very busy with other things at the moment.

[ndahiya]

Thanks for the mod. a couple of suggestion

For guests/not logged in, the mod should ideally use a email based identifier for the user? right now it is cookie based (not sure)?

also, there should be an option to turn FAQs off (use vb's default FAQ system).

have uninstalled it until these changes are incorporated.

ndahiya

[taffy056]

Ok I will try to duplicate and find a fix since Marie is very busy with other things at the moment.

appreciate that, thanks :)

[jervin32189]

I got this problem

Database error in vBulletin 4.0.0:

Invalid SQL:
SELECT * FROM microsupport_departments WHERE id= LIMIT 1;

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 'LIMIT 1' at line 1
Error Number : 1064
Request Date : Thursday, December 24th 2009 @ 05:08:50 AM
Error Date : Thursday, December 24th 2009 @ 05:08:51 AM
Script : http://localhost/support.php?do=replyticket&ticketid=
Referrer : http://localhost/support.php
IP Address : 192.168.1.100
Username : valendono
Classname : vB_Database
MySQL Version : 5.1.37



when ticket already closed and admin wanna see again in Techmenu >> Tickets ToDo >> Closed Filter and click on Title ticket and that happen...

Was able to duplicate this bug. Hopefully we can find a way to fix it.

[Edrondol]

I also had to uninstall. I got database errors when I tried to add FAQs and there just seems to be too many issues at this time to have it on my live site.

Once this comes out of Beta I'll be interested. Until then it's just too many headaches.

[MaryTheG(r)eek]

This message hasn't any meaning of complaining for anything, neighter that I'm apologizing, but I want to make clear some things, that I thought to be self explained.
I know how sad is for anybody, to uninstall a module that he found usefull due to bugs. But believe me, I'm feeling also sad, as it means that I lost my attention somewhere and I brought-up a bug.
If you click on the word "Coder" beside my nickname, you'll see that in a duration of just 10 days since the Gold release of vB4, I've released 2 full mods, 1 addon and 6 ...toys (widgets), while other (commercial) coders have disappeared.
Since Oct 2006, when I released my first free mod, I've released more than 20. For all this work, I got from here just 2 donation at a total of $45. What it means? Simple that I've my own job, for which I need to take care if I want to have the money to live. And because my job is not a 9am-5pm job (I've a Travel Agency office), sometimes I need to spend more than 10 hours a day for it.
Coding is my hobby. I was working for my mods, even on Christmas day (to release microMEMBERS) and I met the new year's eye infront of my PC to release microAUCTIONS.
What I was expecting in exchange? Something very simple, something that everybody expects when is giving a gift. A simple thank you and understanding if my gift dosen't meets your expectations.
Don't know how you use to do in your countries, but in Greece we use to thank for the gift, and later if we find it usefull we use it, otherwise we let it at the back without to use it, but always feeling good for the person who gave us it. We don't drop it on his face, saying: "What bulshit is this...". This is humanity, this is civilazation.I'm really sorry if this post makes some of you to feel uncomfortable, but I had to blow-out what was pressing my mind and my heart.

My warmest wishes to follow you and your beloved, for a happy, healthly and prosperous new year.

Maria Avlatzi

[taffy056]

I did thank you for your efforts Maria, thing is because there are bugs on the hack I can't have it on a live site, I had to uninstall it, I do realise that people has a life outside this, and I run my own business as well.

Hope you have a good New Year Maria

[MaryTheG(r)eek]

I did thank you for your efforts Maria, thing is because there are bugs on the hack I can't have it on a live site, I had to uninstall it, I do realise that people has a life outside this, and I run my own business as well.

Hope you have a good New Year Maria

microSUPPORT will be upgraded and released bug free FOR SURE!!!!!. Unfortunatelly it was my first attempt to vB4 that's why it has bugs, while the 3.8.x version hasn't them. vB4 is very strange. Even if a value exists, it dosen't counts it like to exist, if I don't declare it for use in the template.

Now I became much more familiar with vB. You can understand it easily by seeing microMEMBERS and mostly microAUCTIONS. You'll notice that I even found the way to "colorize" the tables something that gots me lot of time, and it dosen't exists in microSUPPORT. The only that I want is understanding from you (talking in general), that is like to learn a new programming language. So I need time and patiense. That's all. Soon, I promised it in my word, you'll find here this module 100% bug free.

Maria

[iamspookysdaddy]

Awesome Mod but I have persistent issue. When clicking "My Tickets" I recive this error.
Warning: Division by zero in [path]/includes/functions.php on line 2503
Database error
The Victorious Christians Forums database has encountered a problem.
Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the 208.43.23.140 home page, then try to open another page.
Click the Back button to try another link.

I have tried reinstall several times and have the latest update that I have installed.

Also do you know how I can change default text color to white? The text is black and the background is dark so very hard to see...

Many thanks!!!!!

http://208.43.23.140/images/helpdesk.jpg

[Edrondol]

Maria,

First off, I want you to realize that we ALL appreciate what it is you do! Don't think because some have uninstalled that we don't like the idea or what you've done. In fact, once this goes out of Beta stage I'll most certainly be redownloading and installing it again.

As to letting it go, without feedback you have no way of knowing whether or not something needs work. I probably could have been more descriptive in what my issues were, but I got a tad lazy. I don't want you to take the wrong meaning by my post (even though I know you were talking generally and not my post specifically) and know that this is still tagged and I plan on still using this once it's done.

[MaryTheG(r)eek]

As I promised, I spent the whole day today, to redesign and correct everything reported as bug. I've finished 99% of it, left out for the moment, the re-open function, but I'm very tired to release it today, is better to wait till tomorrow morning.

Meanwhile, if you want, you can test the new version at:
http://www.microhellas.com/dev4/
Login: demouser / demopass
I gave technician rights, so you can test that section too.

I took care to hide in any lists products and or departments if they're not active, I changed the question field to be able to save more than 255 chars etc.

Maria

[MaryTheG(r)eek]

Maria,

First off, I want you to realize that we ALL appreciate what it is you do! Don't think because some have uninstalled that we don't like the idea or what you've done. In fact, once this goes out of Beta stage I'll most certainly be redownloading and installing it again.

As to letting it go, without feedback you have no way of knowing whether or not something needs work. I probably could have been more descriptive in what my issues were, but I got a tad lazy. I don't want you to take the wrong meaning by my post (even though I know you were talking generally and not my post specifically) and know that this is still tagged and I plan on still using this once it's done.

I did talked for anyone specific. Let's say like a monologue.

Thank you for your understanding
Maria

[albibak]

MicroHellas,

Thanks for the mod
Please, find in attachment the french translation
You can find the french topic for this mod here: http://forum.vbulletin-fr.org/modifications/1093-MicroSUPPORT-4-3-0

[MaryTheG(r)eek]

Hello,

As I promised, I just released microSUPPORT ver.4.4.0, which I do believe that fixes all reported bugs. Using it, it's easily understandable that it has been redesigned from scratch. No more double navbar, no apperance of departments or products in lists, if you've turn them off.

Please pay attention to confirm that the directory microsupport/attachments is CMOD 777. Sometimes, this causes Internal server error, if its not and you're trying to upload attachments.

For those who want to use it just for FAQ, I've to say that they can do it, by setting up usergroup permissions (no ticket posting) and turning off the Reply info block, from microSUPPORT Options.

Thank you
Maria

[albibak]

Oh, just when we release the translation for the version 4.3.0 ^^.
So, we'll update it soon for the 4.4.0

[MaryTheG(r)eek]

Oh, just when we release the translation for the version 4.3.0 ^^.
So, we'll update it soon for the 4.4.0

As I forgot to use version nbr in phrases, to help you a bit, I added 12 phrases (last in queue) plus 7 in global phrases.

Maria

[Lightwizzard]

Ty for this nice mod.

When u say Maria is final, then i can help with an German Version :)

hm i have one little Problem

When i have an open Ticket so i can look @ To do
i used the Filter Funktion all then the Support System Show mw all Tickets but the Link (same Ticket name) has no id in URL so i get an SQL error.
When i use the pulldown view no problem

can u look at this ?

[albibak]

As I forgot to use version nbr in phrases, to help you a bit, I added 12 phrases (last in queue) plus 7 in global phrases.

Maria
No problem, I use examdiff to know the difference between the 2 versions, but thanks ;)

[MaryTheG(r)eek]

Ty for this nice mod.

When u say Maria is final, then i can help with an German Version :)

hm i have one little Problem

When i have an open Ticket so i can look @ To do
i used the Filter Funktion all then the Support System Show mw all Tickets but the Link (same Ticket name) has no id in URL so i get an SQL error.
When i use the pulldown view no problem

can u look at this ?

Could you please try by using the attached file?

Maria

[Lightwizzard]

ahhhh !!!! works !!

Ty very Much

[apietersen]

Deprecated: Assigning the return value of new by reference is deprecated in C:\wamp\www\forum\support.php on line 291

- I am new with vBulletin
- installed Vb 4.0.0 suite pl1
- imported the product
- can config product
- when clicking on de Helpdesk button in NavBar
- the above error message appears???

What do I wrong?

- Ashley

[apietersen]

I like very much to try the microSUPPORT product. But I run in to an irritating error message:

Deprecated: Assigning the return value of new by reference is deprecated in C:\wamp\www\forum\support.php on line 291

I run vBulletin on a MS W2k3 server, WAMP, vB suite 4.0.0 PL1
I have changed the access rights on the directory "/attachments" (CMOD 777) to fullcontrol for everyone, but also get the same error message. Does somebody knows what goes wrong here?

- Ashley

[MaryTheG(r)eek]

I like very much to try the microSUPPORT product. But I run in to an irritating error message:

Deprecated: Assigning the return value of new by reference is deprecated in C:\wamp\www\forum\support.php on line 291

I run vBulletin on a MS W2k3 server, WAMP, vB suite 4.0.0 PL1
I have changed the access rights on the directory "/attachments" (CMOD 777) to fullcontrol for everyone, but also get the same error message. Does somebody knows what goes wrong here?

- Ashley

Please have patience and don't double (actually triple) post. I don't know why your server has incompatibility, with a normal variable assigment. It's sotething that can't corrected from the code, as it's an important variable.

Maria

[albibak]

Maria,

Please find the french translation for your last version (4.4.1)

Olivier

[apietersen]

Jusr to inform:

I am glad I have found a solution for the errormessage reported earlier - as said, I have initialy installed wamp 2.0i server (with HPH 5.3 included) - looking an googling I found a suggestion:
installing an wamp addon PHP2.9 the problem was solved. (download it from the wampserver site, install it and finaly select it as the running environment)

- Ashley

[MaryTheG(r)eek]

Jusr to inform:

I am glad I have found a solution for the errormessage reported earlier - as said, I have initialy installed wamp 2.0i server (with HPH 5.3 included) - looking an googling I found a suggestion:
installing an wamp addon PHP2.9 the problem was solved. (download it from the wampserver site, install it and finaly select it as the running environment)

- Ashley

You're lucky that you found it, not only because you can use my mod, but to be honest when I seen that you've wamp server, I was nearly sure that you'll have general problems with PHP itsself.

Maria

[zbahadir]

Submit New Ticket custom fields can be added to the section?

Example Custom Fieds
product name =
ftp user =
ftp pass =
..... = ...

bla bla...

[MaryTheG(r)eek]

Submit New Ticket custom fields can be added to the section?

Example Custom Fieds
product name =
ftp user =
ftp pass =
..... = ...

bla bla...

This is not a standard feature even in commercial scripts. That's why I kept it out to include it in a PRO version, that soon I'll have ready. Don't you think that is fair to get some money from my work? Current version, I do believe, that has 90% of the features that a normal support script needs.

Maria

[jervin32189]

Thank you Maria. I love the new version even better than the old version. Everything looks A-OK. Thank you for your dedication in this product.

[taffy056]

I have installed this back on to test, and I am still getting an internal server error, its on when the user who submits the ticket replies, there is no attachment in the reply, and I have cmod the attachment file to 777, another thing is, I have renamed the HelpDesk to Forum Help, and it hasn't changed the name in the navbar, also the Technician link is showing for users despite 'Is Technician Team?' is set to no.

Sorry maria if its a lot, but I can only give the feedback that I am having at the moment, I like the way you have changed things around though, thanks for sharing :)

[MaryTheG(r)eek]

I have installed this back on to test, and I am still getting an internal server error, its on when the user who submits the ticket replies, there is no attachment in the reply, and I have cmod the attachment file to 777, another thing is, I have renamed the HelpDesk to Forum Help, and it hasn't changed the name in the navbar, also the Technician link is showing for users despite 'Is Technician Team?' is set to no.

Sorry maria if its a lot, but I can only give the feedback that I am having at the moment, I like the way you have changed things around though, thanks for sharing :)

For NavBar you need to change the GLOBAL phrase microsupport_support.
For the Internal Server Error, sorry, I've do idea what can be wrong.
I'll check for the menu Technicians.

Maria

[KozmoK]

I upgraded and now I cant see any tickets, just FAQ.

[MaryTheG(r)eek]

I upgraded and now I cant see any tickets, just FAQ.

Have you setup usergroup permissions? (even for Admins).

Maria

[taffy056]

For NavBar you need to change the GLOBAL phrase microsupport_support.
For the Internal Server Error, sorry, I've do idea what can be wrong.
I'll check for the menu Technicians.

Maria

On your other version, you could change the name of the hack on the navbar by altering the name in the admincp.

As for internal server error, I have no idea either, I am not a coder so don't even know where to start, so i am sorry will have to uninstall again, I don't think I will ever be able to use otherwise excellent script if you don't know what the problem is either.

thanks for your help, I will continue using some of your other contributions :)

[KozmoK]

Yes, it was working on previous version.

Have you setup usergroup permissions? (even for Admins).

Maria

[Alex@Mk3OC]

All seems to be working fine, thanks :)

[iamspookysdaddy]

This is not a standard feature even in commercial scripts. That's why I kept it out to include it in a PRO version, that soon I'll have ready. Don't you think that is fair to get some money from my work? Current version, I do believe, that has 90% of the features that a normal support script needs.

Maria

Hey Maria,

I will be interested in getting the pro version. Will that be able to be used without copyright in helpdesk? I have new problem mentioned in another thread. No ticket information shows. Ady advice.

http://208.43.23.140/images/helpdesk1.jpg

[MaryTheG(r)eek]

Hey Maria,

I will be interested in getting the pro version. Will that be able to be used without copyright in helpdesk? I have new problem mentioned in another thread. No ticket information shows. Ady advice.



:confused: What do you mean "No ticket information shows"?? Look at the navbar. As for the PRO version by default it will has no copyright link. But for more you need to visit my site. Most probably should be ready tomorrow.

Maria

[MaryTheG(r)eek]

Yes, it was working on previous version.

Sorry for asking, but as someone else reported something similar, where are you looking for the "Ticket Menu"? It's on the navbar.

Maria

[MaryTheG(r)eek]

Hey Maria,
I will be interested in getting the pro version. Will that be able to be used without copyright in helpdesk? I have new problem mentioned in another thread. No ticket information shows. Ady advice.


For more information, you can read:
http://www.microhellas.com/main/showthread.php?5-microSUPPORT-v4-5-PRO

Maria

[merlin_de]

Hello Maria,
at first: Thank you for another great AddOn !
Is ist possible to hide the popup-menu "Technician" for Users who have no permissions? It seems to me that this link is only usable for my team, isn´t it ?
Greets,Micha

[MaryTheG(r)eek]

Hello Maria,
at first: Thank you for another great AddOn !
Is ist possible to hide the popup-menu "Technician" for Users who have no permissions? It seems to me that this link is only usable for my team, isn?t it ?
Greets,Micha

This is a dammit bug that I'm trying to fix. Even if there is no real access to that section, only by seeing it is unprofessional. I'm using a plugin for this menu, and seems that needs some deeper test. But be sure that I'll fix it.

Have a nice weekend
Maria

[iamspookysdaddy]

:confused: What do you mean "No ticket information shows"?? Look at the navbar. As for the PRO version by default it will has no copyright link. But for more you need to visit my site. Most probably should be ready tomorrow.

Maria

Quite correct you are indeed! Good example how errors are made when starting upgrades and modifications when extremely fatigued:eek: It was harder to make my screenshot than to find the LINK LOL

I will visit your site to purchase pro version....

TNX

[valendono]

report again when u put FAQ, I cannt use WYSIWYG from forum, its html only.. there way to use forum form ?

I dunno if only me or everyone get this problem.. still not fix yet.. event I put [img] its not working... bbcode.. thats the problem is..

[MaryTheG(r)eek]

I dunno if only me or everyone get this problem.. still not fix yet.. event I put [img] its not working... bbcode.. thats the problem is..

That's why in my old mods I was using 3nd party editor:( Sorry but seems that something was going wrong with the editor, if it works in a non forum mod. eg Bullet lists, images and links.

I've post in Private coders forum:
https://vborg.vbsupport.ru/showthread.php?t=232455
but I've no reply 3 days now. Contacting vb.com is a waste of time, as they don't support coding.

Maria

[InsomniacP]

We are using this great mod thank's!

[ndahiya]

very useful mod. thx maria.

is there a way to turn off the FAQ of the mod? just want to use it for ticket system.
also, what is the most effective way to use it for not-logged-in users (i want it to be the one stop ticketing system for everyone, including people who might have a prob registering etc)...

ndahiya

[merlin_de]

But be sure that I'll fix it.

Hello Maria,
i am shure that you will fix it http://www.omega-senator.de/forum/images/smilies/top.gif.

Have a nice weekend

Thx, to you too. Perhaps for you exeptionally without a keyboard ?;)
Greets,Micha

[Chuta]

The delicate touch of a girl. :)

Nice hack Maria, installed and nominated.
Thanks!!

[nomoreturn]

Installed and working perfect thanks for such a nice mod

[ProFifaLeagues]

Installed with ease a superb mod and will be well used,Thank you.
Just some little bits i need to figure out(ie i cany find a link to my main forum from the new page)

[MaryTheG(r)eek]

Thank you all for you kind words. They really help me a lot to continue releasing free mods here. Even if I just released the PRO version in my site, be sure that I'll continue supporting this version here.

Maria

[MaryTheG(r)eek]

The delicate touch of a girl. :)

:p Thank you:)

[merlin_de]

Hello,
is it possible to view all Tickets ? In the dropdownmenu fpr technician ist only an option "Tickets ToDo" (i have it in german). How can i see closed tickets ?
Greets,Micha

Edit: Sorry, i have found it. After choice "Tickets ToDo" i can Filter "all".

[MaryTheG(r)eek]

Hello,
is it possible to view all Tickets ? In the dropdownmenu fpr technician ist only an option "Tickets ToDo" (i have it in german). How can i see closed tickets ?
Greets,Micha

Edit: Sorry, i have found it. After choice "Tickets ToDo" i can Filter "all".

Don't underestimate it's features as its free;)

Maria

[Lightwizzard]

Hey Maria,

i hope u haven an good weekend.

Ty for the Nice Update!

We love this add-on

[MaryTheG(r)eek]

Due to lack of free time, I must decrease the time that I'm spending here for support. By having a long thread for each of my 16 mods, most often I'm bypassing questions. That's why for urgent questions please visit my site (http://www.microhellas.com/), where it's easier to support you, by having a thread per question.

Thank you
Maria

[LifesGreatestGift]

I have a question and an issue. :)

First off, Great Mod!

My issue is that no emails are being sent out from this mod (I registered on your DEV forum under SupportEmailTest)

My question is, how do I display all tickets by default on the Technician page, I hate having to click filter everytime. Default only new tickets are displayed. If I reply, every time I go back, I have to hit filter to display the Work In Progress and closed tickets.

[MaryTheG(r)eek]

I have a question and an issue. :)

First off, Great Mod!

Thank you

My issue is that no emails are being sent out from this mod (I registered on your DEV forum under SupportEmailTest)

What type of email you didn't received? As User or as Technician? As Technician all emails are coming to me. If you didn't got email as user, just check your junk mail folder. For sure works, as there are active installations and nobody reported something like this.

My question is, how do I display all tickets by default on the Technician page, I hate having to click filter everytime. Default only new tickets are displayed. If I reply, every time I go back, I have to hit filter to display the Work In Progress and closed tickets.

Not only new tickets. By defaults the list shows tickets that need technician's reply. Maybe they are new tickets, or tickets that the user has replied on them. And this is the standard in all scripts. Imagine a webmaster who has 1000 tickets and only 20 of them need action?

Maria

[LifesGreatestGift]

Thanks for the fast reply. Yeah, the emails sent find to the account I registered at your forum. I was using it merely as a test. But I made a demo account on my forum, and created a ticket, and replied with a technician account and no emails were sent to either account. :(

[MaryTheG(r)eek]

Thanks for the fast reply. Yeah, the emails sent find to the account I registered at your forum. I was using it merely as a test. But I made a demo account on my forum, and created a ticket, and replied with a technician account and no emails were sent to either account. :(

Please check if:

The mail() function is enabled in your PHP settings. Other emails from vBulletin are working?
Most probably you added your test users from your admincp. Have you assigned email address?
For technicians. Have you assign email address in microSUPPORT Options?Maria

[LifesGreatestGift]

The mail() function is enabled in your PHP settings. Other emails from vBulletin are working?
Yes, the mail function seems to work fine with vB. Members get registration emails, PM notification emails etc.

Most probably you added your test users from your admincp. Have you assigned email address?
Yes
https://vborg.vbsupport.ru/external/2010/01/45.png

For technicians. Have you assign email address in microSUPPORT Options?
Yes
https://vborg.vbsupport.ru/external/2010/01/46.png

[almty1]

I get technician e-mails but the users do not. Also dont see the users name that created the ticket on the technician menu. I'll try and do some more troubleshooting but have been strapped for time and havnt been able to get to you about it yet.

[3DUInc]

Outstanding and thank you very much!!! :)

installed and nominated

[RedHacker]

Is it useful when open one ticket to open auto thread notification to the forum...?

[badawidollah]

is it work for VB4.0.1 ?

[RedHacker]

is it work for VB4.0.1 ?

Yes...

[Trek]

Just installed, working good. Thank you for writing and releasing this.

Only problem I've found so far is that the borders are hard coded and in blue. (seems that way on most of your mods. ;) ). I fixed those manually though so no big thing.

Right now, what I'd like to see is the ability to assign specific people (not usergroups, or maybe usergroups too, but people for sure) to a department. So that they can only work on tickets in their department.

[MaryTheG(r)eek]

Just installed, working good. Thank you for writing and releasing this.

Only problem I've found so far is that the borders are hard coded and in blue. (seems that way on most of your mods. ;) ). I fixed those manually though so no big thing.

Right now, what I'd like to see is the ability to assign specific people (not usergroups, or maybe usergroups too, but people for sure) to a department. So that they can only work on tickets in their department.

I've added these features to Pro version, plus some others (eg including the reply text to email). Ok, actually you can't assign specific people but specific email(s), so I count it to be the same.

At a later time I'll release step by step some more functions to Free version. I believe that currently, it gives the average webmaster, 95% of what he needs. eg for me, the free version fits perfect as I'm the only one who is giving support.

Also in the PRO version I've changed a bit the interface to be closer to vB's standards.
http://www.microhellas.com/dev4/support.php

Maria

[RedHacker]

How display New tickets at left etg screenshots?

[vividbreeze]

How can I buy the PRO versions? I also want the classifieds@

[MandachuvA]

How do I post a ticket, this does not appear the option to post.

look at the picture please it only stays that way - > http://img254.imageshack.us/img254/2145/ticket1.png

[MandachuvA]

double post sorry blame browser

[MaryTheG(r)eek]

How do I post a ticket, this does not appear the option to post.

look at the picture please it only stays that way - > http://img254.imageshack.us/img254/2145/ticket1.png

You can find all the menu options (depending on your usergroup permissions) at the navbar.

Maria

[MaryTheG(r)eek]

How can I buy the PRO versions? I also want the classifieds@

Only in my site (http://www.microhellas.com/main/payments.php) please.

Thank you

[MandachuvA]

You can find all the menu options (depending on your usergroup permissions) at the navbar.

Maria

I adm, I have all the permissions and still not see the full menu
I am interested in buying the pro version before it got to test it to see their efficiency

[MaryTheG(r)eek]

I adm, I have all the permissions and still not see the full menu
I am interested in buying the pro version before it got to test it to see their efficiency

Your screenshoot does not shows the full screen. Could you please post a fullscreen?

Maria

[mrt12345]

Hello Maria
i see that you are doing a bang up job on this script but i was reading about you other mods in the earlier version of VB on kayako support and i just so happen to have a copy . i spent some good $$$ on that script and i hate to see it go to wast , is there by any chance that you would be making a integration script for this in the future. But the really nice thing about you script here is that it is part of vb so there is no template work that is a big plus. I wish you the best of luck on this script and if you come out with a product or a pro version for some $$$ i might be very interested. and i will just try to sell off my Kayako license .
thanks
Tracy:)

[MaryTheG(r)eek]

Hello Maria
i see that you are doing a bang up job on this script but i was reading about you other mods in the earlier version of VB on kayako support and i just so happen to have a copy . i spent some good $$$ on that script and i hate to see it go to wast , is there by any chance that you would be making a integration script for this in the future. But the really nice thing about you script here is that it is part of vb so there is no template work that is a big plus. I wish you the best of luck on this script and if you come out with a product or a pro version for some $$$ i might be very interested. and i will just try to sell off my Kayako license .
thanks
Tracy:)

Hello Tracy,

First of all, thank you for your kind words. I totally understand you, as like you, I've spent thousant in PHP scripts (including Kayako). There is a PRO version, in my site for $50 (including Brand Free). Is not Kayako, but works fine, having the features that you'll really use and not toys to play. In addtional to Free version, it has extra ticket fields, predefinied replies, ability to post a ticket as FAQ (even in multiple categories), abitily to setup email address(es) per department (to inform for new tickets and replies), and more vB like interface.

Maria

[vividbreeze]

I bought the PRO version and I love it so far!

I do have a question though, how can I get sidebars like these: https://vborg.vbsupport.ru/attachment.php?attachmentid=107487&d=1260722783

Because I have a modified vb 4 and it does not show up in my navbar, i dont want it to.

thx!

[Neptun]

Hello Tracy,

In addtional to Free version, it has extra ticket fields, predefinied replies, ability to post a ticket as FAQ (even in multiple categories), abitily to setup email address(es) per department (to inform for new tickets and replies), and more vB like interface.

Maria

I have installed this version now - and it works fine what i have tested in the short time.

What do you mean with the pro "it has extra ticket fields" -> what kinds of fields ?

What do you mean with the pro "and more vB like interface" -> can you explain this ?!

I am very interessed in a professional support ticket center for my system ;)

[MaryTheG(r)eek]

What do you mean with the pro "it has extra ticket fields" -> what kinds of fields ?

1.- Let's say that you're runing a hosting company. You can setup extra fields to collect data like FTP username, FTP password etc

2.- On the same way, if you're operating a shop, you can collect data like order nbr, license nbr etc.

What do you mean with the pro "and more vB like interface" -> can you explain this ?!

Nothing so special (in my opinion) but many users asked for it. I moved the menu options at navbar, I merged my navbar with vb's navbar and finally the sidebar is like vb's sidebar.

Maria

[Tripolis]

When i make a answer of a ticket, i get out of the board and must login again.

So i cant answer any ticket.
Close is going

[vividbreeze]

Maria, I still need to know how to add all the features into the sidebar instead of the navbar?

[ysam]

I found a bug that at least in my system exists. Every field that uses getRecordById() fails badly. I can't figure out why you are using direct mysql functions only in that function.

Anyway if anybody has problems not displaying Departments, Products and posters etc.. This is what you have to do.

in microsupport/includes/functions.php

replace

// Get record by Id
function getRecordById($tablename, $id, $rowname = 'id')
{
global $db, $vbulletin;
$result = $db->query_read("SELECT * FROM ".TABLE_PREFIX."".$tablename." WHERE ".$rowname."=".$id." LIMIT 1");
if(!$result) return array ("id" => 0, "name" => '');
if(mysql_num_rows($result) == 0) return array ("id" => 0, "name" => '');
$ret = array();
while($row = mysql_fetch_assoc($result)) {
$ret = $row;
}
mysql_free_result($result);
return $ret;
}


With..


// Get record by Id
function getRecordById($tablename, $id, $rowname = 'id')
{
global $db, $vbulletin;
$result = $db->query_read("SELECT * FROM ".TABLE_PREFIX."".$tablename." WHERE ".$rowname."=".$id." LIMIT 1");
if(!$result) return array ("id" => 0, "name" => '');
if($db->num_rows($result) == 0) return array ("id" => 0, "name" => '');
$ret = array();
while($row = $db->fetch_array($result)) {
$ret = $row;
}
mysql_free_result($result);
return $ret;
}


This is for 4.4.2 free version.

-Yiannis

[below sea level]

Okay Maria that fixed that problem - thanks :)

But have another now, you know when you go to the ticket in the todo section, when you reply to the ticket I get a

500 Internal Server Error

when I refresh the message it is there

I installed version 4.4.2 today and I'm also getting this problem. The ticket actually submits, but I get the error when the browser tries to go to the next page. Any ideas?

[Neptun]

i have not any problem with this hack - you did all steps exactly like in the install instructions ?!

[meschiash]

Full polish translation for microSUPPORT

[below sea level]

I followed all the steps as per the instructions. It is refreshing to know somebody has had the same problem though.

[sqzdog]

I am thinking of dumping Kayako. Any want to import the kbase to vbulleting? It would be in xml format.

Thanks

[iHatton]

Great modification, but I am having some problems. Once on the main page of microSUPPORT, all I can see is this:

http://img153.imageshack.us/img153/6064/capturejk.png

Cannot create tickets, view open ones, nothing. I have installed various times aswell, done the usergroup permissions correctly and configured the general settings.

[balu84]

After installing the addon, the Average Responce Time shows an indicated value of -351908 Hours : 15 Minutes.
Has anybody the same problem or a solution for fixing it?

[Trek]

After installing the addon, the Average Responce Time shows an indicated value of -351908 Hours : 15 Minutes.
Has anybody the same problem or a solution for fixing it?

Same problem here. I mentioned it, but I've never seen a response about it or a fix.

[OPsNaStYM0FO]

Also I noticed no one has noticed that "Responce" is spelled wrong "Response"

[apietersen]

Had this problem too. Strange negative response time. Even after some upgrades.

Finaly I deleted all (test) tickets and created a new ticket from scratch, now it shows normal positive response timing again.

[apietersen]

Oeps, just checked again my response time, again a negative response time. Sorry for the confusion. Problem still exists. Hope microHellas can solve this.

[iDrapes]

hey after i installed this plugin my forum is getting an error

Fatal error: Call to undefined function fetch_language_fields_sql() in /home/wizta/public_html/defeatthesystem.com/includes/class_core.php on line 3557

[mrt12345]

Any word on a upgrade to 4.0.2 yet and the payed version?

[E.T.]

Hi,

Is it possible to hide the HelpDesk button in the NAVBAR for users who are not allowed to create tickets ?

So that only users in a special membergroup are seing the HelpDesk button.

thanks in advance.

Regards,
Marcel

[mp3u]

Hi,
i'm interested in buying the Pro version - or at least in getting some more information about it. I tried on of the links you posted and got a broken link, when I go to www.microhellas.com I have to register before I can see any information about any products - however the register link just takes me to a broken page.
Hope to hear back from you, this is something I am interested in.
Regards,
D

[kf4eok]

I like this idea, looks and works great.
thanks for tho effort put into this.

[Sascha Henken]

I just found this Addon and i?m pretty impressed with this neat little tool :up:

However I have an issue which is so far only charismatic:

When i?ve created a Ticket and i?m watching the Ticket afterwards under "My Tickets", I cannot see the Product and/or Department info, nor the Ticket Title at all. However i?ve specified a Product and Department and i?ve enabled those options as well.

Any clue on this?

I?m using vB 4.0.2

Thank you!

[MaryTheG(r)eek]

I just found this Addon and i?m pretty impressed with this neat little tool :up:

However I have an issue which is so far only charismatic:

When i?ve created a Ticket and i?m watching the Ticket afterwards under "My Tickets", I cannot see the Product and/or Department info, nor the Ticket Title at all. However i?ve specified a Product and Department and i?ve enabled those options as well.

Any clue on this?

I?m using vB 4.0.2

Thank you!

I've corrected it since the early days. Wondering if I haven't released the update here. I need to check my files.

Maria

[Sascha Henken]

Thank you Maria. Short update of my post earlier:

The Title is being displayed. Only the Department and Product is not being displayed when you watch the submitted Ticket under "My Tickets".

Another thing i?ve noticed:

I?m running my forum in english (USA) language. In the Options I can specify an own text for submitted ticket, updated ticket and closed ticket. Regardless what i?m entering there, it is not displayed in the emails at all. Just a standard english text. Is this normal?

Another side question:

Are you probably going to enhance this product so that Ticket Numbers will be generated? And is it possible that probably the person who submitted the Ticket will be notified via either Email or PM or probably both? Or if that is not an option, is it possible to have a visual information visible on the Forum Home when you login such as "Your Ticket Has been updated" or "Please check your Tickets"?

Sorry to bother you with so much info :)

[Sascha Henken]

I've corrected it since the early days. Wondering if I haven't released the update here. I need to check my files.

Maria

Do you have any news on this? I have unininstalled the mod and rebuilt all styles. Then i?ve reinstalled the Mod again but still have the issues. I know this is Beta of course so I shouldn?t ask for support anyway :)

But it would be nice if there is something else on my forum that probably messes up your Mod. And why do I use Departments if I cannot assign a newly submitted Ticket to a particular Helpdesk Person? Or is Departments just charismatic?

Don?t get me wrong Maria. I?m just trying to understand you Mod and it?s way of operational tasks :)

Thank you!

[McAtze]

Hi,

a big thanks for this good work.

I've one question:

I've translated this AddOn into german, can i postet it to vbulletin-germany.org with a referal link to this thread?

thx a lot

[w-elbalad.com]

thank u Maria
can i tranz it for arabic ?

[w-elbalad.com]

can u do that for me :)?
http://img697.imageshack.us/img697/1003/marye.png

[E.T.]

Hi,

Is it possible to hide the HelpDesk button in the NAVBAR for users who are not allowed to create tickets ?

So that only users in a special membergroup are seing the HelpDesk button.

thanks in advance.

Regards,
Marcel

Could someone please answer this ?

[valendono]

I found a bug that at least in my system exists. Every field that uses getRecordById() fails badly. I can't figure out why you are using direct mysql functions only in that function.

Anyway if anybody has problems not displaying Departments, Products and posters etc.. This is what you have to do.

in microsupport/includes/functions.php

replace

// Get record by Id
function getRecordById($tablename, $id, $rowname = 'id')
{
global $db, $vbulletin;
$result = $db->query_read("SELECT * FROM ".TABLE_PREFIX."".$tablename." WHERE ".$rowname."=".$id." LIMIT 1");
if(!$result) return array ("id" => 0, "name" => '');
if(mysql_num_rows($result) == 0) return array ("id" => 0, "name" => '');
$ret = array();
while($row = mysql_fetch_assoc($result)) {
$ret = $row;
}
mysql_free_result($result);
return $ret;
}


With..


// Get record by Id
function getRecordById($tablename, $id, $rowname = 'id')
{
global $db, $vbulletin;
$result = $db->query_read("SELECT * FROM ".TABLE_PREFIX."".$tablename." WHERE ".$rowname."=".$id." LIMIT 1");
if(!$result) return array ("id" => 0, "name" => '');
if($db->num_rows($result) == 0) return array ("id" => 0, "name" => '');
$ret = array();
while($row = $db->fetch_array($result)) {
$ret = $row;
}
mysql_free_result($result);
return $ret;
}


This is for 4.4.2 free version.

-Yiannis

thanks buddy, solved my problem

[MaryTheG(r)eek]

1.- Version 4.6.0 *** NEW FEATURES ***
Predefinied Replies
Add a Ticket to F.A.Q (even to multiple categories)
Technician's emai address for notification moved from General options, to Departments. So now, you can assign per Department, as many email addresses as you like, to be informed for the new tickets and/or replies
Technician's email reply to member, now contains the reply text.
Fixed all reported (in my site) bugs.2.- Upgrade to 4.6.0 from 4.4.2
Download and unzip microsupport.zip
Upload support.php to destination, overwriting the old one.
Import product-microsupport.xml checking to overwritePlease note that support is limited to installation issues only!!

[Mrwill]

Is it possible to post a forum topic of every ticket? (Like Helpcenter)

[Mrwill]

I receive the below error

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, webmaster@internetforce.org and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

[MaryTheG(r)eek]

I receive the below error

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, webmaster@internetforce.org and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Have you cmod 777 the folder microsupport/attachments ?

Maria

[Chuta]

Thanks Maria for the update, I love your product :D. Working fine on Soporte - vBHispano- vBulletin en Espa?ol (http://www.vbhispano.com/foros/soporte/) ;)

It would be great to include a feature that allows editing of messages. :rolleyes:

Thanks again
Best regards.

[Ata123]

My custom style didn't seem to work on the microsupport pages. Adding

{vb:raw headinclude_bottom}

right before

</head>

in the

microsupport_main

template fixed this.

[vikris]

Weird, I have installed the product and Vbulletin tells me that I have not permission to view the helpdesk. Is there anything that I'm missing here?

P.S. It gives me: * Login or Register to be able to use our Ticketing HelpDesk!

[vikris]

Problem solved, forgot to setup user group permissions. Silly me. :)

Is there a way to setup a widget for FAQ on the CMS page that is content.php?

Is there a way, when guest wants to send a question, not to register, just to send the question with a mandatory field for the email of the guest who sends the question?

Thanks in Advance!

[Mrwill]

Is it possible to post a forum topic of every ticket? (Like Helpcenter)

I guess the answer is no ?

I receive the below error

Internal Server Error

The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, webmaster@internetforce.org and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Problem fixed...I thought CHMOD was done. Thanks!

[Verionia]

Why doesn't it look like the pics in the demo? I thought these were free mods?

[Dan Clark]

Maria,

Hi. Everything installed fine and I'm looking forward to using this excellent tool. However when I attempt to enter a new ticket, I get this error:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [path]/microsupport/includes/functions.php on line 420

Steps to reproduce:
1) Click "New Ticket".
2) Enter simple Title and Description.
3) Click "Submit"

Expected Result:
Ticket Created.

Actual Result:
Error listed above.

I'm using vB V4.0.3.

Any idea why this is occurring?

Thanks and regards,

Dan.

[MaryTheG(r)eek]

Maria,

Hi. Everything installed fine and I'm looking forward to using this excellent tool. However when I attempt to enter a new ticket, I get this error:


Steps to reproduce:
1) Click "New Ticket".
2) Enter simple Title and Description.
3) Click "Submit"

Expected Result:
Ticket Created.

Actual Result:
Error listed above.

I'm using vB V4.0.3.

Any idea why this is occurring?

Thanks and regards,

Dan.

Why I thought that I've corrected it before release. It comes from function getRecordById, because most probably are you using other database than MySQL.

Please try the attached file and let me know if it works.

Maria

[MaryTheG(r)eek]

Why doesn't it look like the pics in the demo? I thought these were free mods?

Yes, they were from the Free version, but the zip file for download is the full version. Have no time to get new screenshoots.

Maria

[Amit86]

I have been using this great addon for a month now, its great.
Wanted to thank you personaly for the hard work!
If I could add more suggestions you might missed or things you havent tought of it would be the following:

Filter tickets by poster
Search tickets
Mass close tickets (using radio buttons)
the ability to "assign" a ticket to a certain technitian
statistics of products\departments
make permissions per department, only permitted allowed to view\close ticket per department
Limit poster to X open tickets
add more status's and the ability to change status ourselves
Email all related repliers in a ticket when it was replied (like Starred tickets)


Thanks again!
Amit:)

[Dan Clark]

Why I thought that I've corrected it before release. It comes from function getRecordById, because most probably are you using other database than MySQL.

Please try the attached file and let me know if it works.

Maria
Maria,

That was FAST work! It worked PERFECTLY! :D :up: :up:

Many thanks!!!

Regards,

[fluidswork]

Great idea ...........