Fri, Jan 24, 5:46 PM CST

Renderosity Forums / Bryce

All Forums

Welcome to the Bryce Forum

Forum Moderators: TheBryster

Bryce F.A.Q (Last Updated: 2025 Jan 23 6:01 pm)

[Gallery]     [Tutorials]

THE PLACE FOR ALL THINGS BRYCE - GOT A PROBLEM? YOU'VE COME TO THE RIGHT PLACE

Subject: AgentSmith?Clay? little error with the SQL.

Rayraz opened this issue on Nov 18, 2002 ยท 10 posts
Back to Forum Print
Rayraz ( ) posted Mon, 18 November 2002 at 8:03 AM ยท edited Wed, 15 January 2025 at 3:17 AM

SQL Query Error: Unknown column 'numranking' in 'order clause' Query was: SELECT galleryid, thumbwidth, thumb, thumbheight, datestring, author, gallery.name as name, numviewed, ranking, imagewidth, imageheight, imagesize, gallerysection.name as sectName, numrankings, numcomments, nudity FROM gallery LEFT JOIN gallerysection ON gallery.sectionid = gallerysection.sectionid WHERE rating='Y' AND gallery.sectionid = 2 ORDER BY ranking DESC, numranking DESC LIMIT 0, 18

(_/)
(='.'=)
(")(")This is Bunny. Copy and paste bunny into your signature to help him gain world domination.

Rayraz ( ) posted Mon, 18 November 2002 at 8:07 AM

I tried to view the Best Rankings and I got the above message. Also happens in the all images gallery and probably everywhere else if you try to view best rankings.

(_/)
(='.'=)
(")(")This is Bunny. Copy and paste bunny into your signature to help him gain world domination.

clay ( ) posted Mon, 18 November 2002 at 9:28 AM

Hmm..strange. It all seems to be working on my end.

Do atleast one thing a day that scares the hell outta ya!!

Rayraz ( ) posted Mon, 18 November 2002 at 1:28 PM

Maybe some error in the network. I tried it at school. I'll try it here.

(_/)
(='.'=)
(")(")This is Bunny. Copy and paste bunny into your signature to help him gain world domination.

Rayraz ( ) posted Mon, 18 November 2002 at 1:29 PM

Also doesn't work at my fathers computer... strange. It'll never work on my computer, but that's because my own computer is a stand-alone.

(_/)
(='.'=)
(")(")This is Bunny. Copy and paste bunny into your signature to help him gain world domination.

Rayraz ( ) posted Mon, 18 November 2002 at 1:30 PM

Everything works fine except for the best rankings galleries.

(_/)
(='.'=)
(")(")This is Bunny. Copy and paste bunny into your signature to help him gain world domination.

lsstrout ( ) posted Mon, 18 November 2002 at 2:37 PM

I also see that error on the Best Rankings page. It shows up as the text underneath the title. Lin

Anruth ( ) posted Mon, 18 November 2002 at 2:45 PM

Never Tried Best Rank button. Till now. Yep its Broke. :)

AgentSmith ( ) posted Wed, 20 November 2002 at 1:15 AM

Hmm, works just fine on my end also. Don't know what to tell you...:o/ AgentSmith

Contact Me | Gallery | Freestuff | IMDB Credits | Personal Site
"I want to be what I was when I wanted to be what I am now"

Rayraz ( ) posted Wed, 20 November 2002 at 2:54 AM

It works again. I don't know what caused the problem either.

(_/)
(='.'=)
(")(")This is Bunny. Copy and paste bunny into your signature to help him gain world domination.

Privacy Notice

This site uses cookies to deliver the best experience. Our own cookies make user accounts and other features possible. Third-party cookies are used to display relevant ads and to analyze how Renderosity is used. By using our site, you acknowledge that you have read and understood our Terms of Service, including our Cookie Policy and our Privacy Policy.