Empty site after installing smf2.0.4, have i lost all data & member information?

[saibaworld]

Can you pm me the sql file and i'll have look at it for you?

I been tryin to send a copy/paste message via the compose message field, but it simply refuses to send. I tink d data is much, so might need an attachment. But there's no link to send an attachment in Compose Message. How do i attach via pm?

When you rerun the import, are you first clearing out the old data (or doing a DROP TABLE and CREATE TABLE)? It sounds like you may be partially loading the data, and then restarting with some overlap in the data. Or, your original backup is no good and has duplicate data in it.

I really dont understand exactly wat u mean, but wat i did was:
- i signed into phpmyadmin, clicked on 'Check All' n dropped all the tables (after havin saved a db copy usin my host utility)
- i thn went ahead to import d 1st time but got d 1st error msg as above
- i came here to report n was told to delete some lines
- i proceeded to delete the lines i was told to delete, n tried to reimport again
- while doin d 2nd import, the 2nd error msg appeared, so i came back here to report.

those are d exact steps i tuk in dat order. Wat else do i do pls?

[TheListener]

those are d exact steps i tuk in dat order. Wat else do i do pls?

One thing you can do is type the words out properly.

Text speak is not exactly forum friendly these days.

[Chalky]

those are d exact steps i tuk in dat order. Wat else do i do pls?

One thing you can do is type the words out properly.

Text speak is not exactly forum friendly these days.

Normally I'd agree with you Foss, but in this case English isn't the OP's first language so I suspect he's just typing phonetically...

[saibaworld]

Oops! Hey guys, am sorry about that...

It's funny but I really didn't realize that how i typed out my English was an issue here on Simple Machines Forum (smf). Am so used to shorthand messages to and from people, even on forums, that I've never considered it being an offense to anyone.

Again, just like ChalkCat truly pointed out, English isn't my native language although I do speak it very fluently. Thanks for the corrections all the same! I'll try my utmost best to "...type the words out properly."

Regarding the latest technical issues I brought up above, please what do I do next?

[kat]

Thanks for understanding, Saiba!

txtspk is really difficult for us old farts to get into, sometimes.

[TheListener]

txtspk is really difficult for us old farts to get into, sometimes.

Speak for yourself.

[saibaworld]

Am loving this forum more and more...

[kat]

We're not all mad.

Well... Maybe we are.

[Kindred]

Ah. I see what happened.

You did the first import, but it failed part way through.
Now the second attempt is trying to import the same tables all over again...

So... you can either edit your SQL file to remvoe all the tables which have already been successfully imported and continue
or...   drop the failed first attempt tables and start the import again with an empty database.

[The Domain Shop]

If your going to be deleting bits of the sql file then make sure you have another copy of the original just in case you make a mess of it

Have you never backed your entire forum up through cPanel in the past? Restoring your entire forum from a previous backup and then running an upgrade would make your life a little easier.

[saibaworld]

Ah. I see what happened.

You did the first import, but it failed part way through.
Now the second attempt is trying to import the same tables all over again...

So... you can either edit your SQL file to remvoe all the tables which have already been successfully imported and continue
or...   drop the failed first attempt tables and start the import again with an empty database.

Thanks. I did drop the failed first attempt tables and started the import again with an empty database...but i still got an error message.

If your going to be deleting bits of the sql file then make sure you have another copy of the original just in case you make a mess of it

Have you never backed your entire forum up through cPanel in the past? Restoring your entire forum from a previous backup and then running an upgrade would make your life a little easier.

Thanks, that was the first thing i did. 

I have several backup copies of my forum via smf admin utility. I never knew until two days ago that there was an existing issue with backing up that way. No i have never backed up via my host's cpanel...but i now see the wisdom.
I made a terrible mistake and now paying for it plus dragging all you nice guys into my problem. So sorry about that. I guess if i'd come to this forum to ask a question or two before attempting the uninstall/install that i did, or at least even searched through the forum, perhaps things would've turned out quite differently ...

[The Domain Shop]

We all live and learn my friend and I'm sure people here are more than happy to help you when an where they can

You will more then likely get a number of errors with the sql file, you will just have to keep asking for advice on what you should and shouldn't be removing and dig your way through it until you manage to install it without issue.

Would it not be easier to pay for your host to restore the site and go from there?

[Kindred]

what error message did you get this time?

[saibaworld]

Hey guys, good morning...had to go get some little sleep.

We all live and learn my friend and I'm sure people here are more than happy to help you when an where they can

You will more then likely get a number of errors with the sql file, you will just have to keep asking for advice on what you should and shouldn't be removing and dig your way through it until you manage to install it without issue.

Would it not be easier to pay for your host to restore the site and go from there?

Thanks Trax. The upside of this problem is that i'm no longer too greek with databases. I can now navigate my phpmyadmin account and also understand databases, at least to a small extent. I'm a die-hard optimist in life, always looking for the good even in the rotten. Keeps me calm and sane all the time. I still have my host's restore in mind...probably look to them as a last resort, if it becomes obvious the backup copy i saved and trying to upload is truly 'rubbish'.

what error message did you get this time?

The error message i got, after editing the backup copy as i was advised and dropping all database tables again, was:

Error

SQL query:

INSERT INTO `smf_log_search_subjects` (`word`, `ID_TOPIC`) VALUES ('earn', 3200), ('earn', 3206), ('earn', 3225), ('earner', 3054), ('earnings', 3082), ('earth', 1275), ('earthquake', 440), ('earthquake', 536), ('earthquake', 551), ('earthquake', 2606), ('earthquake-ravaged', 462), ('ease', 952), ('ease', 1183), ('easil', 800), ('easily', 1162), ('easily', 3195), ('east', 1135), ('east', 1898), ('east', 3129), ('easter', 3188), ('easy', 306), ('easy', 424), ('easy', 653), ('easy', 864), ('eat', 2453), ('eating', 1497), ('ebay', 3147), ('echiejile', 3037), ('echo', 2602), ('ecobank', 1794), ('economist', 561), ('economy', 1380), ('economy', 1905), ('economy', 3186), ('ecowas', 1142), ('ecowas', 1431), ('ecowas', 1432), ('ecowas', 1433), ('ecpat', 1261), ('ed', 1232), ('eddie', 2971), ('editors', 173), ('edoho', 2930), ('education', 7), ('education', 30), ('education', 68), ('education', 359)[...]

MySQL said: Documentation
#1062 - Duplicate entry 'enough-853' for key 1

I think it's the same message as i posted before...i suppose.

And people, least i forget, today's my birthday. Added one to my age early hours of today. 

[kat]

Let's hope your birthday's the day that this gets sorted-out, then!

Have a good one, either way!

[saibaworld]

Hey guys, my backup finally got imported (thanks to ziycon who worked through on it). I just got this message from phpmyadmin:

Import has been successfully finished, 46580 queries executed.


BUT when i visit my forum on the internet, i get this message:

Unknown column 'add_deny' in 'field list'


Please what do i do now?

[Kindred]

ok... good news!


So, IIRC, you imported a 1.1.x database.

Now, you need to run upgrade.php on that database.

[saibaworld]

ok... good news!


So, IIRC, you imported a 1.1.x database.

Now, you need to run upgrade.php on that database.

you will want to DROP all tables in the new database before doing your import.

then, since your database was saved on 1.1.x, after you do the import, you need to get the upgrade,php and other upgrade SQL files form the large upgrade archive - put them in your smf directory and run upgrade.php

Okay, i do understand you perfectly well sir. I'll get to it immediately, and post my results here.

Thanks!!

[kat]

I must say that I admire both your and Mr. P's persistence, sometimes, Kindred.

Nice work, both.

[saibaworld]

  But just so i dont make any mess of things, i want to confirm that the upgrade files i am to put in my smf directory are as listed below only, or are there more? They are the 6 obvious upgrade files l extracted from the smf large upgrade archive:

upgrade.php, upgrade_1-0.sql, upgrade_1-1.sql, upgrade_2-0_mysql.sql, upgrade_2-0_pstgresql.sql, AND upgrade_2-0_sqlite.sql.


Are there more or only these?