LinHES Forums
http://forums.linhes.org/

R8.3 - Myhthweb can't write to database
http://forums.linhes.org/viewtopic.php?f=22&t=24169
Page 1 of 1

Author:  grego892 [ Wed Apr 15, 2015 6:25 am ]
Post subject:  R8.3 - Myhthweb can't write to database

I upgraded to R8.3 fine. Everything worked. Later did a fresh install of R8.3 and now Mythweb gives error on any screen when I press the save button. I have done the fresh install a few times to make sure I didn't do anything stupid. Still not ruling out the fact i did something stupid though. haha.

Thanks for all your work, guys. Awesome project!!!

Greg


Here's parts of the error message:

Fatal Error

!!NoTrans: SQL Error: Incorrect integer value: '' for column 'finetune' at row 1 [#1366]!!

datetime: 2015-04-15 07:08:06 (CDT)
errornum: 256
error type: User Error
error string: !!NoTrans: SQL Error: Incorrect integer value: '' for column 'finetune' at row 1 [#1366]!!
filename: /data/srv/httpd/mythweb/classes/Database/Query/mysql.php
error line: 79

Author:  tscholl [ Wed Apr 15, 2015 9:41 am ]
Post subject:  Re: R8.3 - Myhthweb can't write to database

Sounds familiar but not sure if it's the same issue., but have a look at this post.

Author:  spideyk21 [ Thu Jun 25, 2015 7:11 pm ]
Post subject:  Re: R8.3 - Myhthweb can't write to database

I have encountered the same issue with a new/fresh install of 8.3. I was able to get things working by doing the following (after a whole bunch of google digging).

change php.ini
Code:
max_input_vars = 100000

and comment out the following line in /user/my.cnf (add # in front of the line)
Code:
sql-mode="STRICT_TRANS_TABLES"

Not sure if this is the "correct" way to fix the problems, but right now there are no ill effects. No to see if can recover a backup from my errored drive to restore on the new hard drive.

Author:  tscholl [ Thu Jun 25, 2015 10:27 pm ]
Post subject:  Re: R8.3 - Myhthweb can't write to database

Great glad it helped!

Page 1 of 1 All times are UTC - 6 hours
Powered by phpBB® Forum Software © phpBB Group
http://www.phpbb.com/