[TYPO3] Document_dirs "NO ROOT FOLDER COULD BE FOUND"

[Jan Bidner]

Hi list,

I've had the script "danp_documentdirs" up and running for a Linux
3.6-installation of typo3 and I think it's great. But now it seems as, no
matter what I try, it wont list any directories i FE.

"NO ROOT FOLDER COULD BE FOUND FOR THIS PAGE" is the message I get. I am
able to upload files in  FE, and when I browse the file-area i BE I see the
files were uploaded. Files and folders are getting indexed alright - I can
see them as registers in the doc_dir-BE-page. But nothing is listed in the
FE.
With debug on I get the following SQL-errors in the front-end:

"0 You have an error in your SQL syntax near ') AND parentid=0 AND hidden=0
ORDER BY foldername' at line 1
 
1 select uid from tx_danpdocumentdirs_folders where pid in () AND parentid=0
AND hidden=0 ORDER BY foldername
-------------------------------------------- 
0 You have an error in your SQL syntax near ')
AND tx_danpdocumentdirs_documents.deleted=0 AND
tx_danpdocumentdirs_documents' at line 4
 
1 SELECT count(*)
FROM tx_danpdocumentdirs_documents
WHERE
pid IN ()
AND tx_danpdocumentdirs_documents.deleted=0 AND
tx_danpdocumentdirs_documents.hidden=0 AND
(tx_danpdocumentdirs_documents.starttime<=1143442227) AND
(tx_danpdocumentdirs_documents.endtime=0 OR
tx_danpdocumentdirs_documents.endtime>1143442227) AND
tx_danpdocumentdirs_documents.fe_group IN (0,-2,2,3,10,17) AND notshow=0
----------------------------------------------
0 You have an error in your SQL syntax near ')
AND tx_danpdocumentdirs_documents.deleted=0 AND
tx_danpdocumentdirs_documents' at line 4
 
1 SELECT tx_danpdocumentdirs_documents.*
FROM tx_danpdocumentdirs_documents
WHERE
pid IN ()
AND tx_danpdocumentdirs_documents.deleted=0 AND
tx_danpdocumentdirs_documents.hidden=0 AND
(tx_danpdocumentdirs_documents.starttime<=1143442227) AND
(tx_danpdocumentdirs_documents.endtime=0 OR
tx_danpdocumentdirs_documents.endtime>1143442227) AND
tx_danpdocumentdirs_documents.fe_group IN (0,-2,2,3,10,17) AND notshow=0

LIMIT 0,40 "

I have a working version of this script in a 3.8-installation where this
problem doesn't occur. What IS the ROOT FOLDER of the page? Is it related to
the registers, sysfolder of the page (do i need one? Or could i simply keep
the registers directly on a standardpage?) or the roofolder of the
page-element? 
Anyone with any suggestions what might be wrong? What can I do to
debug/check the installation? What parameters could be wrong? Grateful for a
solution on this one...

Greetings - Jan
 
----------------------------------------------------------------------------
----------
Jan Bidner                                          Tel: +46(0)90 - 786 66
31, 58 59 
Ladokenheten                                     Fax: +46(0)90 - 786 69 91
Umeå University                                  www:
www.umu.se/ladokenheten
SE - 90187 Umeå                                 AIM: jnlad2
----------------------------------------------------------------------------
----------
"Att fela är mänskligt, men för att verkligen ställa till det behöver man en
dator. "