## SQL Server – Multiple error memory errors in the error log

MSSQL-Server 2017 Express Edition runs on my Linux server.
The server has 4 GB of RAM.
The total size of DB is 300 MB.

My website and the sqlserver server are on the same server. This is a small website with a maximum of 400 to 300 visitors per day.
The use of memory under Linux seems correct, mssql only takes 20% of memory:

The maximum server memory is set to 2147483647 what is the fault I suppose.

After restarting the service mssql, there is no problem for about 2 days, then it repeats itself.

I'd gladly have an answer that would solve this problem for me, but I'd also like to get a resource where I could learn more about memory / cache / pages / SQL server-related allocation because I am not an expert in SQL, I am a programmer. .

## database – MySql errors and I do not know how to repair them

I do a handy job and they gave me a .sql file with a database and data. The idea is to run the script and load everything into my mysql, but the script generates errors. (From where I have to hand over the practical work, they say that they do not generate any problems and that they do not help me that with more than that, the same thing I arrive in 2 different computers).
I enclose an SQL file with the data (I download it on mega because it is very long):
Link to .sql file by mega
And here I attach the errors that come to me.

ERROR 1366 (HY000): Incorrect string value: xC3 xA1n Na … & # 39; for
column & # 39; at line 23

ERROR 1366 (HY000): incorrect string value: xC3 xB3n n for the column
& # 39; name & # 39; in row 1

ERROR 1452 (23000): Can not add or update a child line: a foreign key
the constraint fails (competencias.pelicula, CONSTRAINTS
pelicula_genero FOREIGN KEY (genero_id) REFERENCES genero
(id))

ERROR 1452 (23000): Can not add or update a child line: a foreign key
the constraint fails (competencias.actor_pelicula, CONSTRAINTS
ap_actor_id FOREIGN KEY (actor_id) REFERENCES actor (id))

ERROR 1366 (HY000): Invalid string value: & # 39; xC3 xA8s Ja … & # 39; for
column & # 39; at line 5

ERROR 1452 (23000): Can not add or update a child line: a foreign key
the constraint fails (competencias.director_pelicula, CONSTRAINTS
director_id FOREIGN KEY (director_id) REFERENCES director
(id))

I read something on the Internet that says that the 1366 errors are due to the fact that I can not load the bytes and that I have to send my database to a special utf8 file with mysql and that it would work …
I have run some alter table alter database commands that have changed the encoding, but this one has not been fixed.
And I guess the 1452 errors are generated because something could not be written when it gives the 1366 errors.

I have version 8.0.15 MySQL Community Server.

## deprecation – Crushed index.php. When I restored it, I had a lot of notification level errors

I've overwritten the index.php file in the main wordpress directory.

I was working on something else and have downloaded an index.php file from a different project. I did not realize it and nobody reported it to me for about a week.

I replaced it with one of my hard drive and I had a lot of Note and Obsolete mistakes.

I thought my version was maybe too old, so I checked wp-includes / versions.php and discovered that the site was reporting \$wp_version = '5.2.3';

Below the errors, the site seems to load.

When I look at the file index.php, it's hard to imagine that this simple file is actually the cause of the problem, but as it is this file that I killed, it is my first suspect with regard to my problems.

What are the troubleshooting steps I can take to solve this problem?

## react.js – Potential Errors and Backend Selection

Helo,

The application is used to search for clauses by their name and the keywords that they contain. When a clause is selected, the columns with the text of the clause and its translation are displayed. when a keyword is selected, the examples containing the keyword are selected.

I only have basic features ready, but the application seems to me already quite complicated and barely works. I am an amateur and I am afraid I have made some basic mistakes, which will emerge as I add more features and data. I also want to ask what I can change to make my job easier. For example, I spend a lot of time writing functions for processing data objects. Another problem is sending the data to the application. At the moment, I'm using the JSON file sent from the website for testing purposes. What type of backend should I use for my application? I would also be grateful for all the other tips and comments.

componentDidMount() {
// query server for file size
if (!sessionStorage.getItem("data")) {

axios
.get("https://api.myjson.com/bins/sa5ob")
.then(res => {
this.setState({ data: res.data }, ()=>{sessionStorage.setItem("data", JSON.stringify(this.state.data));});
})
.catch(err => console.log(err));
} else {

let temp = sessionStorage.getItem("data");
let q = JSON.parse(temp);

this.setState({data:q});
}

}
$$```$$

## WebPart – Constant Console Errors in SharePoint Online

I just finished building my first SharePoint Online page. A simple page with some standard Web Parts (image, news, document library, list, events, file integration). Everything seems to work well (except what seems to be a margin-right CSS problem on the web part of news), but I get a continuous stream of console errors the longer I stay on the page.

For example, I'm in Chrome and I've recently reloaded the page at the beginning of entering the question. In 2-3 minutes I went to 85 errors and 12 warnings. Errors are everywhere from

Warning! The use of this tool exposes you to potential security threats that may cause others to access your Office 365 personal data (documents, emails, conversations, etc.). Make sure you trust the person or organization that asked you to access this tool before proceeding.

to mixed content errors related to a browser.pipe.aria.microsoft.com:

Mixed Content: The page on & # 39; has been loaded via HTTPS, but has requested an unsecured XMLHttpRequest endpoint & # 39 ;. This request has been blocked. the content must be served on HTTPS.

to the errors that seem to be related to the PowerPoint integration that I've got:

Access to XMLHttpRequest at the address https://browser.pipe.aria.microsoft.com/ping&#39; from the beginning https: //powerpoint.officeapps.live.com&#39; was blocked by the CORS strategy: No-Access-Control-Allowed The -Origin header is present on the requested resource.

Given my level of experience with SharePoint (literally nonexistent), I would not be totally surprised if I do something wrong, but since I did not use any custom Web Parts nor did I do anything about it. Another theme, I am a bit puzzled. as to what it could be.

Is it normal to have all these console errors?

## Redirect errors generated from the Google webmaster console

My site has 2 redirection errors. These errors appeared during the last two months. There have been no ERRORS on the site for 10 years. Please indicate how I can remove these errors. The website https://www.tillsvisalaw.com/

The following errors:

(1) Image https://stats.g.doubleclick.net/r/collect?v=…etc. Redirect error

The current code (I've tried adding the screen capture. I have an error message?

Error redirecting the account of the Webmaster console completely
Picture
l

Redirect error
Picture
https://www.google-analytics.com/r/collect?v=1&_v=j79&a=179029967&t=pageview&_s=1&dl=https%3A%2F%2Fwww.tillsvisalaw.com%2F&ul=en-us&de=UTF-8&dtt= Buffalo% 20Immigration% 2C% 20Visa% 20law% 2C% 20Attorney% 20in% 20New% 20York% 2C% 20U.SA% 2C% 20Lawyer% 2C% 20Family% 20Visa% 2C% 20F.% 20F.SU% 2C% 20C. 20crossing% 2C% 20United% 20States% 20Entry% 2C% 20Permanent% 20Visa & sd = 24 bits & sr = 412×732 & vp = 980×1741 & I = 0 & _utma = 181033250.1322411620.1571009347.1571009347.1571009347.1 & _utmz = 181033250.1571009347.1.1.utmcsr% 3D (direct)% 7Cutmccn% 3D (direct)% 7Cutmcmd% 3D (none) & _ utmht = 1571009347048 & _u = IQBCAEAB ~ & jid = 2134876339 & gjid = 1129389342 & cid = 1322411620.1571009347 & tid = UA-33066024-1 & _gid = 102343462930292929292929292929292929292929292929292929292929293029292929292929292929292929292929292929292930292929292929292929292929292929292929: 3 years old

## Wise way to report cron job errors

I have several jobs that work at night. Generally they work but from time to time they fail. What is the best way for them to report a failure?

The obvious way to me is to send an email. I have several Google Accounts and I would like to use one for this purpose.

However, I can not, after several attempts, understand how to proceed while protecting my Google Account. I appreciate the need to use OAuth2, which I understand at the design level, but I can not define the details of the implementation.

• I can not find a simple command-line utility that would allow, let's say

to send Recipient's email address –matière error in night work –attachment log file

• I would be happy to start my own command line program, preferably in C ++ and Qt, but I can not get to the detail.

In these circumstances, it usually turns out that the reason I can not find what I want is because I'm trying to do something stupid.

Any suggestions would be greatly appreciated.

[Apologies.] I'm not sure I've labeled this well, because I think it's more about reporting errors than manipulating them, but …. " please, re-mark them if there is a better tag than I forgot.]

## postgresql 12 – The installation of extensions on Postgres 12 causes startup ranking errors

I'm trying to create a new instance of Postgres 12 (debian). In trying to create pg_stat_statements a classification error has occurred and the database has stopped. The error follows:

Oct 11 18:43:57 ip-xx-xx-x-xxx xxxx(19): (10-1)  sql_error_code = 00000 LOG:  statement: CREATE EXTENSION pg_stat_statements WITH SCHEMA public
Oct 11 18:43:57 ip-xx-xx-x-xxx xxxx(19): (11-1)  sql_error_code = 42P22 ERROR:  could not determine which collation to use for string comparison
Oct 11 18:43:57 ip-xx-xx-x-xxx xxxx(19): (11-2)  sql_error_code = 42P22 HINT:  Use the COLLATE clause to set the collation explicitly.
Oct 11 18:43:57 ip-xx-xx-x-xxx xxxx(19): (11-3)  sql_error_code = 42P22 STATEMENT:  CREATE EXTENSION pg_stat_statements WITH SCHEMA public

I read the release notes and realized that the ranking of some system tables had been replaced with "C" by default, but that the ranking needed to be utf-8. the pg_stat_statements is added through shared_preload_libraries in postgresql.conf which, in my opinion, does not allow to define the ranking online.

I've read some sources that were trying to determine where the ambiguity was, but I have not been lucky. Can I make suggestions on where I should deepen my research? Or can anyone advise on how to resolve the installed extension blocked? Thank you.

## go – Import a package, get two conflicting errors about the package not found and the package imported but not used

I'm trying to implement the SQL template found here:
https://github.com/DATA-DOG/go-sqlmock

But have a packet error

I've cloned my companies going repo (none of the services have any import errors), added a test file to a service and tried to duplicate the steps in the github for the sqlmock. I have run the command line to get the package, but now, when I try to import, I get two errors:

import (
"Github.com/DATA-DOG/go-sqlmock"
)

1) Can not import github.com/DATA-DOG/go-sqlmock (no package data for github.com/DATA-DOG/go-sqlmock import path)

2) "github.com/DATA-DOG/go-sqlmock" imported but not used

I can see that the packages have been added to the go.mod and go.sum files, but I do not see anything else.

## boot – I'm trying to install Lubuntu on an old XP computer, but hardware errors are occurring.

I wanted to install a new operating system on an old XP computer that I found in a garage sale. This is not a dual boot, I want Linux to be the main operating system of this system.

I've etched Lubuntu on a 4.7GB DvD and I tried to install it on an old 60GB blank hard drive by booting the operating system. At first it seemed to work, the Lubuntu logo showed and did the loading animation, select the language, the memory test was correct, the disk check was working fine, but I have a problem trying to run the real operating system.
It's a black screen with:

0.036033] mce: [Hardware Error]: CPU 0: Machine Check: 0 Bank 0: a200000010
0080f
0.036033] mce: [Hardware Error]: TSC 0
0.036033] mce: [Hardware Error]: PROCESSOR 0:f49 TIME 1009843292 SOCKET 0 A
IC 0 microcode 3
121.664613] print_req_error: I/O error, dev fd0, sector 0 flags 0
133.928675] print_req_error: I/O error, dev fd0, sector 0 flags 0

or just:

123.796324] print_req_error: I/O error, dev fd0, sector 0 flags 0
136.076077] print_req_error: I/O error, dev fd0, sector 0 flags 0

Both allowing me to use the mouse, but not the keyboard.

I do not know what could have gone wrong, Windows XP works well on this problem, and it can clearly recognize the processor model and use it.