After an evaluation, GNOME has moved from Bugzilla to GitLab. Learn more about GitLab.
No new issues can be reported in GNOME Bugzilla anymore.
To report an issue in a GNOME project, go to GNOME GitLab.
Do not go to GNOME Gitlab for: Bluefish, Doxygen, GnuCash, GStreamer, java-gnome, LDTP, NetworkManager, Tomboy.
Bug 641714 - Database error: Unknown column 'popularity' in 'order clause' - art.gnome.org
Database error: Unknown column 'popularity' in 'order clause' - art.gnome.org
Status: RESOLVED DUPLICATE of bug 606005
Product: website
Classification: Infrastructure
Component: art.gnome.org (obsolete)
current
Other Linux
: Normal normal
: ---
Assigned To: art.gnome.org maintainers
art.gnome.org maintainers
Depends on:
Blocks:
 
 
Reported: 2011-02-07 12:17 UTC by phphasch
Modified: 2011-02-08 14:44 UTC
See Also:
GNOME target: ---
GNOME version: ---

Attachments
SQL - Bug in art.gnome.org (162.74 KB, image/png)
2011-02-07 12:19 UTC, phphasch 		Details

Description phphasch 2011-02-07 12:17:18 UTC 
Hello,

I want to report a bug on http://art.gnome.org/themes/search?text=query .

I have started a "search for themes" but an error occurred:  
" Database error: Unknown column 'popularity' in 'order clause' "

I think that there is a wrong MySQL - Script. If you use PHP to connect to the database, don't forget to use mysql_real_escape_string() for security reasons. It would be a nice soloution to log all errors to a logfile for the admin of this server. Displayed errors show vulnerability of the server. 

I might add that I do love GNOME. Keep on doing your nice work!

greetings from Germany,

Patrick (contact: phphasch@googlemail.com )
Comment 1 phphasch 2011-02-07 12:19:12 UTC 
Created attachment 180287 [details]
SQL - Bug in art.gnome.org
Comment 2 Thomas Wood 2011-02-08 14:44:37 UTC 
Thanks for the bug report. This particular bug has already been reported into our bug tracking system, but please feel free to report any further bugs you find.

*** This bug has been marked as a duplicate of bug 606005 ***