I just wanted to say this is an awesome project and thank you very much for creating this, it is perfect! This messages is basically a FYI to everybody...
I just installed todolist.php on MySQL 5.0.16 and got the following message when trying to login after editing my config.php file.
MySQL Error: 1054 (Unknown column 'todo_todos.todo_id' in 'on clause')
After some research, this is caused by the way MySQL 5 now handles some queries, especially JOINS. You need to edit the following two files for it to work.
functions.inc.php - line 324 - add ()
FROM (todo_todos, todo_responsible_persons, todo_project_members)
pages.inc.php - line 161 - add ()
FROM (todo_todos, todo_responsible_persons, todo_project_members)
Once these files were editied it seems to be working great. thanks again!
~Brian
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
To make the search work on MYSQL 5 it appears you also need to add brackets to the FROM clause on line 394 of functions.inc.php so the line reads as follows:
FROM (todo_todos, todo_responsible_persons rp)
DISCLAIMER: Whilst this solution appears to have worked for me, I cant guarantee it so use at your own risk.
Great project by the way, best PHP todo list that I know of, shame it hasn't been updated in a while.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi All,
I just wanted to say this is an awesome project and thank you very much for creating this, it is perfect! This messages is basically a FYI to everybody...
I just installed todolist.php on MySQL 5.0.16 and got the following message when trying to login after editing my config.php file.
MySQL Error: 1054 (Unknown column 'todo_todos.todo_id' in 'on clause')
After some research, this is caused by the way MySQL 5 now handles some queries, especially JOINS. You need to edit the following two files for it to work.
functions.inc.php - line 324 - add ()
FROM (todo_todos, todo_responsible_persons, todo_project_members)
pages.inc.php - line 161 - add ()
FROM (todo_todos, todo_responsible_persons, todo_project_members)
Once these files were editied it seems to be working great. thanks again!
~Brian
To make the search work on MYSQL 5 it appears you also need to add brackets to the FROM clause on line 394 of functions.inc.php so the line reads as follows:
FROM (todo_todos, todo_responsible_persons rp)
DISCLAIMER: Whilst this solution appears to have worked for me, I cant guarantee it so use at your own risk.
Great project by the way, best PHP todo list that I know of, shame it hasn't been updated in a while.