MyWebSQL icon indicating copy to clipboard operation
MyWebSQL copied to clipboard

Sqlite3 issues

Open SubrataM3 opened this issue 6 years ago • 0 comments

Hi,

Updating database records does not work on sqlite3. I have found sqlite3.php is calling sqlite_changes() which is an old (sqlite2) function. Please see error below.

"PHP message: PHP Fatal error:  Uncaught Error: Call to undefined method SQLite3Result::changes() in /srv/html/mywebsql/lib/db/sqlite3.php:145
Stack trace:
#0 /srv/html/mywebsql/lib/sqlparser.php(389): DB_Sqlite3->getAffectedRows()
#1 /srv/html/mywebsql/modules/queryall.php(29): SqlParser->parseFile(Resource id #1)
#2 /srv/html/mywebsql/lib/util.php(101): processRequest(Object(DB_Sqlite3))
#3 /srv/html/mywebsql/index.php(76): execute_request(Object(DB_Sqlite3))
#4 {main}
  thrown in /srv/html/mywebsql/lib/db/sqlite3.php on line 145"

Thanks.

SubrataM3 avatar Jul 03 '19 20:07 SubrataM3