[GH-ISSUE #32] Fail to find table #158

New issue

Closed

opened 2026-03-07 20:41:41 +03:00 by kerem · 0 comments

kerem commented

2026-03-07 20:41:41 +03:00

Owner

Originally created by @ishmaelen on GitHub (Dec 28, 2016).
Original GitHub issue: https://github.com/DBDiff/DBDiff/issues/32

Hello

When using the server.db.table syntax as below DBDiff fails to find the table in a certain database.
The databasename is equal on both sides (local and remote). I am running php 5.6.29, composer 1.3.0 and latest DBDiff.

#./dbdiff server1.dbname.table1:server2.dbname.table2 --nocomments=true --type=schema

Unexpected error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbname.table1' doesn't exist (SQL: SHOW CREATE TABLE table1)

PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbname.table1' doesn't exist' in /usr/local/src/DBDiff/vendor/illuminate/database/Illuminate/Database/Connection.php:301
Stack trace:
#0 /usr/local/src/DBDiff/vendor/illuminate/database/Illuminate/Database/Connection.php(301): PDOStatement->execute(Array)
#1 /usr/local/src/DBDiff/vendor/illuminate/database/Illuminate/Database/Connection.php(617): Illuminate\Database\Connection->Illuminate\Database{closure}(Object(Illuminate\Database\MySqlConnection), 'SHOW CREATE TAB...', Array)
#2 /usr/local/src/DBDiff/vendor/illuminate/database/Illuminate/Database/Connection.php(581): Illuminate\Database\Connection->runQueryCallback('SHOW CREATE TAB...', Array, Object(Closure))
#3 /usr/local/src/DBDiff/vendor/illuminate/database/Illuminate/Database/Connection.php(304): Illuminate\Database\Connection->run('SHOW CREATE TAB...', Array, Object(Closure))
#4 /usr/local/src/DBDiff/src/DB/Schema/TableSchema.php(40): Illumi in /usr/local/src/DBDiff/vendor/illuminate/database/Illuminate/Database/Connection.php on line 625

Originally created by @ishmaelen on GitHub (Dec 28, 2016). Original GitHub issue: https://github.com/DBDiff/DBDiff/issues/32 Hello When using the server.db.table syntax as below DBDiff fails to find the table in a certain database. The databasename is equal on both sides (local and remote). I am running php 5.6.29, composer 1.3.0 and latest DBDiff. `#./dbdiff server1.dbname.table1:server2.dbname.table2 --nocomments=true --type=schema` > Unexpected error: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbname.table1' doesn't exist (SQL: SHOW CREATE TABLE `table1`) > PHP Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'dbname.table1' doesn't exist' in /usr/local/src/DBDiff/vendor/illuminate/database/Illuminate/Database/Connection.php:301 Stack trace: #0 /usr/local/src/DBDiff/vendor/illuminate/database/Illuminate/Database/Connection.php(301): PDOStatement->execute(Array) #1 /usr/local/src/DBDiff/vendor/illuminate/database/Illuminate/Database/Connection.php(617): Illuminate\Database\Connection->Illuminate\Database\{closure}(Object(Illuminate\Database\MySqlConnection), 'SHOW CREATE TAB...', Array) #2 /usr/local/src/DBDiff/vendor/illuminate/database/Illuminate/Database/Connection.php(581): Illuminate\Database\Connection->runQueryCallback('SHOW CREATE TAB...', Array, Object(Closure)) #3 /usr/local/src/DBDiff/vendor/illuminate/database/Illuminate/Database/Connection.php(304): Illuminate\Database\Connection->run('SHOW CREATE TAB...', Array, Object(Closure)) #4 /usr/local/src/DBDiff/src/DB/Schema/TableSchema.php(40): Illumi in /usr/local/src/DBDiff/vendor/illuminate/database/Illuminate/Database/Connection.php on line 625