Bruce Roy Posted January 9, 2019 Report Share Posted January 9, 2019 Upgraded to 12.0.2 and when I select Reports from the Info menu I get this error message in all browsers and devices: "An error has occurred in the TNG software. This could be due to a setup issue, an incomplete upgrade or a program bug. If you are the site owner, you may contact TNG support for help with this problem. Please copy the query below and paste it into your message.Query: SELECT reportname, reportdesc, reportID FROM tng_reports WHERE active = 1 ORDER BY rank, reportnameUnknown column 'rank' in 'order clause' " Where do I start? Bruce Royhttps://royroyes.net Quote Link to comment Share on other sites More sharing options...
Bruce Roy Posted January 9, 2019 Author Report Share Posted January 9, 2019 That should be 12.0.3! Quote Link to comment Share on other sites More sharing options...
Ken Roy Posted January 9, 2019 Report Share Posted January 9, 2019 Bruce, If you have run the database upgrade script that changes the column name from rank to ranking in the tng_reports, you may need to download the upgrade again and use the reports.php file from the new download. Quote Link to comment Share on other sites More sharing options...
Bruce Roy Posted January 9, 2019 Author Report Share Posted January 9, 2019 I had run the database upgrade but re-installed and ran it - told me the update had already been done. Took me two attempts to re-load and run reports.php but eventually it came good. Once again, thanks for your help!! Bruce Quote Link to comment Share on other sites More sharing options...
borynka Posted January 22, 2019 Report Share Posted January 22, 2019 I have the same problem. After reinstalling 12.0.3 I see my reports, but I can't edit them via "Administration", because after clicking on the reports the above mentioned message appears again. What else can I do? Thanks in advance for the help. Quote Link to comment Share on other sites More sharing options...
Bruce Roy Posted January 22, 2019 Author Report Share Posted January 22, 2019 See Ken Roy's post above. I had already done what he suggested with the upgrade but I had to re-do it twice to get a result - perhaps because my computer was still reading the old version of reports.php. So quit TNG and then re-start. Quote Link to comment Share on other sites More sharing options...
borynka Posted January 23, 2019 Report Share Posted January 23, 2019 Thank you very much for your answer. I reinstalled 12.0.3 5 times and followed the instructions exactly. The result is still negative. Probably I have to wait for a new update if I don't find someone who has an idea for the cause of the problem. Quote Link to comment Share on other sites More sharing options...
Ken Roy Posted January 23, 2019 Report Share Posted January 23, 2019 When did you download TNG 12.0.3? Did you run the database update when you upgraded? Quote Link to comment Share on other sites More sharing options...
borynka Posted January 24, 2019 Report Share Posted January 24, 2019 Hello, Ken. Thanks for the message. I downloaded TNG 12.0.3 again today, unpacked it and uploaded it to the server via FileZilla, then opened the readme file in the browser and finally executed the link "upgrade db1202-12xphp" under point 5 of the installation instructions (update the database structur). However, I don't see a list of messages telling me what is happening and that it is finished. Then I cleared the cache. I did all this three times today and then gave it up. I see in the administration area that there are 4 reports, but I only get the message that Bruce posted but no access to the reports. What am I doing wrong? What could be the reason? Thank you for taking the time for my problems. Greetings from Vienna. Translated with www.DeepL.com/Translator Quote Link to comment Share on other sites More sharing options...
Ken Roy Posted January 24, 2019 Report Share Posted January 24, 2019 Did you upload any of the modules from the upgrade zip file? I believe there was a fix for the reports.php if I remember correctly that would have been merged into the upgrade zip files that was created to fix a problem with the query using the rank column name which was changed to ranking because rank is now a reserved word in MySQL 8 Quote Link to comment Share on other sites More sharing options...
borynka Posted January 24, 2019 Report Share Posted January 24, 2019 I downloaded the zip-file "tngupgrade1202-1203.zip" today and unpacked it. I uploaded all modules to the server. The module "reports.php" was included. A fix is not known to me. Where can I find it? Thanks again for your time. Quote Link to comment Share on other sites More sharing options...
Ken Roy Posted January 24, 2019 Report Share Posted January 24, 2019 Line 8 in reports.php should be $query = "SELECT reportname, reportdesc, reportID FROM $reports_table WHERE active = 1 ORDER BY ranking, reportname"; where it uses ORDER by ranking Quote Link to comment Share on other sites More sharing options...
borynka Posted January 24, 2019 Report Share Posted January 24, 2019 I have to thank you again. But it's exactly the same in line 8 of my reports.php. You can see it in the appendix: reports.php Quote Link to comment Share on other sites More sharing options...
Ken Roy Posted January 24, 2019 Report Share Posted January 24, 2019 I would suggest you report the problem to Darrin, I do not know what else to suggest Quote Link to comment Share on other sites More sharing options...
borynka Posted January 25, 2019 Report Share Posted January 25, 2019 Trank you again. I will do it. Greeting from Vienna. 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.