Date index for Jun 2002
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
PostgreSQL & Achievo_0_8
LS,
I installed Achievo 0_8 on Apache/PHP/PostgreSQL on a solaris system.
1/ I used the achievo_0_9 scripts to create the database because there were
no
achievo _0_8 sql files
2/ In order to get the projects into the system I had to make the following
patch :
Original code in class.project.inc :
function initial_values()
{
return array("startdate"=>array("year"=>date(Y),
"month"=>date(m),
"day"=>date(d)),
"enddate"=>array("year"=>(date(Y)+1),
"month"=>date(m),
"day"=>date(d)),
"status"=>"active");
Patched code :
function initial_values()
{
return array("fixed_price"=>"0.00",
"startdate"=>array("year"=>date(Y),
"month"=>date(m),
"day"=>date(d)),
"enddate"=>array("year"=>(date(Y)+1),
"month"=>date(m),
"day"=>date(d)),
"status"=>"active");
If not patched the Insert into project statement fails.
3/ In order to get the employee display to work without error i had to patch
:
$preFilter->m_destinationFilter = "userid !='[userid]' && status
='active'";
Patched coode
$preFilter->m_destinationFilter = "userid !='[userid]' AND status
='active'";
But now I get the following error in the Time registration, week view (the
day view seems OK).
error: Invalid SQL query: SELECT (uc_hours*60)-sum(time) as leftover FROM
hours LEFT JOIN usercontract ON hours.userid = usercontract.userid WHERE
startdate <= '2002-06-10' AND enddate > '2002-06-10' AND hours.userid =
'admin' AND activitydate between '2002-06-10' and '2002-06-16' GROUP BY
hours.userid
(I am logged in as the user admin).
As this function is working without error in my other (test) mysql
environment I suspect the query is not correct formatted for PostgreSQL.
Do you know where the select is generated and what to change to make it work
?
Are there any other known issues using PostgeSQL and Achievo_0_8 ?
Kind regards,
Herman Reintke
_______________________________________________
Herman Reintke
Project Manager - Vizzavi Nederland
Vizzavi Nederland
Kingsfordweg 151
1043 GR Amsterdam
Nederland
Mobile: +31 (0) 654260211
**********************************************************************
This message contains confidential information and is intended only for the individual named. If you are not the named addressee you should not disseminate, distribute or copy this e-mail: to do so could be a breach of confidence. Please notify us immediately by reply e-mail and then delete this e-mail from your system. Please contact our IT Helpdesk on +44 (0)20 7212 0000 or e-mail ukithelpdesk dot
E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message that arise as a result of e-mail transmission. If verification is required please request a hard-copy version. This message is provided for informational purposes and should not be construed as a solicitation or offer to buy or sell any securities or related financial instruments.
This e-mail has been sent through the e-mail gateway of Vizzavi Europe Limited ("VEL") on its own account or on behalf of and for the benefit of other Vizzavi group companies who use this facility from time to time.
VEL Registered office - 80 Strand London WC2R ORJ England. Registered in England No. 04064873
For this message in Dutch, French, German, Greek, Italian, Portuguese and Spanish, click on http://www.corp.vizzavi.net/disclaimer/
Visit Vizzavi at: http://www.vizzavi.net/
This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses.
www.mimesweeper.com
**********************************************************************