Database error when upgrading?

[SpeedyTV.com]

I just ran the 8.1 /install/upgrade.php file and got the following error:

"SQL/DB Error -- [Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause]"

Any idea what the issue is?

[ServiceNinja]

I'm getting the same thing:

SQL/DB Error -- [Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause]

[kbeeveer46]

Try this fix for now http://www.pligg.com/forum/showthread.php?t=2056

[toopie]

Thank's it helps allot!

[ServiceNinja]

If you're still having issues upgrading try http://www.serviceninja.com/pligg/upgrade.phps

Rename this to upgrade.php and upload, then you should be all set. I noticed that createtables.php, which is for new installs and upgrade.php are not updated the same it seems. This fix should take care of most issues upgrading.

[ServiceNinja]

The above should also help if you're getting the following:

SQL/DB Error -- [Invalid default value for 'user_lastlogin']