Major Additions - microSUPPORT for vB4

*** Link Removed ***

[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]

Originally Posted by MicroHellas

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]

Originally Posted by bart6767

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]

Originally Posted by MicroHellas

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]

Originally Posted by Harley D

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]

Originally Posted by bart6767

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]

Originally Posted by MicroHellas

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

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]

Originally Posted by 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

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