pixeldude

It was a small glitch in the database, which was corrected by invision support. Thanks!

Is there an easy way to change the icon of the member group?

Hi Marc,

Do you mean solved_date  in table core_solved_index has been added by a 3rd party item?

The error persists even when disabling all 3rd party items and a background task is stuck on one specific forum with "Rebuilding solved statistics for forum [name]"

Error log is flooded with :

SELECT AVG(core_solved_index.solved_date-forums_topics.start_date) FROM `forums_topics`  LEFT JOIN `core_solved_index` ON core_solved_index.app='forums' AND core_solved_index.item_id=forums_topics.tid WHERE ( state NOT IN('link','merged') ) AND ( approved NOT IN(-2,-3) ) AND forum_id=25 AND start_date > 1390911377 AND start_date < 1396051140 AND core_solved_index.id IS NOT NULL
BIGINT UNSIGNED value is out of range in '`schq_prd`.`core_solved_index`.`solved_date` - `schq_prd`.`forums_topics`.`start_date`'

The forum in question is of type "discussion", so why is the system even querying for solved dates?

Hello,

I'm getting this background task error after the upgrade to 4.7.5: 

1S111/1 BIGINT UNSIGNED value is out of range in '`schq_prd`.`core_solved_index`.`solved_date` - `schq_prd`.`forums_topics`.`start_date`'

Seems a substraction is causing this error, what can I do to solve this?

Thanks!

On 9/17/2020 at 4:39 PM, Jaymez said:

does this work with 4.5.x?

Unfortunately he hasn‘t answered this, but mentioned on his website ipsguru that development hast stopped. Seems to be abandoned.

Edit: Application is abandoned, no further updates expected.

I'm trying to set up the integration and have some questions:

1. Adding the UUID to the Member Profile enables what exactly? Only showing the the status in the Profile tab?
2. Setting up syncing between Board and TS Group: I expected that Members who have their UUID set in their Profile would be assigned a server group upon login. This does not seem to be the case, or maybe I did something wrong.
3. TS Viewer. It would be awesome to have this functionality without a 3rd party service. Also being able to configure to show only active and/or selected channels. Example: https://github.com/LeoWinterDE/TS3ServerStatusViewer

Is there a way to hide certain trophies/medals from the postbit, but not from the profile?

This looks great and I’d love to buy it, but the renewal is pretty hefty at $40 per year IMO. Nice to have, but not an essential enough feature to justify the ongoing costs. ?