Web Solutions and Technical Support Resources





SQLSTATE42000 syntax error or access violation

This article will guide you on methods to resolve 'sqlstate42000 #syntax error or access violation' which occurs due to wrong syntax entry or extra space or no space in the user's #SQL #query. 

The #1064 error displays any time you have an issue with your SQL syntax, and is often due to using reserved words, missing data in the database, or mistyped/obsolete commands.

As you can see there is more than one cause for the 1064 error within MySQL code. Now, you know how to correct the issues with your SQL Syntax, so your query can run successfully. This list will be updated as more specific instances are reported.

Read More




Install and Configure OpenSSH on windows

This article will guide you on steps to install and configure #OpenSSH on #windows. Also, we saw some common errors relating to OpenSSH.

OpenSSH is the premier connectivity tool for remote login with the #SSH protocol. It encrypts all traffic to eliminate eavesdropping, connection hijacking, and other attacks.

i. To install OpenSSH, start Settings then go to Apps > Apps and Features > Manage Optional Features. 

ii. Scan this list to see if OpenSSH client is already installed. 

iii. If not, then at the top of the page select "Add a feature", then: To install the OpenSSH client, locate "OpenSSH Client", then click "Install".

To Enable the OpenSSH Server in Windows 10:

1. Open the #Settings app and go to #Apps -> Apps & features.

2. On the right, click Manage optional features.

3. On the next page, click the button Add a feature.

4. In the list of features, select OpenSSH Server and click on the Install button.

5. Restart Windows 10.

Read More




Zero sized reply squid error in Horde

This article will guide you on how to fix #Horde webmail 'Zero sized reply squid #error' by making changes to the system configuration file of #Apache. This error occurs in webmail in Plesk after the upgrade of the Plesk version.

#Squid is a caching and forwarding #HTTP web 3proxy. It has a wide variety of uses, including speeding up a web server by caching repeated requests, caching web, DNS and other computer network lookups for a group of people sharing #network resources, and aiding security by filtering traffic.

To fix this error:

1. Try to add to squid.conf an option:

server_http11 on

and restart squid.

2. Put the website to Proxy Exception.

Read More




Recover deleted items in Microsoft outlook

This article will guide you on methods to recover deleted #emails in #Outlook. This is possible by retrieving contents from the Recoverable Items folder. 

By default, the deleted #items won't be included while searching in Outlook. Actually Outlook provides you with a feature of automatically searching all folders include emails in the Deleted Items folder in each #data file.

To Recover Permanently Deleted #Hotmail Messages:

1. Go to Outlook.com and log in to your Live, Hotmail, or other Microsoft email account. 2. Select the Deleted Items folder in the left pane. 

3. Select Recover items deleted from this folder at the top of the message list. The Recoverable Items folder will open.

Read More




Windows Activation Error Code 0xc004f074

This article will guide you on methods to fix #Windows activation error code #0xc004f074 and its causes.

When attempting to activate the Windows operating system, users sometimes receive the 0xC004f074 error code. This is a Windows Activation error that occurs when Windows is unable to reach your company's activation service or system administrator.

Changing your Windows #Product Key does not affect your personal files, installed applications and settings. Enter the new product key and click Next and follow the on screen instructions to #activate over the Internet.

To fix error 0xc004f074 in Windows 10:

1. Use the slmgr. vbs command.

2. Use the Slui 3 command. While on your start screen you need to press and hold the button Windows and the button R.

3. Run SFC scan.

4. Run the Update and Activation #Troubleshooters.

5. Contact #Microsoft Support.

Read More




ISPConfig 500 internal server error

This article will guide you on different ways to resolve #ISPConfig 500 internal server #error and also you will learn about some factors that triggers this error such as exceeded MaxRequest value or PHP-fpm issue. 

The HyperText Transfer Protocol (#HTTP) #500 Internal Server Error server error response code indicates that the server encountered an unexpected condition that prevented it from fulfilling the request. Usually, this indicates the server cannot find a better 5xx error code to response.

The 500 internal server error runs on every page of your site when there's a problem with the server or file system that's powering your site. 

The cause most likely occurs in the root directory, where your WordPress files are, but it can also be caused by a problem on your host's server.

To Resolve 500 Internal Server Error:

1. Debugging the Issue. The first step is to make sense of the situation and try to make sense of the error.

2. Check if the Admin Works.

3. Revert Recent Changes.

4. Audit Your #Plugins/Extensions/Modules.

5. Check File Permissions.

6. Increase PHP #Memory Limit.

Read More