Phoca Forum

Dear all,

i host four different pages, always with a phoca gallery and some other - great - components.

But now, I've a problem.
I actualle use version 2.5.8. since a long time. As I believe in "never change a running system", I didn't install all the updates since then.
But now, I want to upgrade to the actual version 2.7.5. Of course, I read the sentence "fter upgrade of Phoca Gallery version 2.5.x (and older) to 2.6.x go to Administration - Components - Phoca Gallery - Users and click on Authorize All button."
BUT:
If i got tu "Users", I get two warnings:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.sites/831/site611/web/steinhauser/libraries/joomla/database/database/mysql.php on line 344

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/.sites/831/site611/web/steinhauser/libraries/joomla/database/database/mysql.php on line 344

and the following list is empty. Whenn I klick the button "Authorize All", I just get the error message "Fehler bei der Authorisierung aller Bilder und Kategorien." - so it doesn't work...

WHY?

Could it be, that list entries in the database are created during the update?
Becaus when I install the gallery the first time, I always have this problem: (Database)
https://www.phoca.cz/documents/2-phoca-g ... em-solving

THANKS A LOT FOR HELPING!

Hi, enable debug mode, to display the error from database (you should get info about possible missing column, etc.)

Jan

Hello Jan,

so, debug mode enabled - thats the result.

Hope, that you can help me...

Thanks a lot!

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

500 - Es ist ein Fehler aufgetreten

JDatabaseMySQL::query: 1054 - Unbekanntes Tabellenfeld 'cc.owner_id' in field list SQL=SELECT a.*, cc.title AS category, cc.owner_id AS ownerid, u.name AS editor, v.average AS ratingavg, ua.username AS usercatname FROM jos_phocagallery AS a LEFT JOIN jos_phocagallery_categories AS cc ON cc.id = a.catid LEFT JOIN jos_phocagallery_img_votes_statistics AS v ON v.imgid = a.id LEFT JOIN jos_users AS u ON u.id = a.checked_out LEFT JOIN jos_users AS ua ON ua.id = cc.owner_id ORDER BY category, a.ordering LIMIT 0, 20

I'm having the same problem in Backend, it shows the same error messages and also it takes a lot of time to load. And also I have a lot of images and categories almost 2,000 but it shouldn't show that errors and it shouldn't be that slow right?

MaXuS
see:
viewtopic.php?f=1&t=11291&p=48943#p48943

please post answers in the post listed above regarding time issue (to be not confusing and not duplicity).

webstarrr

Unbekanntes Tabellenfeld 'cc.owner_id'

Means, your database misses some Phoca Gallery columns in Phoca Gallery tables, try to re-upgrade or see:
https://www.phoca.cz/documents/2-phoca-g ... em-solving

Jan