ASPPortal | NovoCRM | Spaminator | Knowledgebase Articles

ASPPortal / NovoCRM / Spaminator - User Forum

Thu, 02 Jul 2009 02:32:05 GMT

You can access the public forum system by using the link below.

Please note that you will need to register on the forum.

http://forum.thedevfactory.com

Active Server Pages error 'ASP 0131' Disallowed Parent Path

Thu, 02 Jul 2009 02:32:05 GMT

Error
Active Server Pages error 'ASP 0131' Disallowed Parent Path /junkbox/meadmin/adminlogin.asp, line 1 The Include file '../common/connection_open.asp' cannot contain '..' to indicate the parent directory.

Solution
1. Open the Internet Services Manager in the Microsoft Management Console (MMC).
2. Right-click on your Default Web Site and select Properties.
3. Click the Home Directory tab.
4. Click the Configuration button.
5. Click the App Options tab.
6. Click to select the Enable Parent Paths checkbox.
7. Click the OK button until you return to the MMC

Active Server Error (ASP 0113) script time out /spam/meadmin/admin_main.asp

Thu, 02 Jul 2009 02:32:05 GMT

Error;
Active Server Error (ASP 0113) script time out /spam/meadmin/admin_main.asp.

Solution;
You will need to download Spaminator version 1.3.1 Older versions of Spaminator does not work with MEFilter 6.5 or newer.

Microsoft JET Database Engine error '80004005' Could not use ''; file already in use.

Thu, 02 Jul 2009 02:32:05 GMT

Error;
Microsoft JET Database Engine error '80004005' Could not use ''; file already in use. /common/connection_open.asp, line 41

Resolution;
You could receive the above error when the MEConsole application has been opened on the server and a user tries to login to the spaminator application.

This is not a Spaminator error but simply a limitation when using a MS Access database. We strongly suggest that you use a MS SQL database backend with the Spaminator system, this will improve over all performance.

An expression of non-boolean type specified in a context where a condition is expected, near 'domainname'.

Thu, 02 Jul 2009 02:32:05 GMT

Error;
Microsoft OLE DB Provider for SQL Server error '80040e14'
An expression of non-boolean type specified in a context where a condition is expected, near 'domainname'.
/meadmin/admin_main.asp, line 375

Solution;
This issue has been addressed in the 1.3.0 version, you can download it from the link below.

Missing MEHoldingUserLoad Stored Procedure in the MEFilter SQL database.

Thu, 02 Jul 2009 02:32:05 GMT

Error;
Missing MEHoldingUserLoad Stored Procedure in the MEFilter SQL database.

Resolution;
Run the sql script below to recreate the stored procedure.

*** start of SQL script ***

set ANSI_NULLS ON GO set QUOTED_IDENTIFIER ON GO CREATE PROCEDURE [dbo].[MEHoldingUserLoad] ( @TheRecipAddress nvarchar(255) ) AS SELECT MEHoldingAreas.HoldingAreaName, MEHolding.MessageDate, MEHolding.SenderAddress, MEHolding.PRAAddress, MEHolding.MessageSubject, MEHolding.MessageFilename FROM MEHoldingAreas INNER JOIN MEHolding ON MEHoldingAreas.HoldingAreaNo = MEHolding.HoldingAreaNo WHERE (MEHolding.RecipAddress LIKE @TheRecipAddress) ORDER BY MEHoldingAreas.HoldingAreaName, MEHolding.MessageDate GO

*** end of SQL script ***

Customer Portal - How does it work

Thu, 02 Jul 2009 02:32:05 GMT

The Customer Portal allows NovoCRM users to setup a web based lead registration system and contact management portal.

Once a new registration occurs NovoCRM will create a new Contact which allows the user to login to the Customer Portal and a new Lead will be created that is linked to the Contact. This allows the Lead to manage their own contact information and interact with NovoCRM. Users can then see new activities created when a Customer Portal users asks a question or a new Support Case if the user has a problem or query.

Customer Portal users can also be linked to a Account and view the products purchased by that Account and all Support Cases for the specific Account. Allowing you to automate the interaction between your customers and your sales and support teams.

The Customer Portal ships with NovoCRM 2.6.2.x and higher and is included in the license purchase.

This simplified step-by-step procedure has been proven to be effective countless times before. Taking the whole concept from the way broadband technology works, what this setup gives you is a seamless, zero-hitches management tool guaranteed to keep your operations running smoothly and well-organized.

NovoCRM Service will not start.

Thu, 02 Jul 2009 02:32:05 GMT

NovoCRM Server runs as a Windows Service called "NovoCRM Server" it starts automatically when Windows starts.

Error;
The NovoCRM Service (Server) does not start after I installed it.

Resolution;
The NovoCRM Service (Server) reads from the system registry to locate the server_connect file. The registry location is "HKEY_LOCAL_MACHINE\SOFTWARE\NovoCRM\NovoCRM Server" the key is called "server_connect_path".

If you installed NovoCRM to a different location you may need to change the path to point to the new install location.

This may happen if you install a new version and select a different location than the default install location. The "server_connect_path" is point to the wrong location and the NovoCRM Service (Server) will not be able to find it and will not start. Once the path points to a valid location the server will start.

The default login details for NovoCRM

Thu, 02 Jul 2009 02:32:05 GMT

When you download NovoCRM for evaluation or when you create a new database the default username and password is automatically set.

The default login details are:

Username: admin

Password admin

Please contact the support team if you have any problems using this login.

www.thedevfactory.com

Database support for MS SQL, MS Access and mySQL

Thu, 02 Jul 2009 02:32:05 GMT

When NovoCRM was released support for MS SQL, MS Access and mySQL was provided. The current release (2.5.x.x) only supports MS SQL and MS Access database options for the NovoCRM Server.

We will provide the support back for mySQL in Q4 2007 but we recommend users use NovoCRM with MS SQL Express (Free or Enterprise edition) for the best performance.

Error
Unable to find support for mySQL in version 2.5.x.x

Resolution
We suggest using MS SQL Express or MS SQL in NovoCRM. The support for mySQL will be added back after release 2.6.0.0 in Q4 2007.

Please feel free to contact the support team to assist you in converting existing mySQL data to MS SQL or wait to upgrade later in 2007 once mySQL support is back.

NovoCRM Server does not process invalid e-mail addresses when sending e-mails

Thu, 02 Jul 2009 02:32:05 GMT

The NovoCRM can send e-mail using MS Outlook or the NovoCRM Server. We have added functionality to validate e-mail addresses in the NovoCRM Server and Client. This will ensure that any invalid e-mail addresses do not keep up e-mail in the queue and the NovoCRM Server will mark these messages invalid e-mail address messages.

The NovoCRM Client will also check before sending if the e-mail address is valid or not. A warning will be shown but we will still allow the e-mail to be processed. The NovoCRM may mark a invalid e-mail as an error and it will not be processed.

Error;
NovoCRM server gets stuck when a invalid or bad e-mail address is processed in the e-mail queue.

Resolution;
NovoCRM release 2.6.0.0 will address this issue by verifying the e-mail address format before sending the server will also mark invalid addresses while processing other messages.

Please contact our support team if you have any questions on the e-mail functionality in NovoCRM.

Shared calendars in NovoCRM

Thu, 02 Jul 2009 02:32:05 GMT

Calendar sharing has been added to NovoCRM release 2.6.0.0. This allows users to give other users in NovoCRM access to their calendar. Users can now also view mutiple calendars at once and compare availability in seconds.

The calendar sharing can also be used to manage boardrooms, meeting rooms or any other location by adding a user with the name of that room and then sharing it with other users.

Error;
Share calendar with other users and use calendar to manage shared facilities like meeting rooms.

Resolution;
NovoCRM 2.6.0.0 has addressed this issue with shared calendars that allow any user to grant access to their calendar for any user in NovoCRM.

By adding a user that represents a boardroom, meeting room or any other location and then sharing the calendar with other users you can easily setup a central calendar system in NovoCRM.

This functionality expands the NovoCRM calendar module to manage more than just activities and to do items but to also share information and manage spaces or any other location.

NovoCRM Express supported databases

Thu, 02 Jul 2009 02:32:05 GMT

Supported Database	Tested Platforms
MS SQL
MS SQL 2005	Windows XP, Vista, Vista 64bit
MS SQL 2008	Windows XP, Vista, Vista 64bit

MS SQL Express
MS SQL 2005	Windows XP, Vista, Vista 64bit
MS SQL 2008	Windows XP, Vista, Vista 64bit

If you have any questions please contact support@novocrm.com

HTML Text Viewer uses double spacing on enter (carage return)

Thu, 02 Jul 2009 02:32:05 GMT

NovoCRM supports the use of rich text in most large text fields, allowing users to enter the text and format it as needed.

When the Enter key is pressed double spacing occurs and it seems that the text viewer inserts a new line. This can be fixed by holding down the SHIFT key and pressing enter.

When this is done only a single spacing occurs and no double spacing as is the case without the SHIFT key.

For more information please contact our support team.

NovoCRM Installation error: The service already exists.

Thu, 02 Jul 2009 02:32:05 GMT

The NovoCRM Server installs a windows service call "NovoCRM Server".
This service starts automatically when you login to your windows session or when the computer is turned on.

When you install a new version of NovoCRM you may get the error indicating that the service already exists.

Resolution

Open up the Control Panel and select Administrative Tools.
Select services and move to the service called NovoCRM Server.
If it is started then stop it. Once the service is stopped proceed to start it again.
Now you can double click on the desktop icon and open the NovoCRM Server Admin Utility.
It should not try to install again as the service is already running.

You can then login to the NovoCRM Server Admin utility and setup your database connections or upgrade an existing database.

If you have any other problems please contact our support team.

NovoCRM Express Demo login details

Thu, 02 Jul 2009 02:32:05 GMT

You can login to our online demo of NovoCRM Express by using the following details.

http://demo.novocrm.com
Username: beta
Password: beta

If you have any questions please contact support@novocrm.com

NovoCRM Express supported web browsers

Thu, 02 Jul 2009 02:32:05 GMT

Supported Browsers	Tested Platforms
IE
Internet Explorer 6	Windows XP
Internet Explorer 7	Windows XP, Vista, 7
Internet Explorer 8	Windows XP, Vista, 7

*Firefox*
Firefox 1.x	Windows XP
Firefox 2.x	Windows XP, Vista
Firefox 3.x	Windows XP, Vista, 7, Mac OS X, Linux Ubuntu 8.x,9,x

*Safari*
Safari 3.x	Mac OS X
Safari 4.x	Mac OS X, Windows XP, Vista
iPhone Browser	iPhone 3G 2.2.1

*Opera*
Opera 9.6	Mac OS X, Windows Vista, Linux Ubuntu 8.x,9.x

Google Chrome
Chrome	Windows XP, Vista

If you have any questions please contact support@novocrm.com

ASPPortal ClientCode Online download missing

Thu, 02 Jul 2009 02:32:05 GMT

The ASPPortal system provided users that purchased with a clientcode that they could use to download the updates to the latest ASPPortal SQL version.

This has been removed from our new website but we still provide a download link on request from existing Clients, if you need to download a copy simply send your request to support@aspportal.net and make sure to include the email address that you used when you pruchased the product online or using paypal.

If you have any other questions please contact support@thedevfactory.com

Running NovoCRM Server as a Windows Service

Thu, 02 Jul 2009 02:32:05 GMT

The NovoCRM can run as a Windows Service if you use version 2.5.1.0 or higher. By default the server will run and automatically start when your machine starts.

Service Name;
The service name is "NovoCRM Server" and can be accessed from the services management console under Administartive Tools in the Control panel.

The NovoCRM Server Admin Utility is now used to administer the server and can be used to manage remote NovoCRM Servers.

Setup a database connection (MS Access, MS SQL and MS SQL Express)

Thu, 02 Jul 2009 02:32:05 GMT

NovoCRM supports MS Access, MS SQL and MS SQL Express database engines.

MS Access;
Just browse to the database that is located on your network or on the server that is running the NovoCRM Server. Only the NovoCRM Server needs access to the database for it to work.

Save the database connection and restart the NovoCRM Server / Service.

MS SQL and SQL Express;
Database Name: The name of the database or catalog in SQL.

Server Name: This is the SQL Instance name or IP Address of the machine hosting SQL. For SQL Express you need to add "\SQLEXPRESS". For example: SERVERNAME\SQLEXPRESS

Authentication: Select Windows Authentication for default installations. If you have a custom login select SQL Authtentication.

Can i modify my portal source code?

Thu, 02 Jul 2009 02:32:05 GMT

Yes, ASPPortal is open source so you can modify and change the source code for your own projects.

We will not support any custom code you develope, but all default code will be supported.

If you have any questions please contact our support desk www.aspportal.net

How do i download the latest Spaminator version?

Thu, 02 Jul 2009 02:32:05 GMT

You can download the latest Spaminator version from our website www.aspportal.net this includes the source code and instructions needed to install and configure your Spaminator system.

ASPPortal Release notes

Thu, 02 Jul 2009 02:32:05 GMT

You can view the ASPPortal release notes online by using the link below.

http://www.aspportal.net/aspportal-release-history.aspx

If you have any questions please contact our support team support@aspportal.net

Error adding license key to NovoCRM

Thu, 02 Jul 2009 02:32:05 GMT

When you login to the NovoCRM Client or Server Admin Utility the server will verify that a valid license key exists. If one is not found a dialog will request you to add a license key.

Error;
License key shows as "Invalid License Key" or License does not add.

Resolution;
The license key you enter will be checked by the NovoCRM Server first and then commited to the database. If the license key message indicates "Invalid License" the key my be in the wrong format or may be incomplete. Please ensure that your database connection is correct and that you have created the tables in the database using the Admin Utility.

If the license key shows up as expired it indicates to a evaluation license that has expired. The default evaluation period is 30 days and you will need to contact the sales team to fix this problem.

If you have any other licensing questions please send them to our support team.

How do i get the LDAP login to work with the ASPPortal system?

Thu, 02 Jul 2009 02:32:05 GMT

With the release of ASPPortal 4.0.1 we have included the option to authneticate against your Microsoft Active Directory server using the LDAP protocol.

All you need is to create a user in the aspportal database that has the same username as the LDAP user, then set the security group in your ASPPortal database for this user.

Now when they login they use their domain username and password with the domain name. And they will be able to login to the ASPPortal system with their LDAP password. If you need any help please contact support@aspportal.net

How do I install a theme that I downloaded from ASPPortal?

Thu, 02 Jul 2009 02:32:05 GMT

Theme Installation Steps:

1. Download the theme from the ASPPortal website.
2. Open the ZIP you downloaded.
3. Place the image file into the \images\banners folder in your portal
4. Place the CSS file into the \common\css in your portal
5. Login to your ASPPortal and click on Portal Options
6. In the Stylesheet dropdown select the CSS file you just added
7. Update the banner file name to point to your image IE - ../../images/banners/urban_option.jpg
8. Click on Update and your theme will be applied.

If you have any questions please contact support@aspportal.net

Password encryption options

Thu, 02 Jul 2009 02:32:05 GMT

The ASP Portal system does ship with a default password encryption package, we use a encryption key that is 512bit's long.

Our encryption is not 512bit but the key used contains 512bit's you can upgrade the encryption by changing the follwoing functions in the code;

Page: i_common.asp

Functions to change: Function Encrypt Function DeCrypt you will also need to change the g_key value for the encryption.

Adding Security to a page or a new page you add to the system

Thu, 02 Jul 2009 02:32:05 GMT

You can add your own security to the portal system or to a new page.
Simply call the builtin security function.

'Check Security for page call check_security(1,"../users/login.asp")

if you have any questions please contact our support team support@aspportal.net

Is the ASPPortal username and password case sensitive?

Thu, 02 Jul 2009 02:32:05 GMT

Yes the ASPPortal password is case sensitive, but the username is not.

If you need more information please contact support@aspportal.net

Using IIS 6.0 as your web server

Thu, 02 Jul 2009 02:32:05 GMT

If you use IIS 6.x as your web server then you must allow a few things to run the ASP Portal application.

Resolution

-Allow ASP pages
-Allow parent paths for your website
-Allow read and write access for the ISUR user to the data and /content/stats folders

If you need more information please contact support@aspportal.net

The default login details for the ASP Portal application

Thu, 02 Jul 2009 02:32:05 GMT

The default login details for the ASP Portal application

Username: admin
Password: admin

Also note that the IUSE user must have read/write access to the data folder and the content/stats folder.
If you need more help Please contact support@aspportal.net

How to install aspportal

Thu, 02 Jul 2009 02:32:05 GMT

First unzip the aspportal zip file you downloaded into your root of your webserver or if you created a folder to be the root of your site, then use that folder.

Now edit the global.asa file as per the instructions in teh readme.txt file

Now make sure your IUSER account has read write access to the database and that you allow parent paths.

Now browser to see if your portal is running, if you get a 403 error, it means the connection_open.asp settings to the database is incorrect.

If you still need help please contact support@aspportal.net

Error - HTTP 403 You are not authorized to view this page

Thu, 02 Jul 2009 02:32:05 GMT

If you recieve the following error;
HTTP 403 You are not authorized to view this page

What you need to do to resolve tihs is the follwoing steps

In your global.asa check the the database path is correct, by default the portal will try to auto detect this if this fails then you will get this message.
Simply replace this section in your global.asa;
" & server.MapPath("../data/aspportal.mdb") & ";

With

c:\portal\data\aspportal.mdb
or the actual physical path to the database, also make sure the ISUR has read and write access to this folder.

The object has an invalid ProgID of 'scripting.dictionary'

Thu, 02 Jul 2009 02:32:05 GMT

Error;
Error Type:
Active Server Pages, ASP 0134 (0x80004005)
The object has an invalid ProgID of 'scripting.dictionary'.
/amazing/global.asa, line 1

Solution;
http://support.microsoft.com/default.aspx?scid=kb;en-us;317708
You receive an "Unknown" error message when you open a table in
Access 2002

How to use the Image/photo gallery in ASPPortal

Thu, 02 Jul 2009 02:32:05 GMT

To configure the Image/Photo gallery follow the steps below.

In your portal folder content/gallery/
1. create a folder that will hold your gallery, note that the folder name will be used as the gallery name.
2. After you created the folder simply copy your photo's into the folder.

Now click on the gallery link in your menu and you should see your gallery, click on it and you will see your images.

If you click on the images they will open in actual size in a new browser.
In ASPPortal version 4 we have added a image upload section in the admin module.

ASP Portal Error after completing setup

Thu, 02 Jul 2009 02:32:05 GMT

Issue;
If you recieve the default ASP Portal error screen after you have installed the ASP Portal application and you are not sure what the issue could be, please check the following.

Resolution;
If you are using the SQL version make sure that you created a empty database and that you execute the database creation scripts.

Microsoft VBScript runtime error '800a0046' Permission denied: 'CreateObject'

Thu, 02 Jul 2009 02:32:05 GMT

Issue
Microsoft VBScript runtime error '800a0046'

Permission denied: 'CreateObject'

common/includes/i_common.asp, line 16

Resolution
http://support.microsoft.com/kb/197964
http://support.microsoft.com/kb/q278751/