PhotoPost Community

PhotoPost Community (http://www.photopost.com/forum/)
-   Installs and Upgrade - vBulletin 3.6x (http://www.photopost.com/forum/installs-upgrade-vbulletin-3-6x/)
-   -   I can't help but break it (http://www.photopost.com/forum/installs-upgrade-vbulletin-3-6x/135480-i-cant-help-but-break.html)

DJDarknez February 19th, 2008 04:27 AM

I can't help but break it
 
I figured I should post in here since I'm rocking 3.7B5

I recently installed vBFJournal and was scewing around with a new style. I found this problem. Deleted the style, but I get this when trying to open an image in the gallery.



Quote:

Database error in vBulletin 3.7.0 Beta 5:

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 vb3_adv_gallery_posts AS posts
LEFT JOIN vb3_user AS user ON (posts.userid = user.userid)
LEFT JOIN vb3_userfield AS userfield ON (posts.userid = userfield.userid)
LEFT JOIN vb3_avatar AS avatar ON (avatar.avatarid = user.avatarid)
LEFT JOIN vb3_customavatar AS customavatar ON (customavatar.userid = user.userid)
LEFT JOIN vb3_icon AS icon ON (posts.iconid = icon.iconid)
LEFT JOIN vb3_reputationlevel AS reputationlevel ON (user.reputationlevelid = reputationlevel.reputationlevelid)
LEFT JOIN vb3_usertextfield AS usertextfield ON (usertextfield.userid = posts.userid)
WHERE imageid = '3048' AND posts.visible = 1
ORDER BY posts.dateline
LIMIT 0, 10;

MySQL Error : Unknown column 'level' in 'field list'
Error Number : 1054
Date : Tuesday, February 19th 2008 @ 04:18:55 AM
Script : http://www.djdarknez.com/gallery/sho...ore=0&postid=1
Referrer : http://www.djdarknez.com/gallery/bro...hp?c=1&userid=
IP Address : x
Username : DJDarknez
Classname : vb_database
MySQL Version : 4.1.22-standard-log

Zachariah February 19th, 2008 09:19 AM

ya old bug
http://www.photopost.com/forum/showt...ight=showimage

Edit:
gallery/showimage.php

Find:
Code:

Content visible to verified customers only.
Add Bold line:
Code:

Content visible to verified customers only.
Find:
Code:

Content visible to verified customers only.
Remove

DJDarknez February 19th, 2008 06:47 PM

funky, couldn't find that when I searched.

Ok, thanks!


All times are GMT -5. The time now is 02:27 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97