Debug info: ERROR: value "32768" is out of range for type smallint about moodle-block_advnotifications HOT 6 CLOSED

That's impressive. Even more-so, because the 'seen' field tracks each notification per-user. So a single user (perhaps admin?) has had a notification shown to them that many times.

I've pushed an update (826a322) to increase the maximum seen amount significantly. As per BIGINT:

• PostgreSQL - https://www.postgresql.org/docs/9.1/datatype-numeric.html
• MySQL - https://dev.mysql.com/doc/refman/8.0/en/integer-types.html

Will just wait for TravisCI to finish successfully, and then I'll update it on Moodle Plugins Directory.

Thanks again,
Zander

from moodle-block_advnotifications.

Hi @caiado,

Looks like that notification has been seen a whopping 32767 times! 🤯

I'll update the next release of the plugin to either increase the maximum allowed 'seen' number or add a check if we've reached the maximum.

For now, a work-around would be to re-create the exact same notification - that way it will appear the same to users, but it will start counting from 0 again.

Or, possibly running (untested, please test on test-site first) in the database:

UPDATE mdl_block_advnotificationsdissed SET seen = 1 WHERE id=1

^{(will reset that specific user's view times of that notification to 1)}
or

UPDATE mdl_block_advnotificationsdissed SET seen = 1 WHERE seen > 32000

^{(will reset all notification views of more than 32000 - close to max of 32767 - to 1)}

Hope this helps in the meantime, thanks for reporting with detailed info! 😃

Thanks,
Zander

from moodle-block_advnotifications.

For reference...
Different DB's handle XMLDB's int type and LENGTH differently:
https://docs.moodle.org/dev/XMLDB_column_types

from moodle-block_advnotifications.

Zander,

Our list of users goes beyond 250K.

Looking forward for the update.

Ricardo

from moodle-block_advnotifications.

Thank you!

from moodle-block_advnotifications.

Have released the new version on Moodle Plugins Directory - https://moodle.org/plugins/block_advnotifications

Cheers!
_{Will close this issue now}

from moodle-block_advnotifications.