Category Archives: How to Fix

XLReport / Excel 2013 Ole Error 800A03EC

Ole Error 800A03EC is a well-known Error, and the cause of the Error is widely debated.
Recently, I have been using XLReport VCL to generate EXcel reports. This control (2003) was a great piece of Delphi7. Unfortunately, the following part did not update it for any reason, and even the company was cancelled.
Encountered this error Delphi developers are not a few, but have not been able to say why, have not been solved!
https://www.board4all.biz/threads/xlreport-excel-2013-ole-error-800a03ec.611247/
Through the debug tracking the problem is that call xlEngine. Procedure of pas units TxlExcelDataSource. GetRangeInfo
When ir.unmerge is executed, Ole Error 800A03EC, a nasty exception, occurs. The general view is caused by the upgrade of Excel version, but the original company has abandoned this product, no one can maintain and modify the source code, it is a pity, so excellent VCL.
Because there is source code, so after foreign experts modify, Delphi XE2 subsequent version can be installed and used, after constant exploration, finally solved the Ole Error 800A03EC exception, for the report development work brought high efficiency!

React bootstrap loading and how to use modules

React – Bootstrap website: http://react-bootstrap.github.io/
The style of react-bootstrap is basically the same as bootstrap, only the methods of how to load and how to use its modules are described here.
1. Open the command prompt and install react-bootstrap under wrokspace on react:

npm install react-bootstrap --save

Ii. React – Bootstrap method for Page loading:

import ReactBootstrap , {Panel,Button,SplitButton,MenuItem,handleSelect} from 'react-bootstrap';

Description: {the Panel, Button, SplitButton, MenuItem, handleSelect}
the Panel in curly braces, Button, SplitButton, MenuItem, handleSelect is ReactBootstrap group, with which the load which, need not all loading, can reduce the volume.

For example, the Panel component in ReactBootstrap is used for the component Pan
The code of Panel component officially provided is: Title is Panel title; PanelsInstance is Panel Content;

const title = (
<h3>Panel title</h3>
);

const panelsInstance = (
<div>
<Panel header={title}>
Panel content
</Panel>
</div>
);

//Pan components

import React,{Component} from 'react';
import {render} from 'react-dom';
import ReactBootstrap , {Panel} from 'react-bootstrap';

export default class Pan extends Component{
//initialize state
constructor(props){
super(props);
this.state = {
title: this.props.title
}
}
render(){
//import official module
const title = (
<h3>Panel title</h3>
);

const panelsInstance = (
<div>
<Panel header={title}> //set title as variable
Panel content
</Panel>
</div>
);

//return
return ( <div>
{panelsInstance}
</div>
)
}

Reprint please indicate the source!

[$ injector:unpr ] Unknown provider:–angular.module () function solution

This is undoubtedly one of the trickiest issues to encounter when developing a project with AngularJS:

ionic.bundle.js:26799 Error: [$injector:unpr] Unknown provider: fifoServiceProvider <- fifoService <- FifoController
http://errors.angularjs.org/1.5.3/$injector/unpr?p0=fifoServiceProvider%20%3C-%20fifoService%20%3C-%20FifoController
    at ionic.bundle.js:13443
    at ionic.bundle.js:17793
    at Object.getService [as get] (ionic.bundle.js:17946)
    at ionic.bundle.js:17798
    at getService (ionic.bundle.js:17946)
    at injectionArgs (ionic.bundle.js:17970)
    at Object.instantiate (ionic.bundle.js:18012)
    at $controller (ionic.bundle.js:23417)
    at Object.self.appendViewElement (ionic.bundle.js:59908)
    at Object.render (ionic.bundle.js:57901)

Encounter this problem, have no hint at all, look for a problem all have no way to start, headache unceasingly.
before we talk about the solution, let’s look at the angular.module function:

angular.module('MyApp',[])

In a SPA project, we can actually add more than one module. The module’s dependencies are then declared in that bracket.
This type of dependent function is called a module declaration.

angular.module('MyServices',['OtherService'])

He also USES it in another way, without the parenthesis:

angular.module('MyServices')

This method without brackets is used to refer to the module. So, the same module, of course, we only need to declare once OK:

angular.module('MyApp',['MyControllers','MyServices','MyDirectives']);

angular.module('MyControllers',[]);
angular.module('MyServices',[]);
angular.momdule('MyDirectives'[]);

So, angular.module(“,[]) is used to declare a module, equivalent to the setter function of an Angular module. Angular.module (), which refers to a module, on which we can add our own definitions.
So I check the code. Almost every service has an Angular. Module (“,[] “) in it. This is used to declare modules. Specially here to write, record down, hope to have encountered the same problem can adopt, this pit is really deep…

The garbage plug-in mixed in chrome causes an error in the front-end JS operation: only one instance of Babel Polyfill is allowed

NPM recently compiled a Vue project and ran it under Chrome, and got off to a bad start:
What r.d. fine is not a function
What is only one instance of babel-polyfill is allowed
I’m surprised that it works fine in QQ browser speed mode, but it doesn’t work well in chrome.
This is the bottom left side of the junk plug-ins, I don’t know when mixed into the Chrome browser. Chrome’s plugin is also written by JS, and it gets mixed up in the same programming domain as its own, causing interference. This thing loads all the other NPM components in the mess.

Solve MySQL error 1698 (28000): access denied for user ‘root’ @’localhost ‘

I believe that many users who just installed MySQL on Linux will encounter this problem, how to solve it?I found the answer on StackOverflow (I used method 1 and it worked), carried it over and translated it into Chinese.
The original address: https://stackoverflow.com/questions/39281594/error-1698-28000-access-denied-for-user-rootlocalhost

Problem description: When I log in to the MySQL database via root, I get an ERROR “ERROR 1698 (28000): Access deniedfor user ‘root’ @’ localhost ‘”.

Answer:
This is because MySQL USES the UNIX Auth_Socket Plugin by default in recent Ubuntu installations (and possibly others).
In simple terms, this means that when DB_users use the database, they will be authenticated through the system user authentication table. You can see if your root user is set to this by using the following command:

$ sudo mysql -u root # I had to use "sudo" since is new installation

mysql> USE mysql;
mysql> SELECT User, Host, plugin FROM mysql.user;

+------------------+-----------------------+
| User             | plugin                |
+------------------+-----------------------+
| root             | auth_socket           |
| mysql.sys        | mysql_native_password |
| debian-sys-maint | mysql_native_password |
+------------------+-----------------------+

As you can see from the query, root is using the AUTH_socket plug-in. There are two ways to solve this problem:
1. You can set your root user to use mysql_native_password plug-in 2. You can create a new database user that is consistent with your system user (recommended)
(Note: Method 2 meets the requirements of auth_Socket plug-in)
Option 1:

$ sudo mysql -u root # I had to use "sudo" since is new installation

mysql> USE mysql;
mysql> UPDATE user SET plugin='mysql_native_password' WHERE User='root';
mysql> FLUSH PRIVILEGES;
mysql> exit;

$ service mysql restart

Option 2 (substitute your operating system username for YOUR_SYSTEM_USER) :

$ sudo mysql -u root # I had to use "sudo" since is new installation

mysql> USE mysql;
mysql> CREATE USER 'YOUR_SYSTEM_USER'@'localhost' IDENTIFIED BY '';
mysql> GRANT ALL PRIVILEGES ON *.* TO 'YOUR_SYSTEM_USER'@'localhost';
mysql> UPDATE user SET plugin='auth_socket' WHERE User='YOUR_SYSTEM_USER';
mysql> FLUSH PRIVILEGES;
mysql> exit;

$ service mysql restart

Remember that if you choose to use Method 2, you should connect to MySQL by using your operating system user name (mysql-u YOUR_SYSTEM_USER).
Note: In some operating systems (such as Debian), the ‘auth_Socket’ plugin is called ‘unix_socket’, so the corresponding SQL command statement should be UPDATE User SET plugin= ‘unix_socket’ WHERE user = ‘YOUR_SYSTEM_USER’.

error: unclosed character literal (How to Fix)

Error: Error: the unclosed character literal value that has not ended

String variables using single quotes, double quotes, very low error.
The difference between char and String in Java
1. Char represents characters, defined with single quotes, and can store only one character, e.g. Char c=’x’;
A String is a String, defined in double quotes, that can store one or more characters, such as String name=” Tom “;

2. Char is the basic data type, while String is a class with object-oriented characteristics that can call methods such as name.length() to get the length of the String.

Network Error (dns_unresolved_hostname) -postman

directory
Background error reporting solution

background
Using Postman to access the jSON-Server’s virtual data failed, but there was no problem opening it locally
An error

The solution
File-> setting-> proxy-> Cancel the Add a custom proxy configuration

to cancel the Add a custom proxy configuration

the send again, success (, ̀ omega, ́) y, pay attention to choose the body – & gt; Json format

net core HTTP Error 502.5 – ANCM Out-Of-Process Startup Failure

Personal blog: Yedajiang44.com/blog
Vs was updated yesterday. When opening the project and running today, it directly reported the following error:

HTTP Error 502.5 - ANCM Out-Of-Process Startup Failure
Common causes of this issue:
The application process failed to start
The application process started but then stopped
The application process started but failed to listen on the configured port
Troubleshooting steps:
Check the system event log for error messages
Enable logging the application process' stdout messages
Attach a debugger to the application process and inspect
For more information visit: https://go.microsoft.com/fwlink/?LinkID=808681

Solution: just reinstall the corresponding NET Core SDK of the project, and remember to restart!

Giterror: error cloning remote repo ‘origin’ hudson.plugins.git .GitException

Last night the west wind withered green trees, alone on the tall buildings, look to the horizon road
Jenkins + GitLab continuous integration encountered the following error:

ERROR: Error cloning remote repo 'origin'
hudson.plugins.git.GitException: Could not init /root/.jenkins/workspace/eureka-service
	at org.jenkinsci.plugins.gitclient.CliGitAPIImpl$5.execute(CliGitAPIImpl.java:787)
	at org.jenkinsci.plugins.gitclient.CliGitAPIImpl$2.execute(CliGitAPIImpl.java:579)
	at hudson.plugins.git.GitSCM.retrieveChanges(GitSCM.java:1146)
	at hudson.plugins.git.GitSCM.checkout(GitSCM.java:1186)
	at org.jenkinsci.plugins.workflow.steps.scm.SCMStep.checkout(SCMStep.java:120)
	at org.jenkinsci.plugins.workflow.steps.scm.SCMStep$StepExecutionImpl.run(SCMStep.java:90)
	at org.jenkinsci.plugins.workflow.steps.scm.SCMStep$StepExecutionImpl.run(SCMStep.java:77)
	at org.jenkinsci.plugins.workflow.steps.SynchronousNonBlockingStepExecution$1$1.call(SynchronousNonBlockingStepExecution.java:50)
	at hudson.security.ACL.impersonate(ACL.java:290)
	at org.jenkinsci.plugins.workflow.steps.SynchronousNonBlockingStepExecution$1.run(SynchronousNonBlockingStepExecution.java:47)
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
	at java.lang.Thread.run(Thread.java:748)
Caused by: hudson.plugins.git.GitException: Error performing command: git init /root/.jenkins/workspace/eureka-service
	at org.jenkinsci.plugins.gitclient.CliGitAPIImpl.launchCommandIn(CliGitAPIImpl.java:2023)
	at org.jenkinsci.plugins.gitclient.CliGitAPIImpl.launchCommandIn(CliGitAPIImpl.java:1984)
	at org.jenkinsci.plugins.gitclient.CliGitAPIImpl.launchCommandIn(CliGitAPIImpl.java:1980)
	at org.jenkinsci.plugins.gitclient.CliGitAPIImpl.launchCommand(CliGitAPIImpl.java:1612)
	at org.jenkinsci.plugins.gitclient.CliGitAPIImpl$5.execute(CliGitAPIImpl.java:785)
	... 14 more
Caused by: java.io.IOException: Cannot run program "git" (in directory "/root/.jenkins/workspace/eureka-service"): error=2, 没有那个文件或目录
	at java.lang.ProcessBuilder.start(ProcessBuilder.java:1048)
	at hudson.Proc$LocalProc.<init>(Proc.java:249)
	at hudson.Proc$LocalProc.<init>(Proc.java:218)
	at hudson.Launcher$LocalLauncher.launch(Launcher.java:935)
	at hudson.Launcher$ProcStarter.start(Launcher.java:454)
	at org.jenkinsci.plugins.gitclient.CliGitAPIImpl.launchCommandIn(CliGitAPIImpl.java:2012)
	... 18 more
Caused by: java.io.IOException: error=2, no such file
	at java.lang.UNIXProcess.forkAndExec(Native Method)
	at java.lang.UNIXProcess.<init>(UNIXProcess.java:247)
	at java.lang.ProcessImpl.start(ProcessImpl.java:134)
	at java.lang.ProcessBuilder.start(ProcessBuilder.java:1029)
	... 23 more

Solutions:
To install Git on Jenkins’ host, execute the following command:
yum install git
Testing: