just moved my forum to a new host, and took the opportunity to start from scratch with the layout.....so used the fresh SMF 1.11 install files.
Installed, created a SQL database, and restored the one from my previous host.
BUT after uploading my database some things are funky!!!
300 missing members!?!?!
All the right boards are there with the right number of topics and posts listed...........BUT
No posts in the boards?
?
Sooooo.....I removed the database to start over using this guide:
To Import a SQL File Into a MySQL Database
Log in to your Account Manager.
Under the My Products section, select Hosting.
Click Manage Account.
Under the Databases heading, click MySQL.
Click the Open Manager button.
Enter your user name and password for your database.
Click the database into which you are importing data.
On the far upper-left corner of the page, click the SQL button. This will be immediately to the right of the green Exit button.
Click the Import files tab in the new window that appears.
Click Browse, and then locate the .SQL file on your machine.
Click Go.
:'(
and get
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:
#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 IM STUMPED!
