Thread: SQL Error when updating awards..

Originally Posted by CheeSie

Code:

Database error in vBulletin 3.8.4:

Invalid SQL:
UPDATE awc_awards SET enabled='1',name='Donation Award',description='This award is given to a member of the site who has donated',image='dsaw_1.gif',amount='5.00',ugp='0',display='0',time=null,ugpr='0',frate='5.00',brate='1.00' WHERE id=1 AND sid='ds';

MySQL Error   : Column 'time' cannot be null
Error Number  : 1048

It is telling you the problem TIME can NOT be blank have to set a TIME for the award. Then after created can update and put blank time for permanent. I just forgot to put warning message can't be blank instead of the mysql error will be fixed in next version. This hinders no issues with core software or functioning of software either.

Originally Posted by CheeSie

Also when updating the awards the "User groups that "ARE" affected by the usergroup/membership change" aren't changing..

Works perfect for years of software. It ALL has to do with settings and how you have it set up. If you need more help post a screen shot of your award settings and awards and awards edit of one of them.

Originally Posted by CheeSie

Also at awcoding.php?do=awards&sid=ds
The "flat" and "base" are blank, but the flat value has been inserted into the time column..

This has been posted before some weird combo of turning on and off some causes the issue haven't looked into it yet as most people dont show all that info and was a new feature settings of last version. Before you didnt have option to show all those just the core for awards (image,name,description,amount).

Originally Posted by CheeSie

Sorry my tripple posts but...

When hovering the awards in the postbit, is it possible to get the award description showing instead of the award title?

go to admincp styles and templates. Go to awcoding templates then go to awc_awards_postbit and look for:
{$awc_awards_info['name']}

change it too:

{$awc_awards_info['description']}

See if that works as it should.