0000980: Error in SQL, function all_contact_contracts - SiT! Bugs

SiT! Bugs

View Issue Details [ Jump to Notes ]

[ Issue History ] [ Print ]

ID

Project

Category

View Status

Date Submitted

Last Update

0000980

SiT!

authentication

public

2009-10-14 09:22

2009-10-15 21:55

Reporter

d4rkstar

Assigned To

ivan

Priority

normal

Severity

minor

Reproducibility

have not tried

Status

closed

Resolution

fixed

Platform

OS

OS Version

Product Version

Target Version

3.50

Fixed in Version

3.50

Summary

0000980: Error in SQL, function all_contact_contracts

Description

I found an error in function all_contact_contracts($contactid, $siteid). Version 3.50rc3

$sql = "SELECT DISTINCT m.id AS id
            FROM `{$GLOBALS['dbMaintenance']}` AS m,
            WHERE m.site={$siteid}
            AND m.var_incident_visible_all = 'yes'";

there's a , after the m that shouldn't be there.

Tags

No tags attached.

Relationships

Notes
(0002089) ivan (administrator) 2009-10-14 09:28	thanks!

(0002098) ivan (administrator) 2009-10-15 20:36	Fixed in svn branch 3.x r5937

Issue History
Date Modified	Username	Field	Change
2009-10-14 09:22	d4rkstar	New Issue
2009-10-14 09:28	ivan	Note Added: 0002089
2009-10-14 09:28	ivan	Status	new => confirmed
2009-10-14 09:28	ivan	Target Version	=> 3.50
2009-10-15 20:36	ivan	Note Added: 0002098
2009-10-15 20:36	ivan	Status	confirmed => resolved
2009-10-15 20:36	ivan	Fixed in Version	=> Current SVN
2009-10-15 20:36	ivan	Resolution	open => fixed
2009-10-15 20:36	ivan	Assigned To	=> ivan
2009-10-15 20:38	ivan	Fixed in Version	Current SVN => 3.50
2009-10-15 21:55	ivan	Status	resolved => closed

Copyright © 2000 - 2020 MantisBT Team