[OPT-general] [ outreach-Bugs-1558114 ] Error after last upgrade

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 454-5900

Bugs item #1558114, was opened at 2006-09-13 20:33
Message generated for change (Comment added) made by martinfst
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=410239&aid=1558114&group_id=34206

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Overview
Group: OPT 1.X (Max)
Status: Open
Resolution: None
Priority: 5
Submitted By: Fred Ramos (fredramos)
Assigned to: Martin Vernooij (martinfst)
Summary: Error after last upgrade

Initial Comment:
After the last upgrade, now the Overview screen
presents an error to all user , as follows:

----------------------------------------------------

The following query failed:
select distinct(requests.id) from requests left join
request2task on requests.id = request2task.request
inner join person_task inner join task left join
projects on requests.aproj = projects.id
where (projects.active != 0) and person_task.taskID =
request2task.task and person_task.personID = 7
and request2task.task = task.id and
(task.PercentComplete < 100) and requests.owner <> 7
You have an error in your SQL syntax near 'inner join
task left join projects on requests.aproj = projects.id
where (' at line 2

This error occured while Fred Ramos was accessing
/opt/main_menu/welcome/

The user came here from
http://server.com.br/opt/index.php?OPT_Session=485cbb8e268f38dbc18e3e2651f34cc5

Please make sure you include the lines above when
submitting a bug report!

----------------------------------------------------------------------

>Comment By: Martin Vernooij (martinfst)
Date: 2006-09-14 20:59

Message:
Logged In: YES 
user_id=608879

This error appears to be the result of MySQL changing the
inner join statement. FYI, the 3.23 branch is frozen per
August 16,2002, so over 4 years ago. I don't have the
intention to support these old releases. As I said also, I
don't have a MySQL 3 box anymore, but perhaps by using
phpMyAdmin and toying with the statement (it may be solved
by adding parathesis?) this could be fixed. If you can fix
it (or someone else) please submit the fix and I'll be happy
to test this on MySQL 4&5.

Martin

----------------------------------------------------------------------

Comment By: Fred Ramos (fredramos)
Date: 2006-09-14 20:24

Message:
Logged In: YES 
user_id=626790

Just for you to know, MySql here is 3.23.58 (FC3)
Never had any problems up to now. 
Any other thing I should try ?  

----------------------------------------------------------------------

Comment By: Martin Vernooij (martinfst)
Date: 2006-09-14 20:19

Message:
Logged In: YES 
user_id=608879

Wll this is the first screen you get after logon, so yes
this has been tested on both development machines (two, one
with MySQL 4 and one with MySQL 5) and the demo site (MySQL 4). 

I just tried this query on my dev box (MySQL 5) with
phpMyAdmin and no error. Could the OP still be running MySQL
3? I don't have a box anymore with version 3.

Martin

----------------------------------------------------------------------

Comment By: Bogdan Stancescu (b_stancescu)
Date: 2006-09-13 23:01

Message:
Logged In: YES 
user_id=341406

Hummm... Just realized I executed the query on a server
where I hadn't performed the upgrade. Martin, can you try
the query on your server?

----------------------------------------------------------------------

Comment By: Bogdan Stancescu (b_stancescu)
Date: 2006-09-13 22:58

Message:
Logged In: YES 
user_id=341406

This is pretty strange:

[bogdan@www ~]$ mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 23644 to server version: 4.1.20

mysql> select distinct(requests.id) from requests left join
    -> request2task on requests.id = request2task.request
    -> inner join person_task inner join task left join
    -> projects on requests.aproj = projects.id
    -> where (projects.active != 0) and person_task.taskID =
    -> request2task.task and person_task.personID = 7
    -> and request2task.task = task.id and
    -> (task.PercentComplete < 100) and requests.owner <> 7;
+-----+
| id  |
+-----+
| 182 |
+-----+
1 row in set (0.05 sec)

What version of MySQL are you using?

----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=410239&aid=1558114&group_id=34206