vb.org Archive
Page 12 of 33 « First 21011 12 131422 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)

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

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,
to
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 09:00 PM.
Page 12 of 33 « First 21011 12 131422 Last »
Show 40 post(s) from this thread on one page

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01374 seconds
  • Memory Usage 1,766KB
  • 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
  • (5)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)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