Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
#16 2015-12-23 11:45:53
- bulldog
- New Member
- Registered: 2015-12-15
- Posts: 5
Re: Errors on clean install on localhost.
@ruud, after a language is installed, the (Install)link shows further Update and is clickable (active). Normally, after install or update language, there is no link, just text that says »updated«. You know what I mean?
@ruud, the development version of TXP via GIT (4.6-dev) doesn’t have the lines you mentioned, so I don’t know where I have to add the two SET SQL MODE lines.
Offline
Re: Errors on clean install on localhost.
The line numbers are perhaps a bit different, but those lines are there.
I tried installing a language and for me it showed ‘updated’, so I can’t reproduce that.
Offline
#18 2015-12-24 11:56:43
- bulldog
- New Member
- Registered: 2015-12-15
- Posts: 5
Re: Errors on clean install on localhost.
The issue about the Update languages was related on a missing timezone setting in php.ini. Once I configure this it works well. Sorry, my fault.
But no, the lines you are mentioned are not one-to-one there. OK, I have to dig a little bit deeper ;o)
I edit the file textpattern/lib/txplib_db.php around line 218:
mysqli_query($this->link, "SET NAMES ".$this->charset);Just below that line, I add the following line:
mysqli_query($this->link, "SET SESSION sql_mode = ''");Also I edit textpattern/setup/txpsql.php around line 79 that reads:
mysqli_query($link, "SET NAMES ".$dbcharset);And add the SET SESSION line below as follow:
mysqli_query($link, "SET SESSION sql_mode = ''");This solves all problems and the installation works without any errors.
Merry Christmas @ all
Offline