TOPIC: Updating to 2.2

Hello,

Please advise, just tried to install 2.2 on 2.1.1 and got this:

Hi Mika,

which PHP, Database and Joomla Version are you using? The table name (#__matukio_settings) seems to be missing.

Yves

Hello Yves,

PHP 5.3.24
MySQL 5.1.68-cll
Joomla 3.1.1

How to proceed?

Thanks,
Miika

Hmm testing on a similar system, no idea why this is failing. I only have one idea:

script.php (in the zip file)

Change line 121:

$query = 'SELECT * FROM ' . $db->nameQuote('#__matukio_settings') . ' WHERE title = ' . $db->Quote('db_version');

to

$query = 'SELECT * FROM ' . $db->quoteName('#__matukio_settings') . ' WHERE title = ' . $db->Quote('db_version');


Yves

Ok, helped for that but another issue came up:

Hmm the SQL seems valid, could you perhaps take a look at the #__matukio_settings table and look for the event_stopshowing row? Is it missing?

Yves

Looks like it is there but missing the last part 3=NEVER



Then I added that and now it works. Thanks for the tips.

Btw, have you noticed that Display Login-form is twice in the settings..?



Edit: Will the language files be in Transifex soon?

Hmm funny no i haven't funny, will be fixed in the next version.

Yves

Hi again.. Test booking resulted an error:

SQL=SELECT * FROM wtvlz_matukio_templates WHERE tmpl_name = 'mail_booking'

However the booking was registered, but no email was sent. When trying to cancel the booking (by user), this came up:

SQL=SELECT * FROM wtvlz_matukio_templates WHERE tmpl_name = 'mail_booking_canceled'

Then, tried to cancel the booking from participiant list (from My Offers). That made this:

SQL=SELECT * FROM wtvlz_matukio_templates WHERE tmpl_name = 'mail_booking_canceled_admin'

Did not get emails in any stage from the system.

Hi Miika,

hmm strange, going to recheck seems to be a problem with the SQL Queries, but for me this is working without problems in Joomla 3.1 :/

Yves

Hi,

In addition to the perivous, editing an old event (one that was made before the update) results SQL errors too.

Does this mean that updating on old installation don't work?

Sounds like the database has not been updated correctly. Do the tables #__matukio_organizers and #__matukio_templates exist?

Yves

Nope. Those are missing.

Cheers,
Miika

Then the database has failed - try the following:

- Change db_version from 2.2 to 2.1.10 in #__matukio_settings
- Redownload the Matukio 2.2 archive (it has changed slightly)
- Install it again

Yves

Hi,

Now it seems to be working so far. Had to remove the previously added {3=NEVER} in order to get the installation end successfully.

Thanks for the help & quick fixes!

Cheers,
Miika