SQL/DB Error -- [Incorrect table definition; there can be only one TIMESTAMP column w

**ServiceNinja** · 10-10-2006, 07:13 PM

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

When upgrading from an older version 7 to version 8.1

**kbeeveer46** · 10-10-2006, 07:28 PM

replace current timestamp with NULL in the entire file.

**ServiceNinja** · 10-10-2006, 11:32 PM

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.

**SpeedyTV.com** · 10-11-2006, 05:29 AM

Originally Posted by kbeeveer46

replace current timestamp with NULL in the entire file.

KBeever --

Since I'm a little new to programming....

Which file do I make the changes to?
Also, do I just do a search and replace for "current timestamp" and change it to "NULL"?

**kbeeveer46** · 10-11-2006, 06:31 AM

edit install/upgrade.php and where it says CURRENT_TIMESTAMP, replaec that with NULL and upload it back to your server and run the file.

**ServiceNinja** · 10-11-2006, 09:01 AM

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

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

SQL/DB Error -- [Incorrect table definition; there can be only one TIMESTAMP column w

Thread: SQL/DB Error -- [Incorrect table definition; there can be only one TIMESTAMP column w

Thread Tools

Search Thread

Display

SQL/DB Error -- [Incorrect table definition; there can be only one TIMESTAMP column w

Similar Threads

SQL/DB Error -- [Incorrect key file for table '/tmp/#sql_7bfe_31.MYI'; try to repair

Which values do I add into lft & rght Column in categories table using Mysql?

SQL/DB Error -- [Unknown column 'tag_words' in 'where clause

Incorrect key -> Object error

SQL/DB Error -- [Duplicate column name 'link_title_url']

Posting Permissions