Skip to content
  • Obidos Technologies (P) Ltd
Obidos Technologies (P) Ltd

ObidosTech Knowledge Base

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

About Obidos Technologies (P) Ltd

Profile
ObidosTech

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

Menu
  • Obidos Technologies (P) Ltd
  • Prasanth Kumar.S

Category: MySQL

5 Articles
Categories
Database MySQL Server Technology Windows

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 (>…
Read more
Categories
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…
Read more
Categories
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…
Read more
Categories
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,…
Read more
Categories
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…
Read more