Phoca Forum

I see this error message in the backend, if I will look to my files

[quote]
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /mnt/web5/10/45/5355645/htdocs/bembix_neu/libraries/joomla/database/database/mysql.php on line 317

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /mnt/web5/10/45/5355645/htdocs/bembix_neu/libraries/joomla/database/database/mysql.php on line 317

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /mnt/web5/10/45/5355645/htdocs/bembix_neu/libraries/joomla/database/database/mysql.php on line 317
[/quote]

Joomla 1.6.5 with last Phoca Download.
Only what I do is Update Joomla and Phoca Download.

Debug from Joomla

[code]
Fehler

JDatabaseMySQL::query: 1054 - Unknown column 'a.userid' in 'on clause' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor,uua.id AS uploaduserid, uua.username AS uploadusername, uua.name AS uploadname,ag.title AS access_level,c.title AS category_title, c.id AS category_id,ua.id AS userid, ua.username AS username, ua.name AS usernameno FROM `jos_phocadownload` AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_users AS uua ON uua.id=a.userid LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access LEFT JOIN jos_phocadownload_categories AS c ON c.id = a.catid LEFT JOIN jos_users AS ua ON ua.id = a.owner_id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.title asc
Informationen


Zurückverfolgen (Back-Trace)
Call stack
# Function Location
1 JAdministrator->dispatch() /mnt/web5/10/45/5355645/htdocs/bembix_neu/administrator/index.php:47
2 JComponentHelper::renderComponent() /mnt/web5/10/45/5355645/htdocs/bembix_neu/administrator/includes/application.php:154
3 require_once() /mnt/web5/10/45/5355645/htdocs/bembix_neu/libraries/joomla/application/component/helper.php:152
4 JController->execute() /mnt/web5/10/45/5355645/htdocs/bembix_neu/administrator/components/com_phocadownload/phocadownload.php:27
5 PhocadownloadCpController->display() /mnt/web5/10/45/5355645/htdocs/bembix_neu/libraries/joomla/application/component/controller.php:649
6 JController->display() /mnt/web5/10/45/5355645/htdocs/bembix_neu/administrator/components/com_phocadownload/controller.php:102
7 PhocaDownloadCpViewPhocaDownloadFiles->display() /mnt/web5/10/45/5355645/htdocs/bembix_neu/libraries/joomla/application/component/controller.php:616
8 JView->get() /mnt/web5/10/45/5355645/htdocs/bembix_neu/administrator/components/com_phocadownload/views/phocadownloadfiles/view.html.php:25
9 JModelList->getItems() /mnt/web5/10/45/5355645/htdocs/bembix_neu/libraries/joomla/application/component/view.php:365
10 JModelList->getstart() /mnt/web5/10/45/5355645/htdocs/bembix_neu/libraries/joomla/application/component/modellist.php:118
11 JModelList->getTotal() /mnt/web5/10/45/5355645/htdocs/bembix_neu/libraries/joomla/application/component/modellist.php:244
12 JModel->_getListCount() /mnt/web5/10/45/5355645/htdocs/bembix_neu/libraries/joomla/application/component/modellist.php:213
13 JDatabaseMySQL->query() /mnt/web5/10/45/5355645/htdocs/bembix_neu/libraries/joomla/application/component/model.php:266
14 JError::raiseError() /mnt/web5/10/45/5355645/htdocs/bembix_neu/libraries/joomla/database/database/mysql.php:208
15 JError::raise() /mnt/web5/10/45/5355645/htdocs/bembix_neu/libraries/joomla/error/error.php:179
[/code]

I copy the Joomla site on different provider.
Export and Import the database. After this I test again Phoca Download to look my files.
Same error.

I remove Phoca download, update to Joomla 1.7.0 and install Phoca Download new.
After this I import the Categorie from old database to the new one. That works fine.

I test to import from old database, the files, to the new one.
That will work not. I see every time

Invalid field count in CSV input on line 1.

Hi, not experiences with CSV but missing "userid" column means, you need to paste it manually (install.sql.bak) or Install (Upgrade) the Phoca Gallery component. See forum, there are some information about the userid column

Jan

Thx Jan.
I install it new and insert the files again.
Was not so many files

Ok