after upgrade phoca gallery 2.2.3 @ 2.6.1 same problems

[dd_77]

Hi all,
after upgrade Phoca Gallery to 2.6.1 i have same problems.
I has 3 galleries with 200 images but new version of phoca gallery not loaded them and i can't make new category bcause it get me one error:

Error Saving Phoca Gallery Categories

if i try use "multiple add" can i see the images of galleries missied then i select all for one category and i try saved but it generated on error:

500 - Si è verificato un errore

There are all images on server but i can't displayed in phoca gallery and i dont' make new gallery.. if i try "recreate" i have this error:



help me

[Jan]

Hi, yes, you cannot recreate images if you don't have select them.

Check your database (e.g. with phpMyAdmin) to see if all tables and columns are listed there. Compare it with install.bak file, see:
https://www.phoca.cz/documents/2-phoca-g ... em-solving

Jan

[dd_77]

good, i have create 4 tables in phpMyAdmin with install.sql but now i do this in quote?

If you have all tables in your database (e.g. you are upgrading from 2.1.0 to 2.2.0) check the columns of your tables. E.g. in Phoca Gallery version 2.2.0 there are new colums: extlink1, extlink2 and these should be added into table: #__phocagallery. In case you are upgrading e.g. from 2.1.0 to 2.2.0 and you got some error message while automatically upgrading of Phoca Gallery tables, check the #_phocagallery table and if extlink1 or extlink2 columns are missed, then run the SQL query for 2.2.0 version:

ALTER TABLE `#__phocagallery` ADD `extlink1` text NOT NULL AFTER `params` ;
ALTER TABLE `#__phocagallery` ADD `extlink2` text NOT NULL AFTER `extlink1` ;

If your are upgrading to 2.2.2 run also the SQL query for the 2.2.2 version:

ALTER TABLE `#__phocagallery_categories` ADD `date` datetime NOT NULL default '0000-00-00 00:00:00' AFTER `description` ;

i have update phoca gallery from 2.2.3 then i create sql with:

Code: Select all

-- 2.2.2

-- ALTER TABLE `jos_phocagallery_categories` ADD `date` datetime NOT NULL default '0000-00-00 00:00:00' AFTER `description` ;



-- 2.5.0

-- ALTER TABLE `jos_phocagallery_categories` ADD `geotitle` varchar(255) NOT NULL default '' AFTER `hits` ;

-- ALTER TABLE `jos_phocagallery_categories` ADD `zoom` int(3) NOT NULL default '0' AFTER `hits` ;

-- ALTER TABLE `jos_phocagallery_categories` ADD `longitude` varchar(20) NOT NULL default '' AFTER `hits` ;

-- ALTER TABLE `jos_phocagallery_categories` ADD `latitude` varchar(20) NOT NULL default '' AFTER `hits` ;

-- ALTER TABLE `jos_phocagallery_categories` ADD `deleteuserid` text AFTER `hits` ;

-- ALTER TABLE `jos_phocagallery_categories` ADD `uploaduserid` text AFTER `hits` ;

-- ALTER TABLE `jos_phocagallery_categories` ADD `accessuserid` text AFTER `hits` ;

-- ALTER TABLE `jos_phocagallery` ADD `geotitle` varchar(255) NOT NULL default '' AFTER `hits` ;

-- ALTER TABLE `jos_phocagallery` ADD `zoom` int(3) NOT NULL default '0' AFTER `hits` ;

-- ALTER TABLE `jos_phocagallery` ADD `longitude` varchar(20) NOT NULL default '' AFTER `hits` ;

-- ALTER TABLE `jos_phocagallery` ADD `latitude` varchar(20) NOT NULL default '' AFTER `hits` ;

-- ALTER TABLE `jos_phocagallery` ADD `videocode` text AFTER `hits` ;

-- ALTER TABLE `jos_phocagallery` ADD `vmproductid` text AFTER `hits` ;



-- 2.6.0

-- ALTER TABLE `jos_phocagallery` ADD `imgorigsize` int(11) NOT NULL default '0' AFTER `hits` ;

-- ALTER TABLE `jos_phocagallery_categories` ADD `owner_id` int(11) NOT NULL default '0' AFTER `parent_id` ;

-- ALTER TABLE `jos_phocagallery` `extid` varchar(255) NOT NULL default '' AFTER `hits` ;

-- ALTER TABLE `jos_phocagallery` `extl` varchar(255) NOT NULL default '' AFTER `hits` ;

-- ALTER TABLE `jos_phocagallery` `extm` varchar(255) NOT NULL default '' AFTER `hits` ;

-- ALTER TABLE `jos_phocagallery` `exts` varchar(255) NOT NULL default '' AFTER `hits` ;

-- ALTER TABLE `jos_phocagallery` `exto` varchar(255) NOT NULL default '' AFTER `hits` ;

-- ALTER TABLE `jos_phocagallery` `extw` varchar(255) NOT NULL default '' AFTER `hits` ;

-- ALTER TABLE `jos_phocagallery` `exth` varchar(255) NOT NULL default '' AFTER `hits` ;

  

-- ALTER TABLE `jos_phocagallery_categories` ADD `extid` varchar(255) NOT NULL default '' AFTER `hits` ;

-- ALTER TABLE `jos_phocagallery_categories` ADD `exta` varchar(255) NOT NULL default '' AFTER `hits` ;

-- ALTER TABLE `jos_phocagallery_categories` ADD `extu` varchar(255) NOT NULL default '' AFTER `hits` ;

is it correct?

[dd_77]

i try run the sql with alter table but i have one errore:

Errore

query SQL:

ALTER TABLE `jos_phocagallery` `extid` varchar( 255 ) NOT NULL default '' AFTER `hits` ;

Messaggio di MySQL: Documentazione
#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 '`extid` varchar(255) NOT NULL default '' AFTER `hits`' at line 1

my sql is:

Code: Select all

ALTER TABLE `jos_phocagallery_categories` ADD `geotitle` varchar(255) NOT NULL default '' AFTER `hits` ;

 ALTER TABLE `jos_phocagallery_categories` ADD `zoom` int(3) NOT NULL default '0' AFTER `hits` ;

 ALTER TABLE `jos_phocagallery_categories` ADD `longitude` varchar(20) NOT NULL default '' AFTER `hits` ;

 ALTER TABLE `jos_phocagallery_categories` ADD `latitude` varchar(20) NOT NULL default '' AFTER `hits` ;

 ALTER TABLE `jos_phocagallery_categories` ADD `deleteuserid` text AFTER `hits` ;

 ALTER TABLE `jos_phocagallery_categories` ADD `uploaduserid` text AFTER `hits` ;

 ALTER TABLE `jos_phocagallery_categories` ADD `accessuserid` text AFTER `hits` ;

 ALTER TABLE `jos_phocagallery` ADD `geotitle` varchar(255) NOT NULL default '' AFTER `hits` ;

 ALTER TABLE `jos_phocagallery` ADD `zoom` int(3) NOT NULL default '0' AFTER `hits` ;

 ALTER TABLE `jos_phocagallery` ADD `longitude` varchar(20) NOT NULL default '' AFTER `hits` ;

 ALTER TABLE `jos_phocagallery` ADD `latitude` varchar(20) NOT NULL default '' AFTER `hits` ;

 ALTER TABLE `jos_phocagallery` ADD `videocode` text AFTER `hits` ;

 ALTER TABLE `jos_phocagallery` ADD `vmproductid` text AFTER `hits` ;





 ALTER TABLE `jos_phocagallery` ADD `imgorigsize` int(11) NOT NULL default '0' AFTER `hits` ;

 ALTER TABLE `jos_phocagallery_categories` ADD `owner_id` int(11) NOT NULL default '0' AFTER `parent_id` ;

 ALTER TABLE `jos_phocagallery` `extid` varchar(255) NOT NULL default '' AFTER `hits` ;

 ALTER TABLE `jos_phocagallery` `extl` varchar(255) NOT NULL default '' AFTER `hits` ;

 ALTER TABLE `jos_phocagallery` `extm` varchar(255) NOT NULL default '' AFTER `hits` ;

 ALTER TABLE `jos_phocagallery` `exts` varchar(255) NOT NULL default '' AFTER `hits` ;

 ALTER TABLE `jos_phocagallery` `exto` varchar(255) NOT NULL default '' AFTER `hits` ;

 ALTER TABLE `jos_phocagallery` `extw` varchar(255) NOT NULL default '' AFTER `hits` ;

 ALTER TABLE `jos_phocagallery` `exth` varchar(255) NOT NULL default '' AFTER `hits` ;

  

 ALTER TABLE `jos_phocagallery_categories` ADD `extid` varchar(255) NOT NULL default '' AFTER `hits` ;

 ALTER TABLE `jos_phocagallery_categories` ADD `exta` varchar(255) NOT NULL default '' AFTER `hits` ;

 ALTER TABLE `jos_phocagallery_categories` ADD `extu` varchar(255) NOT NULL default '' AFTER `hits` ;

help me

[dd_77]

now i have changed the last sql code and i put the command "ADD" betwean table name and coloumn name. this is change the sql script completade sucessfully but i have still some problems on phoca gallery as:

1) i see all image in "image management" but i can't cerate new category and i can't load new image

2) i can't also autorize for pubblication already loaded images


can you help me?

[dd_77]

up

[dd_77]

solved!!

i haveexecuted the installer and choice "upgeade"

[Jan]

Ok