Page 1 of 2

Error: Images not Appearing

Posted: Sun Aug 15, 2010 9:33 pm
by ButterflyIllusioned
I just posted this image:
http://e-shuushuu.net/image/314199/

((EDIT: My CCS image has now been replaced by Dancu's image. However, when I posted the image AGAIN, it said it matched the other image 100%, when it clearly doesn't.
Image
))

However, it did not appear on the main page of Shuu, nor does it appear in my Images.

When I edit it and then save it gives me this error:
Message
Unable to open underlying table which is differently defined or of non-MyISAM type or doesn't exist
Code
1168
File
/var/www/e-shuushuu.net/common/functions/db.php
Line
51

Re: Error: Images not Appearing

Posted: Sun Aug 15, 2010 10:44 pm
by Hopeful_Encounter
I was actually just going to talk about this on here.

I uploaded an image about an hour ago and it wasn't appearing on the front page either. Also even when I look in the images I uploaded, the image doesn't show that I had just uploaded. :/ Also my image count, earlier today, wouldn't go up after I uploaded an image.

If someone could explain what is going on if they know, that would be wonderful. Thank you.

Re: Error: Images not Appearing

Posted: Mon Aug 16, 2010 11:04 am
by yong
Got longer one x3
Message
Unknown prepared statement handler (0) given to mysql_stmt_execute
Code
1243
File
/var/www/e-shuushuu.net/common/functions/db.php
Line
375
Backtrace
Array
(
[0] => Array
(
[file] => /var/www/e-shuushuu.net/common/functions/image.php
[line] => 420
[function] => execute
[class] => db_stmt
[type] => ->
[args] => Array
(
)

)

[1] => Array
(
[file] => /var/www/e-shuushuu.net/index.php
[line] => 11
[function] => getPageCount
[args] => Array
(
[0] => SELECT count(*) FROM images
)

)

)
Plus the shuu homepage seems freeze at the same time same date:
http://img175.imageshack.us/img175/4174/shuuuu.jpg
until i logged in,
and the Banners also no longer randomizing, not iw's fixed at the banner that created by Myu-chan x3

Re: Error: Images not Appearing

Posted: Mon Aug 16, 2010 12:44 pm
by AriaHime
Butterfly-san, I got the same thing as you.
It appears when I try to view some images. Just some. Some will work and some won't. It seems to be pretty random.
I also have gotten this:
Warning: mysqli_stmt::bind_param() [mysqli-stmt.bind-param]: Number of variables doesn't match number of parameters in prepared statement in /var/www/e-shuushuu.net/images on line 56
Message
Unknown prepared statement handler (0) given to mysql_stmt_execute
Code
1243
File
/var/www/e-shuushuu.net/common/functions/db.php
Line
375
A couple times...same thing. Sometimes it appears and sometimes it doesn't. This particular one was when I tried to view this image.

Edit: And just now, I got
Message
Unknown prepared statement handler (0) given to mysql_stmt_execute
Code
1243
File
/var/www/e-shuushuu.net/common/functions/db.php
Line
375
when I tried to refresh the browse page/page 1 of images.

Re: Error: Images not Appearing

Posted: Mon Aug 16, 2010 5:33 pm
by LilFlow
I just got exactly the same thing as AriaHime:
Message
Unknown prepared statement handler (0) given to mysql_stmt_execute
Code
1243
File
/var/www/e-shuushuu.net/common/functions/db.php
Line
375

Re: Error: Images not Appearing

Posted: Mon Aug 16, 2010 6:16 pm
by Haruko-chan
I just tried to do a similar images search, and rather than images, under "matches found" I got this:


Message
Table 'images' is marked as crashed and should be repaired
Code
1194
File
/var/www/e-shuushuu.net/common/functions/db.php
Line
375

It had been working just fine before...I did a bunch of searches and then this suddenly came up. I don't have the url of the image anymore, but the only thing that was different from my previous searches had been that I had been uploading files, and I got the error message when I used a url.
I hope this helps in some way in finding a solution...^^

Re: Error: Images not Appearing

Posted: Mon Aug 16, 2010 6:28 pm
by Thursday
For me, I can only see the last image posted before the site went down last night, the others have vanished- earlier today, only when nobody was signed on to E-shuushuu could I not see any images past about 9 pm last night. Now even when I am signed on they are gone, other than one Hakuryu posted today at 7:14 pm. Furthermore, my personal image post count hasn't updated and certain comments I make on images are invisible until someone responds to them.

Can't really help much, but that's Thursday's error report ^^

Re: Error: Images not Appearing

Posted: Mon Aug 16, 2010 6:33 pm
by AriaHime
Same as Thursday. I see this, from August 15 and then the next one is this, posted on August 16 at 7:14. All the other images from today have disappeared...

Re: Error: Images not Appearing

Posted: Mon Aug 16, 2010 6:42 pm
by Kyouchan
I likewise am having the same problem as Thursday and the others, including the image post count issues(the number is at least 50 off) and comment issues. Did something maybe go wrong during maintenance last night?

Re: Error: Images not Appearing

Posted: Mon Aug 16, 2010 7:08 pm
by ButterflyIllusioned
To everyone having the same problem:

Yatchen: anony is aware of the problem.

anonymous_object: A database hiccup caused the loss of today's previously uploaded images. About 250 images lost. Sorry, folks >_<


Reupload the images that you're having problems with. Images and Comments are lost.
Note: It WILL come up at "matched 100%" to the image that replaced where your image was (see my top post).

Re: Error: Images not Appearing

Posted: Mon Aug 16, 2010 8:07 pm
by AriaHime
Okay, something else's come up. Don't know if it's related. These two images:
http://e-shuushuu.net/image/314240/
http://e-shuushuu.net/image/314238/

are listed as having 65535 favs, which they hardly do.

Re: Error: Images not Appearing

Posted: Mon Aug 16, 2010 8:19 pm
by Nue
As everyone, I'm also having the same problem. Similar search doesn't work (at least via URL, didn't try with file yet), I can't see pictures in their full size without giving me error, and so on. But as I can see, the problem is well aware of for now. I hope things get fixed up as soon as possible.

Re: Error: Images not Appearing

Posted: Mon Aug 16, 2010 8:54 pm
by Julia
Okay, I went to my images and it didn't show any of the ones I uploaded today, and when I attempted to upload one of them again it did this:
Image
So, it thought it found a match but didn't display anything.

Re: Error: Images not Appearing

Posted: Mon Aug 16, 2010 11:15 pm
by anonymous_object
Julia wrote:Okay, I went to my images and it didn't show any of the ones I uploaded today, and when I attempted to upload one of them again it did this:
Image
So, it thought it found a match but didn't display anything.
You can safely ignore that message for images that were lost earlier today. Just go ahead and re-upload it.

Re: Error: Images not Appearing

Posted: Tue Aug 17, 2010 9:10 am
by cosmictails
Hopeful_Encounter wrote:I was actually just going to talk about this on here.

I uploaded an image about an hour ago and it wasn't appearing on the front page either. Also even when I look in the images I uploaded, the image doesn't show that I had just uploaded. :/ Also my image count, earlier today, wouldn't go up after I uploaded an image.

If someone could explain what is going on if they know, that would be wonderful. Thank you.
I come across that same problem, too. Also including the tagging that you can't do when you upload your images.

Might have to do them randomly until it is fixed. >.<

The difficult problem is to type the artist name that you already know since the list of artists of its tagging will be down for awhile.

....but you can still look for them in its "Tag" link on the site.