< Niklaus.20180131-oddb-adsense | Index | Niklaus.20180129-migel-dateformat >>
My changes did not work. Adding another pry statement and breaking after 5 in plugin/swissindex
Now I see that often, but not always we have a worng datei
xxx for 01.01.01.00.1 Milchpumpe, handbetrieben, Kauf 1996-01-01 count 0 xxx for 01.01.02.00.2 Milchpumpe, elektrisch, Miete 1996-01-01 count 1 xxx for 01.01.02.01.2 Miete Milchpumpe, elektrisch 1996-01-01 count 2 xxx for 01.01.02.02.2 Zubehörset zu Milchpumpe elektrisch 1996-01-01 count 3 xxx for 01.02.01.00.2 Tracheal-Absauggerät, Miete 1996-01-01 count 4 xxx for 03.02.01.00.2 Insulinpumpen-System, Miete -4712-01-01 count 5 xxx for 03.02.01.01.2 Insulinpumpen-System, Miete -4712-01-01 count 6 xxx for 03.03.01.00.1 Infusionspumpe, für Volumen von 3-10 ml, tragbar, Kauf -4712-01-01 count 7 xxx for 03.03.01.00.2 Infusionspumpe, für Volumen von 3-10 ml, tragbar, Miete Exkl. Verbrauchsmaterial. -4712-01-01 count 8 xxx for 03.03.01.01.3 Ampulle zu Infusionspumpe 3-10 ml -4712-01-01 count 9 xxx for 03.03.01.02.3 Infusionsset mit Nadel zu Infusionspumpe 3-10 ml -4712-01-01 count 10
Also I am asking myself why the jobs/update_migel_products jobs/update_migel_products_with_report and call first save_all_products_all_languages
and only afterwards update_all
. In my opinion it should be the other way round. Changing the order.
Adding some puts as init_fulltext_index_tables takes a long time. Adding puts if migelid has a year < 0. Removing latest and restarting the import.
update_migel is running and updating the indices. At this time I get the error
DRb::DRbConnError at /de/gcc/home_migel/ too large packet 81494773 Ruby /usr/local/ruby-2.5.0/lib/ruby/2.5.0/drb/drb.rb: in load, line 581 Web GET oddb-ci2.dyndns.org/de/gcc/home_migel/
The update_migell shows the line NOTICE: table "migel_product_fulltext_index_fr" does not exist, skipping
because it drops and recreates this index. Nothing to worry, then. After finishing the miigel_update and restarting ch.oddb and migeld, the page https://oddb-ci2.dyndns.org/de/gcc/migel_alphabetical/range/m shows only correct years. This confirmed using the following bin/migel
migel> migelids.values.collect{|x| x.date && x.date.year}.uniq.compact.sort -> [1996, 1997, 1998, 1999, 2000, 2001, 2002, 2003, 2004, 2005, 2006, 2007, 2009, 2010, 2011, 2012, 2013, 2014, 2015, 2016, 2017] # but we have one migelid without a date migel> migelids.values.find_all{|x| !x.date}.size -> 1 migel> migelids.values.find_all{|x| !x.date}.first.migel_code -> 14.11.00.01.0 migel> migelids.values.find_all{|x| !x.date}.first.date.class -> NilClass
Pushed the following commits
Lauching sudo -u apache bundle-250 exec ruby-250 jobs/update_migel
after rm data/csv/MiGeL.xls data/csv/MiGeL-2018.01.30.xls data/csv/MiGeL-latest.xls
on thinpower to force a re-import. Without a restart of ch.oddb nor migeld I get the correct year. See:
Must figure out why with the default theme no publicity is placed. Is this because of a missing or different cookie?
Added somme dummy HTML code to see whether the adsense is place or not. Now these dummy element show, but not the code. Looking at the inspector I suddenly see the following errors
<ins id="aswift_1_expand" style="display:inline-table;border:none; height:undefinedpx; margin:0;padding:0;position:relative;visibility:visible; width:undefinedpx; background-color:transparent;"><ins id="aswift_1_anchor" style="display:block;border:none; height:undefinedpx; margin:0;padding:0;position:relative;visibility:visible; width:undefinedpx; background-color:transparent;"><iframe frameborder="0" marginwidth="0" marginheight="0" vspace="0" hspace="0" allowtransparency="true" scrolling="no" allowfullscreen="true" onload="var i=this.id,s=window.google_iframe_oncopy,H=s&&s.handlers,h=H&&H[i],w=this.contentWindow,d;try{d=w.document}catch(e){}if(h&&d&&(!d.body||!d.body.firstChild)){if(h.call){setTimeout(h,0)}else if(h.match){try{h=s.upd(h,i)}catch(e){}w.location.replace(h)}}" id="aswift_1" name="aswift_1" style="left:0;position:absolute;top:0; width:undefinedpx; height:undefinedpx;">< /iframe></ins></ins >
Corrected this error, but now I see in the javascript console
show_ads_impl.js:1 GET https://googleads.g.doubleclick.net/pagead/ads?client=ca-pub-6948570700973491&output=html&slotname=0&adk=182466085&adf=3251066599&lmt=1517322306&loeid=38893312%2C368226210&channel=1634362463&ad_type=text_image&color_bg=E6FFD6&color_border=DBE1D6&color_link=003366&color_text=003399&color_url=FF3300&url=https%3A%2F%2Foddb-ci2.dyndns.org%2Fde%2Fgcc%2Fhome_pharmacies%2F&ea=0&flash=0&wgl=1&dt=1517322306234&bpp=28&bdt=68&fdt=31&idt=49&shv=r20180124&cbv=r20170110&saldr=sa&correlator=7580948421162&frm=20&ga_vid=915952371.1517237449&ga_sid=1517322091&ga_hid=487196593&ga_fc=1&pv=2&iag=3&icsg=2&nhd=1&dssz=2&mdo=0&mso=0&u_tz=60&u_his=47&u_java=0&u_h=1440&u_w=3440&u_ah=1440&u_aw=3364&u_cd=24&u_nplug=4&u_nmime=5&adx=8&ady=164&biw=1263&bih=737&abxe=1&scr_x=0&scr_y=0&eid=21061122%2C38893302%2C62710011%2C62710014%2C191880502%2C368226200%2C370204013&oid=3&nmo=1&ref=https%3A%2F%2Foddb-ci2.dyndns.org%2Fde%2Fgcc%2Fhome_analysis%2F&rx=0&eae=2&fc=528&brdim=187%2C108%2C187%2C108%2C3364%2C0%2C1263%2C828%2C1263%2C737&vis=1&rsz=%7C%7C%7C&abl=CS&ppjl=f&fu=16&bc=1&osw_key=3396349942&ifi=1&dtd=72 400 ()
I was unable to make the ads appear on the left and on the right. With a simple test.html I was never able to see any ad. The add on the left side in the various homes display nicely, but not in the search results.