Login

Login

Need to register? Lost password?

Options

Advertisements

Advertisements

 

a bug [SQL error]

Bug Reports

Minitokyo » Forum » Minitokyo Fora » Bug Reports  a bug [SQL error]

page 1 of 2
  • zuuti
  • Banned Member
  • 1y 48wk ago

Ok These error happen to any onec page with a gallery.
any page with a gallery link will have this error. Now please wait for Sheqel to address this problem.
Until Sheqel gets into the case, Now please wait.

Enough of complaining i now a lot of people have this problem
so just do something in the mean time that is all.

\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\(...)

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

Query:
SELECT i.id
FROM fav AS f
JOIN gallery_items AS i ON f.iid = i.id
WHERE f.uid = 230198
AND i.cid != 11
ORDER BY i.id DESC LIMIT 3


and

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 = 230198
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 = 230198
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 = 230198
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 = 230198
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 = 230198
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 = 230198
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 = 230198
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 = 230198
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 = 230198
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 = 230198
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 = 230198
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 = 230198
AND n.type = 12
ORDER BY n.id DESC LIMIT 32)
ORDER BY type ASC, stamp DESC

\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\(...)


same here ... :(

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.elite >= 0
AND c.div = 'art'
AND i.cid != 11
ORDER BY i.id DESC
LIMIT 6

These error happens to any page with a gallery.

Hello I can't open gallary

It's said

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

Query:
SELECT
i.id
FROM gallery_items AS i
JOIN gallery_cats AS c ON i.cid = c.id
WHERE i.cid != 11
AND c.div = 'scans'
ORDER BY id DESC
LIMIT 5

Seems like there's a problem with the database

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 = 834
ORDER BY i.favorites DESC
LIMIT 6

yeah i got one too

Like I said, any page with a gallery link will have this error. Now please wait for Sheqel to address this problem.

i thot it was jus me. does anyone know how long till its all good

same here.. how long will this last? i wanna upload the new death note wall i made last night

Until Sheqel gets into the case. Now please kindly wait. Thanks all.

Hwy Awol. Havent seen you since outrospective (dd's forums). Yes i seem to be having this too

This morning I used MT3, it was just fine. Then...

I'm having the same problem..I can't even read my notifications..

Same thing here. I whas rely begining to panick. Wll, just got to weit for it to pass.

I think thats what AWOL has said 3 different times now....

Yeah. Thanks for noticing.

i'm just glad its not me i'll wait it out with the rest of u ^^'

Cannot browse at 29 September 2006, errors:

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

Query:
SELECT SQL_CALC_FOUND_ROWS
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.elite >= 0

AND cid != 11
AND i.aid = 424






ORDER BY i.id desc LIMIT 0, 24

it's just all the same. guys out there, please don't post the same problem again. upon knowing what's going on in such confusing situation is all enough for you already. post only if there's any change / difference from the current situation now. thank you.


SELECT i.id
FROM fav AS f
JOIN gallery_items AS i ON f.iid = i.id
WHERE f.uid = 332140
AND i.cid != 11
ORDER BY i.id DESC LIMIT 3
somebody pls help me..........

could you too please stop this & wait? i'm having the same too btw...

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

Query:
SELECT
i.id
FROM gallery_items AS i
JOIN gallery_cats AS c ON i.cid = c.id
WHERE i.cid != 11
AND c.div = 'art'
ORDER BY id DESC
LIMIT 5

GUYS! Enough of this complaining. Just sit back and watch some anime. This problem will be fixed VERY SOON. Patience is a virtue.
thanks you folks.
(osmone close this thread)

Bah, another bug that's going to reveal the ignorant population of MT. I hope this one's fixed soon. You can do it mods! ^_^

page 1 of 2

Only members can post replies, please register.