taskSavannah Administration - Tasks: task #11901, Database error: unable to browse...

 
 

task #11901: Database error: unable to browse tracker.

Submitter:  Miguel de Benito <mdbenito>
Submitted:  Fri 09 Mar 2012 03:57:05 PM UTC
   
 
Should Start On:  Thu 08 Mar 2012 11:00:00 PM UTC Should be Finished on:  Thu 08 Mar 2012 11:00:00 PM UTC
Category:  System Priority:  * 7 - High
Status:  Wait reply Privacy:  Public
Assigned to:  agn Open/Closed:  Closed
* Mandatory Fields

Add a New Comment Rich Markup
   

Wed 27 Aug 2014 09:21:10 PM UTC, comment #3: 

Hello,

I am closing this task due to inactivity.
If this is still an issue, please reply and it will be re-opened.

Regards,
 - Assaf

Assaf Gordon <agn>
Site Administrator
Tue 12 Aug 2014 12:44:18 AM UTC, comment #2: 

Hello,

I'm reviewing old tasks in GNU Savannah.

As of August 2014, I was not able to reproduce the error with the steps listed in this task.

Are you still experiencing these issues?

If within two weeks I still do not get a reply, I will close this 
request.

Regards,
 - Assaf

Assaf Gordon <agn>
Site Administrator
Fri 09 Mar 2012 03:58:09 PM UTC, comment #1: 

I forgot to mention that the project is TeXmacs, in case it's needed.

Miguel de Benito <mdbenito>
Fri 09 Mar 2012 03:57:05 PM UTC, original submission:  

Hi,

  a particular combination of search criteria causes a database error. Since the last settings are stored in the session I cannot browse the tracker anymore. This is the error:

db_query: SQL query error Unknown column 'bugs.bug_id' in 'on clause' in [SELECT count(DISTINCT bugs.bug_id) AS count FROM bugs ,user user_assigned_to,user user_submitted_by LEFT JOIN bugs_history ON ((bugs_history.bug_id = bugs.bug_id ) AND (bugs_history.date >= 1328050800) ) WHERE bugs.group_id='156' AND (bugs.spamscore < 5 OR submitted_by='80671') AND bugs.status_id IN ('1','5') AND bugs.assigned_to IN ('100','75915') AND bugs.bug_group_id IN ('101','102') AND user_assigned_to.user_id=bugs.assigned_to AND user_submitted_by.user_id=bugs.submitted_by AND bugs_history.bug_id IS NULL]

Miguel de Benito <mdbenito>

 

(Note: upload size limit is set to 16384 kB, after insertion of the required escape characters.)

Attach Files:
   
   
Comment:
   

No files currently attached

 

Depends on the following items: None found

Items that depend on this one: None found

 

Carbon-Copy List
  • -email is unavailable- added by agn (Posted a comment)
  • -email is unavailable- added by mdbenito (Submitted the item)
  • -email is unavailable- added by mdbenito
  •  

    There are 0 votes so far. Votes easily highlight which items people would like to see resolved in priority, independently of the priority of the item set by tracker managers.

    Only logged-in users can vote.

     

    Follow 4 latest changes.

    Date Changed by Updated Field Previous Value => Replaced by
    2014-08-27 agn Open/ClosedOpen Closed
    2014-08-12 agn StatusNone Wait reply
        Assigned toNone agn
    2012-03-09 mdbenito Carbon-Copy- Added mdbenito

    Back to the top

    Powered by Savane 3.13-3230.
    Corresponding source code