Upgrade Joomla 1.5.23 with Phoca Gallery 2.8.0

[dnappa]

Greetings,

However, one of your code lines that I changed from jos_ to j17_ returned the following error:

SQL query:

ALTER TABLE `j17_phocagallery` ADD COLUMN `metadata` TEXT NULL AFTER `metadesc` ,
ADD COLUMN `exttype` TINYINT( 1 ) NOT NULL DEFAULT `0` AFTER `extid` ,
ADD COLUMN `language` CHAR( 7 ) NOT NULL DEFAULT `*` AFTER `exth` ;

MySQL said: Documentation
#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 '`0` AFTER `extid`, ADD COLUMN `language` CHAR(7) NOT NULL DEFAULT `*` AFTER `ex' at line 1

I know just enough about MySQL to make me very dangerous so I haven't a clue what is wrong. Perhaps you can shed some light on it. I'm running MySQL version 5.1.56.

Thanks,

--Allen

Hi Allen,
my MySQL version is different but i think that this isn't the problem, if you try to launch this quesry alone without other query you receive the same error?
it is strange that your error is truncated and don't report the correct column name.

Code: Select all

 NULL DEFAULT `*` AFTER `ex' at

Regards
DN

[Jan]

Hi,

Joomla! 1.5 and Joomla! 1.6 (1.7) are completely different systems inside. The same Phoca Gallery 2.x and Phoca Gallery 3.x are completely different system.

The upgrade function works only in both different system (Joomla!) separatelly.

You can upgrade versions between versions 2x in Joomla! 1.5 and between versions 3.x in Joomla! 1.7 (Joomla! 1.6) ... So e.g. you cannot install Phoca Gallery 2 on Joomla! 1.7, then it means, you cannot upgrade from 2 to 3 in Joomla! 1.7

Jan

[Yxos]

Hi,

Joomla! 1.5 and Joomla! 1.6 (1.7) are completely different systems inside. The same Phoca Gallery 2.x and Phoca Gallery 3.x are completely different system.

Understood!
So, it appears I am right. Having a huge gallary in 1.5 (with PG 2.8.0) means that if I want to upgrade to 1.6 or 1.7, then I have no alternative but to start from scratch with a new gallery.

Jan, it appears that other people in this thread successfuly have run some SQL to alter the database, and thereby achiving what I want to: Having my existing gallery running in the new 1.7 environment.
Why isn't it then possible to provide an upgrade funktion that converts a version 2 gallery to a version 3?
If you say, its not possible due to the big difference in versions, why can these people then do it?

...trying hard to understand the issue in this...

[Jan]

Why isn't it then possible to provide an upgrade funktion that converts a version 2 gallery to a version 3?
If you say, its not possible due to the big difference in versions, why can these people then do it?

Hi, there is a difference between upgrade and migration

Upgrade function is used to upgrade between different versions in one system (Joomla! 1.7 or Joomla! 1.5 - upgrade a gallery e.g. from 3.0.0 to 3.0.1 in Joomla! 1.7)

Migration function is used to migrate from one system to other (from Phoca Gallery run in Joomla! 1.5 to Phoca Gallery run in Joomla! 1.7 (or 1.8 in the future)

It is very time demanding to write both - upgrade and migration scripts but writing migrations script is e.g. 50x more difficult than writing upgrade script.

So for now there is only one reason why there is no migration script - nobody has written it yet ... for me (because of many reasons - overloading, many questions in the forum, many different Joomla! systems - J!1.5, J!1.6, J!1.7, speed of Joomla! development, etc. etc. it is very difficult to find time to write it as many important task (maybe hundreds, maybe thousands) must be solved first

https://www.phoca.cz/phoca-needs-your-help/

Jan

[Yxos]

Jan, thanks for a straight answer! I don't like your answer, but it was honest, and I can get on from here in one of two ways (not being able to write a migration script myself:

MIgrate from 1.5 to 1.7 and then:
1. start my gallery from scratch.
2. try a few of the scripts mentioned ealier in this thread. Nothing worse can happen than it doesn't work.

Still hoping that you will find the time to write a migration script... Thanks anyway!

[Jan]

Ok, I don't like this issue too, of course I would lik to write the migration script, but it is really hard with time if you are developing so much free extensions

[Yxos]

That would be very much appreciated I think.
Your gallery is excellent, which is of course the reason why a lot of people use it.
If you don't provide a migration script, thereby forcing people who migrate from 1.5 to .17 to start their gallery from scratch, they might as well go looking for another gallery.

So much for appealing to your better self...
I promise to press your donate-button and transfer 10$ to you for a working migration script because I like your gallery and if this is what it takes, then the money is well spent! (not to mention that a script will save me hours of work, of course)
Maybe other people will be inspired to do the same.

[pjdevries]

Although I'm only running one Phoca Gallery site, I'm definitely willing to chip in. Jan, how much do you need to make that migration script happen?

[Jan]

Hi, for now the only one I need is a time which I don't have (e.g. only answering posts in forum takes the whole evening after my regular work , etc )

Jan

[Yxos]

"Time" is not a valid currency on PayPal, unfortunately. You will have to accept our humble and miserable dollars, I'm afraid