Intranet Open Source FAQs
Q. Operation must use an updateable query
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
A. If you see this error it will normally be the first time you use Intranet Open Source. It normally means that there is a permissions problem that is not allowing IUSR_Machinename to have write access to the /data folder. Give "full control" access to the IUSR_Machinename account (if not to Everyone) on the database and the /data folder itself.
Q. Error when adding employees
Error # -2147217900 Syntax error in INSERT INTO statement.
SQL = INSERT INTO tbl_permissions (employee_id, permall, permadmin, permadmincalendar, permadmindatabasesetup, permadminemployees, permadminemployeesperms, permadminfilerepository, permadminforum, permadminnews, permadminresources, permadminsurveys, permadminthoughts, permclientsadd, permclientsedit, permclientsdelete, permprojectsadd, permprojectsedit, permprojectsdelete, permtasksadd, permtasksedit, permtasksdelete, permtimecardsadd, permtimecardsedit, permtimecardsdelete, permtimesheetsedit, permforumadd, permrepositoryadd) VALUES (11, , , , , , , , , , , , , , , , , , , , , , , , , , , )
A. See that there is missing data in the line above where all the commas are. That is because this is supposed to be filled in by application variables. The application variables have not been set and there can be 2 explanations for this:
1. check to make sure the global.asa file is in place
2. once you put the site in place or put the global.asa file in place, you may need to stop and restart the web services to get those application variables to take hold.
Q. Disallowed Parent Path
Active Server Pages error 'ASP 0131'
Disallowed Parent Path
A. In IIS there is a setting where you can disallow "parent paths" for include files, this is supposed to help security so someone can't go down through your file system to access files they should not be.
In IIS 5 it is under "Home Directory-->Configuration-->App Options.
If you do not have control of the IIS server or cannot change this then you will have to edit all the include statements and change them to a virtual path from the root of the site. For example:
#include file= '../includes/main_page_header.asp'
would have to be changed to
#include virtual = "/includes/main_page_header.asp'
Q. scripting.dictionary errors
ActiveX component can't create object: 'Scripting.Dictionary'
A. We use the scripting dictionary for all the text throughout the site. All the text is loaded into the dictionary and then when specific text is needed it is pulled from the dictionary object. This makes it easy to change languages.
The scripting run-time dll is scrrun.dll, the reason the error is occuring is because IIS cannot gain access to the dll. It is either a permissions problem, the dll has been removed/uninstalled by someone (commonly done by hosting providers), or there some other type of conflict with multiple dll's. The same dll controls the file system object and it is removed many times for security purposes.
If you cannot use the dictionary object on the system your site is hosted on there are a couple of things you can do, but will require some work on your part:
1. If you are not concerned about being able to use multiple languages you can remove any include statements to the languages.asp file and then go through the files of the site doing a search for "dictLanguage" and replace all those instances with text that fits the application.
2. If you would still like to keep all the language in one file you can remove the dictionary object and just change all the dictionary instances to variables and then replace the same dictionary references throughout the site with those variables using the process in 1 above.
This will not fix the problems with not being able to use the file system object (used for document repository), though. If it is disabled by your hosting provider you will not be able to use the document repository.
Q. Data type mismatch when trying to login
Error # -2147217913 Data type mismatch in criteria expression.
SQL = UPDATE tbl_employees SET lastlogin = '29-Aug-2002' WHERE employeelogin
= 'TEST'
A. Normally this will occur if your primary language is not English. There are a couple of things to do:
1. Open up the page /includes/connection_open.asp. On that page you will find a function called MediumDate(). Inside that function you will see the a portion where Month names are set for a variable named aMonth. Change those month abbreviations to use the 3 letter month name abbreviations for your language.
2. In the file /includes/siteconfig.asp the Jet database driver is used in the connection string by default. Try commenting that line out and uncommenting the Access driver line. The Access driver seems to be a little friendlier with international dates than the Jet driver is.
Q. I get an error message when trying to login
A. What error message are you getting?
If you are getting a generic error message go to Internet Explorer, Tools, Internet Options, Advanced and uncheck the "Show Friendly HTTP Errors" checkbox. This will display the error for you.
More than likely you will get an "operation must use updatable query" error. See the FAQ above for more information.
Q. Options is missing
A. The user defined options (there is a setting for it in the SiteConfig file) has not been implemented as of yet. But we are planning on creating that functionality in the future and have been from early on. A setting was created for that from the very beginning as a placeholder for the future.
In version 2.6.0 and later the "options" item was commented out from the DHTML menu.
Q. Uploading file - page hangs, server needs reboot
When I try to insert the employee images though the admin employee page. The page will process and never ending with the process page. after that I need to restart my IIS and nothing is updated
A. I ran into this problem a while back while working on a website on a hosting provider's server. The problem is more than likely a conflict with Norton AntiVirus. The file system object, which saves the uploaded file to the file system, uses the scrrun.dll. Unfortunately Norton AntiVirus sees any scripts that try to gain access to the file system as malicious so it does not allow it. You must disable script blocking.
http://www.aspfaqs.com/aspfaqs/ShowFAQ.asp?FAQID=192
I believe that you can exclude specific file types from being checked by NAV?
Q. Is it possible to... ?
A. Is it possible to... (add in any kind of functionality to IOS that you can think of)?
I get this type of question a lot! I have a few standard answers for this.
1. Will I steer you in right direction if you want to tackle this yourself? Yes.
2. Will I do it for you? No.
3. Will I add it into the next IOS version? If you need it right now you should probably do it yourself or have someone build it for you. If you can wait for awhile and you think it is a really good idea that everyone needs then add it to our request list and it might make it into the next release.
4. Anything is possible as long as you are a competent ASP coder or you know a competent ASP coder.
5. But you don't have an ASP developer? check out our favorites like Marpanhou, Developer At Large, and ElectronicArt Design.
Q. Disallowed Parent Path - Windows 2003 / IIS6
A. By default Parent Paths are disallowed in Windows 2003/IIS6. You will have to change the settings to allow parent paths at least for the site that IOS is running under. See FAQ above for more information.
Q. Error # 70 Permission denied
Error # 91 Object variable not set
A. You may get this error when attempting to update site configuration properties in the admin section.
Making these changes in the admin is just an automated way of making changes to the siteconfig.asp file. When you are doing this the code is opening up the siteconfig.asp file and writing your chosen values to it. The file, siteconfig.asp, must have permissions that allow you to write to it.
You should give IUSR_Machinename (if not Everyone) write permissions to /include/siteconfig.asp.
Q. Is this open source?
A. I received this email a few days ago:
Dear Digger Solutions,
I think you might be falsely advertiseing open source. The Market of open source clear states that you can see the code and modify the code and distribute the code . That is if the code is "open Source:"
I would like to know what the diffrence is about your open source and what the industry stander from these site's that i have listed below.
I am interested in your open source but am concerned of why there is a conflict in the meaning of the term open source.
I have attached some open source definition links so you know what the commen knowledge is about open source and what rules apply.
http://www.fsf.org/philosophy/free-sw.html
http://www.redhat.com/about/mission/opensource.html
I look forward to you helping me understand these differnces.
my answer:
I am sure that we are not falsely advertising our product. But I always welcome debate.
The first link you mentioned (fsf.org) discusses the definitions and prerequisites for "free" software. Our software is not "free software" it is "open source", so nothing on that page applies to us.
The second link that you mentioned (redhat.com) defines open source as: "Open source means the code can be seen and changed." Because our code is asp, which is a scripting code that is not compiled, it can be seen and changed. It is all included in the files that can be freely downloaded from our site and can be seen and changed by anyone. So by the basic definition of open source as defined by Redhat on that page, all ASP code, whether you pay for it or not, is open source.
Why do we offer our software as open source? We want to make it available for the developer community, but we want to make sure that it is not misused. We chose to make it available as open source under our own licence agreement: it can be used, changed, modified however the user sees fit, for non-commercial or commercial use, as long as the original copyrights stay in place, our comments in the code stay in place, and any images or links referencing Digger Solutions in the software stay in place (mostly the "powered by digger solutions" logo/link). Additionally, because the product is open source it cannot be sold or resold to any third parties. We do not make the distinction that any derived products remain open source, but we maintain that our copyrights, links, etc. must remain within our code in those derived products.
Why not free? We do not want unscrupulous people misrepresenting our work as their own. We don't want unknowing customers paying $10,000 for a solution from an unscrupulous developer when they could download the exact thing from our website for nothing. Sadly, both of those things still happen, though. But, for the most part people honor and respect our wishes and use our software fairly and honestly.
Basically, we just want credit for our work and we want to make sure people don't get ripped off.
Hoped my explanation helped to dispel your fears about us and our products.
Q. Issues with international dates, currency, etc.
A. This post originally posted by DWE.
*******************************************************************
Administrator note: Normally, IOS should work fine for you as it is setup by default - it will use the default date, time, and currency settings based on the default locale and LCID settings on the server. Most of the time this is sufficient, however sometimes it will not be. Ex: you are located in the Germany, but use a US-based hosting provider to host your website. The server will probably use US date/time settings and currency display settings. You need to change something to make it use German settings. The following explanation will help.
*******************************************************************
The problems in relation to the default time settings can be troublesome and quite often have to do with the default LCID settings on the server - most dates are formatted mm/dd/yyyy for the compatibility of other programs running at the ISP
To ensure that your default settings are set to your country follow the following directions :
** in your root directory (where the main files of IOS reside, locate default.asp - open it and locate the following line:
strOption = Request.QueryString("opt")
Immediately below that line, insert the following lines being careful not to overwrite any other lines of code
response.write("<p>")
response.write("Default LCID is: " & Session.LCID & "<br />")
response.write("Date format is: " & date() & "<br />")
response.write("Currency format is: " & FormatCurrency(350))
Close and save the file.
Upload it to the server and browse to you login page - now in the top left hand corner you will see something similar to the following :
Default LCID is: 3081
Date format is: 8/06/2004
Currency format is: $350.00
Now do some research on google to find out what your country LCID is
The Default for Australia - who uses the default dd/mm/yyyy format is 3081
Microsoft have released a table with all LCID's at :
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/vsmsclcid.asp
To change the LCID to the local one - ie for your country if the dates are not formatting correctly, you need to change the default LCID for the user session
You can do this in any number of places but the best is probably the global.asa file.
Locate the global.asa file - in should be in the same directory as default.asp edited earlier. Open this file in NOTEPAD not Frontpage or write or word or anyother editor - just a plain and simple text editor
Find the line thats says :
Sub Application_OnStart
and immediately above it insert the following lines being careful not to over write any code - if need be insert a few blank lines above it before inserting:
Sub Session_OnStart
Session.LCID = 3081
End Sub
Save and close the file - upload the global.asa file and go to your default login page. You should probably now see a different LCID, different time format and a different currency symbol.
NOTE THE LCID FOR AUSTRALIA is 3081. If you are in the UK then your LCID would be 3079 and the pound symbol will show for the currency and the time should be shown as per your locale.
I truly hope this little explanation helps someone because it toook me a half day of search to findout the exact problem and how to fix it.