?
avatar cspratt
cspratt
4 Feb 2012

I just upgraded my 1.7.3 site to 2.5.1 and noticed that Smart Search was missing from the Components menu. After some investigation I realized the plugin needed to be enabled in order for the component to show. I followed the following documentation to do so:

http://docs.joomla.org/index.php?title=Smart_Search_quickstart_guide&oldid=64505

Unfortunately, all the Smart Search plugins seem to be gone or were never installed upon upgrade. This may be due to the way I upgraded Joomla. I used the old method of extracting the Joomla update file, FTPing all the files and overwriting the old, I then logged into Joomla Admin and went to Extension Manager / Database / and clicked Fix. This seems to have worked in every regard, except Finder is not functioning (though I see it was installed via FTP under /components and /administrator/components.

If I type the following I can see com_finder from my Joomla 2.5.1 Admin Panel:

/administrator/index.php?option=com_finder

Unfortunately, it is showing the following error on the page:

Error loading component: com_finder, 1
Error loading component: com_finder, 1

So I am at a loss on how to get the plugins? Is there a download package?

Also, let me explain why I had to upgrade Joomla the old fashioned way. For some reason when I went to Extension Manager / Update and attempted to upgrade to 2.5.1 it gave me the following error over and over again:

JInstaller: :Install: Error SQL DB function failed with error number 1060
Duplicate column name 'sitename' SQL=ALTER TABLE jos_languages ADD COLUMN sitename varchar(1024) NOT NULL AFTER metadesc;
SQL = ALTER TABLE #__languages ADD COLUMN sitename varchar(1024) NOT NULL AFTER metadesc;
Files Update: SQL error file DB function failed with error number 1060
Duplicate column name 'sitename' SQL=ALTER TABLE jos_languages ADD COLUMN sitename varchar(1024) NOT NULL AFTER metadesc;
SQL = ALTER TABLE #__languages ADD COLUMN sitename varchar(1024) NOT NULL AFTER metadesc;

avatar cspratt cspratt - open - 4 Feb 2012
avatar mbabker
mbabker - comment - 4 Feb 2012

Try going to the Extension Manager's Discover view and click the Discover button to see if there are any extensions not installed.

avatar mbabker
mbabker - comment - 4 Feb 2012

Also, go to the Extension Manager's Database view and click Fix to update your database to the current schema.

avatar cspratt
cspratt - comment - 4 Feb 2012

You're a life saver. Discover fixed the issue. The strange thing is, I tried discover, but only 2 extensions came up originally. I clicked it again and all the Smart Search stuff displayed.

The only problem now is a problem that we touched on in the Finder-Integration GitHub Repository. When I click on Index under Smart Search it gives me the following error again (which actually had been fixed):

undefined

undefined
null

avatar cspratt
cspratt - comment - 4 Feb 2012

Ah I remembered this was due to certain plugins not playing nicely. I will try disabling all non-mandatory plugins.

avatar dextercowley
dextercowley - comment - 4 Feb 2012

Did you follow the update instructions here? (
http://docs.joomla.org/Upgrading_from_an_existing_version#Manually_Copy_New_Program_Files).
This includes using the Database check tab and the Discover->Install tab.
Mark

On Sat, Feb 4, 2012 at 9:57 AM, Christopher Pratt <
reply@reply.github.com

wrote:

I just upgraded my 1.7.3 site to 2.5.1 and noticed that Smart Search was
missing from the Components menu. After some investigation I realized the
plugin needed to be enabled in order for the component to show. I followed
the following documentation to do so:

http://docs.joomla.org/index.php?title=Smart_Search_quickstart_guide&oldid=64505

Unfortunately, all the Smart Search plugins seem to be gone or were never
installed upon upgrade. This may be due to the way I upgraded Joomla. I
used the old method of extracting the Joomla update file, FTPing all the
files and overwriting the old, I then logged into Joomla Admin and went to
Extension Manager / Database / and clicked Fix. This seems to have worked
in every regard, except Finder is not functioning (though I see it was
installed via FTP under /components and /administrator/components.

If I type the following I can see com_finder from my Joomla 2.5.1 Admin
Panel:

/administrator/index.php?option=com_finder

Unfortunately, it is showing the following error on the page:

Error loading component: com_finder, 1
Error loading component: com_finder, 1

So I am at a loss on how to get the plugins? Is there a download package?

Also, let me explain why I had to upgrade Joomla the old fashioned way.
For some reason when I went to Extension Manager / Update and attempted to
upgrade to 2.5.1 it gave me the following error over and over again:

JInstaller: :Install: Error SQL DB function failed with error number 1060
Duplicate column name 'ordering' SQL=ALTER TABLE test_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 test_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;


Reply to this email directly or view it on GitHub:
#118

avatar cspratt
cspratt - comment - 4 Feb 2012

Hey Dexter. I did follow those instructions, but on my first attempt clicking Discover it only brought back 2 items that were unrelated to Finder/Smart Search. After the advice above I went back and clicked it again, it did the same thing... so I clicked it a second time. BOOM! All kinds of stuff showed up. I do not keep Browser Cache or Internet History, so I know that wasn't an issue. Thank you for the help though Dexter!

On another note. I have a #_content table of just about 3G. 30k Articles and 4k Categories. In earlier versions of Finder before it was integrated into the latest release of Joomla 2.5 Stable I had the same problem I'm having now. It hangs. I think this is due to having specific articles that are in pagebreak standards are almost 400 pages long. I have been building an online library using Joomla (which in retrospect may have been a bad idea, due to Joomla not really having the opportunity to deal with EXTREMELY large content based sites, and also that it uses MySQL which can be a huge bottleneck with large sites) and I have been letting the GUI Indexer run for about 50 minutes now and it is hung up on 10% which was what happened earlier on in development when I tried this. I have used the CLI as well and let it run for 3 days and it never finished, and eventually shot up an error which ultimately nullified all the prior index.

Any thoughts?

avatar dextercowley
dextercowley - comment - 4 Feb 2012

I think you'll have better luck with this question if you raise it on the
Bug Squad google group (http://groups.google.com/group/joomlabugsquad).
Good luck. Mark

On Sat, Feb 4, 2012 at 11:38 AM, Christopher Pratt <
reply@reply.github.com

wrote:

Hey Dexter. I did follow those instructions, but on my first attempt
clicking Discover it only brought back 2 items that were unrelated to
Finder/Smart Search. After the advice above I went back and clicked it
again, it did the same thing... so I clicked it a second time. BOOM! All
kinds of stuff showed up. I do not keep Browser Cache or Internet History,
so I know that wasn't an issue. Thank you for the help though Dexter!

On another note. I have a #_content table of just about 3G. 30k Articles
and 4k Categories. In earlier versions of Finder before it was integrated
into the latest release of Joomla 2.5 Stable I had the same problem I'm
having now. It hangs. I think this is due to having specific articles that
are in pagebreak standards are almost 400 pages long. I have been building
an online library using Joomla (which in retrospect may have been a bad
idea, due to Joomla not really having the opportunity to deal with
EXTREMELY large content based sites, and also that it uses MySQL which can
be a huge bottleneck with large sites) and I have been letting the GUI
Indexer run for about 50 minutes now and it is hung up on 10% which was
what happened earlier on in development when I tried this. I have used the
CLI as well and let it run for 3 days and it never finished, and eventually
shot up an error which ultimately nullified all the prior index.

Any thoughts?


Reply to this email directly or view it on GitHub:
#118 (comment)

avatar elkuku
elkuku - comment - 4 Feb 2012

Just for the records - The link you posted in the first post leads to a previous version of the article - If you bookmarked it or something you should change it to:
http://docs.joomla.org/Smart_Search_quickstart_guide

avatar zero-24 zero-24 - close - 5 Feb 2012
avatar zero-24 zero-24 - change - 7 Jul 2015
Labels Added: ?
Build staging

Add a Comment

Login with GitHub to post a comment