#49 Links 1 for dP 1.0.2

[Anonymous]

Links didn't work (well) with dP 1.0.2 because you were
never asked for a links name.

So here goes 4 files that will change this forever
(hopefully).

Enjoy,

Pedro A.

FAQ:
Q: I only see one file. Where are the 4 files you
mentioned?
A: Sourceforge does not allow me to send the 4 files
separatly. So they are ziped.

Q: What does "ziped" means?
A: Means they are inside that attached file.

Q: How do I get them out?
A: Unzip them with 7zip

Q: Where can I find 7zip?
A: There's a little search box on sourceforge for you to
find (yes it is open source).

Q: How do I make it work?
A: unzip the 4 files into the dotproject
root/modules/links and overwrite the old ones.

And that's all folks

[Nobody/Anonymous]

Update for the links module so it works with dotProject 1.0.2

[Nobody/Anonymous]

Logged In: NO

I have done the above, however I still get the following error:

ERROR: /www/www1/bo.ep-team.net/ftp/incoming/
public_html/classes/query.class.php(590): query
failed(SELECT project_id,project_name FROM `projects`,
`links` WHERE AND project_id = link_project AND
(project_company IN (1,2,3,6,5,7,8,9)) ORDER BY
project_name) - error was: You have an error in your SQL
syntax near 'AND project_id = link_project AND
(project_company IN (1,2,3,6,5,7,8,9)) ORDER B' at line 1
Backtrace:
0 /www/www1/bo.ep-team.net/ftp/incoming/public_html/
classes/query.class.php:590 dprint('/www/www1/bo.ep-team.
net/ftp/incoming/public_html/classes/query.class.php',590,0,
'query failed(SELECT project_id,project_name FROM
`projects`,`links` WHERE AND project_id = link_project AND
(project_company IN (1,2,3,6,5,7,8,9)) ORDER BY
project_name) - error was: You have an error in your SQL
syntax near \'AND project_id = link_project AND
(project_company IN (1,2,3,6,5,7,8,9)) ORDER B\' at line 1')
1 /www/www1/bo.ep-team.net/ftp/incoming/public_html/
classes/query.class.php:635 exec(2)
2 /www/www1/bo.ep-team.net/ftp/incoming/public_html/
classes/dp.class.php:324 loadhashlist(NULL)
3 /www/www1/bo.ep-team.net/ftp/incoming/public_html/
modules/projects/projects.class.php:237 getallowedrecords('1',
'project_id,project_name','project_name',NULL,array (
'from' => 'links',
'where' => 'AND project_id = link_project AND
(project_company IN (1,2,3,6,5,7,8,9))',
))
4 /www/www1/bo.ep-team.net/ftp/incoming/public_html/
modules/links/index.php:26 getallowedrecords('1','project_id,
project_name','project_name',NULL,array (
'from' => 'links',
'where' => 'AND project_id = link_project',
))
5 /www/www1/bo.ep-team.net/ftp/incoming/public_html/index.
php:324 require('/www/www1/bo.ep-team.net/ftp/incoming/
public_html/modules/links/index.php')
You have an error in your SQL syntax near 'AND project_id =
link_project AND (project_company IN (1,2,3,6,5,7,8,9))
ORDER B' at line 1

I hope you have a solution for me.

Thanks and best regards,
Peter
peter@ebouwhuis.com