vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Big Board Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=172)
-   -   Serious MySQL Problem (https://vborg.vbsupport.ru/showthread.php?t=166183)

EricGT 12-26-2007 06:51 PM

Serious MySQL Problem
 
Hi folks. This isn't a vBulletin problem, strictly speaking, but it is causing a lot of trouble with my development plans for my vBulletin site. I am really hoping someone here some insight into what is going on.

I recently changed to new servers and to MySQL 5.0.62, at the same time. Everything is working properly except for one very troublesome thing: I cannot edit and save any template containing a '< script >' tag, or add any content containing that tag to any template. When I try, the process times out and when I reopen that template, it is blank. This isn't just a vBulletin problem though. I get the same thing if I try to edit or modify and database field that already contains a script tag, or if I try to insert one.

I've experimented and trying to add '<script' causes the failure, while trying to add '<scrip' does not. It is the first part of that tag specifically causing this failure. This is bizarre. I've been using MySQL for eight years and I have never seen anything like this. Does anyone have any ideas on what could be causing this(I hope, I hope)? I am stumped. I appreciate any help any of you could provide. Eric

Yours 12-26-2007 07:13 PM

vBulletin requires MySQL4 or later to work properly. If you are using an older version then you are lucky vBulletin is working at all.

EricGT 12-26-2007 07:15 PM

Well, I solved this one myself. The Intrusion Protection System on my firewall was seeing the script tag in the packet sent to the MySQL server and killing it. DOH!:o No wonder no one is talking about the problem anywhere I could find. Well, it is easy enough to fix. Sometimes this stuff can be frustrating, but it always feels good to track down the problem. Thanks anyway, for the help. Eric

--------------- Added [DATE]1198705831[/DATE] at [TIME]1198705831[/TIME] ---------------

Quote:

Originally Posted by Yours (Post 1409619)
vBulletin requires MySQL4 or later to work properly. If you are using an older version then you are lucky vBulletin is working at all.

That should have said '5.0.62'. That was a typo, on my part. Anyway, it turns out that my firewall's intrusion detection system was the culprit. Thanks for the reply though. Eric

TECK 12-27-2007 07:49 PM

I wonder who do you know at MySQL to get this version (5.0.62)... when the latest is 5.0.51
It is good to know Uncle Lenny... forgetaboutit :D

EricGT 12-27-2007 08:47 PM

Quote:

Originally Posted by TECK (Post 1410290)
I wonder who do you know at MySQL to get this version (5.0.62)... when the latest is 5.0.51
It is good to know Uncle Lenny... forgetaboutit :D

Oops. That is another typo. It should read '5.0.32'. That is the default install version for the stable distro of Debian Linux. Sorry about that. Eric


All times are GMT. The time now is 07:38 AM.

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.01476 seconds
  • Memory Usage 1,716KB
  • 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
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (5)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete