---
We must present a different view when payment via paypal is accepted for a PowerUser.
Replaced the return button by a link to the forward to the home page. See commit Correct handling paypal/return for poweruser checkout. Corrected the unit and watir tests.
Trying to make update_position work again. Okay. Looks that I messed up a row definition as see in a position :taxpoints=>"1,25 Dihydroxycholécalciférol". Did not take into account the fact, that the old rows B (revsion) and G (comment) were deleted. Setting poscd to default value '00' as column B is a float now (was a string) and now the update begins to work fine.
Trying to make update_position work again. Okay. Looks that I messed up a row definition as see in a position :taxpoints=>"1,25 Dihydroxycholécalciférol". Did not take into account the fact, that the old rows B (revsion) and G (comment) were deleted. Setting poscd to default value '00' as column B is a float now (was a string) and now the update begins to work fine. Import seems to be stuck after importing 318 analysis_groups.
Dropping and reimport the database as I got into a situation where I was in an incosistent state of the database. Now importing proceeds and is processing the french xlsx, too. Completed after 45 minutes. Checking manually the results in bin/admin
ch.oddb> analysis_groups.size
-> 1118
ch.oddb> analysis_groups.first
-> ["1000", #<ODBA::Stub:82592320#32356661 @odba_class=ODDB::Analysis::Group @odba_container=80389540#954379>]
ch.oddb> analysis_groups.first[1]
-> #<ODDB::Analysis::Group:0x0000000aeb67e8>
ch.oddb> analysis_groups.first[1].positions
-> {"00"=>#<ODBA::Stub:95645880#32356663 @odba_class=ODDB::Analysis::Position @odba_container=95651360#32356662>}
ch.oddb> analysis_groups.first[1].positions['00']
-> 1,25-Dihydroxycholecalciferol
This looks good, but a search via http://oddb-ci2.dyndns.org/de/gcc/search/zone/analysis/search_query/Dihydroxycholecalciferol? still reports
Ihr Such-Stichwort: "Dihydroxycholecalciferol" hat ein leeres Resultat ergeben. Ihr Such-Stichwort hat zu keinem Suchergebnis geführt. Bitte überprüfen Sie die Schreibweise und versuchen Sie es noch einmal.
Restarting oddb.ch. In its output I see HINWEIS: Textsucheanfrage enthält nur Stoppwörter oder enthält keine Lexeme, ignoriert. Updating the index by calling sudo -u apache /usr/local/bin/ruby jobs/rebuild_indices analysis_alphabetical_index_de. Did not change anything. Activated debugging the search indices. I see that the index analysis_index_de is used
/var/www/oddb.org/src/util/oddbapp.rb:849:in `search_analysis': analysis_index_de Dihydroxycholecalciferol HINWEIS: Textsucheanfrage enthält nur Stoppwörter oder enthält keine Lexeme, ignoriert
Updating this index too and testing whether this helps. After regenerating I found via bin/admin
ch.oddb> analysis_groups.first[1].positions['00'].search_text(:de) -> 125Dihydroxycholecalciferol 1000 100000
And the search via the full text was successfull (url was: http://oddb-ci2.dyndns.org/de/gcc/search/zone/analysis/search_query/125Dihydroxycholecalciferol%201000%20100000?). But looking for a partial match like Dihydroxycholecalciferol failed. Search for 125Dihydroxycholecalciferol 1000 was okay, but not for 125Dihydroxycholecalciferol 100. Also search for 125 worked and found position 1216.00 with description CA 125 G
Search for CA produced "Ein Fehler ist aufgetreten".
I am wondering whether my setup for search is correct. But first I will throw out the superfluos debug information from my patch and push the changes.
Pushed commit Fix analysis import. Run it first day of month. Fixed watir specs