vb.org Archive - Major Additions - microSUPPORT for vB4

Page 3 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)

Mrquarter2

12-23-2009 03:15 AM

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

MaryTheG(r)eek

12-23-2009 08:34 AM

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

12-23-2009 09:02 AM

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

12-23-2009 09:15 AM

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

Quote:

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

12-23-2009 09:25 AM

Quote:

Originally Posted by Naxon (Post 1936180)

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

12-23-2009 10:59 AM

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 .

Code:

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	12-23-2009 11:12 AM

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

Naxon

12-23-2009 03:08 PM

Quote:

Originally Posted by MicroHellas (Post 1936184)

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

12-23-2009 03:31 PM

Quote:

Originally Posted by Naxon (Post 1936453)

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

12-23-2009 03:39 PM

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

12-23-2009 04:00 PM

Quote:

Originally Posted by MicroHellas (Post 1936477)

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

Maria

Already done...

tyfoon

12-23-2009 04:26 PM

Quote:

Originally Posted by taffy056 (Post 1936488)

Solution , change

Code:

<?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',

);

Code:

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

12-23-2009 04:44 PM

I'll just use Projects, good mod anyway!

taffy056

12-23-2009 04:47 PM

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

Code:

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

12-23-2009 05:00 PM

@taffy did you turn departments on in the admincp ?

and specified them there ?

MaryTheG(r)eek

12-23-2009 05:11 PM

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

12-23-2009 05:12 PM

Quote:

Originally Posted by taffy056 (Post 1936572)

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

Code:

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

12-23-2009 05:44 PM

Quote:

Originally Posted by MicroHellas (Post 1936596)

Fixed. Sorry for troubles.

Maria

Nice one that works .

taffy056

12-23-2009 05:55 PM

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

12-23-2009 06:01 PM

Quote:

Originally Posted by taffy056 (Post 1936660)

I just tryed that and it works for me .

taffy056

12-23-2009 06:09 PM

Quote:

Originally Posted by bart6767 (Post 1936669)

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

12-23-2009 06:20 PM

PHP Code:


		
			
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

PHP Code:


		
			
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

12-23-2009 06:23 PM

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

bart6767

12-23-2009 06:55 PM

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

12-23-2009 07:17 PM

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

Mrquarter2

12-23-2009 07:20 PM

Great job! it works :)

valendono

12-23-2009 07:50 PM

I got this problem

HTML Code:

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

12-25-2009 05:10 PM

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

MaryTheG(r)eek

12-25-2009 06:43 PM

Quote:

Originally Posted by KozmoK (Post 1938092)

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

12-25-2009 07:13 PM

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

12-25-2009 09:38 PM

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/v...ditor.js?v=400

kf4eok

12-26-2009 02:11 AM

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

KozmoK

12-27-2009 10:35 PM

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

12-28-2009 07:51 PM

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

Code:

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

12-28-2009 08:02 PM

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.

Code:

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

12-29-2009 02:53 PM

Quote:

Originally Posted by wildweaselmi (Post 1940788)

Code:

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

12-29-2009 08:14 PM

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

12-30-2009 08:51 AM

Quote:

Originally Posted by Edrondol (Post 1941573)

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:

Code:

    $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:

Code:

'question' => TYPE_NOHTML,

Code:

'question' => TYPE_STR,

Maria

MaryTheG(r)eek

12-30-2009 09:01 AM

Quote:

Originally Posted by KozmoK (Post 1941866)

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

Quote:

Originally Posted by KozmoK (Post 1941866)

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.

Quote:

Originally Posted by KozmoK (Post 1941866)

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

01-01-2010 02:47 AM

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

All times are GMT. The time now is 04:47 PM.

Page 3 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.01457 seconds Memory Usage 1,880KB 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 (11)bbcode_code_printable (1)bbcode_html_printable (2)bbcode_php_printable (16)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)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: