Registered Users Cannot Login - Super Users Canhttp://mail.joellipman.com/articles/cms/joomla/registered-users-cannot-login-super-users-can.html

26 February 2014 a parent_id of 0. The fix is immediate after the change is committed to the database. NTS: Possible Related Error: "You cannot access the private section of this site"

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: en-GB

SSRS Subscriptions cannot be createdhttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-subscriptions-cannot-be-created.html

22 November 2013 Studio 2008 (BIDS) Microsoft SQL Server 2008 R2 What? This article describes solutions to the error: Subscriptions cannot be created because the credentials used to run the report are not stored, or if a linked report, the link is no longer valid. How?...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Deserialization and cannot checkout files in TFShttp://mail.joellipman.com/articles/microsoft/tfs/deserialization-and-cannot-checkout-files-in-tfs.html

03 January 2013 Why? So I get back from annual leave and I can't check-out / check-in any files in a Visual Studio 2010 project. All my colleagues can. What? Rather silly I know and the solution is one of those obvious ones for those that know how but for those who...

• Type: Article
• Author: Joel Lipman
• Category: Team Foundation Server
• Language: *

SSIS: Cannot open Data Flow Task: DTS.Pipeline.2 issuehttp://mail.joellipman.com/articles/microsoft/ssis/ssis-cannot-open-data-flow-task-dts-pipeline-2-issue.html

09 June 2014 What? I started getting this error: The task with the name "Data Flow Task" and the creation name "DTS.Pipeline.2" is not registered for use on this computer Why? We use a combination of MS Visual Studio 2008, 2010 and 2012. VS2008 for our old SSIS...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Integration Services
• Language: en-GB

SSRS Dropdown parameter cannot be blank!http://mail.joellipman.com/articles/microsoft/ssrs/ssrs-dropdown-to-allow-blank-values.html

14 December 2011 as OPTIONAL. When I leave the 3rd and 4th parameter untouched (=""), the report complains saying "Report #3 parameter cannot be blank!". Before you ask, I have ticked both "Allow Blank" and "Allow NULL". How? This is the tough part. I was reading up on...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Licence GNU/GPLhttp://mail.joellipman.com/static-items/licence-gnugpl.html

03 April 2009 that patents applied to a free program could make it effectively proprietary. To prevent this, the GPL assures that patents cannot be used to render the program non-free. The precise terms and conditions for copying, distribution and modification...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Expecting ZC_SUBFORM_250 expression found COLLECTIONhttp://mail.joellipman.com/articles/crm/zoho/expecting-zc_subform_250-expression-found-collection.html

19 October 2020 ZC_SUBFORM_250 expression found COLLECTION expression Another error you may get when using the deluge script is: LIST value cannot be assigned to 'mySubform' -- or -- COLLECTION value cannot be assigned to 'mySubform' or expecting ZC_SUBFORM_70...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: Create a Widget which uses JavaScripthttp://mail.joellipman.com/articles/crm/zoho/zoho-creator-create-a-widget-which-uses-javascript.html

24 October 2020 Your information is still secure because Google Chrome stopped the connection before any data was exchanged. You cannot visit 127.0.0.1 at the moment because the website sent scrambled credentials that Google Chrome cannot process. Network errors and...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

ZohoBooks: Broken UK Banking Feedhttp://mail.joellipman.com/articles/crm/zoho/zohobooks-broken-uk-banking-feed.html

16 October 2025 causes. Sometimes the issue is with the bank or the Open Banking token, but other times the feed itself becomes stuck and cannot be refreshed or disabled from within Zoho Books. Pre-amble: I had to check ZohoBooks Downtime Server Incidents: US Zoho...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Create Read-Only Database User in SQL Serverhttp://mail.joellipman.com/articles/database/create-read-only-database-user-in-sql-server.html

09 November 2010 Definition Language (DDL) command in a database. db_denydatareader Members of the db_denydatareader fixed database role cannot read any data in the user tables within a database. db_denydatawriter Members of the db_denydatawriter fixed database role...

• Type: Article
• Author: Joel Lipman
• Category: Databases
• Language: *

SSRS Querying on either of 2 Parametershttp://mail.joellipman.com/articles/microsoft/ssrs/ssrs-querying-on-either-of-2-parameters.html

19 July 2011 First(Fields!S_STUDENTREFERENCE.Value, "StudentDetails")) should work: Apparently not because "fields cannot be used in report parameter expressions". I tried this with "Default values" and got the same problems. Note: before you try, "Variable values...

• Type: Article
• Author: Joel Lipman
• Category: SQL Server Reporting Services
• Language: en-GB

Zoho CRM/Creator - Common Errors & Gotchashttp://mail.joellipman.com/articles/crm/zoho/zoho-crm-creator-common-errors-gotchas.html

06 February 2020 [ url :v_DataEndpoint type :PUT parameters:m_CreateRecord headers:m_Header ]; Problem: Value is empty and 'get' function cannot be applied Following a post similar to the above example by InvokeURL and then getting a JSON response back, the response...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho People: Reject an Application for Leave in Deluge based on Criteriahttp://mail.joellipman.com/articles/crm/zoho/zoho-people-reject-an-application-for-leave-in-deluge.html

10 December 2020 "uri": "/api/forms/json/P_ApplyLeave/updateRecord", "errors": { "code": 7115, "message": { "From": "Sorry, this record cannot be edited." } }, "status": 1 } } [The working solution] I'll cut to the quick solution, which was not to try to update the form...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

Zoho Creator: isBlank and isNull: Before or After?http://mail.joellipman.com/articles/crm/zoho/zoho-creator-isblank-and-isnull-before-or-after.html

10 February 2025 is NULL isBlank Preceding is TRUE isBlank Succeeding is FALSE: Error at line : 57, Value is empty and 'isBlank' function cannot be applied isNull Preceding is TRUE isNull Succeeding is TRUE Equals Blank is FALSE */ I've tried this in both Zoho Creator...

• Type: Article
• Author: Joel Lipman
• Category: Zoho
• Language: *

GDPR Privacy Policyhttp://mail.joellipman.com/static-items/gdpr-privacy-policy.html

14 February 2019 have used these links to leave our site, please note that we do not have any control over that other website. Therefore, we cannot be responsible for the protection and privacy of any information you provide whilst visiting such sites, and such sites...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

Privacy Policyhttp://mail.joellipman.com/static-items/privacy-policy.html

30 May 2009 used these links to leave our site, you should note that we do not have any control over that other website. Therefore, we cannot be responsible for the protection and privacy of any information which you provide whilst visiting such sites and such...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: en-GB

Forum Ruleshttp://mail.joellipman.com/static-items/forum-rules.html

31 May 2009 You may not make posts threatening to leave the board. This causes flaming to occur. Because of what a problem this is, I cannot issue a warning for violations. Anyone responding poorly to these threads will also be muted. Warning - Depending on how...

• Type: Article
• Author: Joel Lipman
• Category: Static Items
• Language: *

How to redirect the visitor after the contact pagehttp://mail.joellipman.com/articles/cms/joomla/how-to-redirect-the-visitor-after-the-contact-page.html

06 September 2009 change the default text that is displayed "Thank you for your e-mail" to something else I will explain how in this guide. I cannot be 100% sure this guide will work for people who have certain extensions installed or who have SEO turned on as i have not...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *

Database Error: Unable to connect to the database: Could not connect to MySQLhttp://mail.joellipman.com/articles/database/mysql/database-error-unable-to-connect-to-the-database-could-not-connect-to-mysql.html

25 September 2009 after I use my website (using the default Joomla welcome template with NO modifications whatsoever) I start to get the "cannot connect to MYSQL." I contacted my webhost, and the problem is the number of MYSQL database queries. It goes up to about...

• Type: Article
• Author: Joel Lipman
• Category: MySQL
• Language: en-GB

Using K2 with jezReCaptcha plugin causing errorshttp://mail.joellipman.com/articles/cms/joomla/using-k2-with-jezrecaptcha-plugin-causing-errors.html

25 September 2009 K2 Comments to use it's own ReCaptcha. If you try adding a comment, you may get something like the following: Fatal error: Cannot redeclare_recaptcha_qsencode() ( previously declared in...

• Type: Article
• Author: Joel Lipman
• Category: Joomla
• Language: *