What the Tech?! Free tech support Archive
This is a read-only archive. No new posts or registrations. Privacy Page
What the Tech Community

Database issues resolved

4 min read

This thread's last reply is from . Advice, software, and links below may be out of date — treat specific steps and download links with caution.

Post #1
Hello, everyone. On behalf of the Admin team here at TC, I would like to apologize for the troubles you all encountered posting today. There were some issues with the database that we are confident are now corrected. You will notice some "empty" topics as you surf the boards. Mods and Admins, please feel free to close and/or delete these topics. If they were posts for "help" (such as in the Malware forum), please pm the original poster and let them know their post did not go through. That way, they can post again for the help they need. :) To everyone, if you run into any difficulties or have any more MySQL errors, please reply to this thread and let us know. Give us as much information as you can, as well as paste any errors you receive, and what you were trying to do at the time. (start a thread, reply to a post, etc). That way, we can address the issues as quickly as possible. Thank you for your patience as we worked to get everything under control. Special thanks to DeviousTrap and Magilla for their hard work fixing the database. :)
Post #2 last edited
If you get any more SQL errors, chances are that you won't be able to post in this thread :P IM me if you can't, and I'll log it, and we'll work from there :) AIM: TehMagilla MSN: [removed] ICQ: 11689987 Alternatively, you can catch me on IRC. Try me (Magilla) in #seport on freeNode, or #geekstogo on Wyldryde
Post #3
Still can't post reply to HJT log :angry: mySQL query error: INSERT INTO ibf_mail_queue (mail_to,mail_date,mail_subject,mail_content) VALUES('[removed]',1134478209,'Topic Subscription Reply Notification','RuyLopez,\r\n\r\nLDTate has just posted a reply to a topic that you have subscribed to titled \"CWS.LoadAdv.400 and MidAddle Infection\".\r\n\r\nThe topic can be found here:\r\nhttp://forums.tomcoyote.org/index.php?showtopic=52251&view;=getnewpost\r\n\r\nThere may be more replies to this topic, but only 1 email is sent per board visit for each subscribed topic. This is\r\nto limit the amount of mail that is sent to your inbox.\r\n\r\nUnsubscribing:\r\n————–\r\n\r\nYou can unsubscribe at any time by logging into your control panel and clicking on the \"View Subscriptions\" link.\r\n\r\nRegards,\r\n\r\nThe TomCoyote Forums team.\r\nhttp://forums.tomcoyote.org/index.php\r\n') SQL error: Duplicate entry '1346906' for key 1 SQL error code: Date: Tuesday 13th of December 2005 06:50:09 AM
Post #4

Still can't post reply to HJT log :angry:


mySQL query error: INSERT INTO ibf_mail_queue (mail_to,mail_date,mail_subject,mail_content) VALUES('[removed]',1134478209,'Topic Subscription Reply Notification','RuyLopez,\r\n\r\nLDTate has just posted a reply to a topic that you have subscribed to titled \"CWS.LoadAdv.400 and MidAddle Infection\".\r\n\r\nThe topic can be found here:\r\nhttp://forums.tomcoyote.org/index.php?showtopic=52251&view;=getnewpost\r\n\r\nThere may be more replies to this topic, but only 1 email is sent per board visit for each subscribed topic. This is\r\nto limit the amount of mail that is sent to your inbox.\r\n\r\nUnsubscribing:\r\n————–\r\n\r\nYou can unsubscribe at any time by logging into your control panel and clicking on the \"View Subscriptions\" link.\r\n\r\nRegards,\r\n\r\nThe TomCoyote Forums team.\r\nhttp://forums.tomcoyote.org/index.php\r\n')

SQL error: Duplicate entry '1346906' for key 1
SQL error code:
Date: Tuesday 13th of December 2005 06:50:09 AM


Please give this a try now.
Post #5 last edited
Lets see if it works. I'm at work so I'll see how it's working at home. Right now it seems slow in responding, but so far so good :thumbup: Thanks
Post #7
wng_z3r0, are you still having this issue? I can't find anything in your profile that got messed up, so you SHOULD be able to see everything you're supposed to. Let me do a bit more digging, and check all the permission masks. We actually had one get completely DELETED at g2g at one point. :blink:
Post #8
and now, (at home computer) I can see everything. The computer where I couldn't see most of the forums was at school. And it used to work fine at school. I'll double check it tomorrow. wng
Post #9
mySQL query error: SELECT s.topic_track_type, s.trid, s.member_id, s.topic_id, s.last_sent, s.start_date as track_started, t.*, f.id as forum_id, f.name as forum_name FROM ibf_tracker s, ibf_topics t, ibf_forums f WHERE s.member_id=15276 AND t.tid=s.topic_id AND f.id=t.forum_id AND t.last_post > '1131920783' ORDER BY f.id, t.last_post DESC SQL error: Got error 127 from storage engine SQL error code: Date: Tuesday 13th of December 2005 04:26:23 PM
Post #11
mySQL query error: INSERT INTO ibf_tracker (member_id,topic_id,start_date,topic_track_type) VALUES(6554,53616,1134513215,'immediate') SQL error: Duplicate entry '74139' for key 1 SQL error code: Date: Tuesday 13th of December 2005 04:33:35 PM
Post #13 last edited

mySQL query error: INSERT INTO ibf_tracker (member_id,topic_id,start_date,topic_track_type) VALUES(6554,53616,1134513215,'immediate')

SQL error: Duplicate entry '74139' for key 1
SQL error code:
Date: Tuesday 13th of December 2005 04:33:35 PM


Fixed that.
Post #15
Everyone *please* keep all issues in THIS thread, and don't start new ones. It will make things much easier on us to be able to keep track of what has and has not been fixed. :) Thanks!