#133 Error after last upgrade

OPT_1.X_(Max)
closed-wont-fix
Overview (3)
5
2006-09-14
2006-09-13
Fred Ramos
No

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!

Discussion

  • Bogdan Stancescu

    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?

     
  • Bogdan Stancescu

    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?

     
  • Martin Vernooij

    Martin Vernooij - 2006-09-14
    • assigned_to: guy_davis --> martinfst
     
  • Martin Vernooij

    Martin Vernooij - 2006-09-14

    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

     
  • Fred Ramos

    Fred Ramos - 2006-09-14

    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 ?

     
  • Martin Vernooij

    Martin Vernooij - 2006-09-14

    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

     
  • Bogdan Stancescu

    Logged In: YES
    user_id=341406

    For what it's worth, I agree with Martin. That's a really
    old version of MySQL, and you should consider upgrading,
    regardless of OPT--you'll probably start bumping into
    problems with many other recent packages you install.

     
  • Bogdan Stancescu

    • status: open --> closed-wont-fix
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks