You can subscribe to this list here.
2002 |
Jan
|
Feb
(189) |
Mar
(43) |
Apr
(56) |
May
(52) |
Jun
(99) |
Jul
(26) |
Aug
(89) |
Sep
(27) |
Oct
(23) |
Nov
(2) |
Dec
(6) |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2003 |
Jan
(10) |
Feb
(1) |
Mar
(1) |
Apr
(11) |
May
(15) |
Jun
(73) |
Jul
(7) |
Aug
(46) |
Sep
(25) |
Oct
(81) |
Nov
(20) |
Dec
(13) |
2004 |
Jan
(13) |
Feb
(6) |
Mar
(5) |
Apr
(8) |
May
(5) |
Jun
(2) |
Jul
(6) |
Aug
(1) |
Sep
|
Oct
(10) |
Nov
(10) |
Dec
(13) |
2005 |
Jan
(21) |
Feb
(7) |
Mar
|
Apr
|
May
|
Jun
|
Jul
(1) |
Aug
|
Sep
(2) |
Oct
|
Nov
(2) |
Dec
|
2006 |
Jan
|
Feb
(1) |
Mar
(1) |
Apr
|
May
|
Jun
(2) |
Jul
|
Aug
(2) |
Sep
(21) |
Oct
(1) |
Nov
|
Dec
(1) |
From: SourceForge.net <no...@so...> - 2006-12-08 18:24:42
|
Bugs item #1611744, was opened at 2006-12-08 18:24 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=410239&aid=1611744&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: None Group: None Status: Open Resolution: None Priority: 5 Private: No Submitted By: clemens walch (cwalch) Assigned to: Nobody/Anonymous (nobody) Summary: SQL error Initial Comment: After installing the update to 1.2.7 i have this error message: The following query failed: select if (year(2006-11-15 23:59:59)!=year(now()), date_format(2006-11-15 23:59:59,"%b %d %Y"), if (dayofyear(2006-11-15 23:59:59)=dayofyear(now()), "Today", date_format(2006-11-15 23:59:59,"%b %d") ) ) from people where id="7" You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '23:59:59)!=year(now()), date_format(2006-11-15 23:59:59,"%b %d %Y"),' at line 2 This error occured while Clemens Walch was accessing /opt_neu/tasks/task/?proj=53&task=10653&action=display What to do?? ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=410239&aid=1611744&group_id=34206 |
From: SourceForge.net <no...@so...> - 2006-10-25 00:31:35
|
Patches item #1584095, was opened at 2006-10-24 18:31 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=410241&aid=1584095&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: None Group: OPT 1.X (Max) Status: Open Resolution: None Priority: 5 Private: No Submitted By: Steve Cichosz (vranicoff) Assigned to: Nobody/Anonymous (nobody) Summary: SQL failure in Overview feature Initial Comment: Upon upgrading OPT to version 1.2.7 on a MySQL version 5.0.22 database I encountered SQL that was creating errors in the Overview functions. I made the updates included in the attached file. My updates can be found by searching on "SSC" within the file. Additional detail can be found in the forum entry titled "SQL failure accessing overview screen" and dated 2006-10-19 and the newer entries to "SQL query failure on login" dated 2003-06-16. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=410241&aid=1584095&group_id=34206 |
From: SourceForge.net <no...@so...> - 2006-09-17 09:43:00
|
Bugs item #1560072, was opened at 2006-09-17 11:42 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=410239&aid=1560072&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: Newsletter Group: OPT 1.X (Max) Status: Open Resolution: None Priority: 5 Submitted By: Martin Vernooij (martinfst) Assigned to: Martin Vernooij (martinfst) Summary: Newsletter overview loops Initial Comment: When viewing the newsletter overview, the 5th entry of the database is displayed repeatably and keeps looping. Other newsletter entries are not shown. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=410239&aid=1560072&group_id=34206 |
From: SourceForge.net <no...@so...> - 2006-09-14 20:05:09
|
Bugs item #1558114, was opened at 2006-09-13 21:33 Message generated for change (Settings changed) made by b_stancescu 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: Closed >Resolution: Wont Fix 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: Bogdan Stancescu (b_stancescu) Date: 2006-09-14 23:04 Message: 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. ---------------------------------------------------------------------- Comment By: Martin Vernooij (martinfst) Date: 2006-09-14 21: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 21: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 21: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-14 00: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 23: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 |
From: SourceForge.net <no...@so...> - 2006-09-14 20:04:42
|
Bugs item #1558114, was opened at 2006-09-13 21:33 Message generated for change (Comment added) made by b_stancescu 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: Bogdan Stancescu (b_stancescu) Date: 2006-09-14 23:04 Message: 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. ---------------------------------------------------------------------- Comment By: Martin Vernooij (martinfst) Date: 2006-09-14 21: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 21: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 21: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-14 00: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 23: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 |
From: SourceForge.net <no...@so...> - 2006-09-14 18:59:47
|
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 |
From: SourceForge.net <no...@so...> - 2006-09-14 18:24:29
|
Bugs item #1558114, was opened at 2006-09-13 15:33 Message generated for change (Comment added) made by fredramos 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: Fred Ramos (fredramos) Date: 2006-09-14 15: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 15: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 18: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 17: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 |
From: SourceForge.net <no...@so...> - 2006-09-14 18:19:38
|
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: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 |
From: SourceForge.net <no...@so...> - 2006-09-13 21:01:01
|
Bugs item #1558114, was opened at 2006-09-13 21:33 Message generated for change (Comment added) made by b_stancescu 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: Guy Davis (guy_davis) 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: Bogdan Stancescu (b_stancescu) Date: 2006-09-14 00: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 23: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 |
From: SourceForge.net <no...@so...> - 2006-09-13 20:58:55
|
Bugs item #1558114, was opened at 2006-09-13 21:33 Message generated for change (Comment added) made by b_stancescu 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: Guy Davis (guy_davis) 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: Bogdan Stancescu (b_stancescu) Date: 2006-09-13 23: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 |
From: SourceForge.net <no...@so...> - 2006-09-13 18:33:32
|
Bugs item #1558114, was opened at 2006-09-13 15:33 Message generated for change (Tracker Item Submitted) made by Item Submitter 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: Guy Davis (guy_davis) 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! ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=410239&aid=1558114&group_id=34206 |
From: SourceForge.net <no...@so...> - 2006-09-10 14:56:11
|
Bugs item #900010, was opened at 2004-02-18 16:42 Message generated for change (Comment added) made by barrettb You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=410239&aid=900010&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: Projects Group: OPT 1.X (Max) Status: Closed Resolution: None Priority: 5 Submitted By: B Barrett (barrettb) Assigned to: Guy Davis (guy_davis) Summary: JavaScript date pickers fail on Safari (Mac OS X) Initial Comment: Version: OPT 1.2.5 MAX OS: Mac OS X (10.3.2) Browser: Safari 1.2 To reproduce: 1. Log-in (I did so as admin) 2. Get to a date picker icon, I did this by: 2a. Select Projects from the navigation bar 2b. choose "team availability" under "project reports" but any date picker will do. 3. Click on the little calander month icon Result: --> A month pops-up in a new small window 4. Click the previous or next month arrows next to the month name. Result: --> Nothing happens. Work around: Just enter the date in the text field. Discussion: The tool that is driving the calander is: ts_picker.js the version of the javascript in use is 1.0 There is a new version (alas, done somewhat differently) here: http://www.softcomplex.com/products/tigra_calendar/ If you want I can figure out how to integrate the new code and submit changes in the next few days. ---------------------------------------------------------------------- >Comment By: B Barrett (barrettb) Date: 2006-09-10 07:56 Message: Logged In: YES user_id=978986 I no longer have Outreach installed. I just tries it on the demo site with a current Safari version (2.0.4 on Intel) and it is working fine. Thanks! ---------------------------------------------------------------------- Comment By: Martin Vernooij (martinfst) Date: 2006-09-10 07:00 Message: Logged In: YES user_id=608879 This may wel be a Safari problem, that has been fixed by now. As I don't have access to a Mac, and this request is quite old, I believe it's time to close this one. As always, a new request could be submitted if required. Martin ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=410239&aid=900010&group_id=34206 |
From: SourceForge.net <no...@so...> - 2006-09-10 14:14:24
|
Feature Requests item #1327156, was opened at 2005-10-14 23:29 Message generated for change (Settings changed) made by martinfst You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=410242&aid=1327156&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: None >Group: OPT 1.X (Max) Status: Open Priority: 5 Submitted By: Marc Beneteau (mbeneteau) Assigned to: Nobody/Anonymous (nobody) Summary: I can't pipe mail into mail_retrieve.pl Initial Comment: For some reason my host is not able to pipe mail into mail_retrieve.pl by setting up an alias as described in the documentation (they say they run Exim as root and don't support aliases). I am wondering how difficult it would be to modify mail_retrieve.pl to read mail POP3 and then run it from a cron. Any ideas would be appreciated. ---------------------------------------------------------------------- Comment By: Martin Vernooij (martinfst) Date: 2005-10-17 18:55 Message: Logged In: YES user_id=608879 Too bad your ISP doesn't support mail aliasses. Exim certainly does support aliases. I gues you could modify mail_retrieve.pl and replace the "push" to "pull" and schedule this new function with cron. However, you still want to sent email to an "OPT" user, so you have a mailbox on your system. If you can use IMAP, it would also be possible to poll this inbox with a new function. And of course, POP3 would also be possible. Now for active development: You can put this request on the OPT RFE,, but I have to say, it might stay there for a while. Or perhaps you can write a utility yourself, and I would be happy to incorporate this enhancement. Regards, Martin ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=410242&aid=1327156&group_id=34206 |
From: SourceForge.net <no...@so...> - 2006-09-10 14:08:13
|
Bugs item #1122255, was opened at 2005-02-14 10:59 Message generated for change (Comment added) made by martinfst You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=410239&aid=1122255&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: None >Group: OPT 1.X (Max) >Status: Closed Resolution: None Priority: 5 Submitted By: Garret Graystone (garretg) Assigned to: Nobody/Anonymous (nobody) Summary: error on login, Initial Comment: I just finished installing 1.2.6 MAX and right after click on the login button, i receive the following message. Not Found The requested URL /proj/opt/main_menu/<hr>The following query failed:<br />select count(*) from news<br /> where chindate>0000-00-00 00:00:00<br />You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '00:00:00' at line 2<br><p>This error occured while Administrator was accessing /proj/opt/index.php<p>The user came here from http://172.16.21.100/proj/opt/<p>Please make sure you include the lines above when submitting a bug report!<hr><div class= was not found on this server. I suscpect it has something to do with the newletter module but Im not sure can anyone please help me troubleshoot this? I used all of the defaults settings. Im using freebsd 5.1 as my OS. ---------------------------------------------------------------------- >Comment By: Martin Vernooij (martinfst) Date: 2006-09-10 16:08 Message: Logged In: YES user_id=608879 This was caused by the quoting and date changes between MySQL 3, 4 and 5. This should be fixed in the 1.2.7 release. Martin ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2005-04-28 11:35 Message: Logged In: NO i got the same in Apache/2.0.53 (Ubuntu) PHP/4.3.10-10 MySQL 3.23.56 ---------------------------------------------------------------------- Comment By: Martin Vernooij (martinfst) Date: 2005-03-30 20:05 Message: Logged In: YES user_id=608879 Sorry, missed this one. What version of MySQL are you using? PHP version? Martin ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=410239&aid=1122255&group_id=34206 |
From: SourceForge.net <no...@so...> - 2006-09-10 14:03:19
|
Bugs item #1078789, was opened at 2004-12-04 10:04 Message generated for change (Comment added) made by martinfst You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=410239&aid=1078789&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: Closed >Resolution: Fixed Priority: 5 Submitted By: Martin Vernooij (martinfst) Assigned to: Martin Vernooij (martinfst) Summary: Overview of documents, forums and e-mails does not work Initial Comment: When requesting an overview of all projects, the menu items for documents, forums and emails do not produce any result. This happens because the case statement in opt/overview/all/index.php does not contain entries for these tasks. Also the to be included sub-programs are missing. I have to think a bit more about what needs to be displayed here. Suggestions welcome. Martin ---------------------------------------------------------------------- >Comment By: Martin Vernooij (martinfst) Date: 2006-09-10 16:03 Message: Logged In: YES user_id=608879 I had this already fixed in the 1.2.6 release, but never updated the bug list. Shame on me. Martin ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=410239&aid=1078789&group_id=34206 |
From: SourceForge.net <no...@so...> - 2006-09-10 14:00:14
|
Bugs item #900010, was opened at 2004-02-19 01:42 Message generated for change (Comment added) made by martinfst You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=410239&aid=900010&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: Projects Group: OPT 1.X (Max) >Status: Closed Resolution: None Priority: 5 Submitted By: B Barrett (barrettb) Assigned to: Guy Davis (guy_davis) Summary: JavaScript date pickers fail on Safari (Mac OS X) Initial Comment: Version: OPT 1.2.5 MAX OS: Mac OS X (10.3.2) Browser: Safari 1.2 To reproduce: 1. Log-in (I did so as admin) 2. Get to a date picker icon, I did this by: 2a. Select Projects from the navigation bar 2b. choose "team availability" under "project reports" but any date picker will do. 3. Click on the little calander month icon Result: --> A month pops-up in a new small window 4. Click the previous or next month arrows next to the month name. Result: --> Nothing happens. Work around: Just enter the date in the text field. Discussion: The tool that is driving the calander is: ts_picker.js the version of the javascript in use is 1.0 There is a new version (alas, done somewhat differently) here: http://www.softcomplex.com/products/tigra_calendar/ If you want I can figure out how to integrate the new code and submit changes in the next few days. ---------------------------------------------------------------------- >Comment By: Martin Vernooij (martinfst) Date: 2006-09-10 16:00 Message: Logged In: YES user_id=608879 This may wel be a Safari problem, that has been fixed by now. As I don't have access to a Mac, and this request is quite old, I believe it's time to close this one. As always, a new request could be submitted if required. Martin ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=410239&aid=900010&group_id=34206 |
From: SourceForge.net <no...@so...> - 2006-09-10 13:57:30
|
Bugs item #819960, was opened at 2003-10-08 14:38 Message generated for change (Comment added) made by martinfst You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=410239&aid=819960&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: Security Group: None >Status: Closed >Resolution: Fixed Priority: 5 Submitted By: Martin Vernooij (martinfst) Assigned to: Nobody/Anonymous (nobody) Summary: OPT_MAX 1.1: session reset if user does not logout Initial Comment: Hi, I noticed that when users close their browser, without they have logged off from the system, they effectively get locked out from the system. They cannot login anymore. There are two work arounds for the short term I use. Either reset the status field in the 'people' to 5 (couldn't figure out exact explanation of the status codes, as a it seems to be used as a binary int) , but this seems to work. Other option ofcourse is to reset the user passwd with the admin module. I believe there should be a session timeout, and the user should be reset automatically if a session is expired. I'm not an experienced php programmer, so I'll have to leave this to the experts. Martin. ---------------------------------------------------------------------- >Comment By: Martin Vernooij (martinfst) Date: 2006-09-10 15:57 Message: Logged In: YES user_id=608879 This bug is no longer reproducable anymore in 1.2.7 Max. 1.2.7 has some enhancements for session and execution abortion, so I believe this bug has been fixed. Martin ---------------------------------------------------------------------- Comment By: Martin Vernooij (martinfst) Date: 2003-10-08 14:40 Message: Logged In: YES user_id=608879 Sorry, a screen refresh just bumped in on me here. Please ignore this request. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=410239&aid=819960&group_id=34206 |
From: SourceForge.net <no...@so...> - 2006-09-10 13:52:06
|
Bugs item #800965, was opened at 2003-09-05 11:17 Message generated for change (Comment added) made by martinfst You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=410239&aid=800965&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: None Group: OPT 1.X (Max) >Status: Closed >Resolution: Fixed Priority: 1 Submitted By: Nobody/Anonymous (nobody) Assigned to: Guy Davis (guy_davis) Summary: re opening bug: #795344 sql syntax Initial Comment: re opening bug: #795344 I've had a look at version 1.1.0, there is the same sql problem (in my opinion). Summary: necessity for single quoting a value with mysql. example: SELECT * FROM task WHERE id=$myid If you get the value from the function "getvalue - include/general.php line 162" this function may return the special value "n/a". So the previous sql: SELECT * FROM task WHERE id=n/a brings an error. To correct it you need to single quote all the value in all the sql query you do. Second example (security) DELECT * FROM task WHERE id=$myid If the id is provided from a link in the page, it can be easily forged.. so, something like that can be possible: $myid="1 or id=2 or id=3 or id=4" etc.. DELETE * FROM task WEHRE id=1 or id=2 or id=3 or id=4. If you had single quoted the value, this wouldn't function. Conclusion: this bug is not to be found on this place or another, you need to correct all the sql queries and add a single quote. Even if actualy you don't seems to see this error, it's a potential error that could arise later.. Best regards ps: sorry for my english, I hope you could understand my point of view. Yann Sagon y dot sagon at hasa dot ch ---------------------------------------------------------------------- >Comment By: Martin Vernooij (martinfst) Date: 2006-09-10 15:52 Message: Logged In: YES user_id=608879 With the 1.2.7 Max release, a lot of SQL statements and associated functions have been revisited. As this bug is no longer reproducable, I thinks this has been fixed. Martin ---------------------------------------------------------------------- Comment By: Ronny Hanssen (godvin) Date: 2003-11-06 11:27 Message: Logged In: YES user_id=347330 I have also had this problem. It has happened maybe 4 or 5 times I think. It specifically referred to the n/a value. I would seriously reconsider the priority of this bug, since it does annoy the users quite bad. Also it makes the users loose their trust in OPT, since it "evidently is so buggy"... ---------------------------------------------------------------------- Comment By: Guy Davis (guy_davis) Date: 2003-10-06 01:15 Message: Logged In: YES user_id=22084 Ok. I understand what your first message was trying to get at now. However, MySQL actually doesn't recommend that web applications use quoting to catch malformed user input. They indicate this should be handled by the application not the database. In the case of task deletion, you can see that the user input variable is first run through abs() which would throw a parse exception on something other than a valid number. This isn't the prettiest way to handle the error, but it doesn't rely on the database to handle it and it doesn't allow for SQL injection. However, I understand your general concern. I'll leave this issue open at low priority and hopefully get to it one day. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=410239&aid=800965&group_id=34206 |
From: SourceForge.net <no...@so...> - 2006-09-10 13:49:15
|
Bugs item #593193, was opened at 2002-08-09 21:28 Message generated for change (Comment added) made by martinfst You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=410239&aid=593193&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: None Group: OPT 0.9.X >Status: Closed >Resolution: Out of Date Priority: 5 Submitted By: Nobody/Anonymous (nobody) Assigned to: Bogdan Stancescu (b_stancescu) Summary: Gettext version short or long codes Initial Comment: Hello: I still have a problem with translations. I have found that my gettext system does not operates correctly by specifing only "en" it needs the long code of gettext such as "en_US". I have found comments about this in: http://www.php.net/manual/en/function.gettext.php Does someone could let me know what version of gettext are you running? Provided that you are using translations. My gettext version is 0.10.36 The alternative is to change tables (fields are 2 chars long) and maybe some code, but I would not like to personalize code to keep the posibility of doing updates of the code. Best regards and thanks: Javier ---------------------------------------------------------------------- >Comment By: Martin Vernooij (martinfst) Date: 2006-09-10 15:49 Message: Logged In: YES user_id=608879 As the 0.9 versions are not supported anymore, this report is out-of-date. The Max branch may suffer from similar issues, but these should then be reported seperately. Martin ---------------------------------------------------------------------- Comment By: Johannes Alfer (alfaenger) Date: 2003-04-27 17:32 Message: Logged In: YES user_id=260003 Thanks Javier! It worked for my German translation just the same way! Johannes ---------------------------------------------------------------------- Comment By: Bogdan Stancescu (b_stancescu) Date: 2002-08-14 17:44 Message: Logged In: YES user_id=341406 OPT will be adapted to use long language codes - that's indeed the correct way to do things actually. Thank you for the notification! ---------------------------------------------------------------------- Comment By: Nobody/Anonymous (nobody) Date: 2002-08-10 22:41 Message: Logged In: NO I have found a "dirty" solution for this. As the language I needed is spanish, I added some lines into /include/general.php. Lines added inside the function OPT_locale from line 594: if ($lang=="es") { $lang="es_ES"; } After this, translations started to work for spanish. However, Im not sure about what can happen with the rest of the application. This is not a good solution. May be a way to configure gettext to accept two letters country codes? OPT must be adapted to new gettext versions with long country codes? Best regards: Javier By the way: Im running SuSE linux 7.2 ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=410239&aid=593193&group_id=34206 |
From: SourceForge.net <no...@so...> - 2006-09-10 13:45:49
|
Bugs item #1111366, was opened at 2005-01-28 12:15 Message generated for change (Comment added) made by martinfst You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=410239&aid=1111366&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: Timesheets Group: OPT 1.X (Max) >Status: Closed >Resolution: Works For Me Priority: 5 Submitted By: Tobias Dittrich (lasrik) Assigned to: Martin Vernooij (martinfst) Summary: Still one week missing Initial Comment: In the timesheets sections there is still one week missing (the first week of this year). Also all following weeks are shiftet by one week, so that always the wrong week is displayed. I think this has to to with the 53. week of the last year (week one of a year starts with the first thursday of the year). This bug is still present in the new 1.2.6 MAX release. ---------------------------------------------------------------------- >Comment By: Martin Vernooij (martinfst) Date: 2006-09-10 15:45 Message: Logged In: YES user_id=608879 As I cannot reproduce this and I know the locales sections is sub-optimal, I've decided to close this report. If anyone experiences a similar issue, please re-open or submit a new bug. Martin ---------------------------------------------------------------------- Comment By: Tobias Dittrich (lasrik) Date: 2005-01-28 16:51 Message: Logged In: YES user_id=768400 Well, I dirty hacked it for now: i just subtract 2 rather than 1 (return $week_one_start+(3600*24*7*($week-2)); ). This works for me, but I don't know about the implications... Frankly I think this is all a bit overcomplicated, maybe due to prior versions of PHP or so ... next week I might have time to install the fresh version and maybe try to learn a bit about date calculations in PHP. Might be that I am just fastidious from my usual programming language Java :) ---------------------------------------------------------------------- Comment By: Martin Vernooij (martinfst) Date: 2005-01-28 14:28 Message: Logged In: YES user_id=608879 Wild guess, but perhaps it's a good one. I Googled for locale german and date functions and saw from the php manual an interesting comment: see e.g. http://nl.php.net/strftime <quote> Note: %G and %V, which are based on ISO 8601:1988 week numbers can give unexpected (albeit correct) results if the numbering system is not thoroughly understood. See %V above and example below. </quote> OPT uses a date function like: $is_weekone = strftime("%V", $first_day) == 1; I only looked at this briefly, but it looks like the example in the link above is showing the %V variable and the different results you get with different locales. Well, as I plan to rework the whole language stuff handling for a next major release, I'm not sure how much time I should spent on fixing this, as locale support is "less optimal" in OPT right now anyway. Let me know what you find with a fresh install and I'll give this some more thoughts. Martin. ---------------------------------------------------------------------- Comment By: Tobias Dittrich (lasrik) Date: 2005-01-28 14:26 Message: Logged In: YES user_id=768400 Okay I found the place where the error occurs, but since I'm no PHP programmer I can't say what exactly is wrong :-} The problem is the function: get_date_from_week in date_funcs.php. This always returns a date one week later than apropriate which in turn is then used as starting point for the strtotime function. Btw: it's not necessary to calculate the $week_start every loop, is it? :) ---------------------------------------------------------------------- Comment By: Tobias Dittrich (lasrik) Date: 2005-01-28 13:18 Message: Logged In: YES user_id=768400 I get this error via: People->Timesheets then there is already the incorrect week displayed (1 week shifted). When I use the "Previous" links at week "Jan 10, 2005" it skips directly to "Dez 27, 2004". Maybe this has something to do with the german locale I am using? See also the bug report about the missing locale from me... (okay this is just a blind shot :)). Or just that I use a complete german system (apache and php are localised also). I will try setting up a fresh new installation of the new OPT release (I just upgraded our current installation which already contained the patches I reported). ---------------------------------------------------------------------- Comment By: Martin Vernooij (martinfst) Date: 2005-01-28 12:54 Message: Logged In: YES user_id=608879 It has to do with week 53, absolutely. Problem is, I cannot reproduce this failure. You can try on the demo site (http://opt.tiempo.nl) and you will see all weeks, and nothing shiufted. Unless you're taking another route to get there. Do you mind sharing which menu steps you do in the menu's to get to the incorrect behaviour? Thanks, Martin ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=410239&aid=1111366&group_id=34206 |
From: SourceForge.net <no...@so...> - 2006-09-10 13:38:12
|
Bugs item #837097, was opened at 2003-11-06 11:24 Message generated for change (Comment added) made by martinfst You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=410239&aid=837097&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: Requests Group: OPT 1.X (Max) >Status: Closed >Resolution: Out of Date Priority: 5 Submitted By: Ronny Hanssen (godvin) Assigned to: Nobody/Anonymous (nobody) Summary: Error message from opt while editing a request Initial Comment: The mail I received from OPT is as follows: The OPT system at opt.teleplan.no issued a database error: -------------------------- The following query failed: select id from requests where id = You have an error in your SQL syntax near '' at line 1 -------------------------- This error occured while Ronny Hanssen was accessing /rt/req_view/gantt_image.php?_jpg_csimd=1 The user came here from http://opt/rt/req_view/ OPT 1.2.0 Max GET variables: _jpg_csimd = 1 Register globals: On User Agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; .NET CLR 1.1.4322) ---------------------------------------------------------------------- >Comment By: Martin Vernooij (martinfst) Date: 2006-09-10 15:38 Message: Logged In: YES user_id=608879 Not reproducable and very old request. Cleaning. Martin ---------------------------------------------------------------------- Comment By: Guy Davis (guy_davis) Date: 2003-12-23 21:08 Message: Logged In: YES user_id=22084 Did this only happen once or all the time? Is it still happening for you? I'm having trouble reproducing this one. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=410239&aid=837097&group_id=34206 |
From: SourceForge.net <no...@so...> - 2006-09-10 13:33:52
|
Bugs item #1151287, was opened at 2005-02-24 20:23 Message generated for change (Comment added) made by martinfst You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=410239&aid=1151287&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: None Group: OPT 1.X (Max) >Status: Closed >Resolution: Fixed Priority: 5 Submitted By: Nobody/Anonymous (nobody) >Assigned to: Martin Vernooij (martinfst) Summary: SQL Select Error on MySQL 4.1 for date value Initial Comment: On MySQL 4.1 and above all queries with date values in it fail. This happens because MySQL changed the format of the returned value of typ timestamp. Before the format was a number. In this version of MySQL the format is in form "yyyy-mm-dd hh:MM:ss". A possible solution is to quote the value which is inserted in the select string. example from forum_lib.php: $sql="select (forums.date>$newDate) from forums where id=$msg"; change to: $sql="select (forums.date>'$newDate') from forums where id=$msg"; Above is one errormessage from the OPT system: The following query failed: select (forums.date>2005-02-24 18:12:34) from forums where id=1 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '18:12:34) from forums where id=1' at line 1 This error occured while xxxx was accessing /forums/Msg_List/ The user came here from http://xxxxxx/forums/Msg_Add/?att_type=projects&att_id=2 Please make sure you include the lines above when submitting a bug report! ---------------------------------------------------------------------- >Comment By: Martin Vernooij (martinfst) Date: 2006-09-10 15:33 Message: Logged In: YES user_id=608879 This has been fixed in the 1.2.7 Max release. Should be backwards compatible. ---------------------------------------------------------------------- Comment By: Martin Vernooij (martinfst) Date: 2005-09-29 19:52 Message: Logged In: YES user_id=608879 This is all because the functionality of the date field in MySQL. MySQL has two forms as can be seen from the MySQL function now() [copy/paste from http://dev.mysql.com/doc/mysql/en/date-and-time-functions.html] NOW() Returns the current date and time as a value in 'YYYY-MM-DD HH:MM:SS' or YYYYMMDDHHMMSS format, depending on whether the function is used in a string or numeric context. mysql> SELECT NOW(); [1] -> '1997-12-15 23:50:26' mysql> SELECT NOW() + 0; [2] -> 19971215235026 On the demo site, I don't have the problems, because the database was originally running on MySQL 3.23. By just copying the data I still have in the demo site the values like: 20050929164937. As longs as all tables use this, you're oke. But what I see happening is that a lot of new setups, automagically start filling the tables with the string format. While [2] is an arithmatic value, [1] is a string and the minus sign is interpreted by the database server. And the space brakes the sql statement all together. On the list there have been suggestions to quote every used date function/field, so effectively start using format [1]. To be honest: I'm not convinced this is the right approach. I would prefer either format [2] or use the UNIX_TIMESTAMP() function. But whatever solution is choosen, it means quite some work to locate every used date functionality in the scripts. And as I said before: I'm pretty busy. And unfortunately for Outreach it's not on my top-priority list, as my paying customers are. As soon as I can find some time, I'll dig into this and probably go for an intermediate 1.2.7 release to get these breaking SQL statements out of the way. ---------------------------------------------------------------------- Comment By: chrismai (chris_mai) Date: 2005-09-28 14:05 Message: Logged In: YES user_id=1353122 There are more bugs, if you use OPT with MYSQL 4.1. The most critical bug is, that there is a function nicedate () in include/gui.php. This function edits the date to show it in a better format. To use this function an error message will be shown, if you want to see the people/task report: The following query failed: select if (year(2005-09-28 13:28:49)!=year(now()), date_format(2005-09-28 13:28:49,"%b %d %Y"), if (dayofyear(2005-09-28 13:28:49)=dayofyear(now()), "Today", date_format(2005-09-28 13:28:49,"%b %d") ) ) from people where id="6" You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '13:28:49)!=year(now()), date_format(2005-09-28 13:28 This error occured while Administrator was accessing /opt/tasks/report/people_task.php?proj=2 The user came here from http://eisfair/opt/tasks/leftmenu/?proj=2. If you convert the variable $field in the function nicedate (), the date will never be shown. For example in the mask Forums the threads dont have a dateinformation or in the Admin area the logs for all users will not be shown. ---------------------------------------------------------------------- Comment By: Matthias Munnich (langelino) Date: 2005-07-02 01:32 Message: Logged In: YES user_id=596252 I ran into the same problem and was able to fix it by adding quotes around 4 variables in two file. See the patch belowWARNING: I am a php illiterate so this might be a bad way to fix it, however is works for me. Langelino --- OPT_1-2-6_MAX/opt/index.php 2002-08-28 04:15:36.000000000 -0700 +++ index.php 2005-07-01 16:16:59.000000000 -0700 @@ -81,13 +81,13 @@ if ($CRM_comp==1) { $sql="select count(*) from news - where chindate>$lastlog"; + where chindate>'$lastlog'"; } else { $sql="select count(*) from news where (company=$CRM_comp or company=0) - and chindate>$lastlog"; + and chindate>'$lastlog'"; } $result=CRM_run_query($sql); $myrow=OPT_fetch_row($result); --- OPT_1-2-6_MAX/opt/main_menu/welcome/index.php 2004-12-16 23:56:54.000000000 -0800 +++ index.php 2005-07-01 16:17:47.000000000 -0700 @@ -299,7 +299,7 @@ // Other logins // ======================== $lastlog=getvalue("people","prevlog",$CRM_user); - $sql="select count(*) from people where lastlog>$prevlog and id!=$CRM_user"; + $sql="select count(*) from people where lastlog>'$prevlog' and id!=$CRM_user"; $result=crm_run_query($sql); list($people_logged)=OPT_fetch_row($result); if ($people_logged) { @@ -311,7 +311,7 @@ // ======================== if ($CRM_user > 5) { - $doc_count=crm_elements("documents"," and chindate>$prevlog"); + $doc_count=crm_elements("documents"," and chindate>'$prevlog'"); if ($docs=OPT_num_rows($doc_count)) { echo(sprintf(__("%d documents have been posted since you last logged in"),$docs)."<br>\n"); } ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=410239&aid=1151287&group_id=34206 |
From: Martin V. <mar...@ti...> - 2006-09-10 13:22:28
|
Today I released a new version of OPT (1.2.7), which fixes the security issue and adds support for MySql 4 & 5. Some other enhancements are implemented at the same time. Please see the release notes for all details. Enjoy, Martin |
From: Martin V. <mar...@ti...> - 2006-08-18 21:29:40
|
Today, August 18, 2006, the server running the demo OPT site has been hacked due to a vulnerability in include/urights.php. The demo site is currently off-line till this has been fixed. For those running OPT on a public webserver, please take immediate action to protect your server. Martin |
From: SourceForge.net <no...@so...> - 2006-06-26 13:27:52
|
Patches item #1512717, was opened at 2006-06-26 13:27 Message generated for change (Tracker Item Submitted) made by Item Submitter You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=410241&aid=1512717&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: None Group: None Status: Open Resolution: None Priority: 5 Submitted By: Marcus Nilsson (marcusn) Assigned to: Nobody/Anonymous (nobody) Summary: Shows only accessible people under Overview -> All -> People Initial Comment: In Max 1.2.6, if you go to Overview -> All -> People, you see _all_ people, regardless if you have access or not. This patch filters people in the same way as People -> Users does, using crm_elements. ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=410241&aid=1512717&group_id=34206 |