cmalvache Posted September 23, 2020 Report Share Posted September 23, 2020 Hi, I have a problem with Medias. Since the update 13: the page showmedia is blocked on Loading... It's strange because if I choose Slide Show it works. Try here : https://www.malvache.net/showmedia.php?mediaID=14847&albumlinkID=5&tngpage=4 I disabled all mods ...same problem Any ideas ? Quote Link to comment Share on other sites More sharing options...
cmalvache Posted September 23, 2020 Author Report Share Posted September 23, 2020 I just completely reinstalled tng13. The problem persists. Quote Link to comment Share on other sites More sharing options...
Ken Roy Posted September 23, 2020 Report Share Posted September 23, 2020 Error message being returned indicates Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '=' So you need to fix your database collation sequence Quote Link to comment Share on other sites More sharing options...
cmalvache Posted September 23, 2020 Author Report Share Posted September 23, 2020 It works many thanks. Solution: open my database with phpmyadmin select operations : Quote Link to comment Share on other sites More sharing options...
theKiwi Posted September 23, 2020 Report Share Posted September 23, 2020 Except it isn't really fixed in total - there are issues with the language files it seems as I see a number of missing characters, replaced by the ? in a black diamond on the page linked above The source code for the page shows it's using UTF-8. Is TNG properly configured to be using the UTF-8 language files? Roger Quote Link to comment Share on other sites More sharing options...
cmalvache Posted September 24, 2020 Author Report Share Posted September 24, 2020 Il y a 12 heures , theKiwi said: Except it isn't really fixed in total - there are issues with the language files it seems as I see a number of missing characters, replaced by the ? in a black diamond on the page linked above The source code for the page shows it's using UTF-8. Is TNG properly configured to be using the UTF-8 language files? Roger Oups, thanks. It's ok now Quote Link to comment Share on other sites More sharing options...
MichaelM Posted September 26, 2020 Report Share Posted September 26, 2020 Hi, I have the same problem, showmedia is hangig at "Loading" ; Dia-Show is working But I do not have a glance, what to do and what adjustments, I should make in PHPMyAdmin. Currently It shows: Currently I try running TNG13 under Xampp, prior to publish it on my Website.. regards Michael Quote Link to comment Share on other sites More sharing options...
MichaelM Posted September 26, 2020 Report Share Posted September 26, 2020 Am 23.9.2020 um 18:31 schrieb Ken Roy: Error message being returned indicates Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '=' So you need to fix your database collation sequence Hello Ken, where can I retrieve the Error Message from ? Currently, I do not see an Error, just a hanging pagelike this: regards Michael Quote Link to comment Share on other sites More sharing options...
MichaelM Posted September 26, 2020 Report Share Posted September 26, 2020 SOLVED SOLVED SOLVED SOLVED I crawled in PHBMyAdmin and found the Error-Message under "Operations" related to the TNG-Database and changed all Collation to "latin1_general_cs"; Hope this is correct... Now Media were loaded. regards Michael Quote Link to comment Share on other sites More sharing options...
Ken Roy Posted September 26, 2020 Report Share Posted September 26, 2020 Michael, latin1_general_cs would only be valid if your database is not created as a UTF-8 database. If you use accented characters these days, it might be better to create your database as UTF-8 For access to the PHP errors, you can install the Show PHP Error Log mod or the Prolog Mod but in both cases you may need to follow the instructions in PHP Error Log Quote Link to comment Share on other sites More sharing options...
MichaelM Posted September 26, 2020 Report Share Posted September 26, 2020 Thankyou, Ken On Xampp all seems to be is o.K. now. I'll try the qbove mods, when running into PGP problems again. Ive transferred the application to my public Webserver and got other problems; I'll setup a new post in the forum ... regards Michael Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.