Mythweb Error on CentOS 6

Have a MythTV related problem? Ask for help from other MythTV users here.

Moderator: Forum Moderators

Post Reply
kbocek
Senior
Posts: 112
Joined: Mon Jul 20, 2015 4:42 pm
United States of America

Mythweb Error on CentOS 6

Post by kbocek » Wed May 22, 2019 4:56 pm

I upgraded from .27 to 29.1 and am getting this error in Mythweb when I try to use the configuration tool:

Code: Select all

    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.

User avatar
bill6502
Developer
Posts: 1358
Joined: Fri Feb 07, 2014 5:28 pm
United States of America

Re: Mythweb Error

Post by bill6502 » Thu May 23, 2019 11:00 pm

Hi,

Please mention a specific page, e.g. .../mythweb/settings/mythtv . I
clicked on all six and they display fine.

Also, you've upgraded mythweb to v29 too right (have to ask.)

kbocek
Senior
Posts: 112
Joined: Mon Jul 20, 2015 4:42 pm
United States of America

Re: Mythweb Error

Post by kbocek » Sun May 26, 2019 3:43 pm

The page is http://myserver/mythweb/settings/database:

Code: Select all

    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
Yes, Mythweb is 29.1:

Code: Select all

$ rpm -q mythweb
mythweb-29.1-2.el6.noarch

User avatar
bill6502
Developer
Posts: 1358
Joined: Fri Feb 07, 2014 5:28 pm
United States of America

Re: Mythweb Error

Post by bill6502 » Mon May 27, 2019 10:17 pm

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.

kbocek
Senior
Posts: 112
Joined: Mon Jul 20, 2015 4:42 pm
United States of America

Re: Mythweb Error on CentOS 6

Post by kbocek » Tue May 28, 2019 3:21 pm

Done.

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.

Vaska
Junior
Posts: 17
Joined: Fri Sep 01, 2017 11:09 pm
Canada

Re: Mythweb Error on CentOS 6

Post by Vaska » Wed Jun 12, 2019 1:42 am

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.

Vaska

kbocek
Senior
Posts: 112
Joined: Mon Jul 20, 2015 4:42 pm
United States of America

Re: Mythweb Error on CentOS 6

Post by kbocek » Wed Jun 12, 2019 4:41 pm

Nope did not. I'm running 29.1 on CentOS6. I too thought it might be a PHP version issue but I have no answers.

Vaska
Junior
Posts: 17
Joined: Fri Sep 01, 2017 11:09 pm
Canada

Re: Mythweb Error on CentOS 6

Post by Vaska » Mon Jun 24, 2019 5:42 pm

FYI - I just applied the patch below and it resolved my issue, it will probably fix your problem too.

https://code.mythtv.org/trac/ticket/13368#no1

Cheers

kbocek
Senior
Posts: 112
Joined: Mon Jul 20, 2015 4:42 pm
United States of America

Re: Mythweb Error on CentOS 6

Post by kbocek » Mon Jun 24, 2019 5:58 pm

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.

User avatar
bill6502
Developer
Posts: 1358
Joined: Fri Feb 07, 2014 5:28 pm
United States of America

Re: Mythweb Error on CentOS 6

Post by bill6502 » Mon Jun 24, 2019 6:23 pm

Download the patch from the link above. In this example, the
patch is in ~/Downloads and mythweb is under /var/www:

Code: Select all

# 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.

Vaska
Junior
Posts: 17
Joined: Fri Sep 01, 2017 11:09 pm
Canada

Re: Mythweb Error on CentOS 6

Post by Vaska » Mon Jun 24, 2019 8:54 pm

kbocek - It's just one file in the mythweb folder mythweb/modules/tv/search.php

Just create a backup of it if you're hesitant to patch it "cp search.php search.php.backup" then apply the patch as shown above.

Don't let the fact that you installed it from a package stop you from patching this one file, especially since it resolves the issue.

kbocek
Senior
Posts: 112
Joined: Mon Jul 20, 2015 4:42 pm
United States of America

Re: Mythweb Error on CentOS 6

Post by kbocek » Tue Jun 25, 2019 5:15 pm

Nope. Patch applied without an error. Still a problem clicking on the button in Mythweb for settings.

Code: Select all

    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
Here's the full backtrace:
https://pastebin.com/wC02dtcB

Post Reply