Error: Images not Appearing

See something wrong? Let us know
User avatar
ButterflyIllusioned
Posts: 67
Joined: Fri Jan 08, 2010 2:37 am

Error: Images not Appearing

Post 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
Last edited by ButterflyIllusioned on Mon Aug 16, 2010 7:04 pm, edited 7 times in total.
Image
User avatar
Hopeful_Encounter
Posts: 379
Joined: Sat Aug 29, 2009 10:37 pm
Location: A Sunflower Garden
Contact:

Re: Error: Images not Appearing

Post 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.
Image
I'm gonna be the one that saves you.
User avatar
yong
Posts: 996
Joined: Sat May 03, 2008 8:37 am

Re: Error: Images not Appearing

Post 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
Image
User avatar
AriaHime
Posts: 433
Joined: Sat Apr 10, 2010 10:53 am

Re: Error: Images not Appearing

Post 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.
Image
How the hell does a broken heart
get back together when it's torn apart?
Teach itself to start
Beating again...
User avatar
LilFlow
Posts: 325
Joined: Tue Jan 08, 2008 3:30 pm
Location: UK
Contact:

Re: Error: Images not Appearing

Post 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
User avatar
Haruko-chan
Posts: 457
Joined: Sun Mar 07, 2010 8:42 am
Location: USA!!! :D

Re: Error: Images not Appearing

Post 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...^^
Image
I'll owe everything to you.
How much pain has cracked your soul?
How much love will make you whole?

stats~
User avatar
Thursday
Posts: 110
Joined: Wed Apr 14, 2010 3:05 pm

Re: Error: Images not Appearing

Post 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 ^^
Image
User avatar
AriaHime
Posts: 433
Joined: Sat Apr 10, 2010 10:53 am

Re: Error: Images not Appearing

Post 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...
Image
How the hell does a broken heart
get back together when it's torn apart?
Teach itself to start
Beating again...
User avatar
Kyouchan
Posts: 14
Joined: Sun Jun 06, 2010 1:12 am
Location: Utah, USA

Re: Error: Images not Appearing

Post 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?
百合がさいこうだ~魔法少女リリカルなのはのことが大大大好きやねん~Image
User avatar
ButterflyIllusioned
Posts: 67
Joined: Fri Jan 08, 2010 2:37 am

Re: Error: Images not Appearing

Post 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).
Image
User avatar
AriaHime
Posts: 433
Joined: Sat Apr 10, 2010 10:53 am

Re: Error: Images not Appearing

Post 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.
Image
How the hell does a broken heart
get back together when it's torn apart?
Teach itself to start
Beating again...
User avatar
Nue
Posts: 216
Joined: Mon Jan 18, 2010 1:48 pm

Re: Error: Images not Appearing

Post 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.
User avatar
Julia
Posts: 973
Joined: Wed Aug 05, 2009 7:45 pm
Location: Texas

Re: Error: Images not Appearing

Post 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.
Image
Image
Mami chibi drawn by Jiino, animated by me. | Sophie sig by Misuzu | My Anime-Planet page
RockRabbit wrote:but you know, not every image has a source and not every character has a name :3
User avatar
anonymous_object
Site Admin
Posts: 1584
Joined: Tue Jan 24, 2006 2:04 pm
Location: Good old US of A
Contact:

Re: Error: Images not Appearing

Post 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.
e-shuushuu!
Image
User avatar
cosmictails
Posts: 56
Joined: Wed Jan 23, 2008 10:17 pm
Location: Florida

Re: Error: Images not Appearing

Post 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.
Locked