FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum Development » Bug Reports » Import forum data
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
Import forum data [message #165541] Mon, 11 July 2011 09:26 Go to next message
Alexey is currently offline  Alexey   
Messages: 70
Registered: June 2005
Karma: 0
Member
add to buddy list
ignore all messages by this user
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 01:57]

Report message to a moderator

Re: Import forum data [message #165543 is a reply to message #165541] Mon, 11 July 2011 11:48 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3632
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
See http://fudforum.org/forum/index.php?t=msg&goto=164183
Re: Import forum data [message #165547 is a reply to message #165543] Wed, 13 July 2011 08:19 Go to previous messageGo to next message
Alexey is currently offline  Alexey   Russian Federation
Messages: 70
Registered: June 2005
Karma: 0
Member
add to buddy list
ignore all messages by this user
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.
Re: Import forum data [message #165549 is a reply to message #165547] Wed, 13 July 2011 11:16 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3632
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Drop the entire table to see if it would help.
SQL> DROP TABLE fud26_tv_1;
Re: Import forum data [message #165556 is a reply to message #165549] Sat, 16 July 2011 04:30 Go to previous messageGo to next message
Alexey is currently offline  Alexey   Russian Federation
Messages: 70
Registered: June 2005
Karma: 0
Member
add to buddy list
ignore all messages by this user
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 01:56]

Report message to a moderator

Re: Import forum data [message #165557 is a reply to message #165556] Sat, 16 July 2011 05:17 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3632
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
I'm out of ideas.

Can you provide me with a copy of the dump or access to your system to troubleshoot the problem?
Re: Import forum data [message #165558 is a reply to message #165557] Sun, 17 July 2011 01:58 Go to previous messageGo to next message
Alexey is currently offline  Alexey   Russian Federation
Messages: 70
Registered: June 2005
Karma: 0
Member
add to buddy list
ignore all messages by this user
Send backup on email.
Re: Import forum data [message #165559 is a reply to message #165558] Sun, 17 July 2011 02:21 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3632
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
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.
Re: Import forum data [message #165562 is a reply to message #165559] Sun, 17 July 2011 06:29 Go to previous messageGo to next message
Alexey is currently offline  Alexey   
Messages: 70
Registered: June 2005
Karma: 0
Member
add to buddy list
ignore all messages by this user
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.
Re: Import forum data [message #165563 is a reply to message #165562] Sun, 17 July 2011 07:42 Go to previous message
naudefj is currently offline  naudefj   South Africa
Messages: 3632
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Solution to users table being empty after an import is at http://fudforum.org/forum/index.php?t=msg&goto=164989
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
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) ] [ RSS ]

Current Time: Sat Dec 16 17:45:00 EST 2017

Total time taken to generate the page: 0.00753 seconds