serendipity_suppress migration problem

[TKS]

I've migrated to a host and am having some syntax errors with the migration...

Is the table serendipity_suppress needed for .8? I'd like to just drop it because I can't get it to create across due to the following line:

Code: Select all

`last` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,

It says that this syntax isn't supported. This is odd considering I'm moving from a MySQL database phpadmin export to a MySQL database phpadmin import.

I had to cut and paste everything leaving off the following code for each table:

Code: Select all

ENGINE=MyISAM DEFAULT CHARSET=latin1

Am I causing problems for myself? How can I fix this? Should I start with a fresh from scratch install? I need a direction to go on this.


UPDATE: Found out that I'm trying to migrate from a MySQL 4.1.8 database w php 4.3.10 to a 4.0.24 with php 4.3.11

TKS

[garvinhicking]

The suppress table is neede for Referrer Tracking, you will need it supposedly.

The SQL-code you pasted comes from a SQL export (phpMyAdmin?) and not from Serendipity. You need to create a simple MySQL 3.23 export SQL dump which does not contain those timestamp options.

Regards,
Garvin

[TKS]

Garvin,


does phpmyadmin have that function or do I need to go command line for it?

[TKS]

Found it! Cool...the database part is ok now...thanks Garvin!