Test xpdf with php

[Daniel]

Ok, i changed that and went to My Documents menu point where it shows me this message at the top of the page:

....

Looks like the sql statements in $user->getApprovalStatus() failed for some reason.

Are you using the right version of LetoDMS_Core?

The next step would be to echo the sql statements in getApprovalStatus()
found in the file LetoDMS_Core/Core/inc.ClassUser.php

Uwe

The core.php file states * @version Release: 3.4.0RC4, the same also for inc.ClassUser.php

How to do the echo? The same way, just adding the statement you gave me above?

Go into LetoDMS_Core/Core/inc.ClassUser.php
In line 721 starts the function getApprovalStatus() which calls two sql statements. Both are stored in a variable $queryStr (line 745 and 781).
Output both with

echo $queryStr;

place that line before the $db->getResultArray() call.

Try both in your favorite mysql client (phpmyadmin or just mysql).
I suspect one of them fails. The statements can't do any harm because they are just select statements.

Uwe

Hi Uwe,

Beside that i'm a N00b in SQL and got some failures in the statement (until i noted that MySQL complains about the ") i found that it asks for a table tblGroupMembers but i can't see the table in the database.

Is there something wrong? The database has been created with the LetoDMS setup.

And don't worry about the database, is's just a test one with only 3 docs in there, so if i mess it up i just create it again.

Daniel