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

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

×