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

Home » FUDforum » FUDforum Installation Issues » Problem when moving forum
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
Problem when moving forum [message #30120] Sun, 05 February 2006 15:03 Go to next message
bigbubbaj is currently offline  bigbubbaj   United States
Messages: 7
Registered: February 2006
Location: Colorado, USA
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
I am moving my forum from a subdirectory to a sub domain.

http://www.domain.com/forum to forum.domain.com

installed at the new location, imported. Looks great.

When I click on the forums I get an error. i cant re-get the error w/o re importind the dump.

The tables for the new forum are in the same DB as the old one, but the table prefixes are different, so that should not be an issue unless there is a common index or something.

When I run consistency and stuff, it fixes the error, but now when I click on a forum and view topics, and go bak to the category view, the forum shows up one additional time for eachtime that I have clicked on the forum... so 10 clicks = 10 copies of the forum
index.php?t=getfile&id=2381&private=0

Any ideas?
  • Attachment: multi.png
    (Size: 103.48KB, Downloaded 664 times)
Re: Problem when moving forum [message #30125 is a reply to message #30120] Sun, 05 February 2006 16:30 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Have you updated the config to reflect the new location of the forum?

FUDforum Core Developer
Re: Problem when moving forum [message #30127 is a reply to message #30120] Sun, 05 February 2006 16:40 Go to previous messageGo to next message
bigbubbaj is currently offline  bigbubbaj   United States
Messages: 7
Registered: February 2006
Location: Colorado, USA
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Yes. The GLOBALS.php is correct.

Everything works great except for the duplication of the forum data.

I will re-import again and get the exact sql error.

Thanks.
Re: Problem when moving forum [message #30132 is a reply to message #30127] Mon, 06 February 2006 09:04 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Have you ran the consistency checker after the move?

FUDforum Core Developer
Re: Problem when moving forum [message #30138 is a reply to message #30120] Mon, 06 February 2006 10:42 Go to previous messageGo to next message
bigbubbaj is currently offline  bigbubbaj   United States
Messages: 7
Registered: February 2006
Location: Colorado, USA
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Yes, after doing that is when the problems start.
The forum works great, except for that every click to a forum makes a duplicate (view only, same forumID)

Might this have something to do with the view tracking?

Here are the errors.

Processed 10000 queries
Processed 20000 queries
Processed 30000 queries
Processed 40000 queries
Processed 50000 queries
Processed 60000 queries
Processed 70000 queries
(/home/user/public_html/atticData/include/theme/default/db.inc:73
/home/user/public_html/attic/adm/admimport.php:170
) 1146: Table 'user_fudforum2.fud26_fud26attic_cat' doesn't exist
Query: INSERT INTO fud26_fud26attic_cat VALUES ('1','Test Category',' - Just a test category','3','1','0')
_POST: array ( 'S' => '5ba54496c4dbf1f0be93bafaef353e0d', 'SQ' => '99ff23dbfd11ef7f334259da19c18695', 'path' => '/home2/user/public_html/otherForum/FUDforum/tmp/FUDforum_05_02_2006_09_55. fud.gz', 'btn_submit' => 'Import Data', )
Server Version: 4.1.14-standard
[Referring Page] http://site.domain.com/adm/admimport.php?S=5ba54496c4dbf1f0be93bafaef353e0d &SQ=99ff23dbfd11ef7f334259da19c18695

(/home/user/public_html/attic/index.php:76
/home/user/public_html/attic/index.php:136
/home/user/public_html/attic/theme/XYZ/thread.php:180
/home/user/public_html/attic/index.php:1181
) 1146: Table 'user_fudforum2.fud26_tv_7' doesn't exist
Query: SELECT seq FROM fud26_tv_7 ORDER BY seq DESC LIMIT 1
_GET: array ( 't' => 'thread', 'frm_id' => '7', 'S' => '06b5cd99708f24f5f0d8c0dae0541457', )
Server Version: 4.1.14-standard
[Referring Page] http://site.domain.com/index.php?S=06b5cd99708f24f5f0d8c0dae0541457&SQ= 226b2bd3b17624f9e811774532d73070
Re: Problem when moving forum [message #30141 is a reply to message #30138] Mon, 06 February 2006 11:36 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
Looks like the import process failed due to the dataimport containing extra tables for which the defintions are not available. Such as the fud26_fud26attic_cat table. You need to remove this table from the datadump or add a defenition of it to the SQL.

FUDforum Core Developer
Re: Problem when moving forum [message #30146 is a reply to message #30141] Mon, 06 February 2006 15:43 Go to previous message
bigbubbaj is currently offline  bigbubbaj   United States
Messages: 7
Registered: February 2006
Location: Colorado, USA
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
Thanks. I will let you know.
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
Previous Topic: Newinstallation on Windows IIS5 Server
Next Topic: IMAP Extension
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Sep 19 09:19:02 EDT 2018

Total time taken to generate the page: 0.00744 seconds