vb.org Archive - Major Additions - microSUPPORT for vB4

Page 1 of 9

Last »

Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- Modification Graveyard (https://vborg.vbsupport.ru/forumdisplay.php?f=224)

- - Major Additions - microSUPPORT for vB4 (https://vborg.vbsupport.ru/showthread.php?t=230112)

MaryTheG(r)eek

12-12-2009 10:00 PM

microSUPPORT for vB4

*** Link Removed ***

jaytech

12-13-2009 02:37 PM

upload it then lol..

garretbyrne

12-13-2009 02:38 PM

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

12-13-2009 02:39 PM

Quote:

Originally Posted by jaytech (Post 1929924)

upload it then lol..

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

MaryTheG(r)eek

12-13-2009 02:40 PM

Quote:

Originally Posted by garretbyrne (Post 1929926)

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

garretbyrne

12-13-2009 02:44 PM

I've setup two Departments... No products

MaryTheG(r)eek

12-13-2009 02:49 PM

Quote:

Originally Posted by garretbyrne (Post 1929936)

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

12-13-2009 03:07 PM

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

12-13-2009 03:19 PM

Very nice komsu

MaryTheG(r)eek

12-13-2009 03:20 PM

Quote:

Originally Posted by garretbyrne (Post 1929952)

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

12-13-2009 03:29 PM

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

12-13-2009 03:45 PM

Nice product :)

MaryTheG(r)eek

12-13-2009 03:46 PM

Quote:

Originally Posted by Charlie98902 (Post 1929971)

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

12-13-2009 03:56 PM

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

Mythotical

12-13-2009 04:36 PM

Just so you know, you have an uncached template:

Code:

microsupport_support_navbar

Mythotical

12-13-2009 04:40 PM

Found a database error:

Code:

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

12-13-2009 04:44 PM

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

MaryTheG(r)eek

12-13-2009 04:44 PM

Quote:

Originally Posted by Steve M (Post 1930012)

Found a database error:

Code:

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

12-13-2009 05:20 PM

Thanks very much and cant wait for the fix tomorro .

Charlie98902

12-13-2009 05:27 PM

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

12-13-2009 05:59 PM

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

12-13-2009 06:05 PM

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

12-13-2009 11:58 PM

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

garretbyrne

12-14-2009 12:03 AM

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

12-14-2009 12:17 AM

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

12-14-2009 04:32 AM

Quote:

Originally Posted by shadowedsoul (Post 1930222)

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

12-14-2009 04:40 AM

Quote:

Originally Posted by Steve M (Post 1930233)

...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

12-14-2009 04:56 AM

Quote:

Originally Posted by MicroHellas (Post 1930299)

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

12-14-2009 05:11 AM

Quote:

Originally Posted by taffy056 (Post 1930066)

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

12-14-2009 05:15 AM

Quote:

Originally Posted by Charlie98902 (Post 1930045)

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.

Quote:

Originally Posted by Charlie98902 (Post 1930045)

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.

Quote:

Originally Posted by Charlie98902 (Post 1930045)

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

12-14-2009 08:16 AM

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

Code:

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

12-14-2009 08:34 AM

Quote:

Originally Posted by MicroHellas (Post 1929940)

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

12-14-2009 09:14 AM

Quote:

Originally Posted by bart6767 (Post 1930351)

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

12-14-2009 09:18 AM

Quote:

Originally Posted by MicroHellas (Post 1930364)

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

12-14-2009 09:19 AM

Quote:

Originally Posted by Harley D (Post 1930353)

Your 3.8 version does this as well.

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

Code:

    if($vbulletin->options["microsupport_products"])

    {

       $products = getProducts($ticket["productid"]);

    }

    if($vbulletin->options["microsupport_products"])

    {

       $departments = getDepartments($ticket["departmentid"]);

    }

Must be:

Code:

    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

12-14-2009 09:23 AM

Quote:

Originally Posted by bart6767 (Post 1930366)

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

12-14-2009 09:41 AM

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

12-14-2009 09:45 AM

Quote:

Originally Posted by MicroHellas (Post 1930369)

Thanks very much for your help .

Giangy94

12-14-2009 10:12 AM

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

PHP Code:


		
			
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

PHP Code:


		
			
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

12-14-2009 10:24 AM

Quote:

Originally Posted by Giangy94 (Post 1930390)

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

PHP Code:


		
			
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

PHP Code:


		
			
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

All times are GMT. The time now is 09:20 AM.

Page 1 of 9

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.06651 seconds Memory Usage 1,871KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (6)bbcode_code_printable (4)bbcode_php_printable (20)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (2)pagenav_pagelink (1)post_thanks_navbar_search (1)printthread (40)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: