Error Installing Demo

GK User
Thu Jan 05, 2012 11:09 am
Hi,

I am using the Joomla 1.7.2 CMS.
I installed the GK Finance Business template and all of the required plugins. I attempted to installed the quickstart (as if it were a template), but I get this error when installing the demo:

JInstaller: :Install: Error SQL DB function failed with error number 1060
Duplicate column name 'ordering' SQL=ALTER TABLE `jos_languages` ADD COLUMN `ordering` int(11) NOT NULL default 0 AFTER `published`;
SQL =
ALTER TABLE `#__languages` ADD COLUMN `ordering` int(11) NOT NULL default 0 AFTER `published`;Files Update: SQL error file DB function failed with error number 1060
Duplicate column name 'ordering' SQL=ALTER TABLE `jos_languages` ADD COLUMN `ordering` int(11) NOT NULL default 0 AFTER `published`;
SQL =
ALTER TABLE `#__languages` ADD COLUMN `ordering` int(11) NOT NULL default 0 AFTER `published`;


I'm not sure if I am doing something incorrectly or if there is something wrong on the server end.
Please advise.

Mike
User avatar
Fresh Boarder

GK User
Thu Jan 05, 2012 12:57 pm
Just few points before i go into more details.
You cannot install GK Quickstart on top of already installed Joomla. To install a quickstart package use a fresh folder and a fresh database. if you don't have an extra database available use a different prefix for your tables. If you have already installed joomla from original joomla.org then you need to install only template file by using Extensions manager in joomla 1.7.

Now if you can tell us how did you try to install then we can see where the problem is.

Errors you are seeing simply telling you that you can't create a second table as there is one already, which is why you see dublicate errors. This would be caused by if you tried to install but installation has failed at some point without finishing and reattempt at installation you will see these errors.
Or
You are trying to install on top of an already installed joomla which has same named mysql tables,
Or
Quickstart package you are using has extra mysql commands which is a repeat therefore causing dublicate error. Which is unlikely considering many have used original packages without such errors.

Easiest would be if you don't have an important data then delete mysql database and delete all files in where you are trying to install then start over again.

To install quickstart do above then extract folders to your servers folder, generally in public_html folder then browse to your www.domainname.com then automatic installation same as joomla installation will start.

Anyway let us know and we take it from there.

See you around...
User avatar
Platinum Boarder


cron