Kategorien & Mitglieder Modul verursachen DB-Fehler

Phoca Gallery - image gallery extension
dee1337
Phoca Newbie
Phoca Newbie
Posts: 4
Joined: 11 Feb 2010, 17:41

Kategorien & Mitglieder Modul verursachen DB-Fehler

Post by dee1337 »

Hallo zusammen,

ich hab auch ein Problem mit der Phoca Gallery in Version 2.6.2.
Nachdem ich die Gallery auf nem Joomla 1.5.15 installiert habe (und den Install Button gedrückt habe) kann ich alle Control-Panel Module der Phoca Gallery öffnen nur bei dem Modul Kategorien und Mitglieder kommt ein Datenbankfehler.
Bei Kategorien:

Code: Select all

Warning: Invalid argument supplied for foreach() in [...]/administrator/components/com_phocagallery/models/phocagallerycs.php on line 126
Bei Mitglieder:

Code: Select all

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [...]/libraries/joomla/database/database/mysql.php on line 344 
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in [...]/libraries/joomla/database/database/mysql.php on line 344

Die Tabellen der Datenbank wurden korrekt angelegt (Verglichen mit einer anderen Joomla Installation, auf dem selben Webspace, wo die Gallery funktioniert)

Hat jemand eine Idee?

Gruß
Dee
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49150
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Kategorien & Mitglieder Modul verursachen DB-Fehler

Post by Jan »

Hi, such error is displayed in case there is missing some table or some column only :idea: :idea: :(
If you find Phoca extensions useful, please support the project
dee1337
Phoca Newbie
Phoca Newbie
Posts: 4
Joined: 11 Feb 2010, 17:41

Re: Kategorien & Mitglieder Modul verursachen DB-Fehler

Post by dee1337 »

Hi Jan,
thank you for your answer.
I am in complete agreement with you, it is a table or column problem but I checked the database and table structure and compared it to another installation (same joomla version, same phoca version). The structure is the same every table has the right columns with it. :x
The only difference between the installations was that the one with the problem was a joomla 1.5.10 befor I updated it to 1.5.15. But this shouldn't be a problem..

So far..
regards
Dee
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49150
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Kategorien & Mitglieder Modul verursachen DB-Fehler

Post by Jan »

Hi, yes I think this should not be a problem. So if the tables are correct,then there must be some problem with getting the data from database. Try to enable debug mode to see if you get some error message from the database?

Jan
If you find Phoca extensions useful, please support the project
dee1337
Phoca Newbie
Phoca Newbie
Posts: 4
Joined: 11 Feb 2010, 17:41

Re: Kategorien & Mitglieder Modul verursachen DB-Fehler

Post by dee1337 »

Hi jan,
i enabled the debug mode and got two 500 errors one with the members module and the other with the categories module.
I attachted a screenshot of the categories error. Hope you can see anything.. :idea:

Image
DOWNLOAD
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49150
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Kategorien & Mitglieder Modul verursachen DB-Fehler

Post by Jan »

Hi, try to upgrade you mysql, seems like your mysql version doesn't work with combined queries :-(

Jan
If you find Phoca extensions useful, please support the project
dee1337
Phoca Newbie
Phoca Newbie
Posts: 4
Joined: 11 Feb 2010, 17:41

Re: Kategorien & Mitglieder Modul verursachen DB-Fehler

Post by dee1337 »

WOW, amazing..
IT WORKS!
It was the SQL Database.. I upgraded it to MYSQL 5.0 and now everything is fine..
I missed the version of the database all DBs were Version 5 only this one was 4..
Thank you very much! You're the best ;)
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49150
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Kategorien & Mitglieder Modul verursachen DB-Fehler

Post by Jan »

Great to hear it. Jan
If you find Phoca extensions useful, please support the project
cookie
Phoca Newbie
Phoca Newbie
Posts: 4
Joined: 05 Dec 2009, 00:44

Re: Kategorien & Mitglieder Modul verursachen DB-Fehler

Post by cookie »

As I mentioned in a different post around christmas, I do have the same problem with 2.6.2. I tried everything, but the fault remains the same as mentioned by Dee. Now I backuped my DB and photos and downgraded to version 2.5.8 of phoca gallery and it´s working now.

You´re right, the problem must be the mysql version, but unfortunately I can´t upgrade mysql, because my provider still uses mysql 4 and don´t give the option of 5.

Isn´t there an option, that you can ask in your program, what version of mysql is used and use for mysql 4 these queries, which are working? Otherwise an upgrade to newer gallery versions is not possible. And I have chosen joomla, because it is working very well with mysql 4.

Thanks
Martin
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49150
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: Kategorien & Mitglieder Modul verursachen DB-Fehler

Post by Jan »

Hi, the only one solution is:

- somebody will find the problem in the SQL which will not work in version 4
- and will paste some solution for version 4

For now I don't have any information about which part is not working uder 4 and how to change it so it will be working under 4 version.

If I get such information, I will try to implement it into new version ASAP so it can work without any problems in version 4

Jan
If you find Phoca extensions useful, please support the project
Post Reply