Major Additions - microSUPPORT for vB4

*** Link Removed ***

[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/v...ditor.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]

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

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]

Originally Posted by Edrondol

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]

Originally Posted by KozmoK

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

Originally Posted by KozmoK

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.

Originally Posted by KozmoK

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?