DC_CCFC

Just spotted a bug – when I change it to Manual, it automatically switches back to “Auto”.

For the columns, I set the Statistics to “manual”, but I can’t find where to untick what columns are displayed?

Found out. Forces the position numbers to be displayed when teams are tied.

Hi Roch

Found the issue is with tie-break.

Disabling tie-break fixes the issue for me.

See other thread
https://www.ads-software.com/support/topic/database-error-with-tables/page/2/#post-8847407

Found it! Awesome! ??

Disabling tie-break also worked.

How do I disable tie break?!

Thanks for finding the temporary fix!

Any updates on this or a planned fix in future release?

Actually turns out it’s still distorted – not sure why! ??
https://www.corkcityfc.ie/home/list/cork-city-senior-team/

Any ideas on this one?

This worked! Thanks

Was able to fix this! Was caused by some images not being square.

Hi Roch,

Just wondering if you heard any thing back from the developers?

I’ve got my finger on the button ready to purchase the Pro licence, but this is the only thing that’s holding me back.

Thanks for all the help.

That worked perfectly! Thanks!

To not have the same happen on a “team” page, would it be:

.sp_team-template-default .post-image {
display: none;
}

My site has been re-activated by my host and the SQL query has been killed.

I can see the League Table created now when I go to manage League Tables.

If I click to edit it or “View” it on the site, the whole site times out again due to the query not closing.

My host gave me these logs:

DB_USERNAME | [IP_ADDRESS]:[PORT] | DB_NAME | Query | 1055 | Locked | SELECT wp_posts.* FROM wp_posts WHERE 1=1 AND (( YEAR( wp_posts.post_date ) = 2017 AND MONTH                  
DB_USERNAME | [IP_ADDRESS]:[PORT] | DB_NAME | Query | 1050 | Locked | SELECT SQL_CALC_FOUND_ROWS wp_posts.ID FROM wp_posts WHERE 1=1 AND wp_posts.post_type = 'post'

• This reply was modified 7 years, 9 months ago by DC_CCFC.

Update on this.

I enabled W3 TC caching plugin and enabled the Object Cache option.

I deleted all league tables.

I went to create a new league table. I was able to enter the details, set the filters (League, Teams, Season etc).

When I clicked “Publish”, the page just spins and spins and doesn’t complete.

This caused my whole site to go down, and my host advised that it’s due to an unclosed SQL connection.