Jump to content
TNG Community
Bruce Roy

Reports do not show

Recommended Posts

Bruce Roy

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, reportname

Unknown column 'rank' in 'order clause'  "

Where do I start?

Bruce Roy
https://royroyes.net

Share this post


Link to post
Share on other sites
Bruce Roy

That should be 12.0.3!

Share this post


Link to post
Share on other sites
Ken Roy

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.

Share this post


Link to post
Share on other sites
Bruce Roy

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

Share this post


Link to post
Share on other sites
borynka

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.

 

 

Share this post


Link to post
Share on other sites
Bruce Roy

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.

Share this post


Link to post
Share on other sites
borynka

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.

Share this post


Link to post
Share on other sites
Ken Roy

When did you download TNG 12.0.3?  Did you run the database update when you upgraded?

Share this post


Link to post
Share on other sites
borynka

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

Share this post


Link to post
Share on other sites
Ken Roy

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

Share this post


Link to post
Share on other sites
borynka

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.

Share this post


Link to post
Share on other sites
Ken Roy

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

Share this post


Link to post
Share on other sites
borynka

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

Share this post


Link to post
Share on other sites
Ken Roy

I would suggest you report the problem to Darrin, I do not know what else to suggest

Share this post


Link to post
Share on other sites
borynka

Trank you again. I will do it. Greeting from Vienna. 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×