Page 1 of 1
after upgrade phoca gallery 2.2.3 @ 2.6.1 same problems
Posted: 13 Dec 2009, 18:49
by 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
Re: after upgrade phoca gallery 2.2.3 @ 2.6.1 same problems
Posted: 13 Dec 2009, 19:59
by 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
Re: after upgrade phoca gallery 2.2.3 @ 2.6.1 same problems
Posted: 13 Dec 2009, 22:27
by 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?
Re: after upgrade phoca gallery 2.2.3 @ 2.6.1 same problems
Posted: 14 Dec 2009, 00:06
by 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
Re: after upgrade phoca gallery 2.2.3 @ 2.6.1 same problems
Posted: 14 Dec 2009, 13:28
by 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?
Re: after upgrade phoca gallery 2.2.3 @ 2.6.1 same problems
Posted: 15 Dec 2009, 00:42
by dd_77
Re: after upgrade phoca gallery 2.2.3 @ 2.6.1 same problems
Posted: 16 Dec 2009, 09:11
by dd_77
solved!!
i haveexecuted the installer and choice "upgeade"
Re: after upgrade phoca gallery 2.2.3 @ 2.6.1 same problems
Posted: 16 Dec 2009, 22:14
by Jan
Ok
