Based on the discussion in this thread, "How to automatically Clear Cache" I decided to test converting my tables from MyISAM to InnoDB on my test site and on the user table received the following error
Invalid default value for 'passworddate'
Shown below is the output of Describe user; I'm assuming once I correct passworddate I'll have the same issue with birthday_search. Can you let me know what the correct default value for these fields should be?
If it matters,
MySQL 5.7.22
PHP 7.1.18
vBulletin 5.4.2
Invalid default value for 'passworddate'
Shown below is the output of Describe user; I'm assuming once I correct passworddate I'll have the same issue with birthday_search. Can you let me know what the correct default value for these fields should be?
PHP Code:
+-----------------------+----------------------+------+-----+------------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-----------------------+----------------------+------+-----+------------+----------------+
| userid | int(10) unsigned | NO | PRI | NULL | auto_increment |
| usergroupid | smallint(5) unsigned | NO | MUL | 0 | |
| membergroupids | varchar(250) | NO | | | |
| displaygroupid | smallint(5) unsigned | NO | | 0 | |
| username | varchar(100) | NO | MUL | | |
| passworddate | date | NO | | 0000-00-00 | |
| email | varchar(100) | NO | MUL | | |
| styleid | smallint(5) unsigned | NO | | 0 | |
| parentemail | varchar(50) | NO | | | |
| homepage | varchar(100) | NO | | | |
| icq | varchar(20) | NO | | | |
| aim | varchar(20) | NO | | | |
| yahoo | varchar(32) | NO | | | |
| msn | varchar(100) | NO | | | |
| skype | varchar(32) | NO | | | |
| google | char(32) | NO | | | |
| status | mediumtext | YES | | NULL | |
| showvbcode | smallint(5) unsigned | NO | | 0 | |
| showbirthday | smallint(5) unsigned | NO | | 2 | |
| usertitle | varchar(250) | NO | | | |
| customtitle | smallint(6) | NO | | 0 | |
| joindate | int(10) unsigned | NO | MUL | 0 | |
| daysprune | smallint(6) | NO | | 0 | |
| lastvisit | int(10) unsigned | NO | | 0 | |
| lastactivity | int(10) unsigned | NO | MUL | 0 | |
| lastpost | int(10) unsigned | NO | | 0 | |
| posts | int(10) unsigned | NO | MUL | 0 | |
| reputation | int(11) | NO | | 10 | |
| reputationlevelid | int(10) unsigned | NO | | 1 | |
| timezoneoffset | varchar(4) | NO | | | |
| pmpopup | smallint(6) | NO | | 0 | |
| avatarid | smallint(6) | NO | | 0 | |
| avatarrevision | int(10) unsigned | NO | | 0 | |
| profilepicrevision | int(10) unsigned | NO | | 0 | |
| options | int(10) unsigned | NO | | 167788559 | |
| privacy_options | mediumtext | YES | | NULL | |
| notification_options | int(10) unsigned | NO | | 1073741818 | |
| birthday | varchar(10) | NO | MUL | | |
| birthday_search | date | NO | MUL | 0000-00-00 | |
| maxposts | smallint(6) | NO | | -1 | |
| startofweek | smallint(6) | NO | | 1 | |
| ipaddress | varchar(45) | NO | | | |
| referrerid | int(10) unsigned | NO | MUL | 0 | |
| languageid | smallint(5) unsigned | NO | | 0 | |
| emailstamp | int(10) unsigned | NO | | 0 | |
| threadedmode | smallint(5) unsigned | NO | | 0 | |
| emailnotification | smallint(5) unsigned | NO | | 0 | |
| pmtotal | smallint(5) unsigned | NO | | 0 | |
| pmunread | smallint(5) unsigned | NO | | 0 | |
| importuserid | bigint(20) | NO | | 0 | |
| adminoptions | int(10) unsigned | NO | | 0 | |
| lastpostid | int(10) unsigned | NO | | 0 | |
| sigpicrevision | int(10) unsigned | NO | | 0 | |
| ipoints | int(10) unsigned | NO | | 0 | |
| infractions | int(10) unsigned | NO | | 0 | |
| warnings | int(10) unsigned | NO | | 0 | |
| infractiongroupids | varchar(255) | NO | | | |
| infractiongroupid | smallint(5) unsigned | NO | | 0 | |
| profilevisits | int(10) unsigned | NO | | 0 | |
| friendcount | int(10) unsigned | NO | | 0 | |
| friendreqcount | int(10) unsigned | NO | | 0 | |
| vmunreadcount | int(10) unsigned | NO | | 0 | |
| vmmoderatedcount | int(10) unsigned | NO | | 0 | |
| socgroupinvitecount | int(10) unsigned | NO | | 0 | |
| socgroupreqcount | int(10) unsigned | NO | | 0 | |
| pcunreadcount | int(10) unsigned | NO | | 0 | |
| pcmoderatedcount | int(10) unsigned | NO | | 0 | |
| gmmoderatedcount | int(10) unsigned | NO | | 0 | |
| assetposthash | varchar(32) | NO | | | |
| fbuserid | varchar(255) | NO | MUL | NULL | |
| fbjoindate | int(10) unsigned | NO | | 0 | |
| fbname | varchar(255) | NO | | NULL | |
| logintype | enum('vb','fb') | NO | | vb | |
| fbaccesstoken | varchar(255) | NO | | NULL | |
| newrepcount | smallint(5) unsigned | NO | | 0 | |
| bloggroupreqcount | int(10) unsigned | NO | | 0 | |
| showblogcss | int(11) | NO | | 1 | |
| panjo_selling | tinyint(1) | YES | | NULL | |
| token | varchar(255) | NO | | | |
| scheme | varchar(100) | NO | | | |
| secret | varchar(100) | NO | | | |
| autosubscribe | smallint(5) unsigned | NO | | 0 | |
| privacyconsent | tinyint(4) | NO | MUL | 0 | |
| privacyconsentupdated | int(10) unsigned | NO | | 0 | |
| eustatus | tinyint(4) | NO | | 0 | |
+-----------------------+----------------------+------+-----+------------+----------------+
If it matters,
MySQL 5.7.22
PHP 7.1.18
vBulletin 5.4.2
Comment