Jump to content
TNG Community
Sign in to follow this  
etysne

Report error when open report

Recommended Posts

etysne

In admin, when I open reports, I get message:
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 reportID, reportname, reportdesc, ranking, active FROM tng_reports ORDER BY ranking, reportname, reportID LIMIT 200

Unknown column 'ranking' in 'field list'

Running 12.0.3 on my site

regards

Share this post


Link to post
Share on other sites
Chris Lloyd

If you've upgraded recently it may be caused by a mod that needs to be re-installed. The error message is stating that there is no db field for ranking.

Some mods require new db fields.

Share this post


Link to post
Share on other sites
Ken Roy

Did you upgrade recently?  or was this a new install?  The field name was changed from rank to ranking in TNG 12.0.3 and there is a fix in the TNG 12.1 beta related to this change, so you may need to contact Darrin to get the fix.

Edited:  If this was an upgrade, you need to make sure you ran the db_upgrade step that changed the field from rank to ranking

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
Sign in to follow this  

×