Upgrading error (bug?)

[MPT.]

Now i'm trying to handle evertything with the create_backup and restore_backup tool.  I'll notify if it will be succesful.

[Knave]

Hi.

It's seems really fun: I got same error when try to update my forum in Opera browser, but when i open upgrade.php in IE, upgrading finish successfully!

[MPT.]

Now i'm trying to handle evertything with the create_backup and restore_backup tool.  I'll notify if it will be succesful.

Not worked.

I don't want to upgrade my own forum before I have tested it.

[MPT.]

Time Elapsed:
649 mins, 21 seconds.


Whehehe, lol...

[lifeless]

I'm getting the same error, stuck on 14%

mysql = 5.0.38
php = 5.2.1

[MatrixCrawler]

No news on this as it seems.....

[leoedin]

14 seems to be an unlucky number

[leoedin]

I have no idea if this would help, but I've tried loading the SQL file manually into PHPMyAdmin. It gives syntax errors right from the beginning. Obviously it wasn't really designed to be loaded by phpMyAdmin so it may simply not work.

Thoughts?

[leoedin]

OK: New light:

I ran the upgrade script using the same forum data on two web servers. The first one was hostgator, and the second one was a smaller company called medialayer. They are running different versions of mySQL (and I assume PHP - can't be bothered checking as that's unlikely to be the problem).

So, it's almost certainly a database issue. What mods might toy with the database?
Is there any way to "clean" the database - to export it to a new install of 1.1.4 with only the original tables?

I'll try optomizing the database in SMF before dumping/trying to upgrade.

*goes away again*

Checked for errors: apparently a member has received a PM that doesn't exist
Optimized tables: a few hundred kb saved, nothing major
Database is currently not UTF-8. Does that make a difference?

trying to upgrade again.

No luck. UTF-8 DB doesn't make a difference. Optomisation doesn't make a difference, Checking for errors doesn't make a difference.

[MPT.]

I think I've found something, I've tried to upgrade from 1.1 RC3, but I see this:

Upgrading from YaBB SE!
Thank you for choosing to upgrade to SMF 2.0 Beta 3 Public. All files appear to be in place, and we're ready to proceed.
!!
Warning!
This upgrade script is out of date! The current version of SMF is ?? but this upgrade script is for 2.0 Beta 3 Public.

It is recommended that you visit the Simple Machines website to ensure you are upgrading to the latest version.

[MatrixCrawler]

I have no idea if this would help, but I've tried loading the SQL file manually into PHPMyAdmin. It gives syntax errors right from the beginning. Obviously it wasn't really designed to be loaded by phpMyAdmin so it may simply not work.

Thoughts?

I don't think that should make a difference. an sql file has a specific syntax an phpmyadmin should be able to parse through it.
But I would like to know why most people seem to be able to upgrade their boards without any problems and only a handfull of unlucky ones like us encounter this "14 percent upgrade death".  Or are we the only ones complaining about it?

[dem..!..rep]

That's it? It dies on an error and you can't recover until you revert back and look for the problem? This isn't going to be much fun.


Adding permission profiles for boards." (16 of 27 - of this script).
..
..
..
Migrating old board profiles to profile sysetem...


!!
Error!
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 's Gallery')' at line 4

Obviously a mod - but I can only assume it's in a permissions or members php script - doesn't help much in directing me to my issue.

php - 5.2.5
mysql - 5.0.45

[rsw686]

The upgrade scripte just deals with database changes since it uses a clea set of 2.0 files. I would suspect some mod made modifications to the board table. Why not compare it to a 1.1.4 table.

[dem..!..rep]

Thanks ...

[dem..!..rep]

Was less painful than I suspected once I determined that just repointing to the upgrade.php on the site would continue from the last imcomplete step. First run was without the new language packs - take a while to see how well it all did.

[npereira]

Im having the same proble with the error @ 14%...

here is the list of mods installed:

Mod Name Version 
1. SMF 1.0.12 / 1.1.4 / 2.0 b1.1 Update 1.0   [ Uninstall ] [ List Files ] [ Delete ] 
2. MessagePreviewOnHover 1.5   [ Uninstall ] [ List Files ] [ Delete ] 
3. SMF Links 1.6.7   [ Uninstall ] [ List Files ] [ Delete ] 
4. Auto Embed Video Clips 2.1.4   [ Uninstall ] [ List Files ] [ Delete ] 
5. Ad Managment 2.3   [ Uninstall ] [ List Files ] [ Delete ] 
6. Users Online Today Mod 1.4.0   [ Uninstall ] [ List Files ] [ Delete ] 
7. Ignore user 1.4   [ Uninstall ] [ List Files ] [ Delete ] 
8. SMF Gallery Pro 1.3beta2.1   [ Uninstall ] [ List Files ] [ Delete ] 
9. Hide Tag 1.7.0   [ Uninstall ] [ List Files ] [ Delete ] 
10. SSI Membergroup 1.0   [ Uninstall ] [ List Files ] [ Delete ] 

Also running TP 0.9.8

[†MavN†]

I have this problem too.

[rsw686]

You shouldn't have any mods installed when doing the upgrade process. The upgrade requires you to replace all the forum files with the SMF 2.0 version. Thus removing any modifications to those files. Then run the upgrade.php script.

Afterwards you will need to see if there are new versions of the mods or convert them yourself.

[metallica48423]

have you ran a repair on the database tables from phpmyadmin before the upgrade?

[†MavN†]

I am refresh update and continue with out problem.