Project

General

Profile

Support #3863

DB Update Fails: Expected no record, got 2 rows: SHOW TABLE STATUS WHERE Name='Form'

Added by Carsten Rose over 3 years ago. Updated over 3 years ago.

Status:
Closed
Priority:
Normal
Assignee:
Target version:
-
Start date:
07.06.2017
Due date:
% Done:

0%

Estimated time:
Discuss:

Description

QFQ in combination with dbq2/form2 throws an exception on load:

Expected no record, got 2 rows: SHOW TABLE STATUS WHERE Name='Form'
#1

Updated by Carsten Rose over 3 years ago

  • Status changed from New to In Progress

Check: https://mariadb.com/kb/en/mariadb/server-system-variables/#lower_case_table_names

The problem: tablenames might be case insesitive. In DB 'math' we have 'form' (dbq2) and 'Form' (QFQ). For regular queries (SELECT, INSERT, UPDATE, ...) this seems not to be a problem under Linux. But for "SHOW TABLE STATUS WHERE Name='Form'" (even udner linux) this breaks.

Approach to fix:
1) the DB-UPDATE check will handle multiple matching tables automatically
2) the DB_UPDATE check can be switched off.

#2

Updated by Carsten Rose over 3 years ago

  • Status changed from In Progress to Closed

fixed

Also available in: Atom PDF