Mythweb Error on CentOS 6

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

Moderator: Forum Moderators

Post Reply
kbocek
Junior
Posts: 83
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: 1249
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
Junior
Posts: 83
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: 1249
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
Junior
Posts: 83
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
Newcomer
Posts: 13
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
Junior
Posts: 83
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.

Post Reply