Dear all,
Hope someone can help. Please advise...
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 upgrade script 1 of 2.
Executing: "Cleaning up database..." (8 of 19 - of this script)
Error text is as below:
Updating indexes on "messages"...done
Updating table 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
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
Installing theme settings...done
Renaming personal message tables...done
Updating indexes on "pm_recipients"...done
Updating columns on "pm_recipients"...done
Updating columns on "members"...done
Updating columns on "members" - part 2...done
Updating member approval...done
Adding new holidays...done
Updating event start and end dates...done
Converting other date columns...done
Checking for an old table...done
Creating "message_icons"...done
Inserting "message_icons"...done
Creating "package_servers"...done
Inserting "package_servers"...done
Updating flood control log...done
!!
Error!
Server has not responded for 30 seconds. It may be worth waiting a little longer or otherwise please click here to try this step again
I have quite some mods installed. Should I set the forum to non maintenance and remove the mods?
My webshot is Hostgator and have asked them to increase timeout to max.
Mysql version is 5.5.23
The upgrade is an intense process to the server. Your host is one of the famous oversellers and MySQL server "dies" during the process.
My advice: run the converter in your localhost, if you're comfortable with that.
I am sorry that you are having trouble.
How large is your forum?
My forum has been around for 5 years. The backup is 235MB. I cannot really see the number of posts now as it is in the maintenance / upgrade mode. As we speak the upgrade is still hung at the same line.
When you say run in localhost, it means run on my computer? I go search the board to see how to do so.
Time elapsed always shows...
Time Elapsed: 0 mins, 29 seconds.
Progress
Step 1: Login
Step 2: Upgrade Options
Step 3: Backup
Step 4: Database Changes
Step 5: Delete Upgrade
27%
Overall Progress
20%
Step Progress
Now when I remove the maintenance mode, I get this error...
Unknown column 'a.attachment_type' in 'field list'
Sigh...
Please, can anyone help?
a lot of gurus here... hope someone can help.
So should I run the repair_settings file to reset? I see that the repair settings is for v 2, while I was on SMF 1, upgrading to 2. Should I continue still?
Hi Chase78,
First, this 30-sec is NOT a showstopper. The server will proceed when your browser sends a new request to it (in about 30 sec) so as long as your browser (and your PC) is on, the 30-sec will proceed.
You will mainly have to wait for 1] the search cache build (14 of 19) and 2] the attachment conversions.
For the (14 of 19) wait, it seems unnecesary, there is a solution.
Deactivate this line in subs.php,
// $words = un_htmlspecialchars($smcFunc['strtolower']($words));
I'm currently doing a similar conversion, coming from 1.08 with mods.
I posted a topic with my adventures some weeks ago with a few tips to overcome several waits,
http://www.simplemachines.org/community/index.php?topic=512234.0
Be carefull with the mods. And make sure you upload your attachments. I did not do that and I ran into a few problems.
Lx
when u say attachment conversions, you mean photo attachments on the forum? I disabled all attachments.
It seems there is some progress, after 12 hours... my computer had hibernated in the meantime.
so should i edit the subs.php still or continue to wait?
28%
Overall Progress
21.2%
Step Progress
Ok... I removed the line in subs.php... and re-run the upgrade script. But now stuck at the same phase 8 of 19...
I dont think I cant wait for longer for my forum to be back up and running.
What is the best way to restore back to 1.0? how do I load back the backed up database and restore everything back? Do i re upload the old php forum 1.1.x php files?
i will wait a bit more... the progress is faster today after commenting out the line as Goodies suggested.
But please, if anyone has more advice, please let me know.
ok i restored the forum and removed mods. Now when I run the upgrade script... it is stuck at same part. sigh.
As I've told you...
Quote from: margarett on October 19, 2013, 03:38:59 AM
The upgrade is an intense process to the server. Your host is one of the famous oversellers and MySQL server "dies" during the process.
My advice: run the converter in your localhost, if you're comfortable with that.
If you ask your host to raise these (in php.ini):
upload_max_filesize = 2M (or whatever size you want)
max_execution_time = 60 (also, higher if you need).
...the script might work. But, your host may well either refuse, point-blank, or demand a pot of cash.
Quote from: margarett on October 21, 2013, 08:59:38 AM
As I've told you...
Quote from: margarett on October 19, 2013, 03:38:59 AM
The upgrade is an intense process to the server. Your host is one of the famous oversellers and MySQL server "dies" during the process.
My advice: run the converter in your localhost, if you're comfortable with that.
Thanks... i will look to how to run converter in localhost. I will try to figure this part out. Thanks.
Quote from: K@ on October 21, 2013, 04:23:51 PM
If you ask your host to raise these (in php.ini):
upload_max_filesize = 2M (or whatever size you want)
max_execution_time = 60 (also, higher if you need).
...the script might work. But, your host may well either refuse, point-blank, or demand a pot of cash.
Thanks. Their response...
safe mode = Off (cannot adjust)
memory_limit = 256M (MAXIMUM)
max_execution_time = 30 (MAXIMUM in seconds)
max_input_time = 60 (MAXIMUM in seconds)
post_max_size = 64M (MAXIMUM)
upload_max_filesize = 64M (MAXIMUM)
enable_dl = Off (cannot adjust)
You are right. Seems like they dont budge.
Quote from: margarett on October 21, 2013, 08:59:38 AM
As I've told you...
Quote from: margarett on October 19, 2013, 03:38:59 AM
The upgrade is an intense process to the server. Your host is one of the famous oversellers and MySQL server "dies" during the process.
My advice: run the converter in your localhost, if you're comfortable with that.
Hi... i am trying to put this together...
1. so when I install the WAMP or XAMPP, the database and SMF files are moved to this localhost computer.
2. I run the upgrade.php.
3. The database has been modifed.
4. I upload this new 2.2.x database to the hostgator webhost to replace my old 1.1.x database.
The steps are as above?
Yes, that should be correct.
Yes. Just remember that, depending in the size if the database, you might get a timeout when uploading it.
If that happens, have a look at "bigdump.php"
Quote from: chase78 on October 21, 2013, 07:03:20 PMcolor=red]max_execution_time = 30 (MAXIMUM in seconds)[/color]
They won't even raise that, temporarily?
Miserable bastards.
I don't think that's the real issue, K@.
I really think that you can put there 10 minutes if you like. It will die nevertheless...
well, the database and files are not "atuomagically" copied... You have to do that yourself.
Quote from: margarett on October 22, 2013, 07:30:53 AM
I don't think that's the real issue, K@.
I really think that you can put there 10 minutes if you like. It will die nevertheless...
You could be right, of course.
I just thought that it might be worth trying, tiz all. :)
thanks guys... for all your feedback.
i will try to do this.
makes me feel i need a better webhost.
I couldn't disagree, with that. :)
Avoid any that offer "Unlimited" anything. There's no such animal. ;)
Have a look here:
http://www.simplemachines.org/community/index.php?board=4.0
Thanks everyone.
I installed WAMP (its quite a breeze compared to 10 tens ago when Apache had to be setup "manually").
My database is too big... did all the timeout changes... and I cannot even import into the WAMP server.
mysql> source chase_singthaidisco.sql.gz
ERROR:
ASCII '\0' appeared in the statement, but this is not allowed unless option --bi
nary-mode is enabled and mysql is run in non-interactive mode. Set --binary-mode
to 1 if ASCII '\0' is expected. Query: '▼'.
Bye
Please dont answer if you are not comfortable, as I understand this is not a MYSQL forum. I might outsource the upgrade to eLance freelancers LOL.
WAMP includes phpMyAdmin, head over to localhost/phpmyadmin. There you should be able to import the file.
You should have phpmyadmin available, why are you doing it via command prompt?
What is the size of your backup?
Edit: ninja'd :P
You're not trying to run a public website from a WampServer installation are you? This is not a good idea.
Thanks everyone. I am learning something new with this task.
I tried importing via phpmyadmin but it does not work. I cant remember the error. I had increase all those max file this max time out variables.
So from online advice, they suggested importing via mysql command line.
I dont think I am running a public website. I dunno how to do that.
Try a staggered import tool like bigdump.php
http://www.ozerov.de/bigdump/
As for public: are you serving any users from your computer or is it just a test installation for yourself? Are you blocking access with your firewall?
I don't know about WAMP, but XAMPP is pre-configured to accept connections from any origin, I had to change it to lock it to localhost...
http://www.apachefriends.org/f/viewtopic.php?p=150195
Ok, i have asked someone in elance to help with the upgrade. and his vps server is not powerful enough and the upgrade job fails...
is this bigdump still required? Not really right? I dont need to import but now the upgrade still does not work right?
I am confused with all these people who are having problems... I just upgraded a moderately large forum on an ancient GoDaddy shared server... it took a bit, but successfully completed in about 3 hours.
@Chase78 I understood you don't use attachments and you did do the hack in subs.php
Now it still does not finish in time ? what's the size of your smf_messages table ? How many messages are there ?
If you are using WAMP, I advise to put the settings in php.ini to the max on your local machine too. Also set max execution time to 6000. This will help the import of your 1.1 backup via phpMyAdmin.
Once you have your database loaded into the local phpMyAdmin setup, you can partition the uploads in e.g. 50.000 messages at a time, using Export options in phpMyAdmin. I had to do my forum in several chunks for smf_messages and smf_log_topics. The other tables transferred quickly.
One other reminder: when transferring your database using phpMyAdmin, make sure the format (e.g. UTF-8) is set the same on both sides. Otherwise you'll run into these \0 messages..
Lx
My smf_messages has 258K rows, size is 138MB.
I will think through the suggestions you all have mentioned and try again on my localhost.
I had retrieved my database backup from hostgator's cpanel interface. Maybe I check with hostgator on whether they use the format of UTF 8.
Thanks everyone. A bit of good news. I used the big dump to import the database backup into my localhost home computer.
Now I tried putting the forum script, change the settings.php but get the
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator at
[email protected] to inform them of the time this error occurred, and the actions you performed just before this error.
More information about this error may be available in the server error log.
I moved the repair_settings.php into the localhost folder and run but got the same error.
I did not make any changes to the repair_settings file and just ran it in the browser.
That is happening in your local machine? Did you load the forum files to the public_html folder (or in a sub folder) and put repair_settings in the same place?
You should never get an error 500... That's some server error that shouldn't happen. Check the apache logs to try to find the cause.
Thanks... that was my computer at home.
I am now trying at another computer and get other errors... I have done the database import and overwritten the old 1.1.x php script with the large Upgrade script.
The errors are as below and displayed in Orange tables... it is a whole series, not just the few mentioned below... but all say that there is something missing in upgrade.php
Notice: Undefined index: upgrade_overall_progress in C:\wamp\www\forums\upgrade.php on line 3502
Call Stack
# Time Memory Function Location
1 0.0156 760360 {main}( ) ..\upgrade.php:0
2 0.2812 1662368 upgradeExit( ) ..\upgrade.php:695
3 0.2812 1662488 template_upgrade_above( ) ..\upgrade.php:736
Notice: Undefined index: upgrade_time_mins in C:\wamp\www\forums\upgrade.php on line 3528
Call Stack
# Time Memory Function Location
1 0.0156 760360 {main}( ) ..\upgrade.php:0
2 0.2812 1662368 upgradeExit( ) ..\upgrade.php:695
3 0.2812 1662488 template_upgrade_above( ) ..\upgrade.php:736
Notice: Undefined index: upgrade_progress in C:\wamp\www\forums\upgrade.php on line 3488
Call Stack
# Time Memory Function Location
1 0.0156 760360 {main}( ) ..\upgrade.php:0
2 0.2812 1662368 upgradeExit( ) ..\upgrade.php:695
3 0.2812 1662488 template_upgrade_above( ) ..\upgrade.php:736
Notice: Undefined index: upgrade_step in C:\wamp\www\forums\upgrade.php on line 3493
Call Stack
# Time Memory Function Location
1 0.0156 760360 {main}( ) ..\upgrade.php:0
2 0.2812 1662368 upgradeExit( ) ..\upgrade.php:695
3 0.2812 1662488 template_upgrade_above( ) ..\upgrade.php:736
Notice: Undefined index: upgrade_step in C:\wamp\www\forums\upgrade.php on line 3493
Call Stack
# Time Memory Function Location
1 0.0156 760360 {main}( ) ..\upgrade.php:0
2 0.2812 1662368 upgradeExit( ) ..\upgrade.php:695
3 0.2812 1662488 template_upgrade_above( ) ..\upgrade.php:736
Finally at the bottom:
Updating Your SMF Install!
The upgrader was unable to find some crucial files.
Please make sure you uploaded all of the files included in the package, including the Themes, Sources, and other directories.
Click here to try again.
I have rewritten the upgrade files but the error still occurs. :'(
Please put your 1.1 files back, then run repair_settings.php. Before you start the upgrade process, please make sure your 1.1 forum is "live" and can be accessed.
Then you can go with the upgrade ;)
when i ran repair_settings I get the below error.
Notice: Undefined index: database_error in C:\wamp\www\forums\Sources\Subs-Db-mysql.php on line 572
Call Stack
# Time Memory Function Location
1 0.0000 315856 {main}( ) ..\repair_settings.php:0
2 0.0781 1001960 show_settings( ) ..\repair_settings.php:215
3 0.1406 1095608 guess_attachments_directories( ) ..\repair_settings.php:582
4 0.1406 1096248 smf_db_query( ) ..\repair_settings.php:672
5 0.1406 1096760 smf_db_error( ) ..\Subs-Db-mysql.php:358
( ! ) Fatal error: Call to undefined function allowedTo() in C:\wamp\www\forums\Sources\Subs-Db-mysql.php on line 573
Call Stack
# Time Memory Function Location
1 0.0000 315856 {main}( ) ..\repair_settings.php:0
2 0.0781 1001960 show_settings( ) ..\repair_settings.php:215
3 0.1406 1095608 guess_attachments_directories( ) ..\repair_settings.php:582
4 0.1406 1096248 smf_db_query( ) ..\repair_settings.php:672
5 0.1406 1096760 smf_db_error( ) ..\Subs-Db-mysql.php:358
when i copy the old 1.x.x. files over, the forum can run. But the upgrade cannot run, with the mentioned errors.
Those are strange errors. Especially here:
Quote
4 0.1406 1096248 smf_db_query( ) ..\repair_settings.php:672
5 0.1406 1096760 smf_db_error( ) ..\Subs-Db-mysql.php:358
repair_settings and Subs-xxxx are NOT supposed to be in the same folder..
i had put repair settings in the root of the forum.
different from the sources folder.
that's not what your errors indicate...
Now the upgrade script can run.
The error is caused by that I had deleted the old default themes and that I used a modified theme. The database does not have record of the default themes. So after I managed to reset to my modified theme, the errors disappeared.
Dear support members, you all can take note and advise upgraders who encounter the same problem that they should have the default themes intact or at least reset to the current usable theme. I appreciate your advice so far.
Now...
Database Changes
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 upgrade script 2 of 2.
Executing: "Upgrading the error log." (14 of 42 - of this script)
WAITING WAITING... there progress bar for "Updating error log tables" is moving slowly. Fingers crossed. O:) :D
QuoteThe error is caused by that I had deleted the old default themes
A configuration totally unsupported by us in any eventuality. SMF is not designed to be run without the *default* theme since every theme without fail should be deriving from it unless you put *every* template into it and even then there are likely to be edge conditions, not least this.
(And no, I don't see us fixing the upgrader for this eventuality.)
understand your point. 8)
now the script has been running at the same step 14 of 42 for the last 2 hours...
Executing: "Upgrading the error log." (14 of 42 - of this script)
The progress is increasing slowly, now at 45%. I am using i3 processor.
now i am doing at another computer.
its at the same stage, error_log at 54% and been running for 15 hours.
Any thoughts? I should wait?
/me wonders if Chase ever got this finished...
Ran for 42 hours and got to error_log at 78% and... someone closed my localhost browser with the upgrade still running.
Where is this error_log file anyway??
The place where all the errors are logged. But for it to take any serious period of time, that would imply you have a *lot* of errors. Try emptying the table.
FINALLY!!!
I tried on a 3rd computer and everything works. The database upgrade done in 4 mins! I cant rem what settings I changed, like max file size and stuff...
I checked that its the new 2.0.6. Hurray!!
Now I trying to export from phpmyadmin and its 0 bytes. Googling now.
Thanks everyone. This case can be closed.
WoOt!
Phew... ;)
Thanks everyone. it has been much ado.
I remember changing some setting in mysql, maybe because of this, the upgrade time is a lot faster.
Do you know where to get the repair_settings for smf 1.1.x? I am trying to retrieve something from my old forum.
It's the same file for both versions ;)
Strange. does not seem to work. The display is shown as 2.0 and no save button appears at the bottom. Thanks!!
I mean... its fine. You dont have to reply anymore. I got what I wanted. Have a nice day.