Hi, I've already sent this to gT, but I'm hoping to get a faster reply from here :)

...I've done a DMOZ import on my server, and now transfered some of the messed up charachters to their correct ones. The problem I am now having, is importing the database form a 'Links SQL Backup' (not MySQL Dump, cos the other server uis using Postgres).... The error I am getting is;

WARNING: Unable to import `60557|La Armada Española|http://www.geocities.com/Pentagon/3223|Admin|2002-10-01|2002-10-01|Sitio no oficial dedicado a la Armada Española de hoy y a su historia reciente. Incluye secciones sobre su organización actual, eventos históricos y foro.|NULL|NULL|0|No|No|Yes|Yes|0.00|0|0|0000-00-00 00:00:00|20021228021014' (line 40 of /webs/cgi-bin/links/admin/dump/sql-backup.sql): ERROR: Bad timestamp external representation '0000-00-00 00:00:00'
WARNING: Unable to import `60558|Ejército del Aire|http://www.ejercitodelaire.mde.es/|Admin|2002-10-01|2002-10-01|Completa web con amplia información y novedades relacionadas con el Cuerpo, así como de actividades aéreas relacionadas.|NULL|NULL|0|No|No|Yes|Yes|0.00|0|0|0000-00-00 00:00:00|20021228021015' (line 41 of /webs/cgi-bin/links/admin/dump/sql-backup.sql): ERROR: Bad timestamp external representation '0000-00-00 00:00:00'

Anyone got any ideas on how to fix this? I have gone into Setup > Date Setup, and all of those variables seem to match that of which I have setup on my installation

Just so you know, this is a Spanish installation (not sure if this is why I'm getting the error)

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

Anyone?

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

Hello Andy!

I thought just to share my solution / approaches in the past. May not help you at all, so just excuse me.

What I did in a similar situation was to insert manually through admin few links and then export them. Like this I was sure that what is coming out could be going in the database. This would tell me what is coming out should match the going in format.

Then I had matched in the table properties, sync them too, checked manually if the defs match also, checked the Import sequence in the L2S2.pm also. I followed the sequence

Import file format >> Import module >> defs >> config >> table properties

Checking in this sequence helped me a lot to find out many many problems.