From: Jauslin K. <kai...@li...> - 2007-09-07 08:00:19
|
Hello, I've upgraded our reference and development systems to the latest SVN = trunk. Most things work very nice and fast, including uploading = documents. I did an upgrade and import of the latest xsds.xml. On the = reference system, a new database was created with a fresh setup.=20 There seems to be a problem with the "Browse by Subject", e.g. the ASRC. = On the development machine also with our own, existing classification. I = don't see any "fez_record_search_key_subject.rek_pid" in the schema. = Here is the extract from error_handler.log: Cheers, Kai ---snip [Fri Sep 07 05:48:32 2007] Array ( [txt] =3D> Array ( [0] =3D> Array [1] =3D> ( [2] =3D> [0] =3D> DB Error: no such field [3] =3D> [1] =3D> SELECT r2.rek_subject, count(distinct = r2.rek_pid) [4] =3D> FROM fez_record_search_key_subject r2 [5] =3D>=20 [6] =3D> =20 [7] =3D> WHERE r2.rek_subject IN (465585, 465584, 465587, = 465588, 465589, 465590, 465591, 465592, 465593, 465594, 465595, 465596, = 465586, 465598, 465599, 465600, 465601, 465602, 465603, 465604, 465605, = 465606, 465607, 465597, 465609, 465610, 465611, 465612, 465613, 465614, = 465615, 465616, 465608, 465618, 465619, 465620, 465621, 465622, 465623, = 465624, 465625, 465626, 465627, 465617, 465629, 465630, 465631, 465632, = 465633, 465634, 465635, 465636, 465637, 465628, 465639, 465640, 465641, = 465642, 465643, 465644, 465645, 465646, 465647, 465648, 465638, 465650, = 465651, 465652, 465653, 465654, 465655, 465656, 465657, 465658, 465659, = 465649, 465661, 465662, 465663, 465664, 465665, 465666, 465667, 465668, = 465669, 465670, 465660, 465672, 465673, 465674, 465675, 465676, 465677, = 465678, 465679, 465680, 465671, 465682, 465683, 465684, 465685, 465686, = 465687, 465688, 465689, 465690, 465681, 465692, 465693, 465694, 465695, = 465696, 465697, 465698, 465699, 465700, 465701, 465691, 465703, 465704, = 465705, 465706, 465707, 465708, 465709, 465710, 465711, 465702, 465713, = 465714, 465715, 465716, 465717, 465718, 465719, 465720, 465721, 465722, = 465712, 465724, 465725, 465726, 465727, 465728, 465729, 465730, 465731, = 465732, 465733, 465723, 465735, 465736, 465737, 465738, 465739, 465740, = 465741, 465742, 465734, 465744, 465745, 465746, 465747, 465748, 465749, = 465750, 465751, 465743, 465753, 465754, 465755, 465756, 465757, 465758, = 465759, 465752, 465761, 465760) [8] =3D> =20 [9] =3D> GROUP BY r2.rek_subject = [nativecode=3D1054 ** Unknown column 'r2.rek_pid' in 'field list'] [10] =3D> ) [11] =3D>=20 ) [script] =3D> C:\Fez\eth-trunk\include\class.collection.php [line] =3D> 331 [backtrace] =3D> Array ( [0] =3D> Array ( [file] =3D> = C:\Fez\eth-trunk\include\class.collection.php:331 [call] =3D> Error_Handler::logError ) [1] =3D> Array ( [file] =3D> = C:\Fez\eth-trunk\include\class.lister.php:466 [call] =3D> Collection::getCVCountSearch ) [2] =3D> Array ( [file] =3D> C:\Fez\eth-trunk\list.php:42 [call] =3D> Lister::getList ) ) ) [Fri Sep 07 05:48:32 2007] Array ( [txt] =3D> Array ( [0] =3D> Array [1] =3D> ( [2] =3D> [0] =3D> DB Error: no such field [3] =3D> [1] =3D> SELECT distinct r2.rek_pid, = r6.rek_ as sort_column =20 [4] =3D> FROM fez_record_search_key r2 [5] =3D> =20 [6] =3D>=20 [7] =3D> =09 [8] =3D>=20 [9] =3D> =09 [10] =3D>=20 [11] =3D> =20 [12] =3D> INNER JOIN fez_record_search_key r5 = ON r2.rek_status =3D 2 =20 [13] =3D> order by sort_column asc , r2.rek_pid desc [14] =3D>=20 [15] =3D> LIMIT 50 OFFSET 0=20 [16] =3D>=20 [17] =3D>=20 [18] =3D> =09 [19] =3D>=20 [20] =3D> [nativecode=3D1054 ** Unknown = column 'r6.rek_' in 'field list'] [21] =3D> ) [22] =3D>=20 ) [script] =3D> C:\Fez\eth-trunk\include\class.collection.php [line] =3D> 658 [backtrace] =3D> Array ( [0] =3D> Array ( [file] =3D> = C:\Fez\eth-trunk\include\class.collection.php:658 [call] =3D> Error_Handler::logError ) [1] =3D> Array ( [file] =3D> = C:\Fez\eth-trunk\include\class.lister.php:467 [call] =3D> Collection::browseListing ) [2] =3D> Array ( [file] =3D> C:\Fez\eth-trunk\list.php:42 [call] =3D> Lister::getList ) ) ) --=20 Kai Jauslin, Dipl. Informatik-Ing. ETH, ETH Z=FCrich, ETH-Bibliothek, = R=E4mistrasse 101, CH-8092 Z=FCrich kai...@li..., Tel +41-44-6324972, B=FCro STB F19 |
From: Christiaan K. <c.k...@li...> - 2007-09-07 08:26:07
|
Thanks for reporting that Kai, I'll take a look at it over the weekend. It should be a simple fix. Cheers, Christiaan On 7/9/07 6:00 PM, "Jauslin Kai" <kai...@li...> wrote: > Hello, > > I've upgraded our reference and development systems to the latest SVN trunk. > Most things work very nice and fast, including uploading documents. I did an > upgrade and import of the latest xsds.xml. On the reference system, a new > database was created with a fresh setup. > > There seems to be a problem with the "Browse by Subject", e.g. the ASRC. On > the development machine also with our own, existing classification. I don't > see any "fez_record_search_key_subject.rek_pid" in the schema. Here is the > extract from error_handler.log: > > > Cheers, Kai > > > ---snip > [Fri Sep 07 05:48:32 2007] Array > ( > [txt] => Array > ( > [0] => Array > [1] => ( > [2] => [0] => DB Error: no such field > [3] => [1] => SELECT r2.rek_subject, count(distinct > r2.rek_pid) > [4] => FROM fez_record_search_key_subject r2 > [5] => > [6] => > [7] => WHERE r2.rek_subject IN (465585, 465584, 465587, 465588, > 465589, 465590, 465591, 465592, 465593, 465594, 465595, 465596, 465586, > 465598, 465599, 465600, 465601, 465602, 465603, 465604, 465605, 465606, > 465607, 465597, 465609, 465610, 465611, 465612, 465613, 465614, 465615, > 465616, 465608, 465618, 465619, 465620, 465621, 465622, 465623, 465624, > 465625, 465626, 465627, 465617, 465629, 465630, 465631, 465632, 465633, > 465634, 465635, 465636, 465637, 465628, 465639, 465640, 465641, 465642, > 465643, 465644, 465645, 465646, 465647, 465648, 465638, 465650, 465651, > 465652, 465653, 465654, 465655, 465656, 465657, 465658, 465659, 465649, > 465661, 465662, 465663, 465664, 465665, 465666, 465667, 465668, 465669, > 465670, 465660, 465672, 465673, 465674, 465675, 465676, 465677, 465678, > 465679, 465680, 465671, 465682, 465683, 465684, 465685, 465686, 465687, > 465688, 465689, 465690, 465681, 465692, 465693, 465694, 465695, 465696, > 465697, 465698, 465699, 465700, 465701, 465691, 465703, 465704, 465705, > 465706, 465707, 465708, 465709, 465710, 465711, 465702, 465713, 465714, > 465715, 465716, 465717, 465718, 465719, 465720, 465721, 465722, 465712, > 465724, 465725, 465726, 465727, 465728, 465729, 465730, 465731, 465732, > 465733, 465723, 465735, 465736, 465737, 465738, 465739, 465740, 465741, > 465742, 465734, 465744, 465745, 465746, 465747, 465748, 465749, 465750, > 465751, 465743, 465753, 465754, 465755, 465756, 465757, 465758, 465759, > 465752, 465761, 465760) > [8] => > [9] => GROUP BY r2.rek_subject [nativecode=1054 > ** Unknown column 'r2.rek_pid' in 'field list'] > [10] => ) > [11] => > ) > > [script] => C:\Fez\eth-trunk\include\class.collection.php > [line] => 331 > [backtrace] => Array > ( > [0] => Array > ( > [file] => > C:\Fez\eth-trunk\include\class.collection.php:331 > [call] => Error_Handler::logError > ) > > [1] => Array > ( > [file] => C:\Fez\eth-trunk\include\class.lister.php:466 > [call] => Collection::getCVCountSearch > ) > > [2] => Array > ( > [file] => C:\Fez\eth-trunk\list.php:42 > [call] => Lister::getList > ) > > ) > > ) > > [Fri Sep 07 05:48:32 2007] Array > ( > [txt] => Array > ( > [0] => Array > [1] => ( > [2] => [0] => DB Error: no such field > [3] => [1] => SELECT distinct r2.rek_pid, r6.rek_ as > sort_column > [4] => FROM fez_record_search_key r2 > [5] => > [6] => > [7] => > [8] => > [9] => > [10] => > [11] => > [12] => INNER JOIN fez_record_search_key r5 ON > r2.rek_status = 2 > [13] => order by sort_column asc , r2.rek_pid desc > [14] => > [15] => LIMIT 50 OFFSET 0 > [16] => > [17] => > [18] => > [19] => > [20] => [nativecode=1054 ** Unknown column > 'r6.rek_' in 'field list'] > [21] => ) > [22] => > ) > > [script] => C:\Fez\eth-trunk\include\class.collection.php > [line] => 658 > [backtrace] => Array > ( > [0] => Array > ( > [file] => > C:\Fez\eth-trunk\include\class.collection.php:658 > [call] => Error_Handler::logError > ) > > [1] => Array > ( > [file] => C:\Fez\eth-trunk\include\class.lister.php:467 > [call] => Collection::browseListing > ) > > [2] => Array > ( > [file] => C:\Fez\eth-trunk\list.php:42 > [call] => Lister::getList > ) > > ) > > ) > -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Christiaan Kortekaas Senior Library Open Sorcerer Library Technology Service The University of Queensland, Australia QLD 4072 Telephone : (+61) (7) 3346 4337 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
From: Jauslin K. <kai...@li...> - 2007-09-07 08:51:50
|
I found one other issue - but I don't know whether this has always been = like this: case-sensitivity Document title: "TreeMap survey" Quick search (top right) for "tree*" finds nothing, "Tree*" finds it - = same for search/advanced search.=20 Also, the frontpage ajax suggestor doesn't seem to work consistently: - same issue with case sensitivity - will suggest for "su">"survey", but not for "Tr">"TreeMap" - it will sometimes just stop working (in IE7 and Firefox2), no JS error = messages Cheers, Kai --=20 Kai Jauslin, Dipl. Informatik-Ing. ETH, ETH Z=FCrich, ETH-Bibliothek, = R=E4mistrasse 101, CH-8092 Z=FCrich kai...@li..., Tel +41-44-6324972, B=FCro STB F19 -----Urspr=FCngliche Nachricht----- Von: fez...@li... = [mailto:fez...@li...] Im Auftrag von = Christiaan Kortekaas Gesendet: Freitag, 7. September 2007 10:26 An: fez...@li... Betreff: Re: [Fez-developers] Fez2 / Browse by subject Thanks for reporting that Kai, I'll take a look at it over the weekend. It should be a simple fix. Cheers, Christiaan On 7/9/07 6:00 PM, "Jauslin Kai" <kai...@li...> wrote: > Hello, >=20 > I've upgraded our reference and development systems to the latest SVN = trunk. > Most things work very nice and fast, including uploading documents. I = did an > upgrade and import of the latest xsds.xml. On the reference system, a = new > database was created with a fresh setup. >=20 > There seems to be a problem with the "Browse by Subject", e.g. the = ASRC. On > the development machine also with our own, existing classification. I = don't > see any "fez_record_search_key_subject.rek_pid" in the schema. Here is = the > extract from error_handler.log: >=20 >=20 > Cheers, Kai >=20 >=20 > ---snip > [Fri Sep 07 05:48:32 2007] Array > ( > [txt] =3D> Array > ( > [0] =3D> Array > [1] =3D> ( > [2] =3D> [0] =3D> DB Error: no such field > [3] =3D> [1] =3D> SELECT r2.rek_subject, = count(distinct > r2.rek_pid) > [4] =3D> FROM fez_record_search_key_subject r2 > [5] =3D> > [6] =3D> > [7] =3D> WHERE r2.rek_subject IN (465585, 465584, = 465587, 465588, > 465589, 465590, 465591, 465592, 465593, 465594, 465595, 465596, = 465586, > 465598, 465599, 465600, 465601, 465602, 465603, 465604, 465605, = 465606, > 465607, 465597, 465609, 465610, 465611, 465612, 465613, 465614, = 465615, > 465616, 465608, 465618, 465619, 465620, 465621, 465622, 465623, = 465624, > 465625, 465626, 465627, 465617, 465629, 465630, 465631, 465632, = 465633, > 465634, 465635, 465636, 465637, 465628, 465639, 465640, 465641, = 465642, > 465643, 465644, 465645, 465646, 465647, 465648, 465638, 465650, = 465651, > 465652, 465653, 465654, 465655, 465656, 465657, 465658, 465659, = 465649, > 465661, 465662, 465663, 465664, 465665, 465666, 465667, 465668, = 465669, > 465670, 465660, 465672, 465673, 465674, 465675, 465676, 465677, = 465678, > 465679, 465680, 465671, 465682, 465683, 465684, 465685, 465686, = 465687, > 465688, 465689, 465690, 465681, 465692, 465693, 465694, 465695, = 465696, > 465697, 465698, 465699, 465700, 465701, 465691, 465703, 465704, = 465705, > 465706, 465707, 465708, 465709, 465710, 465711, 465702, 465713, = 465714, > 465715, 465716, 465717, 465718, 465719, 465720, 465721, 465722, = 465712, > 465724, 465725, 465726, 465727, 465728, 465729, 465730, 465731, = 465732, > 465733, 465723, 465735, 465736, 465737, 465738, 465739, 465740, = 465741, > 465742, 465734, 465744, 465745, 465746, 465747, 465748, 465749, = 465750, > 465751, 465743, 465753, 465754, 465755, 465756, 465757, 465758, = 465759, > 465752, 465761, 465760) > [8] =3D> > [9] =3D> GROUP BY r2.rek_subject = [nativecode=3D1054 > ** Unknown column 'r2.rek_pid' in 'field list'] > [10] =3D> ) > [11] =3D> > ) >=20 > [script] =3D> C:\Fez\eth-trunk\include\class.collection.php > [line] =3D> 331 > [backtrace] =3D> Array > ( > [0] =3D> Array > ( > [file] =3D> > C:\Fez\eth-trunk\include\class.collection.php:331 > [call] =3D> Error_Handler::logError > ) >=20 > [1] =3D> Array > ( > [file] =3D> = C:\Fez\eth-trunk\include\class.lister.php:466 > [call] =3D> Collection::getCVCountSearch > ) >=20 > [2] =3D> Array > ( > [file] =3D> C:\Fez\eth-trunk\list.php:42 > [call] =3D> Lister::getList > ) >=20 > ) >=20 > ) >=20 > [Fri Sep 07 05:48:32 2007] Array > ( > [txt] =3D> Array > ( > [0] =3D> Array > [1] =3D> ( > [2] =3D> [0] =3D> DB Error: no such field > [3] =3D> [1] =3D> SELECT distinct r2.rek_pid, = r6.rek_ as > sort_column =20 > [4] =3D> FROM fez_record_search_key r2 > [5] =3D> > [6] =3D> > [7] =3D> =20 > [8] =3D> > [9] =3D> =20 > [10] =3D> > [11] =3D> =20 > [12] =3D> INNER JOIN fez_record_search_key = r5 ON > r2.rek_status =3D 2 > [13] =3D> order by sort_column asc , r2.rek_pid = desc > [14] =3D> > [15] =3D> LIMIT 50 OFFSET 0 > [16] =3D> > [17] =3D> > [18] =3D> =20 > [19] =3D> > [20] =3D> [nativecode=3D1054 ** Unknown = column > 'r6.rek_' in 'field list'] > [21] =3D> ) > [22] =3D> > ) >=20 > [script] =3D> C:\Fez\eth-trunk\include\class.collection.php > [line] =3D> 658 > [backtrace] =3D> Array > ( > [0] =3D> Array > ( > [file] =3D> > C:\Fez\eth-trunk\include\class.collection.php:658 > [call] =3D> Error_Handler::logError > ) >=20 > [1] =3D> Array > ( > [file] =3D> = C:\Fez\eth-trunk\include\class.lister.php:467 > [call] =3D> Collection::browseListing > ) >=20 > [2] =3D> Array > ( > [file] =3D> C:\Fez\eth-trunk\list.php:42 > [call] =3D> Lister::getList > ) >=20 > ) >=20 > ) >=20 --=20 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Christiaan Kortekaas Senior Library Open Sorcerer Library Technology Service The University of Queensland, Australia QLD 4072 Telephone : (+61) (7) 3346 4337 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -------------------------------------------------------------------------= This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Fez-developers mailing list Fez...@li... https://lists.sourceforge.net/lists/listinfo/fez-developers |
From: Christiaan K. <c.k...@li...> - 2007-09-07 09:19:16
|
Hi Kai Yes I have also noticed this one. Probably also easily fixed. Thanks for reporting it! Cheers, Christiaan On 7/9/07 6:51 PM, "Jauslin Kai" <kai...@li...> wrote: > I found one other issue - but I don't know whether this has always been like > this: case-sensitivity > > Document title: "TreeMap survey" > Quick search (top right) for "tree*" finds nothing, "Tree*" finds it - same > for search/advanced search. > > Also, the frontpage ajax suggestor doesn't seem to work consistently: > - same issue with case sensitivity > - will suggest for "su">"survey", but not for "Tr">"TreeMap" > - it will sometimes just stop working (in IE7 and Firefox2), no JS error > messages > > > Cheers, Kai > -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Christiaan Kortekaas Senior Library Open Sorcerer Library Technology Service The University of Queensland, Australia QLD 4072 Telephone : (+61) (7) 3346 4337 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
From: Christiaan K. <c.k...@li...> - 2007-09-07 09:24:10
|
Hi Kai > Also, the frontpage ajax suggestor doesn't seem to work consistently: > - same issue with case sensitivity > - will suggest for "su">"survey", but not for "Tr">"TreeMap" > - it will sometimes just stop working (in IE7 and Firefox2), no JS error > messages I should mention that it requires at least 2 characters AND that's only if you have mysql set to min_ft_word_len (sp?) set to 2. EG If it is set to the default of 4 you won't get any results until you enter in 4 characters. Cheers, Christiaan -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Christiaan Kortekaas Senior Library Open Sorcerer Library Technology Service The University of Queensland, Australia QLD 4072 Telephone : (+61) (7) 3346 4337 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
From: Jauslin K. <kai...@li...> - 2007-09-07 09:39:26
|
Thanks, I forgot about that setting. I have now set = "ft_min_word_lenth=3D2" and restarted MySQL. There still seems to be = some problem with the suggestor - I'll report on any progress. Kai --=20 Kai Jauslin, Dipl. Informatik-Ing. ETH, ETH Z=FCrich, ETH-Bibliothek, = R=E4mistrasse 101, CH-8092 Z=FCrich kai...@li..., Tel +41-44-6324972, B=FCro STB F19 -----Urspr=FCngliche Nachricht----- Von: fez...@li... = [mailto:fez...@li...] Im Auftrag von = Christiaan Kortekaas Gesendet: Freitag, 7. September 2007 11:24 An: fez...@li... Betreff: Re: [Fez-developers] Fez2 / Browse by subject Hi Kai > Also, the frontpage ajax suggestor doesn't seem to work consistently: > - same issue with case sensitivity > - will suggest for "su">"survey", but not for "Tr">"TreeMap" > - it will sometimes just stop working (in IE7 and Firefox2), no JS = error > messages I should mention that it requires at least 2 characters AND that's only = if you have mysql set to min_ft_word_len (sp?) set to 2. EG If it is set to the default of 4 you won't get any results until you enter in 4 characters. Cheers, Christiaan --=20 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Christiaan Kortekaas Senior Library Open Sorcerer Library Technology Service The University of Queensland, Australia QLD 4072 Telephone : (+61) (7) 3346 4337 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -------------------------------------------------------------------------= This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Fez-developers mailing list Fez...@li... https://lists.sourceforge.net/lists/listinfo/fez-developers |
From: Christiaan K. <c.k...@li...> - 2007-09-07 09:50:30
|
Hi Kai Remember the existing fulltext indexes will need to be dropped/re-added after you change this setting (its not an automatic thing on existing fulltext indexes when you change that my.cnf setting). I suggest using sqlyog as a good mysql gui. You can just drop and recreate the fulltext indexes. Mainly the ones on fez_record_search_key (there maybe be some on some of the 1->M search key tables but that's the main one). Cheers, Christiaan On 7/9/07 7:39 PM, "Jauslin Kai" <kai...@li...> wrote: > Thanks, I forgot about that setting. I have now set "ft_min_word_lenth=2" and > restarted MySQL. There still seems to be some problem with the suggestor - > I'll report on any progress. > > Kai > -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Christiaan Kortekaas Senior Library Open Sorcerer Library Technology Service The University of Queensland, Australia QLD 4072 Telephone : (+61) (7) 3346 4337 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
From: Jauslin K. <kai...@li...> - 2007-09-07 10:11:27
|
Funny thing... So I did this: alter table fez_record_search_key drop index rek_fulltext_all; alter table fez_record_search_key drop index rek_description; alter table fez_record_search_key drop index rek_fulltext; alter table fez_record_search_key add FULLTEXT KEY `rek_description` (`rek_description`), add FULLTEXT KEY `rek_fulltext` (`rek_title`,`rek_description`), add FULLTEXT KEY `rek_fulltext_all` = (`rek_pid`,`rek_title`,`rek_description`) After that, the suggestion "Tr">"TreeMap" worked, but not "Te">"Test" = (the document title is "Test TreeMap") Anyway, it has no high priority. And there might still be some issues = with our development instance. I'll try it next week on the reference. Cheers,Kai --=20 Kai Jauslin, Dipl. Informatik-Ing. ETH, ETH Z=FCrich, ETH-Bibliothek, = R=E4mistrasse 101, CH-8092 Z=FCrich kai...@li..., Tel +41-44-6324972, B=FCro STB F19 -----Urspr=FCngliche Nachricht----- Von: fez...@li... = [mailto:fez...@li...] Im Auftrag von = Christiaan Kortekaas Gesendet: Freitag, 7. September 2007 11:50 An: fez...@li... Betreff: Re: [Fez-developers] Fez2 / Browse by subject Hi Kai Remember the existing fulltext indexes will need to be dropped/re-added after you change this setting (its not an automatic thing on existing fulltext indexes when you change that my.cnf setting). I suggest using sqlyog as a good mysql gui. You can just drop and recreate the fulltext indexes. Mainly the ones on fez_record_search_key (there maybe be some on some of the 1->M search = key tables but that's the main one). Cheers, Christiaan On 7/9/07 7:39 PM, "Jauslin Kai" <kai...@li...> wrote: > Thanks, I forgot about that setting. I have now set = "ft_min_word_lenth=3D2" and > restarted MySQL. There still seems to be some problem with the = suggestor - > I'll report on any progress. >=20 > Kai >=20 --=20 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Christiaan Kortekaas Senior Library Open Sorcerer Library Technology Service The University of Queensland, Australia QLD 4072 Telephone : (+61) (7) 3346 4337 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ -------------------------------------------------------------------------= This SF.net email is sponsored by: Splunk Inc. Still grepping through log files to find problems? Stop. Now Search log events and configuration files using AJAX and a browser. Download your FREE copy of Splunk now >> http://get.splunk.com/ _______________________________________________ Fez-developers mailing list Fez...@li... https://lists.sourceforge.net/lists/listinfo/fez-developers |
From: Christiaan K. <c.k...@li...> - 2007-09-07 13:42:18
|
Hi Kai, Mysql fulltext indexing has a list of 'stop words' it will not index and I think 'test' would be one of them. You can manually change mysql's stoplist though I think. Here is the list: http://dev.mysql.com/doc/refman/5.0/en/fulltext-stopwords.html Actually I can't see 'Test' in there! So it is still a mystery. Cheers, Christiaan On 7/9/07 8:11 PM, "Jauslin Kai" <kai...@li...> wrote: > Funny thing... So I did this: > > alter table fez_record_search_key drop index rek_fulltext_all; > alter table fez_record_search_key drop index rek_description; > alter table fez_record_search_key drop index rek_fulltext; > > alter table fez_record_search_key > add FULLTEXT KEY `rek_description` (`rek_description`), > add FULLTEXT KEY `rek_fulltext` (`rek_title`,`rek_description`), > add FULLTEXT KEY `rek_fulltext_all` (`rek_pid`,`rek_title`,`rek_description`) > > After that, the suggestion "Tr">"TreeMap" worked, but not "Te">"Test" (the > document title is "Test TreeMap") > > Anyway, it has no high priority. And there might still be some issues with our > development instance. I'll try it next week on the reference. > > Cheers,Kai -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Christiaan Kortekaas Senior Library Open Sorcerer Library Technology Service The University of Queensland, Australia QLD 4072 Telephone : (+61) (7) 3346 4337 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
From: Christiaan K. <c.k...@li...> - 2007-09-08 05:27:30
|
Hi Kai It looks like this can be resolved by changing the collation from utf8_bin to utf8_general_ci. I'll experiment with this and commit an upgrade script if it seems like the best choice. The utf8_general_ci collation is apparently faster than utf8_bin so that might be an added benefit. Cheers, Christiaan On 7/9/07 6:51 PM, "Jauslin Kai" <kai...@li...> wrote: > I found one other issue - but I don't know whether this has always been like > this: case-sensitivity > > Document title: "TreeMap survey" > Quick search (top right) for "tree*" finds nothing, "Tree*" finds it - same > for search/advanced search. > > Also, the frontpage ajax suggestor doesn't seem to work consistently: > - same issue with case sensitivity > - will suggest for "su">"survey", but not for "Tr">"TreeMap" > - it will sometimes just stop working (in IE7 and Firefox2), no JS error > messages > > > Cheers, Kai > -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Christiaan Kortekaas Senior Library Open Sorcerer Library Technology Service The University of Queensland, Australia QLD 4072 Telephone : (+61) (7) 3346 4337 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |
From: Christiaan K. <c.k...@li...> - 2007-09-08 11:20:14
|
Hi Kai I've fixed this in the SVN trunk (revision 934). http://dev-repo.library.uq.edu.au/websvn/log.php?repname=fez&path=%2F&rev=0& sc=0&isdir=1 I probably won't get around to commit an upgrade sql script to change the collation from utf8_bin to utf8_general_ci until Monday, but I have done it manually and its fixed the case sensitivity problem (so you could do it manually in the mean time if you like). And in my test environments 'Test' or 'test' finds matches in titles ok. Thanks again, Christiaan On 7/9/07 6:00 PM, "Jauslin Kai" <kai...@li...> wrote: > Hello, > > I've upgraded our reference and development systems to the latest SVN trunk. > Most things work very nice and fast, including uploading documents. I did an > upgrade and import of the latest xsds.xml. On the reference system, a new > database was created with a fresh setup. > > There seems to be a problem with the "Browse by Subject", e.g. the ASRC. On > the development machine also with our own, existing classification. I don't > see any "fez_record_search_key_subject.rek_pid" in the schema. Here is the > extract from error_handler.log: > > > Cheers, Kai > > > ---snip > [Fri Sep 07 05:48:32 2007] Array > ( > [txt] => Array > ( > [0] => Array > [1] => ( > [2] => [0] => DB Error: no such field > [3] => [1] => SELECT r2.rek_subject, count(distinct > r2.rek_pid) > [4] => FROM fez_record_search_key_subject r2 > [5] => > [6] => > [7] => WHERE r2.rek_subject IN (465585, 465584, 465587, 465588, > 465589, 465590, 465591, 465592, 465593, 465594, 465595, 465596, 465586, > 465598, 465599, 465600, 465601, 465602, 465603, 465604, 465605, 465606, > 465607, 465597, 465609, 465610, 465611, 465612, 465613, 465614, 465615, > 465616, 465608, 465618, 465619, 465620, 465621, 465622, 465623, 465624, > 465625, 465626, 465627, 465617, 465629, 465630, 465631, 465632, 465633, > 465634, 465635, 465636, 465637, 465628, 465639, 465640, 465641, 465642, > 465643, 465644, 465645, 465646, 465647, 465648, 465638, 465650, 465651, > 465652, 465653, 465654, 465655, 465656, 465657, 465658, 465659, 465649, > 465661, 465662, 465663, 465664, 465665, 465666, 465667, 465668, 465669, > 465670, 465660, 465672, 465673, 465674, 465675, 465676, 465677, 465678, > 465679, 465680, 465671, 465682, 465683, 465684, 465685, 465686, 465687, > 465688, 465689, 465690, 465681, 465692, 465693, 465694, 465695, 465696, > 465697, 465698, 465699, 465700, 465701, 465691, 465703, 465704, 465705, > 465706, 465707, 465708, 465709, 465710, 465711, 465702, 465713, 465714, > 465715, 465716, 465717, 465718, 465719, 465720, 465721, 465722, 465712, > 465724, 465725, 465726, 465727, 465728, 465729, 465730, 465731, 465732, > 465733, 465723, 465735, 465736, 465737, 465738, 465739, 465740, 465741, > 465742, 465734, 465744, 465745, 465746, 465747, 465748, 465749, 465750, > 465751, 465743, 465753, 465754, 465755, 465756, 465757, 465758, 465759, > 465752, 465761, 465760) > [8] => > [9] => GROUP BY r2.rek_subject [nativecode=1054 > ** Unknown column 'r2.rek_pid' in 'field list'] > [10] => ) > [11] => > ) > > [script] => C:\Fez\eth-trunk\include\class.collection.php > [line] => 331 > [backtrace] => Array > ( > [0] => Array > ( > [file] => > C:\Fez\eth-trunk\include\class.collection.php:331 > [call] => Error_Handler::logError > ) > > [1] => Array > ( > [file] => C:\Fez\eth-trunk\include\class.lister.php:466 > [call] => Collection::getCVCountSearch > ) > > [2] => Array > ( > [file] => C:\Fez\eth-trunk\list.php:42 > [call] => Lister::getList > ) > > ) > > ) > > [Fri Sep 07 05:48:32 2007] Array > ( > [txt] => Array > ( > [0] => Array > [1] => ( > [2] => [0] => DB Error: no such field > [3] => [1] => SELECT distinct r2.rek_pid, r6.rek_ as > sort_column > [4] => FROM fez_record_search_key r2 > [5] => > [6] => > [7] => > [8] => > [9] => > [10] => > [11] => > [12] => INNER JOIN fez_record_search_key r5 ON > r2.rek_status = 2 > [13] => order by sort_column asc , r2.rek_pid desc > [14] => > [15] => LIMIT 50 OFFSET 0 > [16] => > [17] => > [18] => > [19] => > [20] => [nativecode=1054 ** Unknown column > 'r6.rek_' in 'field list'] > [21] => ) > [22] => > ) > > [script] => C:\Fez\eth-trunk\include\class.collection.php > [line] => 658 > [backtrace] => Array > ( > [0] => Array > ( > [file] => > C:\Fez\eth-trunk\include\class.collection.php:658 > [call] => Error_Handler::logError > ) > > [1] => Array > ( > [file] => C:\Fez\eth-trunk\include\class.lister.php:467 > [call] => Collection::browseListing > ) > > [2] => Array > ( > [file] => C:\Fez\eth-trunk\list.php:42 > [call] => Lister::getList > ) > > ) > > ) > -- ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Christiaan Kortekaas Senior Library Open Sorcerer Library Technology Service The University of Queensland, Australia QLD 4072 Telephone : (+61) (7) 3346 4337 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ |