looking for a new Gallery..

[Slingblade61]

photopost, long story, short....has a bug. I had my site shut down by my host because showimage.php was exploited and someone was running spam through it.

I have gotten zero support from the usual suspects so I am looking for alternatives that might mesh well with VB.

Suggestions?

[Zachariah]

It was not exploited.

035 Subject: vBulletin Database Error!
071 X-PHP-Script: www.shottalk.com/gallery/showimage.php

The mass email you are getting is when there is an error in mySQL.
- Every page load by a user is shooting an e-mail off to the Admin.

http://www.photopost.com/forum/showp...8&postcount=11

I got 2500+ e-mails in 30min once when there was an error on a page.
- Now I log errors to file.

[Slingblade61]

OK, Thanks.

I just want to clarify....I did not recieve any email myself.
Here is what my host sent me;

www.shottalk.com/gallery/showimage.php and was running a lot of mail activity

exploited, but valid email, not spam

root@washington [/var/spool/exim/input]# cat b/1GXJHb-0007W5-C8-H
1GXJHb-0007W5-C8-H
nobody 99 32004

1160493159 0
-ident nobody
-received_protocol local
-body_linecount 25
-auth_id nobody
-auth_sender nobody@washington.hostforweb.net
-allow_unqualified_recipient
-allow_unqualified_sender
-local
XX
1
dbmaster@example.com

154P Received: from nobody by washington.hostforweb.net with local (Exim 4.52)
id 1GXJHb-0007W5-C8
for dbmaster@example.com; Tue, 10 Oct 2006 10:12:39 -0500
025T To: dbmaster@example.com
035 Subject: vBulletin Database Error!
071 X-PHP-Script: www.shottalk.com/gallery/showimage.php for 213.235.5.109
027F From: dbmaster@example.com
058I Message-Id:
038 Date: Tue, 10 Oct 2006 10:12:39 -0500
root@washington [/var/spool/exim/input]# cat b/1GXJHb-0007W5-C8-D
1GXJHb-0007W5-C8-D
Database error in vBulletin 3.6.0:

Invalid SQL:

SELECT posts.postid, posts.pagetext, posts.title, posts.userid, posts.username AS postusername, posts.dateline, posts.ipaddress AS ip, posts.iconid, posts.allowsmilie, posts.showsignature, user.*, userfield.* ,icon.title as icontitle, icon.iconpath ,avatar.avatarpath, NOT ISNULL(customavatar.filedata) AS hascustom, customavatar.dateline AS avatardateline, avatarrevision , level , usertextfield.signature
FROM adv_gallery_posts AS posts
LEFT JOIN user AS user ON (posts.userid = user.userid)
LEFT JOIN userfield AS userfield ON (posts.userid = userfield.userid)
LEFT JOIN avatar AS avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN customavatar AS customavatar ON (customavatar.userid = user.userid)
LEFT JOIN icon AS icon ON (posts.iconid = icon.iconid)
LEFT JOIN reputationlevel AS reputationlevel ON (user.reputationlevelid = reputationlevel.reputationlevelid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = posts.userid)
WHERE imageid = '178' AND posts.visible = 1
ORDER BY posts.dateline
LIMIT 0, 10;

MySQL Error : Unknown column 'level' in 'field list'
Error Number : 1054
Date : Tuesday, October 10th 2006 @ 10:12:39 AM
Script : http://www.shottalk.com/gallery/showimage.php?i=178&c=2
Referrer : http://www.shottalk.com/gallery/browseimages.php?c=2
IP Address : 213.235.5.109
Username : demetri
Classname : vb_database
root@washington [/var/spool/exim/input]#
Joshua Brown
Technical Support
HostForWeb, Inc.
http://www.hostforweb.com

Is this the same thing?

[BigJohnny]

thats an SQL error....
your missing the table "level" in your database so when someone visits that page it is sending oput an error email....somewhere.

if you manually add the table "level" it should work again.... but i cant tell from the error where the table is supposed to go.

[Zachariah]

Originally Posted by Slingblade61

OK, Thanks.

I just want to clarify....I did not recieve any email myself.
Here is what my host sent me;



Is this the same thing?

In the post above
- 035 Subject: vBulletin Database Error!

The subject of the e-mail that is being sent.

To fix your gallery from causing the error:
Database Error on showimage (fixed) - August 3rd, 2006, 09:03 AM
http://www.photopost.com/forum/showthread.php?t=126400