News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

Install with Old database

Started by marinemarine, August 26, 2016, 11:46:09 AM

Previous topic - Next topic

marinemarine

Hi

As server recommended to re-install our client's forum, I downloaded the new installer and installed on the server.
However  messages came up "field *** not found " and could not complete installation.

Would you tell me how to update the database for new installation, we can not upgrade old forum because of hacking problems on the site.

Illori

why do you need to do the reinstall in the first place?

is there an install already setup and working?

maybe these will help

http://wiki.simplemachines.org/smf/How_to_upload_a_fresh_set_of_files

http://wiki.simplemachines.org/smf/I_think_I_have_been_hacked

marinemarine

We're just advised by the server to re-install the forum.
I am not sure if we can do upgrade.

This is what they say:
------------------------------------------------------------------------
2.) Files have been injected with malicious code. For example both (domain name) and (domain name) had their index.php files modified with malicious code.
Your developer will absolutely need to review and correct this before you are recompromised.

3.) A MySQL table, smf-forum.smf_log_activity was marked as crashed disallowing any new visitors causing PHP to segfault and/or hang.
I corrected this by executing the following:

Illori

so follow the links i provided. the will tell you exactly what you need to do.

Sir Osis of Liver

Do you have clean backups of forum files and database?
Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

marinemarine

Hi

Yes I have all the backups.


The error message i am getting is
'Unknown column 'email_address' in 'field list''

and there was a same question here:
http://www.simplemachines.org/community/index.php?topic=369537.0

and there are answers given, but the url to a php file for the solution is dead.
Would anybody reinstate the updateDatabase.php  for me please.

Illori

i would not recommend you run a file that has not been looked at for about 6 years [the updateDatabase.php file]

is that the complete error message you are getting? sounds like your install or upgrade is not completing which is causing more issues.

marinemarine

Ok,

So please tell what I can do to upgrade this old forum.

This is for our clients and is an urgent issue.

I tried both installing and upgrading.

When upgrading, an error message displayed Unknown column 'add_deny' in 'field list'.

We don't want to lose the old post data from this forum.


marinemarine

The version of this forum is SMF 1.1 .
we will need an upgrade to the latest.

Kindred

Well, what you actually need to do is load a fresh set of 1.1.21 files to match you 1.1.x database...
confirm that is working

THEN (and only then)

load the 2.0.11 upgrade files and run upgrade.php

(at no point should you be using the install archive or process - that will erase your database.)
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

marinemarine

Thanks for your reply.
I did it but don't think this is matching the database we have.

Database Error: Unknown column 'addDeny' in 'field list'
File: /var/www/vhosts/iih.org.uk/httpdocs/iihforum/Sources/Load.php
Line: 739

The table has 'add_deny' instead of 'addDeny'.

Illori

that is because you did not complete the upgrade.

marinemarine

Actually I did upgrading first but was unsuccessful. it could not find fileds.
This database has column names such as 'start_date', not 'startDate'.

Updating and creating indexes...
done.
    Reordering boards and categories... done.
    Updating indexes and data on "smileys"... done.
    Updating indexes on "log_boards"... done.
    Updating indexes on "log_mark_read"... done.
    Updating indexes on "themes"... done.
Successful.
Reorganizing configuration settings...
    Updating data in "settings"... done.
    Adding new settings... done.
    Adding PM spam protection settings. done.
    Cleaning old values from "settings"... done.
    Encoding SMTP password... done.
    Adjusting timezone settings... done.
Successful.
Installing new default theme...
    Installing theme settings... done.
Successful.
Adding and updating member data...
    Renaming personal message tables... done.
    Updating indexes on "pm_recipients"... done.
    Updating columns on "pm_recipients"... done.
    Updating columns on "members"... done.
    Updating member approval... done.
Successful.
Updating holidays and calendar...
    Adding new holidays... done.
    Updating event start and end dates... Unsuccessful!
This query:
UPDATE smf_calendar
SET startDate = '0001-01-01'
WHERE startDate = '0000-00-00';
Caused the error:
Unknown column 'startDate' in 'where clause'

Kindred

so, right...    whatever you did has gotten your system into a really bad state where it is not possible to complete the upgrade and not possible to use the old version either.


Restore your original database.
Using a clean set of files for 1.1.x, put your system back into a working state with that version m(manually edit Settings.php to put in the correct usernames, passwords, URLs and paths)
THEN do the upgrade.
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

marinemarine

Thank you very much for your help - I finally could upgrade it.
There was something wrong with the database - I have restored the data and it went all well -

However, there are things I have to change - template of the index page has wrong links which is not used any longer.
I can't find the file as this content is probably coming from database?

It's inbetween "Hello username" box and the "FORUM RULES & GUIDELINES". There is a welcome message which I need to update.

Kindred

Admin > Main > News & Newsletters
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

marinemarine

Thanks very much, it's all sorted :)

Advertisement: