mobile_medic 43 Posted June 8, 2016 Getting this error when trying to view "content | follow": An error occured with the SQL server:mySQL query error: SELECT l.* FROM core_like l LEFT JOIN topics t ON ( l.like_rel_id=t.tid ) WHERE l.like_member_id=801594 AND l.like_visible=1 AND l.like_app='forums' AND l.like_area='topics' AND ( ( FIND_IN_SET(57,t.forum_id) OR FIND_IN_SET(195,t.forum_id) OR FIND_IN_SET(58,t.forum_id) OR FIND_IN_SET(111,t.forum_id) OR FIND_IN_SET(89,t.forum_id) OR FIND_IN_SET(13,t.forum_id) OR FIND_IN_SET(15,t.forum_id) OR FIND_IN_SET(56,t.forum_id) OR FIND_IN_SET(54,t.forum_id) OR FIND_IN_SET(105,t.forum_id) OR FIND_IN_SET(55,t.forum_id) OR FIND_IN_SET(82,t.forum_id) OR FIND_IN_SET(81,t.forum_id) OR FIND_IN_SET(83,t.forum_id) OR FIND_IN_SET(84,t.forum_id) OR FIND_IN_SET(85,t.forum_id) OR FIND_IN_SET(88,t.forum_id) OR FIND_IN_SET(132,t.forum_id) OR FIND_IN_SET(86,t.forum_id) OR FIND_IN_SET(87,t.forum_id) OR FIND_IN_SET(35,t.forum_id) OR FIND_IN_SET(33,t.forum_id) OR FIND_IN_SET(34,t.forum_id) OR FIND_IN_SET(21,t.forum_id) OR FIND_IN_SET(28,t.forum_id) OR FIND_IN_SET(19,t.forum_id) OR FIND_IN_SET(53,t.forum_id) OR FIND_IN_SET(20,t.forum_id) OR FIND_IN_SET(22,t.forum_id) OR FIND_IN_SET(52,t.forum_id) OR FIND_IN_SET(31,t.forum_id) OR FIND_IN_SET(59,t.forum_id) OR FIND_IN_SET(39,t.forum_id) OR FIND_IN_SET(46,t.forum_id) OR FIND_IN_SET(47,t.forum_id) OR FIND_IN_SET(70,t.forum_id) OR FIND_IN_SET(62,t.forum_id) OR FIND_IN_SET(66,t.forum_id) OR FIND_IN_SET(64,t.forum_id) OR FIND_IN_SET(65,t.forum_id) OR FIND_IN_SET(71,t.forum_id) OR FIND_IN_SET(68,t.forum_id) OR FIND_IN_SET(67,t.forum_id) OR FIND_IN_SET(63,t.forum_id) OR FIND_IN_SET(72,t.forum_id) OR FIND_IN_SET(73,t.forum_id) OR FIND_IN_SET(78,t.forum_id) OR FIND_IN_SET(29,t.forum_id) OR FIND_IN_SET(69,t.forum_id) OR FIND_IN_SET(77,t.forum_id) OR FIND_IN_SET(75,t.forum_id) OR FIND_IN_SET(74,t.forum_id) OR FIND_IN_SET(76,t.forum_id) OR FIND_IN_SET(25,t.forum_id) OR FIND_IN_SET(51,t.forum_id) OR FIND_IN_SET(40,t.forum_id) OR FIND_IN_SET(48,t.forum_id) OR FIND_IN_SET(49,t.forum_id) OR FIND_IN_SET(50,t.forum_id) OR FIND_IN_SET(60,t.forum_id) OR FIND_IN_SET(193,t.forum_id) OR FIND_IN_SET(79,t.forum_id) OR FIND_IN_SET(136,t.forum_id) OR FIND_IN_SET(109,t.forum_id) OR FIND_IN_SET(113,t.forum_id) OR FIND_IN_SET(95,t.forum_id) OR FIND_IN_SET(127,t.forum_id) OR FIND_IN_SET(126,t.forum_id) OR FIND_IN_SET(135,t.forum_id) OR FIND_IN_SET(133,t.forum_id) OR FIND_IN_SET(146,t.forum_id) OR FIND_IN_SET(147,t.forum_id) OR FIND_IN_SET(134,t.forum_id) OR FIND_IN_SET(148,t.forum_id) OR FIND_IN_SET(149,t.forum_id) OR FIND_IN_SET(90,t.forum_id) OR FIND_IN_SET(91,t.forum_id) OR FIND_IN_SET(106,t.forum_id) OR FIND_IN_SET(92,t.forum_id) OR FIND_IN_SET(93,t.forum_id) OR FIND_IN_SET(94,t.forum_id) OR FIND_IN_SET(96,t.forum_id) OR FIND_IN_SET(97,t.forum_id) OR FIND_IN_SET(98,t.forum_id) OR FIND_IN_SET(99,t.forum_id) OR FIND_IN_SET(100,t.forum_id) OR FIND_IN_SET(150,t.forum_id) OR FIND_IN_SET(101,t.forum_id) OR FIND_IN_SET(18,t.forum_id) OR FIND_IN_SET(102,t.forum_id) OR FIND_IN_SET(103,t.forum_id) OR FIND_IN_SET(151,t.forum_id) OR FIND_IN_SET(108,t.forum_id) OR FIND_IN_SET(190,t.forum_id) OR FIND_IN_SET(178,t.forum_id) OR FIND_IN_SET(153,t.forum_id) OR FIND_IN_SET(167,t.forum_id) OR FIND_IN_SET(156,t.forum_id) OR FIND_IN_SET(155,t.forum_id) OR FIND_IN_SET(158,t.forum_id) OR FIND_IN_SET(179,t.forum_id) OR FIND_IN_SET(157,t.forum_id) OR FIND_IN_SET(159,t.forum_id) OR FIND_IN_SET(160,t.forum_id) OR FIND_IN_SET(152,t.forum_id) OR FIND_IN_SET(196,t.forum_id) OR FIND_IN_SET(201,t.forum_id) OR FIND_IN_SET(119,t.forum_id) OR FIND_IN_SET(130,t.forum_id) OR FIND_IN_SET(104,t.forum_id) OR FIND_IN_SET(128,t.forum_id) OR FIND_IN_SET(129,t.forum_id) OR FIND_IN_SET(120,t.forum_id) OR FIND_IN_SET(131,t.forum_id) OR FIND_IN_SET(121,t.forum_id) OR FIND_IN_SET(122,t.forum_id) OR FIND_IN_SET(123,t.forum_id) OR FIND_IN_SET(124,t.forum_id) OR FIND_IN_SET(125,t.forum_id) OR FIND_IN_SET(112,t.forum_id) OR FIND_IN_SET(110,t.forum_id) OR FIND_IN_SET(114,t.forum_id) OR FIND_IN_SET(115,t.forum_id) OR FIND_IN_SET(116,t.forum_id) OR FIND_IN_SET(117,t.forum_id) OR FIND_IN_SET(118,t.forum_id) OR FIND_IN_SET(137,t.forum_id) OR FIND_IN_SET(138,t.forum_id) OR FIND_IN_SET(139,t.forum_id) OR FIND_IN_SET(140,t.forum_id) OR FIND_IN_SET(141,t.forum_id) OR FIND_IN_SET(142,t.forum_id) OR FIND_IN_SET(143,t.forum_id) OR FIND_IN_SET(144,t.forum_id) OR FIND_IN_SET(145,t.forum_id) OR FIND_IN_SET(154,t.forum_id) OR FIND_IN_SET(162,t.forum_id) OR FIND_IN_SET(163,t.forum_id) OR FIND_IN_SET(191,t.forum_id) OR FIND_IN_SET(164,t.forum_id) OR FIND_IN_SET(165,t.forum_id) OR FIND_IN_SET(180,t.forum_id) OR FIND_IN_SET(166,t.forum_id) OR FIND_IN_SET(199,t.forum_id) OR FIND_IN_SET(200,t.forum_id) OR FIND_IN_SET(169,t.forum_id) OR FIND_IN_SET(172,t.forum_id) OR FIND_IN_SET(171,t.forum_id) OR FIND_IN_SET(170,t.forum_id) OR FIND_IN_SET(174,t.forum_id) OR FIND_IN_SET(175,t.forum_id) OR FIND_IN_SET(177,t.forum_id) OR FIND_IN_SET(189,t.forum_id) OR FIND_IN_SET(176,t.forum_id) OR FIND_IN_SET(183,t.forum_id) OR FIND_IN_SET(182,t.forum_id) OR FIND_IN_SET(192,t.forum_id) OR FIND_IN_SET(184,t.forum_id) OR FIND_IN_SET(185,t.forum_id) OR FIND_IN_SET(186,t.forum_id) OR FIND_IN_SET(187,t.forum_id) OR FIND_IN_SET(188,t.forum_id) OR FIND_IN_SET(194,t.forum_id) ) ) ORDER BY t.last_post DESC LIMIT 0,25 This is not a problem with the IPS Community Suite but rather with your SQL server. Please contact your host and copy the message shown above. Also, got a similar, but shorter error when trying to view this thread: https://forums.bistudio.com/topic/184155-forums-migrationupdate-status-items/ An error occured with the SQL server:mySQL query error: SELECT tg.* ,t.*, t.approved, t.title as topic_title, t.posts as topic_posts, t.last_post as topic_last_post,m.*,p.*,xxx.* FROM core_tags tg LEFT JOIN topics t ON (t.tid=tg.tag_meta_id) LEFT JOIN members m ON (last_poster_id=m.member_id) LEFT JOIN profile_portal p ON (p.pp_member_id=m.member_id) LEFT JOIN core_tags_cache xxx ON (xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid))) WHERE tg.tag_meta_app='forums' AND tg.tag_meta_area='topics' AND tg.tag_meta_id !=184155 AND tg.tag_text IN ('forum','status','feedback','issues','forums') AND tg.tag_aai_lookup IN (SELECT tag_perm_aai_lookup FROM core_tags_perms WHERE ( ( FIND_IN_SET(3,tag_perm_text) ) OR ( tag_perm_text='*' ) ) AND tag_perm_visible=1 ) ORDER BY tg.tag_meta_id desc LIMIT 0,100 This is not a problem with the IPS Community Suite but rather with your SQL server. Please contact your host and copy the message shown above. 1 Share this post Link to post Share on other sites
Flax 397 Posted June 8, 2016 Can confirm getting sporadic errors over certain parts of the forum. Can't access certain topics or "Content I Subscribe To" page. ** EDIT 1443 GMT+1 ** Seems to be fixed now. Share this post Link to post Share on other sites
Vasily.B 529 Posted June 24, 2016 I still have those. Try to open this site :https://forums.bistudio.com/topic/183435-rhs-escalation-afrf-and-usaf/page-225Its throwing second error. Share this post Link to post Share on other sites
Alpha-Kilo 36 Posted June 24, 2016 So do I. Some random examples: [WIP] Blood Lust (6-10-2016 v2.4) - MP Support Added! JSRS3 - DragonFyre EDEN 1.4 Share this post Link to post Share on other sites
mobile_medic 43 Posted June 24, 2016 I still have those. Try to open this site : https://forums.bistudio.com/topic/183435-rhs-escalation-afrf-and-usaf/page-225 Its throwing second error. Confirmed. same error to that link for me as well. Share this post Link to post Share on other sites
kklownboy 43 Posted June 24, 2016 "An error occured with the SQL server:".................. hit and miss which thread has the issue Share this post Link to post Share on other sites
HorribleGoat 1464 Posted June 24, 2016 Made accidental double post just now because of got spooked by the error message and hit back and sent the post again just now. Both are corrupted.. :P Share this post Link to post Share on other sites
Grezvany13 64 Posted June 24, 2016 I've experienced the same issue with several topics, and (as far as I can see) it's releated to TAGS which are added to a topic!!! Although I can't debug the error messages (since it only shows the SQL query), I guess the table is corrupted or even gone. 1 Share this post Link to post Share on other sites
HorribleGoat 1464 Posted June 24, 2016 Hmm. I used "optical camouflage" in mine. Could it be the space or length of the tag? Share this post Link to post Share on other sites
Grezvany13 64 Posted June 24, 2016 Hmm. I used "optical camouflage" in mine. Could it be the space or length of the tag? Doesn't seem to, since I also get it at this topic https://forums.bistudio.com/topic/190334-wip-uh-60m-black-hawk/, which has 'uh60' as a tag. Just to add to the "bug report", here's the query in question: SELECT tg.*, t.*, t.approved, t.title as topic_title, t.posts as topic_posts, t.last_post as topic_last_post, m.*, p.*, xxx.* FROM core_tags tg LEFT JOIN topics t ON ( t.tid=tg.tag_meta_id ) LEFT JOIN members m ON ( last_poster_id=m.member_id ) LEFT JOIN profile_portal p ON ( p.pp_member_id=m.member_id ) LEFT JOIN core_tags_cache xxx ON ( xxx.tag_cache_key = MD5(CONCAT('forums',';','topics',';',t.tid)) ) WHERE tg.tag_meta_app='forums' AND tg.tag_meta_area='topics' AND tg.tag_meta_id !=190334 AND tg.tag_text IN ('uh60') AND tg.tag_aai_lookup IN ( SELECT tag_perm_aai_lookup FROM core_tags_perms WHERE ( ( FIND_IN_SET(3,tag_perm_text) ) OR ( tag_perm_text='*' ) ) AND tag_perm_visible=1 ) ORDER BY tg.tag_meta_id desc LIMIT 0,100 Share this post Link to post Share on other sites
ayavadim 13 Posted June 24, 2016 Please help, I'm getting this error when trying to open my topic. https://forums.bistudio.com/topic/191658-zoom-fix-for-vtn-veteran-mod/ mySQL query error: SELECT tg.* ,t.*, t.approved, t.title as topic_title, t.posts as topic_posts, t.last_post as topic_last_post,m.*,p.*,xxx.* FROM core_tags tg LEFT JOIN topics t ON (t.tid=tg.tag_meta_id) LEFT JOIN members m ON (last_poster_id=m.member_id) LEFT JOIN profile_portal p ON (p.pp_member_id=m.member_id) LEFT JOIN core_tags_cache xxx ON (xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid))) WHERE tg.tag_meta_app='forums' AND tg.tag_meta_area='topics' AND tg.tag_meta_id !=191658 AND tg.tag_text IN ('vtn','zoom','fix','veteran','mod') AND tg.tag_aai_lookup IN (SELECT tag_perm_aai_lookup FROM core_tags_perms WHERE ( ( FIND_IN_SET(3,tag_perm_text) ) OR ( tag_perm_text='*' ) ) AND tag_perm_visible=1 ) ORDER BY tg.tag_meta_id desc LIMIT 0,100 Share this post Link to post Share on other sites
opteryx 1562 Posted June 24, 2016 I'm getting this error when trying to open my thread: An error occured with the SQL server: mySQL query error: SELECT tg.* ,t.*, t.approved, t.title as topic_title, t.posts as topic_posts, t.last_post as topic_last_post,m.*,p.*,xxx.* FROM core_tags tg LEFT JOIN topics t ON (t.tid=tg.tag_meta_id) LEFT JOIN members m ON (last_poster_id=m.member_id) LEFT JOIN profile_portal p ON (p.pp_member_id=m.member_id) LEFT JOIN core_tags_cache xxx ON (xxx.tag_cache_key=MD5(CONCAT('forums',';','topics',';',t.tid))) WHERE tg.tag_meta_app='forums' AND tg.tag_meta_area='topics' AND tg.tag_meta_id !=186236 AND tg.tag_text IN ('Building pack') AND tg.tag_aai_lookup IN (SELECT tag_perm_aai_lookup FROM core_tags_perms WHERE ( ( FIND_IN_SET(3,tag_perm_text) ) OR ( tag_perm_text='*' ) ) AND tag_perm_visible=1 ) ORDER BY tg.tag_meta_id desc LIMIT 0,100 This is not a problem with the IPS Community Suite but rather with your SQL server. Please contact your host and copy the message shown above. Share this post Link to post Share on other sites
Vasily.B 529 Posted June 25, 2016 There is new error : forums.bistudio.com Driver Error There appears to be an error with the database. If you are seeing this page, it means there was a problem communicating with our database. Sometimes this error is temporary and will go away when you refresh the page. Sometimes the error will need to be fixed by an administrator before the site will become accessible again. You can try to refresh the page by clicking here ↠Return to the index On site :https://forums.bistudio.com/topic/186835-community-upgrade-project-cup-terrains/page-49#entry3051133 Share this post Link to post Share on other sites
austin_medic 109 Posted June 25, 2016 There is new error : forums.bistudio.com Driver Error There appears to be an error with the database. If you are seeing this page, it means there was a problem communicating with our database. Sometimes this error is temporary and will go away when you refresh the page. Sometimes the error will need to be fixed by an administrator before the site will become accessible again. You can try to refresh the page by clicking here ↠Return to the index On site : https://forums.bistudio.com/topic/186835-community-upgrade-project-cup-terrains/page-49#entry3051133 Its' resolved now at least for me, though others are having issues with blank pages if they're not logged in now as well. Share this post Link to post Share on other sites
R0adki11 3945 Posted June 25, 2016 I believe it is a SQL Database error effecting the Forum Software, it looks like it has been resolved. Share this post Link to post Share on other sites
Tankbuster 1731 Posted June 25, 2016 When this thread was first started, trying to read it was giving that SQL error. :) 2 Share this post Link to post Share on other sites