Error 1065: Query was Emptyhttps://joellipman.com/articles/database/mysql/error-1065-query-was-empty.html

13 December 2012 In view of the fact that this error pops up in so many systems I take over, I have often gone down the wrong path following the red herring as it were when in fact the answer to this is very common. Why? Bespoke systems are the usual suspects....

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

Zoho Deluge: Post a multi-dimensional or nested array to a 3rd-party APIhttps://joellipman.com/articles/crm/zoho/zoho-deluge-post-a-multi-dimensional-or-nested-array-to-a-3rd-party-api.html

03 February 2021 thirdpartyapi\Webservice\Service\Format->factory('auth[key]=06cda...', 'php') #2 /home/thirdpartyapiorg/public_html/thirdpartyapi_controlpanel/user/addons/thirdpartyapi_webservice/libraries/services/webservice_rest.php(149):...

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

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

31 May 2009 you need help with something, you may post again as long as you include additional information about your problem (the fact that you really really want it fixed does not count as additional information). You must post this in the same thread, and you...

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

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

25 September 2009 =YES Update 16.NOV.2009 I don't see this supported anymore so I wouldn't recommend using the JezRecaptcha plugin. In fact I'm not impressed with Recaptcha as it's sound alternative doesn't work and the text form is hackable. I will be changing this over...

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

Community Builder in Joomla Vulnerabilityhttps://joellipman.com/articles/cms/joomla/community-builder-in-joomla-vulnerability.html

10 November 2009 are some more details of prevous CB hacks in the Joomla forum (source: http://forum.joomla.org/viewtopic.php?t=84436) . In fact, there are quite a few vulnerabilities my scanners have picked up on and so I'll be posting solutions for those who need to...

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

Remove write-protect from USB pen in Windowshttps://joellipman.com/articles/microsoft/windows-os/remove-write-protect-from-pen-in-windows.html

13 April 2010 when I go to check the space, my 30Gb has returned!!! It’s called Urescue and it’s become my favourite program (despite the fact that I want to need to use it as little as possible, i.e. once)!!! To find it go to...

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

Migrate Joomla! 1.5.x to 2.5.x+https://joellipman.com/articles/cms/joomla/migrating-from-joomla-15-to-16.html

30 January 2011 upgrade site. This is the ID -- used when installing Joomla CMS. It is important that the script below -- accounts for the fact that you may have a user with the same ID in your -- previous Joomla CMS and we would want to maintain any relationships and...

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

What's the problem? Amusing computer issueshttps://joellipman.com/articles/web-development/whats-the-problem-amusing-computer-reports.html

28 April 2011 Look for "System Up Time". A staff member in a partner institution: "By the way my printer has stopped working, in fact it hasn't been working for ages, could you also look at that". "Is there a power light on when you switch it on?". "Yes it's...

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

Joes FREE Website Thumbnailer (JWT)https://joellipman.com/component/content/article/joes-free-website-thumbnailer.html?catid=40

28 June 2011 to tell which of my members are humans and which are just for fun, so don't share any of your details with other members (in fact do the opposite of a social network - joellipman.com is not a social networking site). I don't have a newsletter so it's...

• Type: Article
• Author: Joel Lipman
• Category: Product Documentation
• Language: *

How to Display Report Execution Time in SSRS (milliseconds)https://joellipman.com/articles/microsoft/ssrs/how-to-display-report-execution-time-in-ssrs.html

17 November 2011 from MS Internet Explorer Check results using Microsoft SQL Server Management Studio (SSMS) My test results showed that in fact my time was closer to the "TimeProcessing" field of the ReportServer database, but good enough for us.

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

Vertically align an asterisk on a linehttps://joellipman.com/articles/web-development/css/vertically-align-an-asterisk-on-a-line.html

02 September 2012 that the asterisk character would overlap the item beneath it (in this case #2) so when a user clicked on #2 they would in fact be clicking on the item containing the asterisk above it. Objective Box List Before: Box List After * 1 2 3 * 1 2 3 How?...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Background Gradient Disappears on Long Pageshttps://joellipman.com/articles/web-development/css/background-disappears-on-long-pages.html

20 November 2012 cause was because the template I was using was not actually specifying "white" as the contents background-color and was in fact setting a gradient as the background. Consider the following: /* ERROR CSS: DO NOT USE !!! */ background: #f7f7f7;...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Three boxes, two roll over, one falls outhttps://joellipman.com/articles/web-development/css/three-boxes-two-roll-over-one-falls-out.html

21 January 2013 in this case, the same width. It isn't so much a miscalculation of 100% divided by 3 that leaves 1 pixel left over, more the fact that the scripts use that 1 pixel (ceiling rather than floor?). Why? We have a row on a website of three boxes made of div...

• Type: Article
• Author: Joel Lipman
• Category: Cascading Stylesheets
• Language: *

Fix Oracle Tnsping 3511 without Windows Registryhttps://joellipman.com/articles/database/pl-sql/fix-oracle-tnsping-3511-without-windows-registry.html

04 March 2013 Furthermore I've been asked why aren't all our Oracle databases the same version? It's due to the fact that these aren't our databases, we simply help support them. You say less than ideal, I say realistic. Quit complaining about processes and...

• Type: Article
• Author: Joel Lipman
• Category: Oracle PL/SQL
• Language: en-GB

Joomla Component: Set default params on installationhttps://joellipman.com/articles/cms/joomla/joomla-component-set-default-params-on-installation.html

24 October 2013 been set. I need to go into the Joomla Admin panel, view the Options of the component, and click on "Save"... despite the fact that I don't change anything. How? Add the following line to the XML installation file: script.php Now create a script.php...

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

SSRS: Performance Improvements: SELECT TOPhttps://joellipman.com/articles/microsoft/ssrs/ssrs-performance-improvements-select-top.html

07 March 2014 about 0.4 seconds. We're obviously not interested in shaving off time from 0.4 seconds; no, we're more interested in the fact that 0.4 Microsoft seconds seems to translate to about 10 minutes in the real world. Where do the extra 9 minutes come from?...

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

Zoho Deluge: Determine if Daylight Savings are in effecthttps://joellipman.com/articles/crm/zoho/zoho-deluge-determine-if-daylight-savings-are-in-effect.html

03 July 2023 client, so here's a quick snippet to just check if Daylight Savings are in effect for the United Kingdom. How? Based on the fact that the United Kingdom is on the Prime Meridian and when no daylight savings are in effect, the hour difference to UTC...

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

MySQL Oracle equivalentshttps://joellipman.com/articles/database/mysql-oracle-equivalents.html

27 September 2010 implies something rather odd and upcoming considering that Sun Microsystems bought MySQL and Oracle bought Sun. But in fact, this is just a quick list of some regular commands in MySQL that I need in Oracle: Objective MySQL Oracle - See if a table...

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