Phoca Download Layout Warning

[bendeguz]

Hi! I cant see my files ind backend.

The component shows warning this message:

COM_PHOCADOWNLOAD_LAYOUT_WARNING
COM_PHOCADOWNLOAD_CATEGORIES_VIEW
COM_PHOCADOWNLOAD_PARAMETERS
{pdtitle} {pddescription} {pdsubcategories} {pdclear}
COM_PHOCADOWNLOAD_STYLES
pd-title pd-desc pd-subcategory pd-no-subcat
COM_PHOCADOWNLOAD_CATEGORY_VIEW
COM_PHOCADOWNLOAD_PARAMETERS
{pdtitle} {pdimage} {pdfile} {pdfilesize} {pdversion} {pdlicense} {pdauthor} {pdauthoremail} {pdfiledate} {pddownloads} {pddescription} {pdfeatures} {pdchangelog} {pdnotes} {pdmirrorlink1} {pdmirrorlink2} {pdreportlink} {pdrating} {pdtags} {pdfiledesctop} {pdfiledescbottom} {pdbuttondownload} {pdbuttondetails} {pdbuttonpreview} {pdbuttonplay} {pdvideo}
COM_PHOCADOWNLOAD_STYLES
pd-title pd-image pd-file pd-fdesc pd-mirrors pd-mirror pd-report pd-rating pd-tags pd-buttons pd-downloads pd-video
COM_PHOCADOWNLOAD_FILE_VIEW
COM_PHOCADOWNLOAD_PARAMETERS
{pdtitle} {pdimage} {pdfile} {pdfilesize} {pdversion} {pdlicense} {pdauthor} {pdauthoremail} {pdfiledate} {pddownloads} {pddescription} {pdfeatures} {pdchangelog} {pdnotes} {pdmirrorlink1} {pdmirrorlink2} {pdreportlink} {pdrating} {pdtags} {pdvideo}
COM_PHOCADOWNLOAD_STYLES
pd-title pd-image pd-file pd-fdesc pd-mirrors pd-mirror pd-report pd-rating pd-tags pd-downloads pd-video

How van I fix it? Thanks.

[Jan]

Hi, I see no warning or error - do you have enabled debug mode to get information from database?

Jan

[bendeguz]

Hi Jan,

in the the debug appears warning

JDatabaseMySQLi::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
Call stack
# Function Location
1 JAdministrator->dispatch() JROOT/administrator/index.php:46
2 JComponentHelper::renderComponent() JROOT/administrator/includes/application.php:153
3 JComponentHelper::executeComponent() JROOT/libraries/joomla/application/component/helper.php:351
4 require_once() JROOT/libraries/joomla/application/component/helper.php:383
5 JController->execute() JROOT/administrator/components/com_phocadownload/phocadownload.php:29
6 PhocadownloadCpController->display() JROOT/libraries/joomla/application/component/controller.php:761
7 JController->display() JROOT/administrator/components/com_phocadownload/controller.php:47
8 PhocaDownloadCpViewPhocaDownloadFiles->display() JROOT/libraries/joomla/application/component/controller.php:722
9 JView->get() JROOT/administrator/components/com_phocadownload/views/phocadownloadfiles/view.html.php:25
10 JModelList->getItems() JROOT/libraries/joomla/application/component/view.php:386
11 JModelList->getStart() JROOT/libraries/joomla/application/component/modellist.php:128
12 JModelList->getTotal() JROOT/libraries/joomla/application/component/modellist.php:265
13 JModel->_getListCount() JROOT/libraries/joomla/application/component/modellist.php:231
14 JDatabaseMySQLi->execute() JROOT/libraries/joomla/application/component/model.php:318
15 JError::raiseError() JROOT/libraries/joomla/database/database/mysqli.php:396
16 JError::raise() JROOT/libraries/joomla/error/error.php:251

[Jan]

Hi, your database - table phocadownload does not include the column userid - did you make some changes in database structure?

Jan

[bendeguz]

Hi Jan,

I didn't make changes in database. Is it possible to repair it?

[Jan]

If the column is missing there, it must be added with help of SQL query (e.g. per phpMyAdmin):

https://www.phoca.cz/documents/2-phoca-g ... em-solving (it is similar problem but not exactly the same)

Jan

[bendeguz]

Thank you very much Jan,

I run SQL query in phpMyAdmin:

ALTER TABLE `jos__phocadownload` ADD `userid` int(11) NOT NULL default '0'AFTER `notes`

I got warning:

#1146 - Table 'dpsfucom_zus.jos__phocadownload' doesn't exist

But I see the table in phpMyAdmin! There is a table named `jos__phocadownload`, i can see there my files, and i see that column `userid`is missing...

[Jan]

Hi, be aware of the underscore:

Maybe you have only: jos_phocadownload (one underscore) not jos__phoca download (two underscores) ( _ is not __ )

Jan

[bendeguz]

Many thanks Jan, now it works properly.

bendeguz

[Jan]

Ok, great to hear it.

Jan