[Owncloud] search function in owncloud

[Jan Giebels - German RepRap GmbH]

Am 21.11.2012 um 18:42 schrieb Jörn Friedrich Dreyer <jfd at owncloud.com>:

> It should return a json response. You should find the reason for the 500 error in the webservers error log.
> 

the error log say:

 PHP Fatal error:  Uncaught exception 'PDOException' with message 'SQLSTATE[42703]: Undefined column: 7 ERROR:  column "tags" does not exist
LINE 3: ...id = $1  AND lower(url || title || description || tags ) lik...
                                                             ^' in /path/to/owncloud/lib/db.php:736
Stack trace:
#0 /path/to/owncloud/lib/db.php(736): PDOStatement->execute(Array)
#1 /path/to/owncloud/apps/bookmarks/lib/bookmarks.php(101): PDOStatementWrapper->execute(Array)
#2 /path/to/owncloud/apps/bookmarks/lib/bookmarks.php(354): OC_Bookmarks_Bookmarks::findBookmarks(0, 'id', 'test', false)
#3 /path/to/owncloud/apps/bookmarks/lib/search.php(35): OC_Bookmarks_Bookmarks::searchBookmarks('test')
#4 /path/to/owncloud/lib/search.php(56): OC_Search_Provider_Bookmarks->search('test')
#5 /path/to/owncloud/search/ajax/search.php(33): OC_Search::search('test')
#6 {main}
  thrown in /path/to/owncloud/lib/db.php on line 736

after deactivation of the bookmarks app the search start working well.
I tried to reactivate Bokmarks but than the search stop working again.

i don't really need Bookmarks right now as of the missing syncing but this is another topic ;)

Thanks a lot .. learned something about oc.

thx

> Let me know what you find.
> 
> So long
> 
> Jörn
> 
> 
> 
> Jan Giebels - German RepRap GmbH <jan at germanreprap.com> schrieb:
> 
> Am 21.11.2012 um 15:12 schrieb Jörn Friedrich Dreyer <jfd at owncloud.com>:
> 
> On 21.11.2012 15:05, Jan Giebels - German RepRap GmbH wrote:
> i use postgres 8.4 as db backend and own cloud 4.5.1.
> 
> i have a sub-folder at files called "Software" with a file called "test.txt" with the content "Hello World".
> 
> No matter if i search for the phrase Software, test or World .. no results who up an no error message show up. simply nothing happens.
> Thx. Full text search is not yet implemented, so searching for 'Hello'
> or 'World' not giving results is to be expected. Searching for 'text'
> sho
>  uld
> however show you that file and 'Software' should show the folder.
> 
> 
> 
> OK, this is understandable.
> 
> where can i have a look if an error occurs somewhere?
> The first thing to check is the browser sending and receiving a
> successful search request. You can best check that using the network
> activity inspection tool of your browser. Then you could have a look at
> data/owncloud.log or the apache error.log of your owncloud installation.
> 
> 
> the network analysis gives me a:
> 
> Error 500 at: 
> 
> https://<mydomain>/search/ajax/search.php?query=Software
> 
> If i enter this URL into the Browser, i get a white page.
> 
> so long
> 
> Jörn
> 
> -- 
> Jörn Friedrich Dreyer (jfd at owncloud.com)
> Software Developer
> ownCloud GmbH
> 
> Your Data, Your Cloud, Your Way!
> 
> ownCloud GmbH, GF: Markus Rex, Holger Dyroff
> Schloßäckerstrasse 26a, 90443 Nürnberg, HRB 28050 (AG Nürnberg)
> 
> 
> Owncloud mailing list
> Owncloud at kde.org
> https://mail.kde.org/mailman/listinfo/owncloud
> 
> 
> Owncloud mailing list
> Owncloud at kde.org
> https://mail.kde.org/mailman/listinfo/owncloud
> 
> -- 
> Diese Nachricht wurde von meinem Android-Mobiltelefon mit K-9 Mail gesendet.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.kde.org/pipermail/owncloud/attachments/20121121/8130b87d/attachment.html>