1.1.6 to 2.0 G Upgrade issues

[ucsccycling]

Using the Large Update to go from 1.1.6 to 2.0.

Update hangs at 39%:

Executing database changes
Please be patient - this may take some time on large forums. The time elapsed increments from the server to show progress is being made!
Executing: "Updating attachment data..." (12 of 42)

Database is fine, I am looking at it now. Any suggestions?

[A11214576266]

I'm having the same issue....

No clue what's causing it though

[rishab555555]

Did you upload all contents of the large upgrade package ?

[Adish - (F.L.A.M.E.R)]

Is your table smf_attachments quite big? It may be due to that reason. Doesn't it ask you to execute the step again?

[Trasric]

Had the same problem and there was no error message shown, but after executing the script directly from shell ( php -f upgrade.php ) i got following error message:

Code Select Expand

Calculating attachment mime types.Unknown column 'file_hash' in 'field list'
So therefore I modified the database and added the 'file_hash' to the table 'smf_attachments' ( i took a varchar(255) for this ) and finally it worked

Hopefully it helps

[ucsccycling]

I was actually at 1.1.4 and upgraded to 1.1.5 then 1.1.6 then got the balls to go 1.1.13 in one step with no problems.

Just did 2.0 Gold with no issues (thought it hung at the attachments).

We have about 40mb of attachments.

[Norv]

Had the same problem and there was no error message shown, but after executing the script directly from shell ( php -f upgrade.php ) i got following error message:

Code Select Expand

Calculating attachment mime types.Unknown column 'file_hash' in 'field list'
So therefore I modified the database and added the 'file_hash' to the table 'smf_attachments' ( i took a varchar(255) for this ) and finally it worked

Thank you for sharing your experience. Hmm, the upgrade script should have done this... Was your forum on a version prior to 1.1.9 as well?

I was actually at 1.1.4 and upgraded to 1.1.5 then 1.1.6 then got the balls to go 1.1.13 in one step with no problems.

Just did 2.0 Gold with no issues (thought it hung at the attachments).

We have about 40mb of attachments.

By "it hung" I suppose you mean it took a long time, but finally did it?

[A11214576266]

Had the same problem and there was no error message shown, but after executing the script directly from shell ( php -f upgrade.php ) i got following error message:

Code Select Expand

Calculating attachment mime types.Unknown column 'file_hash' in 'field list'
So therefore I modified the database and added the 'file_hash' to the table 'smf_attachments' ( i took a varchar(255) for this ) and finally it worked

Hopefully it helps

Thank you. That worked for me as well.

It was stuck on the "Calculating attachment mime types". I have about 1GB of attachments so I figured I should let it hang for a bit but it never really did anything.

After I manually added the 'file_hash' column and tried it again it finished up in a few seconds.

[archiebald]

I had a similar issue that I reported n detail here

http://www.simplemachines.org/community/index.php?topic=437784.0

I have full access to my server so I hacked the database manually which finally got the installation finished.

[Trasric]

Thank you for sharing your experience. Hmm, the upgrade script should have done this... Was your forum on a version prior to 1.1.9 as well?

yes it was i directly upgraded from 1.1.6 to 2.0 gold (using webinstall.php)

[Eyrein]

I'm upgrading from 1.1.1 to 2.0, and I'm running into the same problem.  I've tried to figure out how to add this 'file_has' column, but can't seem to.  I don't know much about database structure, so if someone can help, that would be great.  I'm using phpMyAdmin and I've found the smf_attachments table.  Can't seem to get it beyond that.

[A11214576266]

See the attached image. That should be what you are looking for.

[Norv]

Please make sure you make and keep a complete backup of your database prior to doing the following.

Then, try running the following query in phpmyadmin, from the SQL tab:

Code Select Expand


ALTER TABLE smf_attachments ADD COLUMN file_hash varchar(40) NOT NULL default '';

(where please replace "smf_" with your actual database tables prefix).
After doing so, run again the upgrade.php.

[Eyrein]

That worked!  Thank you.

The only problem now is that when I go to my forum, it still shows that there is an upgrade going on....

[Illori]

log into your ftp and edit settings.php and change the maintenance mode setting so it no longer in maintenance mode
$maintenance = 0;      # Set to 1 to enable Maintenance Mode, 2 to make the forum untouchable. (you'll have to make it 0 again manually!)

[Eyrein]

Done and worked.  Thank you