Migration alpha2 - release candidate

[Geraint]

Most database changes between alpha2 and the release candidate are taken care of by the "setup database" call.

The one thing that is missing is the migration of the events category data. You can do this by applying the following 3 SQL queries to your database after running "setup database".

Code: Select all

INSERT INTO jos_jevents_categories (id, color) (SELECT * FROM jos_events_categories ) ;

Code: Select all

update jos_categories set section='com_jevents' where section='com_events';

Code: Select all

ALTER TABLE `jos_jevents_vevdetail` ADD color varchar(20) NOT NULL default '';

If you table prefix is not "jos_" change the query accordingly. You only need run these queries once.

Geraint

[vtjman]

I am getting this error message in PHPMyAdmin:

Error

SQL query: Documentation

INSERT INTO jos_jevents_categories(
SELECT *
FROM jos_events_categories ) ;

MySQL said: Documentation
#1136 - Column count doesn't match value count at row 1


Any ideas?

[Geraint]

Yes - a good point. I added an extra column a week or two ago.

The revised query should be

Code: Select all

INSERT INTO jos_jevents_categories (id, color) (SELECT * FROM jos_events_categories ) ;

GEraint

[Mogwai]

Hi

I am running v1.5.0 alpha2 in both of my Joomla installations and it worked fine from beginning on.
Now I would like to upgrade to version 1.5.1, but making changes in the database is not something common to me. The only thing that I could arrange with a try in one of the local installations was this:
"ALTER TABLE `jos_jevents_vevdetail` ADD color varchar(20) NOT NULL default '';" - and it worked, my categories were there.
Now I have no idea how to get all my events running as I don't know how to add the other two things needed for the migration.
It would be a pity if I have to enter all the events again in both homepages.
For the moment I have uninstalled v1.5.1, installed the alpha2 again and imported the backuped database, so that the local installation is the same as the online installation.

Maybe someone can give me assistance and help me to get through the upgrade process.
Thank you very much in advance.

Good night
Mogwai

[shmryan]

I have a similar problem as Mogwai has. I am running the 1.5.0 Beta version and need to upgrade to the Stable version, but have no idea when it comes to sql or phpadmin. can someone put it in "dummy" terms for me to understand. I don't want to lose any of my categories or saved events if I don't have to. thanks!

[jerryboone]

i have no idea with phpadmin.. need help! thanks!

[TopCop]

Hi Schwimmbrille!

Do you have phpadmin installed or acces to it through your host?
If so it is easy to do.
Are you German as your nick indicates?


TopCop

[Mogwai]

My problem is also still not solved.
No, I have no access to phpadmin.
I am also talking German (Austria).

Still need help for updating to the actual version.
Thanks

[petersavoy]

I have the same problem: no access to phpadmin.

Thanks million!