Table 'forum.smf_attachments' doesn't exist

[-SiN-]

First I tried to search forum, there were some talkings about this in Turkish language if Im correct, but unfortunately, I dont understand it.
Error Im gettin when I try to import my database is:

MySQL said: 
#1146 - Table 'forum.smf_attachments' doesn't exist 

How this can be solved?

[babjusi]

First I tried to search forum, there were some talkings about this in Turkish language if Im correct, but unfortunately, I dont understand it.
Error Im gettin when I try to import my database is:

MySQL said: 
#1146 - Table 'forum.smf_attachments' doesn't exist 

How this can be solved?

You will have to recreate the missing table. Run the following query at the Sql box in the phpmyadmin at the cp of your host

Code Select Expand

CREATE TABLE `smf_attachments` (
  `ID_ATTACH` int(10) unsigned NOT NULL auto_increment,
  `ID_THUMB` int(10) unsigned NOT NULL default '0',
  `ID_MSG` int(10) unsigned NOT NULL default '0',
  `ID_MEMBER` mediumint(8) unsigned NOT NULL default '0',
  `attachmentType` tinyint(3) unsigned NOT NULL default '0',
  `filename` tinytext NOT NULL,
  `size` int(10) unsigned NOT NULL default '0',
  `downloads` mediumint(8) unsigned NOT NULL default '0',
  `width` mediumint(8) unsigned NOT NULL default '0',
  `height` mediumint(8) unsigned NOT NULL default '0',
  PRIMARY KEY  (`ID_ATTACH`),
  UNIQUE KEY `ID_MEMBER` (`ID_MEMBER`,`ID_ATTACH`),
  KEY `ID_MSG` (`ID_MSG`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

[-SiN-]

If I do that, I get the next error:

Code Select Expand

Error

SQL query:

# --------------------------------------------------------
#
# Dumping data in `smf_board_permissions`
#
INSERT INTO `smf_board_permissions` (
`ID_GROUP` ,
`ID_BOARD` ,
`permission` ,
`addDeny`
)
VALUES (
-1, 0, 'view_attachments', 1
), ( 0, 0, 'post_new', 1 ) , ( 0, 0, 'send_topic', 1 ) , ( 0, 0, 'lock_own', 1 ) , ( 0, 0, 'remove_own', 1 ) , ( 0, 0, 'post_reply_own', 1 ) , ( 0, 0, 'post_reply_any', 1 ) , ( 0, 0, 'delete_own', 1 ) , ( 0, 0, 'modify_own', 1 ) , ( 0, 0, 'report_any', 1 ) , ( 0, 0, 'poll_view', 1 ) , ( 0, 0, 'poll_vote', 1 ) , ( 2, 0, 'mark_notify', 1 ) , ( 2, 0, 'mark_any_notify', 1 ) , ( 2, 0, 'poll_remove_any', 1 ) , ( 2, 0, 'poll_edit_any', 1 ) , ( 2, 0, 'poll_add_any', 1 ) , ( 2, 0, 'poll_post', 1 ) , ( 2, 0, 'poll_vote', 1 ) , ( 2, 0, 'poll_view', 1 ) , ( 2, 0, 'report_any', 1 ) , ( 2, 0, 'modify_any', 1 ) , ( 2, 0, 'modify_own', 1 ) , ( 2, 0, 'delete_any', 1 ) , ( 2, 0, 'delete_own', 1 ) , ( 2, 0, 'post_reply_any', 1 ) , ( 2, 0, 'post_reply_own', 1 ) , ( 2, 0, 'remove_any', 1 ) , ( 2, 0, 'lock_any', 1 ) , ( 2, 0, 'lock_own', 1 ) , ( 3, 0, 'moderate_board', 1 ) , ( 3, 0, 'post_new', 1 ) , ( 3, 0, 'post_reply_own', 1 ) , ( 3, 0, 'post_reply_any', 1 ) , ( 3, 0, 'poll_post', 1 ) , ( 3, 0, 'poll_add_own', 1 ) , ( 3, 0, 'poll_remove_any', 1 ) , ( 3, 0, 'poll_view', 1 ) , ( 3, 0, 'poll_vote', 1 ) , ( 3, 0, 'report_any', 1 ) , ( 3, 0, 'lock_own', 1 ) , ( 3, 0, 'send_topic', 1 ) , ( 3, 0, 'mark_any_notify', 1 ) , ( 3, 0, 'mark_notify', 1 ) , ( 3, 0, 'delete_own', 1 ) , ( 3, 0, 'modify_own', 1 ) , ( 3, 0, 'make_sticky', 1 ) , ( 3, 0, 'lock_any', 1 ) , ( 3, 0, 'remove_any', 1 ) , ( 3, 0, 'move_any', 1 ) , ( 3, 0, 'merge_any', 1 ) , ( 3, 0, 'split_any', 1 ) , ( 3, 0, 'delete_any', 1 ) , ( 3, 0, 'modify_any', 1 ) , (
-1, 0, 'poll_view', 1
), ( 2, 0, 'move_any', 1 ) , ( 3, 0, 'view_attachments', 1 ) , ( 2, 0, 'make_sticky', 1 ) , ( 3, 0, 'post_attachment', 1 ) , ( 2, 0, 'send_topic', 1 ) , ( 2, 0, 'split_any', 1 ) , ( 2, 0, 'merge_any', 1 ) , ( 0, 0, 'poll_post', 1 ) , ( 2, 0, 'post_new', 1 ) , ( 2, 0, 'moderate_board', 1 ) , ( 2, 0, 'view_attachments', 1 ) , ( 2, 0, 'post_attachment', 1 ) , ( 0, 0, 'poll_add_own', 1 ) , ( 0, 0, 'poll_edit_own', 1 ) , ( 0, 0, 'poll_lock_own', 1 ) , ( 0, 0, 'mark_any_notify', 1 ) , ( 0, 0, 'mark_notify', 1 ) , ( 0, 0, 'view_attachments', 1 ) , ( 0, 0, 'post_attachment', 1 ) ;


MySQL said: 
#1146 - Table 'new.smf_board_permissions' doesn't exist

I executed the sql code, and then tried to import database. This is what happened. I had joomla and orstio bridge installed, later and seo4smf. Bridge than stopped to work after seo4smf. I think this may be the cause.

[-SiN-]

I solved the problem. I manually transferred all the tables, one by one to another hosting. Slow, but sure...