MYSQL LOAD DATA INFILE giving ERROR 1265

I’m getting a "Error Code: 1265. Data truncated for column ‘value’ at row 1".

At a complete loss as to the source of the error.

Here is the SQL

LOAD DATA INFILE 'C:/ProgramData/MySQL/MySQL Server 8.0/Uploads/num.csv'  INTO TABLE sec_financials.num FIELDS TERMINATED BY '\t' LINES TERMINATED BY '\n' Ignore 1 LINES (adsh, tag, version, coreg, ddate, qtrs, uom, value); 

and this is the first fews rows of the csv I’m trying to load

adsh tag version coreg ddate qtrs uom value
0001640334-21-000798 AccountsPayableAndAccruedLiabilitiesCurrent us-gaap/2019 20210131 0 USD 10010.0000
0001640334-21-000798 AccountsPayableAndAccruedLiabilitiesCurrent us-gaap/2019 20201031 0 USD 10913.0000
0001477932-21-002126 AccountsPayableAndAccruedLiabilitiesCurrent us-gaap/2019 20201231 0 USD 2372072.0000
0001477932-21-002126 AccountsPayableAndAccruedLiabilitiesCurrent us-gaap/2019 20191231 0 USD 1018145.0000
0001640334-21-000810 AccountsPayableAndAccruedLiabilitiesCurrent us-gaap/2019 20210228 0 USD 2974.0000
0001640334-21-000810 AccountsPayableAndAccruedLiabilitiesCurrent us-gaap/2019 20200531 0 USD 4225.0000
0001477932-21-002140 AccountsPayableAndAccruedLiabilitiesCurrent us-gaap/2019 20191231 0 USD 1039000.0000

and this is the schema:

  CREATE TABLE `num` (   `id` int NOT NULL AUTO_INCREMENT,   `adsh` varchar(20) DEFAULT NULL,   `tag` varchar(256) DEFAULT NULL,   `version` varchar(20) DEFAULT NULL,   `ddate` int DEFAULT NULL,   `qtrs` int DEFAULT NULL,   `uom` varchar(25) DEFAULT NULL,   `coreg` varchar(256) DEFAULT NULL,   `value` float DEFAULT NULL,   PRIMARY KEY (`id`),   UNIQUE KEY `idx_unique_num` (`adsh`,`tag`,`version`,`ddate`,`qtrs`,`uom`,`coreg`)   )  

What’s the default order used by WordPress to load CSS files?

I am working with a commercial theme on which I am making some style changes. Specifically, the parent theme shows a menu which I want to modify. The code for that menu is:

 <div class="mobile-navigation hidden-md hidden-lg">         <div id="close-menu-moblie">             <a href="#">                 <i class="icon-close icons"></i>             </a>         </div>    <div class="mobile-menu-container">         <ul id="menu-menu-movil" class="nav-menu mobile-menu">             <li id="menu-item-4723" class="menu-item menu-item-type-custom menu-item-object-custom current-menu-item current_page_item menu-item-4723 active">                 <a href="/" aria-current="page">La Familia</a>             </li>             <li id="menu-item-4724" class="menu-item menu-item-type-custom menu-item-object-custom menu-item-4724">                 <a href="/tierras.html">La Tierra</a>             </li> 

So I created a child theme and added some CSS to it in its style.css file:

#menu-menu-movil li > a {     font-weight: 500;     font-family: Poppins, Arial, sans-serif;     } 

No way: the site ignores my changes. When I inspect the HTML I see that the browser is applying instead CSS instructions from the parent theme that target different classes:

.mobile-navigation .nav-menu > li > a {     font-size: 16px;     color: #1a1a1a;     font-weight: bold;     text-transform: capitalize; } 

So I think that it’s a problem with conflicting CSS instructions and their level of specificity or whatever… but then I try opening the CSS editor in WP Admin at "Appearance / Customise / Additional CSS" and pasting there my changes… and they work.

This led me to think: is there a default order in which WordPress loads CSS from all the possible places where they can be? ("Additional CSS", child themes, parent themes…). I seem to remember that there was, but after searching around on Google for a while I couldn’t find anything. Or is my problem in the end about CSS specificity?

WordPress Lazy Load

I can lazily load the pages I want. As soon as I select a category from the filter, the category I selected brings the products, but then it starts to load all the products, how can I prevent this?

Following my code : jQuery

jQuery(document).ready(function (){         let page = 1;         let action = 'inactive';         let params = JSON.parse('<?=json_encode($  params)?>');          let checkInput =  jQuery("input[name^='filter']:checked");         let checkInputVal =  jQuery("input[name^='filter']:checked").val();         if (jQuery(checkInput).is(':checked')) {                 params.show_category_filter='yes';             params.category_values=checkInputVal;             params.category=checkInputVal;         }          else if(jQuery(checkInput).not(':checked')) {             function load_country_data(page) {                 params.paged = page;                 params.action = 'test';                 console.log(params);                 jQuery.ajax({                     url: "https://techschuh.com/wp-admin/admin-ajax.php",                     method: "POST",                     data: params,                     cache: false,                      success: function (data) {                         let dataResponse = JSON.parse(data)                         //console.log(dataResponse.html);                         jQuery('.eltdf-masonry-list-wrapper').append(dataResponse.html);                                             if(dataResponse) {                             jQuery('#load_data_message').html("Please Wait.");                               action="inactive";                          } else  {                             alert("Data Not Found");                             action='active';                          }                     }                 });              }         }         if (action === 'inactive') {             action = 'active';             load_country_data(page);         }         jQuery(window).scroll(function () {             if (jQuery(window).scrollTop() + jQuery(window).height() > jQuery('#load_data').height() &&                 action == 'inactive') {                 action = 'active';                 page += 1                  setTimeout(function () {                     load_country_data(page);                 }, 500);             }          });     }); 

Unsafe attempt to load URL from frame with URL. Domains, protocols and ports must match

I am having issue in sitemap.xml. My sitemap.xml (https://www.***.com/sitemap.xml) not working in chrome browser throwing the following console error and screen was blank. But the same is working in Mozilla. Kindly help me to solve this problem.

error:

Unsafe attempt to load URL https://***********.cloudfront.net/wp-content/plugins/google-sitemap-generator/sitemap.xsl from frame with URL https://www.***.com/sitemap.xml. Domains, protocols and ports must match.

Database being hit with thousands of (Google?) search queries causing high load

I have a bit of a strange issue. Running this WordPress site several years now, but never encountered anything like this. LEMP server (ubuntu, nginx 1.18, mysql 8) Two weeks ago (according to Google Search Console excluded noindex pages and me manually checking mysql processes), more and more hits to the database started to occur (now already 4M+). All very similar (search queries?):

SELECT COUNT(*) FROM xx_posts WHERE 1=1 AND (((xx_posts.post_title LIKE '%google=662496898\_session/feed/rss2/<a_href/page/3//page/1/&usg=AOvVaw1w32-jX45qQEhTH-iBghzF

The part after rss2 tends to change. No idea where this is coming from, but it seems to be increasing and causing the server load to increase as well.

Has anyone seen this before? Or hints to find where this is coming from? No new plugins or themes were installed in the past few months. Everything is up to date.

enter image description here

enter image description here

My woolentor custom page does not load on mobile

I have just successfully created my custom shop page using woolentor, and it loads perfectly on desktop. However, when I try to visit the same custom shop url on mobile device it redirects to homepage, and that’s all I get. This concerns me a lot since most users surf the internet on mobile device. Any help with this will be highly appreciated. Thank you, Michael

How to make a content management system to load webpages without a PHP loader and its query strings?

I have a MediaWiki 1.35.2 Hebrew website which is principally all core; I host that website on a Apache, Nginx (as reverse proxy), PHP and MySQL hosting environment.

The default behavior of MediaWiki is to load any webpage with load.php and often many query strings;
It often raises errors in Google Pagespeed Insights about too many resources which consume loading time (maybe it’s better to load these informally without query strings) and it also makes my URLs "long" instead "short" (i.e. without using this load.php method) when they are already long because of Right-To-Left language Encoding.

For some reason/s I have a very hard time finding my way in the following MediaWiki guides on how to get shorter URLs without load.php and its query strings (guides that include explicitly outdated parts and/or many warnings and exceptions):

  • Manual:Short URL
  • Manual:Short URL/Apache

InfluxDB on Raspberry Pi 3 and load issues

first of all, I’m not an database expert at all, but I managed to set up a system fitting my monitoring needs for more than one year now. Unfortunately, now the problem arises. Short summary of my system:

  • Raspberry Pi 3 (Raspbian buster) is running InfluxDB 1.8.5
  • Python script is running as a service, writing ~20 datapoints every 5sec plus additional several 100 per month on demand. I would say, that is not too much in total.

My database is now >1GB:

/var/lib/influxdb $   sudo du -hd1 12K     ./meta 39M     ./wal 1.1G    ./data 1.2G    . 

I started to notice several days/weeks ago, that my system got really laggy. uptime reported load averages >4. I suspected the pretty old sd-card and switched to a proper new one, first only by putting the old image to the new card, later I really reinstalled everything and restored the influx data. It got better, but not really good. uptime reported now load averages in the range of 2. I added a monitor for uptime in my python script and it looks like this: plot of uptime over 3h

(at ~22.30 I restarted influxdb)

I did some more analysis and found that I can read the influx log with the command sudo journalctl -u influxdb.service. In the result I find lots of lines with the content similar to

Apr 26 21:04:22 xxx influxd[5598]: ts=2021-04-26T19:04:22.133912Z lvl=info msg="Error replacing new TSM files" log_id=0TksnBt0000 engine=tsm1 tsm1_strategy=full tsm1_optimize=false trace_id=0TktwGCG000 op_name=tsm1_compact_group db_shard_id=534 error="cannot allocate memory" 

And here my knowledge really stops. Does anyone know what the issue is and what I can do to "repair" my database without loosing more data?

How to make AJAX Load More Posts on Scroll for custom theme and custom-post-type?

I am currently working on a project where I am coding a custom theme with custom-post-type called products. Now, I am coding archive-product.php and stuck at making an AJAX load more posts on scroll for that.

I saw and tried most of the options available on internet. Most of them are made for Twenty Thirteen or some theme. I expect a custom code specifically for custom post type and that works for my custom theme.

Is this possible way to do so? I just want a code so that I can get more posts on scroll.