Aaditya Srivastva

Can't connect to MySQL server on '127.0.0.1' (10061) (2003)

Getting the error “can t connect to mysql server on 127.0 0.1” means you are migrating the MySql database files to a new location. If you have already installed MySQL on a Windows machine make sure that it is running as a service. You can check by doing the following steps showm below: Start --> services -->…

Python

Answered Jul 7, 2021 · 1.5K Views Read answer →

StandardSetController - how does it work?

The StandardSetController uses a database cursor to paginate through the results. Unlike using LIMIT+OFFSET, this method supports 10,000 rows of data, the results will not change each time a new page is pulled back from the database (we call this a "consistent view" of the data), no custom code is required to…

Power BI

Answered Jul 4, 2021 · 1.5K Views Read answer →

git undo commit before push - how to remove a git commit which has not been pushed?

To solve git revert commit before push you can follow the below command: $ git reset HEAD~1Further, you should check whether the working copy is clean by git status or you have pushed your changes to remote $ git revert HEADNote: This command will revert or remove the last one commit or change and then you can push

Devops

Answered Jun 5, 2021 · 910 Views Read answer →

Change directory command in Docker?

Easy ! Just use the WORKDIR command to change the dockerfile change directory you want to. Any other commands you use beyond this command will be executed in the directory you have set. Here's an example: RUN git clone XYZ WORKDIR "/XYZ" RUN makeIt is also a better practice to make use of WORKDIR in docker. OR You can…

Business Analyst

Answered May 26, 2021 · 1.0K Views Read answer →

Extract the first and last row of a dataframe in pandas

The most simple way is .iloc[[0, -1]] to solve pandas last row. Refer to the following code: df = pd.DataFrame({'a':range(1,5), 'b':['a','b','c','d']}) df2 = df.iloc[[0, -1]] print df2 a b 0 1 a 3 4 d

Salesforce

Answered May 16, 2021 · 891 Views Read answer →

How to make execution pause, sleep, wait for X seconds in R?

You can use the Sys.sleep function from the base package to suspend execution for a given time interval. According to R Documentation: Using this function allows R to temporarily be given very low priority and hence not to interfere with more important foreground tasks. Typical use is to allow a process launched from…

Business Analyst

Answered May 6, 2021 · 934 Views Read answer →

com.jcraft.jsch.JSchException: UnknownHostKey

Getting jcraft.jsch.JSchException: UnknownHostKey” exception.Depending on what program you use for ssh, the way to get the proper key could vary. Putty (popular with Windows) uses their own format for ssh keys. With most variants of Linux and BSD that I've seen, you just have to look in ~/.ssh/known_hosts. I usually…

Python

Answered May 1, 2021 · 2.4K Views Read answer →

.gitignore and the following untracked working tree files would be overwritten by checkout

The question seems like you want the files ignored but they have already been committed. For that .gitignore does not affect files that are already in the repo so they need to be removed with git rm --cached The --cached will prevent it from having any effect on your working copy. After the files are removed from the…

Python

Answered Apr 27, 2021 · 1.1K Views Read answer →

Python error "TypeError: Can't convert 'int' object to str implicitly"

If you are facing typeerror: can't convert 'float' object to str implicitly error then the main point is that you cannot concatenate a string and an integer. Convert the integer explicitly to string and then try concatenating. Perform the following command to explicitly convert the integer to string: print("Ok. Your…

Python

Answered Apr 24, 2021 · 957 Views Read answer →

Azure SDK 2.5.1 fails to Publish cloudService

for installing azure sdk 2.5, simply try to remove the Authoring Tools v2.5.1 from Programs and Features, just reinstall it using Web Platform Installer or directly using the links provided below: http://download.microsoft.com/download/1/E/7/1E76DD6F-66F1-47E0-A76A-3BBAAC617316/MicrosoftAzureAuthoringTools-x64.msi…

Business Analyst

Answered Apr 24, 2021 · 658 Views Read answer →

tabPanel switchType=server how to track the active tab?

Your action function for switchtype should look like the following: Controller: Private String var = 'photos'; public void setVar(String n) { var = n; } public String getVar() { return var; }

Business Analyst

Answered Apr 21, 2021 · 605 Views Read answer →

Communications link failure: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException

Your exception seems to indicate that your MySQL server is not available. Exception in thread “main” com.mysql.exceptions.jdbc4. CommunicationsException: Communication link failure. The last packet sent successfully to the server was 0 milliseconds ago. No packet has been received by the driver from the server. Now,…

SQL Server

Answered Apr 20, 2021 · 3.1K Views Read answer →