FUDforum: Bug Reports » Data dump import issues

Home » FUDforum Development » Bug Reports » Data dump import issues

Show: Today's Messages :: Polls :: Message Navigator

Re: Data dump import issues [message #4294 is a reply to message #4293]

Mon, 22 July 2002 06:12

rohan

Messages: 4
Registered: July 2002

Karma:

Junior Member

There was no error of not being able to open a file. The error was instead that it could not insert data into the database because it would not overwrite. For example, it gave the error:
query failed: %( INSERT INTO fud21_custom_tags (id,name,user_id) VALUES(1,"Administrator",1) )% because %( Duplicate entry '1' for key 1 )%

because on installation that row had been added to the database, and it didnt want to overwrite it.

I have also not been able to restore the files, because the script is reading a leading '/' onto the size of files, and is therefore writing all files as size 0. It seems this is because many filenames in the datadump have leading '/'s, which are picked up as the delimiter, and the next slash is read as part of the size. Also, many files have a trailing ".t", which means many files are created with that in their names. For example, from the data dump:
----SQL_END----
//isearch.inc.t//DATA_DIRsrc///7845//
<?php
/************************************************************************** *
* copyright : (C) 2001,2002 Advanced Internet Designs Inc.
* email : forum(at)prohost(dot)org
*

Rohan

Report message to a moderator

[Message index]

		Data dump import issues By: rohan on Sun, 21 July 2002 23:17
		Re: Data dump import issues By: Ilia on Mon, 22 July 2002 01:51
		Re: Data dump import issues By: rohan on Mon, 22 July 2002 06:12
		Re: Data dump import issues By: rohan on Mon, 22 July 2002 06:30
		Re: Data dump import issues By: rohan on Mon, 22 July 2002 12:07

Previous Topic:	moderated forums
Next Topic:	Moderation Queu & Deleted Forums

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 28 00:50:52 GMT 2025

Total time taken to generate the page: 0.06452 seconds