Jump to content

Recommended Posts

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.

 

  • Like 1

Share this post


Link to post
Share on other sites

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

"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

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

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.

  • Like 1

Share this post


Link to post
Share on other sites

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

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

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

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

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

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

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

When this thread was first started, trying to read it was giving that SQL error. :)

  • Like 2

Share this post


Link to post
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now

×