The Joomla! Forum ™

Please help me, two weeks ago I update (with update button) a joomla 1.7 to 1.7.1 and some issues happend, front end buttons save and cancel stop to respond, and IE tell that I have jquery issue. And today I try to update again to joomla 1.7.2 (from 1.7.1) and I have error again (I think it is the same error), I thought that maybe new 1.7.2 update fix the thing. Here is joomla error after updating:


Can anybody help me with this issue... I didn't backup site before updating and now I have a BIG problem .
Thanks in advance

Your database tables already have the column "ordering" and it therefore cannot be added.
Can be a leftover from an earlier attempt to upgrade.

Do the manual update and skip the database change step.

http://docs.joomla.org/Upgrade_1.6.5_to_1.7#Manual_Upload.2FInstallation

Hi, Thank you very much for your post.
So, this link is for manual update, but it is a tutorial for 1.6.5 to 1.7 upgrade. And I didn't mentioned that now I am running 1.7.2, it showed me an error when I was updating but it moved to newer version, but with errors, front end editing buttons don't work, that is my main issue after that updating... I tried to manually copy the update files, and IE still shows me "jquery undefined" ... So, what are your suggestion ?

Try another browser like Opera or Firefox.

jquery is a Javascript library. Either it's not loaded or a module or component loads the wrong version.

What template do you use? Try to switch to one of the core template to check if it's template related.

I tried Chrome, FF, IE, Opera ... Same thing... Template is Artisteer 3.0, but I tried beez too, and nothing...

I had the same issue, when using the "quickstart template installation package" from Joomlart.

Although I received that error, the upgrade did actually take place, and upon changing the screen to another one the latest version of Joomla was showing.

So, we will see what happens on the next upgrade! As it was a "quickstart" pack with all of the demo SQL in it, something has affected the Joomla update mechanism, although there are no duplicated tables showing in the DB.

_________________
http://www.projectamplify.com

Is there any way to take back to joomla 1.7.0 ? ... And then update manually again. Maybe that can fix the things ...

Have you checked your database for duplicate table names, also, do you have multiple tables in the DB with different prefixes (perhaps from trying multiple installs on the same database?)

I suggest in the future using Akeeba backup on your website, so you can take backups before upgrading/including extensions, allowing you to roll-back to earlier version if you have issues.

_________________
http://www.projectamplify.com

Hi airbag, Thank you for your post.

I really don't know much about databases, but I intend to learn (now I must )
I use Akeeba backup, but I have older backups, I forget to backup before I update (big mistake). I made a backup before I made multilngual site (3 languages), and all that was in one day... And if I don't solve "that" issue, I must do it again... ufff... Thank you anyway

Joomla update does work out of the box ok, so it could be your template, or duplicate db tables which are probabaly causing the issue, but who knows weather some other extensions or their tables caused it for you also.

I hope it does not happen again for you, all the best

_________________
http://www.projectamplify.com

Those errors are because of sql files found in
Joomla_1.7.1_to_1.7.2-Stable-Patch_Package\administrator\components\com_admin\sql\updates\mysql

1.7.0-2011-06-06.sql this one does not create that error:
CREATE TABLE IF NOT EXISTS `#__associations` (
`id` VARCHAR(50) NOT NULL COMMENT 'A reference to the associated item.',
`context` VARCHAR(50) NOT NULL COMMENT 'The context of the associated item.',
`key` CHAR(32) NOT NULL COMMENT 'The key for the association computed from an md5 on associated ids.',
PRIMARY KEY `idx_context_id` (`context`, `id`),
INDEX `idx_key` (`key`)
) DEFAULT CHARSET=utf8;

1.7.0-2011-06-06-2.sql:this one DOES create error
ALTER TABLE `#__languages` ADD COLUMN `ordering` int(11) NOT NULL default 0 AFTER `published`;
ALTER TABLE `#__languages` ADD INDEX `idx_ordering` (`ordering`);

both should install but if you already have table 'associations' with 'id', 'context' and 'key' fields with primary index set at 'context' and 'id' and another index on 'key' you should be fine.

second one should change table 'languages' and add field 'ordering', int(11) after field 'published' and add index on 'ordering'.

so if you have all those in your DB you can remove those 2 sql files from zip and go with install. If not remove second one because it looks like you have those tables, fields and indexes.

Hi _X_ , thank you very much for your post.

I really don't know much about DB, but I looked at php myadmin, and I think that everything is ok, like in your post. I tried to delete those second sql, after that both sql from update, like you said, and I got same error:

I'm missing something, but I don't know what. I'll put here a prtscrn of jos_languages table, so you can see, and help me if you can Thank you in advance

http://img546.imageshack.us/img546/8306 ... stable.jpg

best regards,
Vladimir

As far as I can see there are no problems. You should just overwrite all existing joomla files with those from upgrade zip/gz archive and you are good to go. If you have any problems related to DB you know that those can come only from jos_languages table.

I have 6 languages set in my website and I updated from J1.7.3 to J2.5.0. I got DB error and deleted 1.7.0-2011-06-06-2.sql file.
After that DB error is gone but my web site only shows languages flag icons.

If I turn off Language switch, my site shows up without language flag icon.

Is it something that the language translation are not up to J2.5?

_________________
Norito H.Yoshida, Yokohama, Japan
norito@gmail.com
http://kaigai.goyat.info/
goyat.jp

I was getting the same error when doing the one click update:

http://imageshack.us/photo/my-images/545/errorce.png/
But even though error occurred during update, there were some changes. There was a new link "Database" showing up that was not in 1.7.3. And at the bottom, the footer area, the Joomla version number disappeared. It was not showing 1.7.3 nor 2.5.1.

At the same time, the "Quick Icons" on admin home were showing old 1.7.3 icons... with the "Joomla is up-to-date" icon missing.

==========================================

Doing these did not fix the issues:

* Deleting sql files in: administrator/components/com_admin/sql/updates/mysql and trying the whole update thing again with clean Akeeba backup restore.

* Deleting joomla.xml from site's root and re-doing the whole process.

* Fixing the database from new "Database" link returned that database issues were fixed, but the site was still not showing version number at footer (in admin area), and also, the "Quick Icons" were still old 1.7.3.

Look at this in "Database":

http://imageshack.us/photo/my-images/163/error2j.png/

It says "Database schema version (in #__schemas): 1.6.0-2011-01-10"

That means it is I who did some upgrade before that was not done properly, and the database schema was not altered. Somehow it did not generate any error when I upgraded to 1.7.3 from and earlier version. But now, going to 2.5.1, the problem came to surface.

And these are all the errors:

http://imageshack.us/photo/my-images/209/error3.png/

All these will be fixed when I run the sql files from: administrator/components/com_admin/sql/updates/mysql

==========================================

Doing these fixed the issue, and site was updated successfully using one click update:

* Did a fresh 1.7.3 install

* Downloaded all the sql to local machine, from here: administrator/components/com_admin/sql/updates/mysql

http://imageshack.us/photo/my-images/338/sqlfiles.png/

* Restored my site's backup using Akeeba

* Using phpMyAdmin, opened my site's database, and started running the sql scripts one-by-one starting with the 1.7.0-2011-06-06-2.sql, which had these queries inside for example:



So ran all the sql scripts one by one that were downloaded from: administrator/components/com_admin/sql/updates/mysql

* Then, look at this:

http://imageshack.us/photo/my-images/252/700p.png/

This is what the 'schemas' table contained in my fresh 1.7.3 install. But after restoring my site's Akeeba 1.7.3 backup, this table was empty.

* So next I ran this:


* Then I went to one click update and tried the update, and it was done without any errors:

http://imageshack.us/photo/my-images/812/successful.png/

_________________
Hope is against odds.