Web Solutions and Technical Support Resources





An error has occurred in DNN Websites

This article will guide you on how to easily fix 'An #error has occurred' error message appears in #DNN #Pages which occurs when there is a null entry in the #database table. We also looked into the steps for adding the temporary URL.
When trying to add a file attachment to the #DotNetNuke forum module, we received an error that looked like this:
An Error Has Occurred When Attempting To Save The File C:\webroot\site\site.com\wwwroot\Portals\0\imge.jpg. Please Contact Your Hosting Provider To Ensure The Appropriate Security Settings Have Been Enabled On The Server.
If you have a superuser account (common username is HOST) you can login and go to the Host menu, and see if you have an EXTENSIONS page listed, from that page you can see what version of DNN you are on. you can also try the HOST/HOST SETTINGS page.

Read More




Webmail timeout issue in DirectAdmin


This article will guide you on how to resolve #timeout #error in #webmail in #DirectAdmin. Generally, webmail timeout issue can occur if the timeout value is exceeded.
The term timeout or time-out has several meanings, including: A network parameter related to an enforced event designed to occur at the conclusion of a predetermined elapsed time.
To fix Webmail timeout error in DirectAdmin:
Modify the config file "/var/www/html/webmail/inc/config.php" or in /var/www/html/webmail/inc/config.security.php
and set
Code:
# Session timeout for inactivity
#
$idle_timeout = 10; //minutes
to whatever value you need.

Read More




Database version or build from backup file

This article will guide you on how to determine the database #version or build from a #backup file.
To know what #SQL version a #database is:
The first is by using either Enterprise Manager or SQL Server Management Studio and right clicking on the instance name and selecting Properties. In the general section you will see information such as on the following screenshots. The "Product version" or "Version" gives you a number of the version that is installed.
In order to find the SQL Server version from a bak file:
1. Here is the output returned by the RESTORE HEADERONLY statement. Here you will see a DatabaseVersion column that contains the value.
2. That's how you find out from which version of SQL Server a given backup file came.

Read More




Improve SQL Server Bulk Data Import Performance

This article will guide you improve #bulk #data #import #performance. The BULK INSERT command is much faster than bcp or the data pump to perform text file import operations, however, the BULK INSERT statement cannot bulk copy data from #SQL Server to a data file. Use the bcp utility instead of DTS when you need to export data from the SQL Server table into a text file.
To Speed up SQL Bulk Insert with #transactions:
1. Declare the variables that store the number of desired items ( @items ), the size of the chunks( @chunk_size ) and the counter of the number of executed inserts( @counter )
2. Open the first transaction and initialize the while loop.

Read More




Rsync to Exclude Files and Directories

This article will guide you on easily exclude #files and #directories using the #rsync #command.
The --exclude option with the rsync command uses relative paths to the source #directory. Append the --exclude option to the rsync command, followed by the relative path to a directory or file(s).
The basic syntax for the rsync exclude option looks like this:
rsync [OPTIONS] --exclude 'file_or_directory' source/ destination/
Replace source/ with the directory name you want to use as a source for data transfer to another location.
Replace destination/ with the directory name rsync will use as the target location for your data. If the directory does not exist, rsync creates one for you and transfers the files to that directory.

Read More




Install Froxlor on CentOS 7

This article will guide you on steps to #install Froxlor on #CentOS 7 and also resolve common Froxlor #errors.
#Froxlor is a simple but powerful server administration #software for managing #domains, emails and files.
To install Froxlor web hosting control panel:
1. Ensure that your webserver serves /var/www.
2. Extract froxlor into /var/www.
3. Point your browser to http://[ip-of-webserver]/froxlor.
4. Follow the #installer.
5. Login as #administrator.
6. Adjust "System > Settings" according to your needs.
7. Choose your distribution under "System > Configuration".
8. Follow the steps for your services.

Read More