MySQL – ObidosTech Knowledge Base

Help snippets on NodeJs, React, ColdFusion, PHP, Android, iOS and tech news

ObidosTech

Obidos Technologies (P) Ltd is an off-shore development and maintenance center for ColdFusion applications, PHP application along with ReactJS, NodeJS

Fixed: Maria DB – Row size too large (> 8126) – Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED

January 11, 2023

1 min read

When trying to import an SQL file with InnoDB, Maria DB users can see the following message as an error or warning:. SQL Error (1118): Row size too large (>…

ColdFusion Database Lucee MySQL Server Tomcat Windows

Fixed: Lucee page rendering taking 2-3 seconds every time

December 14, 2022

1 min read

In one of our latest Windows servers, the latest version of Lucee (5.3.10.97) with default configuration was showing an apparent slowness. Every page, whether it is a single line output…

ColdFusion Integration JSON MySQL PHP QuickBooks Server Technology

SOLVED QuickBooks Integration Error – EDGE-CR-ERR-8090 – Auth ID does not exist

October 14, 2016October 19, 2016

2 mins read

Integration with QuickBooks is easy if you know the OAuth flow. QuickBooks uses the OAuth 1.0 specification. They provide libraries for PHP, Java and other popular languages. For ColdFusion/Railo, you…

Database MySQL

Mysql join and sum is doubling result

August 23, 2016August 23, 2016

1 min read

The way to get around this is to create inline views of your aggregates and join on the those results. SELECT R.title_id, R.revenue, R.cost, F.interest FROM (SELECT title_id, Sum(revenue) revenue,…

Database MySQL PHP Server

Fixing error with MySQL “Headers and client library minor version mismatch.”

August 18, 2016

1 min read

With PHP and MySQL, if the MySQL is upgraded you may end up with this error on every request to the database from PHP. This error means the MySQL library…

Category: MySQL

Fixed: Maria DB – Row size too large (> 8126) – Changing some columns to TEXT or BLOB or using ROW_FORMAT=DYNAMIC or ROW_FORMAT=COMPRESSED

Fixed: Lucee page rendering taking 2-3 seconds every time

*SOLVED* QuickBooks Integration Error – EDGE-CR-ERR-8090 – Auth ID does not exist

Mysql join and sum is doubling result

Fixing error with MySQL “Headers and client library minor version mismatch.”

SOLVED QuickBooks Integration Error – EDGE-CR-ERR-8090 – Auth ID does not exist