T-SQL Conversion failed when converting the varchar to data type inthttps://www.joellipman.com/articles/database/t-sql/t-sql-conversion-failed-when-converting-the-varchar-to-data-type-int.html

14 May 2013 but then you google the above and you get half a million results. That's a lot of reading so here's the simple fix for my issue: Returning an error: LTRIM(RTRIM(rm.Name + ', ' + rm.[Zone] + ', ' + rm.[Capacity] + ', ' + rm.[Type] + ', ' + rm.[DeptId]))...

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

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

26 February 2014 to Joomla CMS v2.5.14 What? This article is a note on how I fixed an issue on a client site. The website had a redirect on the login which would go to a page accessible by "registered" users but only "Super Users" could actually login. "Registered"...

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

SSRS Stop Scrolling Behindhttps://www.joellipman.com/articles/microsoft/ssrs/ssrs-stop-scrolling-behind.html

08 April 2014 Basically, I want the opposite result of "Fixed headers while scrolling". How? Once I figured out why I had a scrolling issue, the reverse was easier to work out: Open the Report in Design mode. Check that advanced mode is switched on as per the...

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

Android: Keytool and Google Maps displaying greyhttps://www.joellipman.com/articles/google/androidos/android-keytool-and-google-maps-displaying-grey.html

31 October 2014 SHA1 with the Google API console instead of the app SHA1, but here are some red herrings I found when debugging this issue: Download from the Play Store: The google maps api will apparently NOT work if you downloaded the APK from another location. This...

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

Zoho Deluge - Update Creator from CRMhttps://www.joellipman.com/articles/crm/zoho/zoho-deluge-update-creator-from-crm.html

18 February 2019 Creator from a workflow written in a Deluge Script held in ZohoCRM. Why? I've also started this article to document an issue we encountered where our code was as per the documentation provided, and the responses returned as successful, but the target...

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

Zoho CRM: Template: Empty Space between Header and Line Itemshttps://www.joellipman.com/articles/crm/zoho/zoho-crm-template-empty-space-between-header-and-line-items.html

03 February 2022 A very quick article on how to deal with an issue where a CRM template has been used and where the table of line items appears on a separate page (and to remind me of the CSS to fix this). Why? By default / out-of-the-box / vanilla, in a Zoho CRM...

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

ZohoCRM GetRelatedRecords INVALID_DATAhttps://www.joellipman.com/articles/crm/zoho/zohocrm-getrelatedrecords-invalid_data.html

30 January 2025 What? A ridiculously quick article on resolving a zoho.crm.getRelatedRecords() combined with a zoho.crm.bulkUpdate issue. Why? Trying to be clever and reducing the API calls to go through a few thousand records and to update the related records. I was...

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

Forum Ruleshttps://www.joellipman.com/static-items/forum-rules.html

31 May 2009 "No Hacking" which immediately results in a permanent ban: Warning - Depending on how serious a violation is, you may be issued a warning first Muting - Muting for 10 days Temporary ban - People who cause more problems after being muted for 10 days will...

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

Setting up your store to use SSLhttps://www.joellipman.com/articles/ecommerce/setting-up-your-store-to-use-ssl.html

11 September 2009 If, on the other hand you get any warning messages or other errors please contact your hosting company to resolve the issue. If you have shared SSL your hosting company should have given you your secure URL which in most cases will be a domain with...

• Type: Article
• Author: Joel Lipman
• Category: eCommerce Systems
• Language: *

Applying a button and centering it in the RocketTheme Affinity templatehttps://www.joellipman.com/articles/cms/joomla/applying-a-button-and-centering-it-in-the-rockettheme-affinity-template.html

15 September 2009 This took me a while to do so I thought I'd document it for future reference. The Issue See the restore default setting link at the bottom of this page in the footer? I wanted to put one of the styled buttons behind it but then found that there's a lot...

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

Using a HTML form and PHP to upload a filehttps://www.joellipman.com/articles/web-development/php/using-a-html-form-and-php-to-upload-a-file.html

17 September 2009 Issue Basically you have a HTML form with an input field type of 'FILE' (ie. ) and want a PHP file to process this. This example applies to a Linux Apache MySQL PHP (LAMP) environment. The Solution 1. The first thing to do is check that your HTML form...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

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

25 September 2009 There are reports though that some people set up websites with NO 3rd-party items whatsoever... For those of you with this issue, I'd double-check your website host allows Joomla and if they don't, look for either an upgrade or a different host. If your...

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

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

25 September 2009 The Issue Basically that you've installed JoomlaEZ's ReCaptcha Integrator plugin to protect your forms ("type two words" captcha) and then installed K2 Comments to use it's own ReCaptcha. If you try adding a comment, you may get something like the...

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

Installing phpBB3 for Joomla with a RocketTheme templatehttps://www.joellipman.com/articles/cms/joomla/installing-phpbb3-for-joomla-with-a-rockettheme-template.html

28 September 2009 as the applied Rocket Theme template, just not with Virtuemart modules... We are investigating this as it seems to be an issue with all Vmart modules but not with Virtuemart itself. This is what I did because I did the above in the wrong order... Fix...

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

Add Image Mouseover effect in AutoHotkey GUIhttps://www.joellipman.com/articles/automation/autohotkey/add-image-mouseover-effect-in-autohotkey-gui.html

25 January 2010 Couldn't find this anywhere on the net and kinda needed it so am making a note of how to do it here. The issue is that I wanted to make my autohotkey program change the image that the mouse hovers over (within it's own GUI). No third-party component or...

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

Project Plan for Freelance Websitehttps://www.joellipman.com/articles/web-development/project-plan-for-freelance-website.html

25 February 2010 http://www.buydomains.com/ http://www.sedo.com/ When you have registered a domain name, please tell us and we will issue you the assigned NameServers to point your domain at (done via your domain registrars control panel). Styles, Visuals and Source...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *

Windows Live Messenger: Error 80048820https://www.joellipman.com/articles/microsoft/windows-os/windows-live-messenger-error-80048820.html

08 March 2010 This is an issue relating to the Time Server Synchronization error. Basically you start up windows live messenger and get the following error: {rokbox title=|Messenger Error 80048820|}/images/screenshots/windows_live_error_80048820.png{/rokbox}...

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

URL passed settings in Reporting Serviceshttps://www.joellipman.com/articles/microsoft/ssrs/url-passed-settings-in-reporting-services.html

11 February 2011 Development Studio (BIDS) is "Code". Click on the browse button next to it to edit. Visit http://odetocode.com/code/128.aspx Issues encountered Note there appears to be an issue with regards to rendering. An updated and deployed report on the same day...

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

PHP & MySQL Search Enginehttps://www.joellipman.com/articles/web-development/php/php-a-mysql-search-engine.html

09 March 2011 Great! Few problems though, multiple terms are not supported; quotation marks and apostrophes may be an issue; Full PHP: $sanitized_search=(isset($_GET['search'])&&($sanitized_search==""))?trim(strip_tags(addslashes($_GET['search']))):""; # 2 functions...

• Type: Article
• Author: Joel Lipman
• Category: Personal Home Page
• Language: en-GB

Developer's Checklist: Taking over a projecthttps://www.joellipman.com/articles/web-development/developers-checklist-taking-over-a-project.html

01 March 2011 - the spec) Details on the Development Environment (is there a TEST system and deployment procedure in place?) Known Issues/Bugs (is there an "Issues Log"? Anything that still needs addressing?) System Requirements (in case you need to transfer/move to...

• Type: Article
• Author: Joel Lipman
• Category: Web-Development
• Language: *