NSN GR downloads unknown column

Susann · Posted: Fri Apr 11, 2008 12:47 pm

Thats the first time I found an entry in rnlogs from NSN gr downloads.

Quote:

Unknown column 'unit' in 'order clause'
SQL was: SELECT * FROM nuke_nsngd_downloads WHERE (title LIKE '%g%' OR description LIKE '%g%') AND active>'0' ORDER BY unit LIMIT 0,10
remote addr: xxx

Guess its from the search. Can I ignore this or will there follow mass entries whenever someone use the same word combination to search for a download.

Guardian2003 · Site Admin Joined: Aug 28, 2003 Posts: 5815

I may have a different version of NSN GR Downloads but checked my local copy and there is no 'unit' feild name in the tablw, which is fair enough otherwise you wouldn't see that error but none of the files in the downloads modules even have the word 'unit' in them.
I'll try and dig some more.

Susann · Posted: Fri Apr 11, 2008 3:10 pm

Guardian I´ve checked my logs and it looks like there was someone who searched for 3 words likeA+unit+blahblah.
Of course I have a download file which contains the word "unit". But I´m not sure if I broke the NSN file somewhere. The search works fine.I don´t see an error.

montego · Posted: Sat Apr 12, 2008 8:44 am

Susann, thanks for letting us know. I've forwarded to Bob too to see if he can take a look.