vb.org Archive - Major Additions - microSUPPORT for vB4

Page 4 of 33

« First

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)

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 05:00 PM.

Page 4 of 33

« First

Last »

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01466 seconds Memory Usage 1,779KB 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 (3)bbcode_code_printable (4)bbcode_php_printable (7)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (1)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)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: