Problem importing Data Base

[-=[Vyorel]=-]

Errors:

Error

SQL query:

INSERT INTO `smf_log_activity` (
`date` ,
`hits` ,
`topics` ,
`posts` ,
`registers` ,
`mostOn`
)
VALUES # --------------------------------------------------------
#
# Table structure for table `smf_log_banned`
#

DROP TABLE IF EXISTS `smf_log_banned` ;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'DROP TABLE IF EXISTS `smf_log_banned`' at line 5

Whi?

PS: I deleted the tables.

[-=[Vyorel]=-]

Please help! 

[kat]

I know this might be a bit simplistic...


But, have you tried going to your cpanel and repairing the database?

[MrPhil]

1. Please do not BUMP in less that 24 hours. We're all volunteers here.

2. You can temporarily fix this by removing the following lines:

Code Select Expand

INSERT INTO `smf_log_activity` (
`date` ,
`hits` ,
`topics` ,
`posts` ,
`registers` ,
`mostOn`
)
VALUES
The problem is that the table was empty, and shouldn't have output an INSERT statement for it. It's a known bug in SMF.

3. You can try permanently fixing this problem with the attached rewrite of Sources/DumpDatabase.php.

Add: Try repairing the table first, as suggested by Kat. It's possible that the table isn't really empty, but is crashed. If that doesn't work, if the table actually is empty, and you may need the fix I give here.