Page 1 of 1

Cannot create a category

Posted: 14 Jun 2012, 09:36
by igonasu
Hi!
After download Phoca Download i want to create my first category but i'm not enable to create this:
display categories:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/dehedin.ch/httpdocs/dehjla173de/libraries/joomla/database/database/mysql.php on line 282

Click on new:
/var/www/vhosts/dehedin.ch/httpdocs/dehjla173de/administrator/components/com_phocadownload/helpers/phocadownload.php on line 19

want to save the categorie
Speichern fehlgeschlagen! Fehler: CATEGORY MUST HAVE A TITLE
Warning: Invalid argument supplied for foreach() in /var/www/vhosts/dehedin.ch/httpdocs/dehjla173de/libraries/joomla/database/database/mysql.php on line 368

All tables have been created manually and are in the database!
while debugging i have the following protocol (only the first 2 lines):
JDatabaseMySQL::query: 1146 - Table 'dehjla173.w349y_phocadownload_categories' doesn't exist SQL=SELECT a.*,l.title AS language_title,uc.name AS editor,ag.title AS
but the 'dehjla173.w349y_phocadownload_categories' still exists!

Thank You for your help.

igonasu

Joomla 1.7.3

Re: Cannot create a category

Posted: 15 Jun 2012, 17:55
by Jan
Hi, the debug tells it:
"Table 'dehjla173.w349y_phocadownload_categories' doesn't exist"

the Phoca Download tables were not created while installing, see:

https://www.phoca.cz/documents/16-joomla ... ent-errors

Jan

Re: Cannot create a category

Posted: 17 Jun 2012, 14:40
by igonasu
hi!
Hi!
I have uninsalled the component and the tables and i reload and reinstall the component.
Then i have created the tables one by one and anlysed the SQL
error.
now it works
Thank You for your help
igonasu

Re: Cannot create a category

Posted: 17 Jun 2012, 18:03
by Jan
Ok