Warning: Undefined array key "HTTP_ACCEPT_LANGUAGE" in /var/www/minitokyo/www/includes/common.inc.php on line 360 MySQL Error? - Minitokyo

This thread is closed for posting.

page 1 of 1 6 total items

chrisp

chrisp

~You gotta love me~

hey guys!please help me!i can't see the pictures!and i can'T see my notifications...this appears when i logg in:

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

and this when i click on "Notifications"

(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 = 498795
(A LOTS OF THIS)
what the hell is this? i am not good at pc..so please help meeee!

Signature
	Image
chamber-of-kingskatekyo-hitman-rebornvectoryvector-wallerstag-liciousretro-studiomy-maiden

kashikosa

kashikosa

~Perfect in my own way~

Something's going on, you're not the only one with the problem. I think the only thing we can do now is wait and hopefully the mods will settle the problem

founder of: Vectory
Signature
	Image

Kohana-Ami

Kohana-Ami

Amii the Ripper

Yeah this is what happens when I click on notifications:
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 = 354351
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 = 354351
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 = 354351
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 = 354351
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 = 354351
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 = 354351
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 = 354351
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 = 354351
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 = 354351
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 = 354351
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 = 354351
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 = 354351
AND n.type = 12
ORDER BY n.id DESC LIMIT 32)
ORDER BY type ASC, stamp DESC

I hope the mods can fix it...hmmm....

Signature
	Image

Aiira

Linguistics

Aiira

SOON..

Me too..it said the same thing..just like everyone is..
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 = 290381
AND i.cid != 11
ORDER BY f.stamp DESC LIMIT 3

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

WHAT'S GOING ON AT MT?

Signature
	Image
CHERISH yesterday
DREAM tomorrow
LIVE today

so we should wait right if we get this bug it probably the server someone messed up somewhere

MapleRose

Retired Moderator

MapleRose

likes rainbows :D

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

page 1 of 1 6 total items

Back to Bug Reports | Active Threads | Forum Index

Only members can post replies, please register.

Warning: Undefined array key "cookienotice" in /var/www/minitokyo/www/html2/footer.html on line 73
This site uses cookies. By continuing to browse the site you are agreeing to our use of cookies. Read more.