Phoca Forum

After the upgrade to 2.5.8 I cannot save a newly created category. Error message: unable to save...
The structure of the table looks as follows.

Does anyone see the problem?

Thx Walter


id int(11) No
parent_id int(11) No 0
title varchar(255) No
name varchar(255) No
alias varchar(255) No
image varchar(255) No
section varchar(50) No
image_position varchar(30) No
description text No
date datetime No 0000-00-00 00:00:00
published tinyint(1) No 0
checked_out int(11) No 0
checked_out_time datetime No 0000-00-00 00:00:00
editor varchar(50) Yes NULL
ordering int(11) No 0
access tinyint(3) No 0
count int(11) No 0
hits int(11) No 0
accessuserid text Yes NULL
uploaduserid text Yes NULL
deleteuserid text Yes NULL
latitude varchar(20) No
longitude varchar(20) No
zoom int(3) No 0
geotitle varchar(255) No
params text No

I also have this error when I try to save an existing category... seems to be somethin in the DB structure... but what??

Thxs
Walter

Hi, are all the phoca gallery tables in the database (compare with install.bak file)

Jan

Hi, no it is not bug. Installation is made by script not by the file because of upgrade possibility. The install.bak file is here because of manual installation. It means if you have problems with standard installation you can add the sql queries manually.

Joomla! doesn't have any upgrade possibility yet, so the standard install.sql file is not used as this doesn't allow upgrade options.


Jan