datetime: 2019-05-22 09:54:47 (PDT)
errornum: 256
error type: User Error
error string: !!NoTrans: SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '+found' at line 1 [#1064]!!
filename: /var/www/html/mythweb/classes/Database/Query/mysqlicompat.php
error line: 98
Does anyone have any ideas? Thanks.
Last edited by kbocek on Tue May 28, 2019 3:16 pm, edited 1 time in total.
datetime: 2019-05-26 08:44:07 (PDT)
errornum: 256
error type: User Error
error string: !!NoTrans: SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '+found' at line 1 [#1064]!!
filename: /var/www/html/mythweb/classes/Database/Query/mysqlicompat.php
error line: 98
That page works for me too. But I'm a *buntu user and on v31-Pre.
I suggest editing the Subject line in your initial post and adding your
distribution name (to see if anyone else picks up on it.)
If there's more to the error above, it may help. The filename above:
var/www/html/mythweb/classes/Database/Query/mysqlicompat.php
on line 98 is just printing the error, but we don't have the full query
that's failing.
MAYBE looking in /var/log/mysql/error.log when the page is accessed
will help.
Now I'm getting the error on the main setting page: http://myserver/mythweb/settings. I checked the mysql log and don't see anything when accessing this URL. I restarted mysql to confirm the log was being written to.
I'm also experiencing this "!!NoTrans" error/issue on 30-Fixes. I recently upgraded from PHP 7.2 to 7.3 which I believe to be the root of the issue but my 7.3 php.ini file appears to have the same settings as my 7.2 did.
Did you ever resolve this issue? Sucks not to be able to search for titles in MythWeb. I'm on Gentoo so I suspect this problem is distribution agnostic.
Meh. I've installed Myth via packages. Patching isn't an option. That is unless I can manually make the change. The bug post is talking about Python 2.7. This host has 2.6.6.
# EXAMPLE, adjust paths as required.
$ cd /var/www/mythweb/
$ sudo patch --dry-run -p1 < ~/Downloads/mythweb.patch
(Stripping trailing CRs from patch; use --binary to disable.)
checking file modules/tv/search.php
Remove the --dry-run from the last command (if you get the same
response) and it will be applied.
Can't explain the Python comment, that ticket is for PHP.
datetime: 2019-06-25 10:14:28 (PDT)
errornum: 256
error type: User Error
error string: !!NoTrans: SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '+found' at line 1 [#1064]!!
filename: /var/www/html/mythweb/classes/Database/Query/mysqlicompat.php
error line: 98
@kbocek, do you have a lost+found directory (could be a file) where your database is stored?
Perhaps /var/lib/mysql/mythconverg or /var/lib/mysql/mysql. The above is trying to check a
table with that name.
datetime: 2019-12-04 08:18:26 (PST)
errornum: 256
error type: User Error
error string: !!NoTrans: SQL Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '+found' at line 1 [#1064]!!
filename: /var/www/html/mythweb/classes/Database/Query/mysqlicompat.php
error line: 98
==========================================================================
Backtrace:
...
I'm assuming /var/lib/mysql is a mount point in the above.
The mysql filesystem is OK (got one myself) but it appears that in a database (I'm guessing
mythconverg, but possibly the mysql DB) there's a lost+found entry that appears to be a table.
In the php in the backtrace, a "SHOW TABLES" is sent and the results are checked. If you
do SQL, then I'd run SHOW TABLES; in both databases to see if lost+found shows up.
[I'd restore the lost+found you removed if you haven't already]