Joomla Templates Club 406,261 posts

[desosturcan Friend desosturcanJoin date: July 2011Posts: 4Downloads:0Uploads:0 Thanks: 3]

#168091

Hello,

In the powweb service, the principal websiste is http://www.desosturcan.com in the folder /htdocs with the joomlart template Business joomla 1.6 and the web http://www.biospherest.com is the second one, that point to /htdocs/biospherest/, where is the joomlarte template Travel joomla 1.7.
Now my problem is with the joomla 1.7, travel template and http://www.biospherest.com

I was trying to activate the languagefilter in the joomla, and there are some difficulties.
First of all, I installed the spanish Site and Administrator language, and had no problem.
Then I created a new Content language, so now I have English and Spanish

Then I went to the plug-ins and activated the System – Language Filter, but then the website front-end had this message:
“Warning: Invalid argument supplied for foreach() in /hermes/web03/b1574/pow.desosturcancom/htdocs/biospherst/libraries/joomla/language/helper:php on line 86” and reload all the time

After that I searched in google and I found this:
http://forum.joomla.org/viewtopic.php?p=2560862
http://docs.joomla.jp/Upgrade_1.6.5_to_1.7
http://forum.joomla.org/viewtopic.php?f=622&t=637606

So I tried to solve this on my own:
1. I used “If you didn’t get the prefix before starting, open your site’s configuration.php and search for $dbprefix”, and saw that my prefix is “cgimz”
2. Then I went to /htdocs/biospherest/administrator/components/com_admin/sql/updates/mysql and changed:

1.7.0-2011-06-06-2.sql to

ALTER TABLE `cgimz__languages` ADD COLUMN `ordering` int(11) NOT NULL default 0 AFTER `published`;
ALTER TABLE `cgimz__languages` ADD INDEX `idx_ordering` (`ordering`);

and 1.7.0-2011-06-06.sql to

CREATE TABLE IF NOT EXISTS `cgimz__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;

Also I went to /htdocs/biospherest/libraries/joomla/language/helper.php and changed the $query->from(‘#__extensions’); to $query->from(‘cgimz__extensions’);

After all this, it didn’t work.

Anyway, I don’t understand this “Once you’ve done this go to your site’s phpmyadmin (or any way you usually manage your database) and open the database your site uses. There will be a tab called SQL, open this. Paste the content of your modified joomla_update_17ga.sql inside the text area and press go. “, so maybe I can’t finally solve it.

I hope you can help me to solve this problem.
Thank you very much and best regards,

[desosturcan Friend desosturcanJoin date: July 2011Posts: 4Downloads:0Uploads:0 Thanks: 3]

#410210

Hello again,

As one staff member told me, I did most of the things they told me, but I don’t know how to do the last thing “Then you log in to phpMyAdmin, and go to Joomla’s database.
There is a tab called SQL , click it. Paste the content and pressed go.”
Whis contect do I have to paste? I see many tabs called SQL in the phpMyAdmin

On the other hand, the files now are as follow:

/htdocs/biospherest/administrator/components/com_admin/sql/updates/mysql/1.7.0-2011-06-06-2.sql

ALTER TABLE `jos_languages` ADD COLUMN `ordering` int(11) NOT NULL default 0 AFTER `published`;
ALTER TABLE `jos_languages` ADD INDEX `idx_ordering` (`ordering`);

/htdocs/biospherest/administrator/components/com_admin/sql/updates/mysql/1.7.0-2011-06-06.sql

CREATE TABLE IF NOT EXISTS `jos_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;

And, as I saw in http://forum.joomla.org/viewtopic.php?p=2560862, I also changed /htdocs/biospherest/libraries/joomla/language/helper.php in the suspicious line,
$query->from(‘#__extensions’);
so I changed from “#__extensions” to “jos_extensions”, but still it doesn’t work.

On the other hand, as I saw in http://forum.joomla.org/viewtopic.php?p=2560862, if a search for the /htdocs/biospherest/configuration.php there is this wrote:

public $db = ‘biospherest’;
public $dbprefix = ‘cgimz_’;
public $live_site = ”;

Isn’t it my prefix cgimz_ and not jos_ ?

Thank you very much for your time and best regards,

[Blaine Friend BlaineJoin date: August 2007Posts: 1443Downloads:0Uploads:25 Thanks: 98 Thanked: 177 times in 154 posts]

#410964

As far as your site’s phpmyadmin, you need to familiarize your self with the way your host operates on this. See if this helps you.
They will help you if you need help.
To better understand SQL and how it works, please read this
I have also replied to your ticket.

1 user says Thank You to Blaine for this useful post

1. desosturcan

[Author]

Posts