Out of range value for column 'HITS'

[ecommweb]

Hi there
hope someone can help

We Updated to 2.1 from 2.0
reinstalled the Ads mod and it sort of worked, but on each page either the top or the bottom Ad worked but not both, and this message appears at the foot of the page when logged in as admin

Code Select Expand

Out of range value for column 'HITS' at row 1
File: /home/sites/7a/3/3724611fe4/public_html/Sources/LoadAds.php

Tried uninstalling the mod and reinstalling the mod and now there are no ads anyway, just the error message for admins as above and this one for non logged in users

Code Select Expand

Database Error
Please try again. If you come back to this error screen, report the error to an administrator.
https://www.beachbuggy.info
Line: 298

Gary

[vbgamer45]

Run the following SQL query on your database for a fix

Code Select Expand

alter table smf_ads change HITS HITS BIGINT NOT NULL default '0';