IT Handyman

Because sometimes you need a little help…

Menu
Skip to content
  • Home
  • About / Contact information
  • Dulare uses…

Tag: MySQL

“Access denied for user” on views only – after MySQL database restore
  • SQL

“Access denied for user” on views only – after MySQL database restore

  • Posted on 2022-03-092022-03-10
  • by dulare

We encountered this issue when moving the database from the old server to the new one. Everything looked fine, there was access to tables (select, insert, update, delete) but when…

Read More
The value class java.time.LocalDateTime cannot be converted to a date
  • ColdFusion

The value class java.time.LocalDateTime cannot be converted to a date

  • Posted on 2022-03-022022-03-03
  • by dulare

You may encounter this error in ColdFusion when working with MySQL. It is rather strange: First, let’s talk about the solution. This error occurs due to the MySQL Connector version…

Read More
Connecting ColdFusion 2016 to MySQL 8
  • ColdFusion

Connecting ColdFusion 2016 to MySQL 8

  • Posted on 2022-02-232022-02-23
  • by dulare

If you still happen to use ColdFusion 2016 and you want to connect it to MySQL 8 (or MariaDB 10), you will receive the following error: It is not telling…

Read More
Don’t use “CALL StoredProcedure()” in Python :)
  • Python

Don’t use “CALL StoredProcedure()” in Python :)

  • Posted on 2021-12-152022-01-19
  • by dulare

This issue is related to MySQL (I’m using mysql-connector-python). Surprisingly, when I was changed my query to a stored procedure, my code stopped working. It looked like this: And it…

Read More
Calculate hash of multiple columns in MySQL
  • SQL

Calculate hash of multiple columns in MySQL

  • Posted on 2021-08-042021-09-10
  • by dulare

What do I calculate the hash of multiple columns for? I’m working with API that is limiting the number of calls per hour. I don’t want to send the same…

Read More
Create a URL-safe string in MySQL
  • Database

Create a URL-safe string in MySQL

  • Posted on 2020-12-022020-12-26
  • by dulare

Given that my native language uses some funny chars like ‘ą’ or ‘ć’ and there are multiple chars that are not safe when placed in the URL, from time to…

Read More

Recent Posts

  • Sending emails from Docker using Postfix installed on the Host
  • Fuzzy search testing – using PostgreSQL compared to Qdrant vector database
  • OpenAI models fine-tuning considerations
  • Oxygen upgrade issue: Download failed. Unauthorized
  • OxyMade update failed – how to pull the license key from the database

Tags

3D printing administration Apache Arduino AWS ColdFusion databases development EC2 ESP8266 Express FriendlyTracker FTP git Handlebars IIS Infusionsoft IoT Java Javascript Linux Lucee Machine Learning MS SQL Server MySQL Node OpenAI OpenVPN programming Python Qdrant Security Selenium SQL SSL TestBox threads timelapse tips TLS Ubuntu vector database web development Windows WordPress
© Copyright 2025 – IT Handyman
Bezel Theme by SimpleFreeThemes ⋅ Powered by WordPress