No Categories displayed in Backend

[Speedsurfer]

Hello,

i have updated my Phoca Gallery from 1.8.8 to 2.0.0 beta.
Everything works fine, but the categories aren't displayed in the administrator backend. Also when i create a new category it isn't listed.
In the frontend the visitors can see the categories.

Thank you for helping me. You can answer in English or in German.

[Jan]

??? , maybe some files are missed while installtion, try to reinstall Phoca Gallery, try to look into a database, if all tables for Phoca Gallery are here (you find the names of tables in install.bak file)

Jan

[Speedsurfer]

Hello,

thank you for your fast answer.

I have reinstalled the Phoca Gallery.
After the installation i get the following error-message:

Phoca Gallery not successfully installed:
DB function failed with error number 1064
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=utf8' at line 13 SQL=CREATE TABLE `jos_phocagallery_votes` ( `id` int(11) NOT NULL auto_increment, `catid` int(11) NOT NULL default 0, `userid` int(11) NOT NULL default 0, `date` datetime NOT NULL default '0000-00-00 00:00:00', `rating` tinyint(1) NOT NULL default '0', `published` tinyint(1) NOT NULL default '0', `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `ordering` int(11) NOT NULL default '0', `params` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM DEFAULT CHARSET=utf8;
DB function failed with error number 1064
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=utf8' at line 14 SQL=CREATE TABLE `jos_phocagallery_comments` ( `id` int(11) NOT NULL auto_increment, `catid` int(11) NOT NULL default 0, `userid` int(11) NOT NULL default 0, `date` datetime NOT NULL default '0000-00-00 00:00:00', `title` varchar(255) NOT NULL default '', `comment` text NOT NULL, `published` tinyint(1) NOT NULL default '0', `checked_out` int(11) unsigned NOT NULL default '0', `checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00', `ordering` int(11) NOT NULL default '0', `params` text NOT NULL, PRIMARY KEY (`id`) ) TYPE=MyISAM DEFAULT CHARSET=utf8;
DB function failed with error number 1064
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=utf8' at line 7 SQL=CREATE TABLE `jos_phocagallery_votes_statistics` ( `id` int(11) NOT NULL auto_increment, `catid` int(11) NOT NULL default 0, `count` tinyint(11) NOT NULL default '0', `average` float(8,6) NOT NULL default '0', PRIMARY KEY (`id`) ) TYPE=MyISAM DEFAULT CHARSET=utf8;
DB function failed with error number 1064
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'DEFAULT CHARSET=utf8' at line 7 SQL=CREATE TABLE `jos_phocagallery_user_category` ( `id` int(11) NOT NULL auto_increment, `catid` int(11) NOT NULL default 0, `userid` int(11) NOT NULL default 0, PRIMARY KEY (`id`), KEY `catid` (`catid`,`userid`) ) TYPE=MyISAM DEFAULT CHARSET=utf8;

[hiaz0r]

Hi,

die Fehlermeldungen kommen weil die Tabellen schon in deiner Datenbank vorhanden sind!

Hast du mal versucht im Categorien Menü oben rechts auf "Status wählen" auf freigegeben oder nicht freigegeben zu gehen?!? Als ich vorhin im Control Panel war, habe ich auch keine Kategorien gesehen, als ich dann auf freigegeben gegangen bin wurde alles angezeigt...

Gruß

Hiaz0r

[Jan]

Hi, the problem is not that the tables were created but the following part in SQL queries:

DEFAULT CHARSET=utf8

Delete this part in SQL queries (in install.bak file) and add the query manually. IF YOU UPGRADE, don't add the first two tables (phocagallery, phocagallery_categories) because in this case, all old data will be lost...

Jan

[Speedsurfer]

Should i delete only "DEFAULT CHARSET=utf8" or the whole line and which query should i add manually?

[Jan]

Only DEFAULT CHARSET=utf8 ...

don't forget to rename the tables in install.bak file:

from:
#__table
to your prefix, e.g. jos_table...

see:
https://www.phoca.cz/documentation/index ... stallation

[Speedsurfer]

i have changed the install.bak with your instruction, but then the installation failed completely.
the only solutions was to "downdate" the gallery to 1.8.8. then it works perfect.

of course i want to use version 2 in future, but i think i have to wait till there's no beta-stadium. perhaps then it is no problem to update.
do you have any idea, when the stable version will come?

thank you for your very good support.

[hiaz0r]

Phoca Gallery 2.0.0 (stable) ist seit gestern released!

http://joomlacode.org/gf/download/frsre ... v2.0.0.zip

Hastest du meinen Ratschlag befolgt?!?

Gruß

Hiaz0r

[Jan]

the upgrade method in 2 is the same as in 1.8.8 ... there can be problem e.g. in case of obsolete database which cannot work with: DEFAULT CHARSET=utf8 ... in this case sql queries must be added manually (but surely there should be not added sql queries of tables which exist in database - phocagallery, phocagallery_categories)