PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |
Old February 19th, 2008, 04:27 AM   #1 (permalink)
Member
 
Join Date: Apr 2005
Posts: 50
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
DJDarknez is offline   Reply With Quote
Old February 19th, 2008, 09:19 AM   #2 (permalink)
Registered User
 
Zachariah's Avatar
 
Join Date: Nov 2005
Location: Canoga Park, CA
Posts: 3,244
Send a message via ICQ to Zachariah Send a message via AIM to Zachariah Send a message via MSN to Zachariah Send a message via Skype™ to Zachariah
ya old bug
Database Error on showimage (fixed)

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
Zachariah is offline   Reply With Quote
Old February 19th, 2008, 06:47 PM   #3 (permalink)
Member
 
Join Date: Apr 2005
Posts: 50
funky, couldn't find that when I searched.

Ok, thanks!
DJDarknez is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
PP 562 - custompal no line break snoopy5 Photopost Pro How Do I...? 4 December 5th, 2007 04:05 PM
Move Photos & not break links? scoles15 Photopost Pro How Do I...? 3 June 24th, 2007 05:17 PM
Break Tag Appears with Comments RealityHiker Photopost Pro How Do I...? 4 June 4th, 2006 01:42 PM
Will anything break if I define index as 'gallery;? kall General Discussion 7 April 2nd, 2005 02:03 PM
I looked everywhere.. so i am going to break down and ask Fred Classifieds Installation & Upgrades 2 January 31st, 2005 06:08 PM


All times are GMT -5. The time now is 11:36 PM.

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