User Upload Problem

[ardn0001]

As admin I cannot add a file in the frontend, there are not sections listed nor categories, I created a section and the category from backend but the problem is the same.

[ardn0001]

Digging there I found [s]get [/s]the query:

Code: Select all

LECT cc.id AS value, cc.title AS text
FROM jos_phocadownload_categories AS cc
LEFT JOIN jos_phocadownload_sections AS s ON s.id = cc.section
WHERE (
cc.uploaduserid LIKE '%-1%'
OR cc.uploaduserid LIKE '%62%'
)
ORDER BY s.ordering, cc.ordering
LIMIT 0 , 30 

Removing WHERE condition shows:
value text
2 Utilidades
1 Herramientas

SELECT cc.id AS value, cc.title AS text
FROM jos_phocadownload_categories AS cc
LEFT JOIN jos_phocadownload_sections AS s ON s.id = cc.section
ORDER BY s.ordering, cc.ordering
LIMIT 0 , 30

CC.UPLOADUSERID ??? what does it mean? .. Where is the user option to create a Category from front end?

[ardn0001]

phoca download category table:

Code: Select all

id  parent_id  section  title  name  alias  image  image_position  description  published  checked_out  checked_out_time  editor  ordering  access  uploaduserid  date  count  params  
      1 0 1 Herramientas   herramientas   left   1 0 0000-00-00 00:00:00 NULL 2 0 -2 2009-12-29 00:00:00 0 NULL 
      2 0 1 Utilidades   utilidades   left   1 0 0000-00-00 00:00:00 NULL 1 0 -1 2009-12-29 23:22:41 0 NULL 

Changing the uploaduserid to -1, It works for that category, but my question Is it workin properly ?

[Jan]

Hi, you need to add upload rights (for you) into the category.

Jan