Hello Beeant-san. I'm having a problem. I can't get in to the "Notes" area and it… - Feed Post from Aniumixie to beeant
Hello Beeant-san.
I'm having a problem. I can't get in to the "Notes" area and it keeps giving me this error:
A Database Error Occurred
Error Number: 1242
Subquery returns more than 1 row
SELECT *, nvs.mtime as nvs_time, nvs.owner as nvs_owner, ni.language as ni_language , (SELECT wrong FROM note_vocab_stats nvst WHERE owner = 'Aniumixie' AND nvst.vocID = nvs.vocID) user_wrong, (SELECT correct FROM note_vocab_stats nvst WHERE owner = 'Aniumixie' AND nvst.vocID = nvs.vocID) user_correct, (SELECT mtime FROM note_vocab_stats nvst WHERE owner = 'Aniumixie' AND nvst.vocID = nvs.vocID) user_mtime FROM note_vocab_stats nvs, note_items ni, notes n WHERE type = 'note' AND ni.no = nvs.vocID AND ni.note_id = n.no AND n.private = 0 ORDER BY nvs.mtime DESC
Filename: /var/www/Sites/japaneseclass.jp/httpdocs/models/note_model.php
Line Number: 282
I'm having a problem. I can't get in to the "Notes" area and it keeps giving me this error:
A Database Error Occurred
Error Number: 1242
Subquery returns more than 1 row
SELECT *, nvs.mtime as nvs_time, nvs.owner as nvs_owner, ni.language as ni_language , (SELECT wrong FROM note_vocab_stats nvst WHERE owner = 'Aniumixie' AND nvst.vocID = nvs.vocID) user_wrong, (SELECT correct FROM note_vocab_stats nvst WHERE owner = 'Aniumixie' AND nvst.vocID = nvs.vocID) user_correct, (SELECT mtime FROM note_vocab_stats nvst WHERE owner = 'Aniumixie' AND nvst.vocID = nvs.vocID) user_mtime FROM note_vocab_stats nvs, note_items ni, notes n WHERE type = 'note' AND ni.no = nvs.vocID AND ni.note_id = n.no AND n.private = 0 ORDER BY nvs.mtime DESC
Filename: /var/www/Sites/japaneseclass.jp/httpdocs/models/note_model.php
Line Number: 282
posted by Aniumixie
Comments 4
Hello Aniumixie,
which page of notes do you have this problem?
can you give me to URL?
and what action did you try to do?
I wanted to go to the main "Notes" area, so I clicked its link on the toolbar.
http://japaneseclass.jp/note/user- Are you still having the problem?
it's working ok for me. - Yes, I still have that problem.