FUDforum: Bug Reports » Import forum data

Home » FUDforum Development » Bug Reports » Import forum data

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

Import forum data [message #165541]

Mon, 11 July 2011 13:26

Alexey

Messages: 70
Registered: June 2005

Karma: 0

Member

FUDforum 3.0.2.
Restore problem:

..
..

Skip table fud26_title_index!
Process table fud26_user_ignore:
...63 rows loaded.
Process table fud26_users:
...6044 rows loaded.
Creating indexes...

1061: Duplicate key name 'fud26_tv_1_i_t'<br /> Query: ALTER IGNORE TABLE fud26_tv_1 ADD UNIQUE fud26_tv_1_i_t (thread_id)

[Updated on: Sun, 17 July 2011 05:57]

Report message to a moderator

Re: Import forum data [message #165543 is a reply to message #165541]

Mon, 11 July 2011 15:48

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

See http://fudforum.org/forum/index.php?t=msg&goto=164183

Report message to a moderator

Re: Import forum data [message #165547 is a reply to message #165543]

Wed, 13 July 2011 12:19

Alexey

Messages: 70
Registered: June 2005

Karma: 0

Member

Delete index:
ALTER TABLE fud26_tv_1 DROP INDEX fud26_tv_1_seq
ALTER TABLE fud26_tv_1 DROP INDEX fud26_tv_1_i_t
Make forum datadump
Import forum data
And this mistake show again.

Report message to a moderator

Re: Import forum data [message #165549 is a reply to message #165547]

Wed, 13 July 2011 15:16

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

Drop the entire table to see if it would help.
SQL> DROP TABLE fud26_tv_1;

Report message to a moderator

Re: Import forum data [message #165556 is a reply to message #165549]

Sat, 16 July 2011 08:30

Alexey

Messages: 70
Registered: June 2005

Karma: 0

Member

Drop the table. Don't work.

1061: Duplicate key name 'fud26_tv_1_i_t'<br /> Query: ALTER IGNORE TABLE fud26_tv_1 ADD UNIQUE fud26_tv_1_i_t (thread_id)

[Updated on: Sun, 17 July 2011 05:56]

Report message to a moderator

Re: Import forum data [message #165557 is a reply to message #165556]

Sat, 16 July 2011 09:17

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

I'm out of ideas.

Can you provide me with a copy of the dump or access to your system to troubleshoot the problem?

Report message to a moderator

Re: Import forum data [message #165558 is a reply to message #165557]

Sun, 17 July 2011 05:58

Alexey

Messages: 70
Registered: June 2005

Karma: 0

Member

Send backup on email.

Report message to a moderator

Re: Import forum data [message #165559 is a reply to message #165558]

Sun, 17 July 2011 06:21

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

Two solutions:

1. Delete file sql/fud_thread_view.tbl, take a fresh backup and restore.

2. If you cannot take a new backup, edit admimport.php and change

pf('Creating indexes...');
foreach ($idx as $v) {

to...

pf('Creating indexes...');
foreach (array_unique($idx) as $v) {

Then, re-run the restore.

Report message to a moderator

Re: Import forum data [message #165562 is a reply to message #165559]

Sun, 17 July 2011 10:29

Alexey

Messages: 70
Registered: June 2005

Karma: 0

Member

Thanks work,
but

..
..
Process table fud26_users:
...6059 rows loaded.
Creating indexes...
Import GLOBAL settings...
Your current login (Алексей) is not found in the imported database.
Therefor you'll need to re-login once the import process is complete.
Recompiling Templates...
Restore successfully completed.

The table fud26_users is clean after restore.

Report message to a moderator

Re: Import forum data [message #165563 is a reply to message #165562]

Sun, 17 July 2011 11:42

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

Solution to users table being empty after an import is at http://fudforum.org/forum/index.php?t=msg&goto=164989

Report message to a moderator

Previous Topic:	New web server, try to install 3.0.0 / clearos 5.2
Next Topic:	Error mailing to mailing list

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Oct 30 15:56:09 GMT 2024

Total time taken to generate the page: 0.04703 seconds