NOTE: this thread will be kept clean, and all posts not necessary anymore will be deleted

Ok, this thread will give you the guidelines for bug forum. Writing it sketchily cause I'm doing too many things and I'll update later

- ONE bug per thread please
- Explain in the title as much as you can so other users can post in your thread if they have the SAME bug
- Search for duplicates before submitting threads

More to come..

EDIT (by eunasahng):

Common Problems and Solutions Thread has now been posted. Check this thread before you post.

Hello I make an account long time ago, cause i also forgot my username and password, but my email is the dragon_cangry_joe@hotmail.com, who can help me get it back?

I am unable to view my notifications and submission, it appear as SQL error... What happen actually?

I can see none of minitokyo gallery's
it just appears a square with the programming web page's language and telling what should have been appearing

Quote by ToshieI am unable to view my notifications and submission, it appear as SQL error... What happen actually?

Ditto, it's happening to me too. Plus I can't go to my UP.

i cant view any of minitokyo galleries it says MySQL Error:
Can't open file: 'gallery_items.MYI' (errno: 145)? wat am i supose to do?

Same here.

Quote:
MySQL Error:

Can't open file: 'gallery_items.MYI' (errno: 145)
Query:

(SELECT
n.id, n.type, n.rid, p.stamp, p.uid, u.name AS uname, u.status, NULL AS rid2, t.subject AS title
FROM notifications AS n
JOIN forum_threads AS t ON n.rid = t.id
JOIN forum_posts AS p ON t.first_pid = p.id
JOIN users AS u ON p.uid = u.id
WHERE n.recipient_id = 400554
AND n.type = 1
ORDER BY n.id DESC LIMIT 32)
UNION
(SELECT
n.id, n.type, n.rid, f.stamp, u.id AS uid, u.name AS uname, u.status, NULL AS rid2, f.type AS title
FROM notifications AS n
JOIN friends AS f ON n.rid = f.id
JOIN users AS u ON f.friend_uid = u.id
WHERE n.recipient_id = 400554
AND n.type = 2
ORDER BY n.id DESC LIMIT 32)
UNION
(SELECT
n.id, n.type, n.rid, f.stamp, u.id AS uid, u.name AS uname, u.status, i.id AS rid2, i.title
FROM notifications AS n
JOIN fav AS f ON n.rid = f.id
JOIN users AS u ON f.uid = u.id
JOIN gallery_items AS i ON f.iid = i.id
WHERE n.recipient_id = 400554
AND n.type = 3
ORDER BY n.id DESC LIMIT 32)
UNION
(SELECT
n.id, n.type, n.rid, p.stamp, u.id AS uid, u.name AS uname, u.status, i.id AS rid2, i.title
FROM notifications AS n
JOIN gallery_posts AS p ON n.rid = p.id
JOIN users AS u ON p.uid = u.id
JOIN gallery_items AS i ON p.iid = i.id
WHERE n.recipient_id = 400554
AND n.type = 4
ORDER BY n.id DESC LIMIT 32)
UNION
(SELECT
n.id, n.type, n.rid, p.stamp, u.id AS uid, u.name AS uname, u.status, t.id AS rid2, t.subject AS title
FROM notifications AS n
JOIN forum_posts AS p ON n.rid = p.id
JOIN users AS u ON p.uid = u.id
JOIN forum_threads AS t ON p.tid = t.id
WHERE n.recipient_id = 400554
AND n.type = 5
ORDER BY n.id DESC LIMIT 32)
UNION
(SELECT
n.id, n.type, n.rid, p.stamp, u.id AS uid, u.name AS uname, u.status, NULL AS rid2, NULL AS title
FROM notifications AS n
JOIN guestbook_posts AS p ON n.rid = p.id
JOIN users AS u ON p.uid = u.id
WHERE n.recipient_id = 400554
AND n.type = 6
ORDER BY n.id DESC LIMIT 32)
UNION
(SELECT
n.id, n.type, n.rid, p.stamp, u.id AS uid, u.name AS uname, u.status, p.id rid2, p.subject AS title
FROM notifications AS n
JOIN pm_inbox AS p ON n.rid = p.id
JOIN users AS u ON p.sender_uid = u.id
WHERE n.recipient_id = 400554
AND n.type = 7
ORDER BY n.id DESC LIMIT 32)
UNION
(SELECT
n.id, n.type, n.rid, i.stamp, u.id AS uid, u.name AS uname, u.status, i.id rid2, i.title
FROM notifications AS n
JOIN gallery_items AS i ON n.rid = i.id
JOIN users AS u ON i.uid = u.id
WHERE n.recipient_id = 400554
AND n.type = 8
ORDER BY n.id DESC LIMIT 32)
UNION
(SELECT
n.id, n.type, n.rid, p.stamp, u.id AS uid, u.name AS uname, u.status, t.id rid2, t.subject AS title
FROM notifications AS n
JOIN forum_threads AS t ON n.rid = t.id
JOIN forum_posts AS p ON t.first_pid = p.id
JOIN users AS u ON p.uid = u.id
WHERE n.recipient_id = 400554
AND n.type = 9
ORDER BY n.id DESC LIMIT 32)
UNION
(SELECT
n.id, n.type, n.rid, r.stamp, u.id AS uid, u.name AS uname, u.status, r.id rid2, a.title
FROM notifications AS n
JOIN reviews AS r ON n.rid = r.id
JOIN animes AS a ON r.aid = a.id
JOIN users AS u ON r.uid = u.id
WHERE n.recipient_id = 400554
AND n.type = 10
ORDER BY n.id DESC LIMIT 32)
UNION
(SELECT
n.id, n.type, n.rid, p.stamp, u.id AS uid, u.name AS uname, u.status, r.id AS rid2, a.title
FROM notifications AS n
JOIN reviews_posts AS p ON n.rid = p.id
JOIN users AS u ON p.uid = u.id
JOIN reviews AS r ON p.rid = r.id
JOIN animes AS a ON r.aid = a.id
WHERE n.recipient_id = 400554
AND n.type = 11
ORDER BY n.id DESC LIMIT 32)
UNION
(SELECT
n.id, n.type, n.rid, p.stamp, g.id AS uid, g.name AS uname, 3 AS status, t.id rid2, t.subject AS title
FROM notifications AS n
JOIN forum_threads AS t ON n.rid = t.id
JOIN forum_posts AS p ON t.first_pid = p.id
JOIN groups_threads AS gt ON t.id = gt.tid
JOIN groups AS g ON gt.gid = g.id
WHERE n.recipient_id = 400554
AND n.type = 12
ORDER BY n.id DESC LIMIT 32)
ORDER BY type ASC, stamp DESC

I think it's been already been reported. But I hope you find something helpfull. I just open MT and this appears:
MySQL Error:
Can't open file: 'gallery_items.MYI' (errno: 145)

Query:
SELECT
i.id,
a.title AS aname,
c.name AS cname
FROM gallery_items AS i
JOIN gallery_cats AS c ON i.cid = c.id
LEFT JOIN animes AS a ON i.aid = a.id
WHERE i.id > (SELECT MAX(id) - 80 FROM gallery_items)
AND i.elite >= 0
AND c.div = 'art'
AND i.cid != 11
ORDER BY i.id DESC
LIMIT 6

Thanks in advance.

Hi! we have a bug on Hispania's group:

MySQL Error:

Can't open file: 'gallery_items.MYI' (errno: 145)
Query:

SELECT
i.id
FROM groups_galleries AS g
JOIN gallery_items AS i ON g.iid = i.id
WHERE g.gid = 995
ORDER BY i.favorites DESC
LIMIT 6

Please, Help!

Hi!

I'm getting the same wrroe as everyone else above... so I can't see my galler, control panel, notifications, etc.

Hope this thing will be solved soon.

Thanks for reporting the bug. The admins have been contacted and are trying to fix the problem. In the mean time, please be patient.