Database error when upgrading?
-
Pligg Donor
Database error when upgrading?
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?
-
New Pligger
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]
-
Pligg Developer/Admin
-
Casual Pligger
-
New Pligger
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.
-
New Pligger
The above should also help if you're getting the following:
SQL/DB Error -- [Invalid default value for 'user_lastlogin']
Similar Threads
-
By comptalk in forum Questions & Comments
Replies: 7
Last Post: 09-25-2011, 02:21 PM
-
By cybertooth in forum Questions & Comments
Replies: 4
Last Post: 08-22-2009, 04:27 PM
-
By winagain in forum Questions & Comments
Replies: 4
Last Post: 09-09-2008, 10:19 PM
-
By mike34z in forum Questions & Comments
Replies: 3
Last Post: 07-31-2008, 10:45 PM
-
By Tomek Wlodarek in forum Questions & Comments
Replies: 0
Last Post: 12-25-2007, 01:20 PM
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules