Page 1 of 1
User Upload Problem
Posted: 30 Dec 2009, 02:11
by 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.
Re: User Upload Problem
Posted: 30 Dec 2009, 02:51
by 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?
Re: User Upload Problem
Posted: 30 Dec 2009, 03:06
by 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 ?
Re: User Upload Problem
Posted: 04 Jan 2010, 19:18
by Jan
Hi, you need to add upload rights (for you) into the category.
Jan