View Issue Detail

ID	Project	Category	Submitted / Last Updated
01458	UserSpice	Plugins	2022-01-25 22:50:52 / 2022-02-19 14:33:15
Reported	Cary Hendricks	Assigned To	Unassigned
Priority	none	Reported	5.4.0
Status	addon	Resolution Version and Commit
Summary	passwordless plugin does not seem to install all the fields required in user table
Description	Quick observation about a possible bug, in the passwordless install.php It has 2 lines (44,45) to add 2 fields to the user table. (pwl and pwl_to) but the installer did not add it to my db. I installed the plugin via spice shaker. The table plg_passwordless_settings did get created and the alter (line 43) to add the timeout column worked. I tried to add the columns manually but the following error popped up, possibly the reason it failed during the installation. ALTER TABLE users ADD COLUMN pwl varchar(255); MySQL said: #1118 - Row size too large. The maximum row size for the used table type, not counting BLOBs, is 8126. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs