I use smf 2.0.9 , I want upgrade v2.1 beta but when I run upgrade.php, say this error,
Table 'u836798840_dstk.smf_moderator_groups' doesn't exist
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/u836798840/public_html/upgrade.php on line 1117
Warning: mysql_free_result() expects parameter 1 to be resource, boolean given in /home/u836798840/public_html/upgrade.php on line 1119
Notice: Undefined index: database_error in /home/u836798840/public_html/Sources/Subs-Db-mysql.php on line 636
Notice: Undefined index: try_again in /home/u836798840/public_html/Sources/Subs-Db-mysql.php on line 640
Fatal error: Call to undefined function fatal_error() in /home/u836798840/public_html/Sources/Subs-Db-mysql.php on line 648
You are not trying to upgrade a live/production site, are you? ?
Quote from: Kindred on February 17, 2015, 09:53:10 AM
You are not trying to upgrade a live/production site, are you? ?
Yes i try live site.
You most certainly should **NOT** be doing that...
Quote from: Kindred on February 17, 2015, 06:41:02 PM
You most certainly should **NOT** be doing that...
No problem ı have backup. How can i convert v2.0.9 database to v2.1 ?
upgrade.php will do the conversion...
However, it seems that your installation is missing some of the required files... or you are using the wrong conversion function.
or the op is using the files on sm.org which is broken and should use what is on github.
I've got the same situation as the OP.
QuoteI use smf 2.0.9 , I want upgrade v2.1 beta but when I run upgrade.php, say this error,
Table 'u836798840_dstk.smf_moderator_groups' doesn't exist
And I get that the final word is to use what is on github, but the version on github that I'm finding doesn't have upgrade.php that I'd expect it to have.
https://github.com/SimpleMachines/SMF2.1
I'm doing this on a (non production) development server but with of course, the production database and files copied locally. I was hoping to just start getting a feel for how painful an upgrade will be one day. Appreciate any direction.
take a look at http://www.simplemachines.org/community/index.php?topic=523428.0
Looked at it. Are you saying that upgrade is not ready yet? If so why wasn't it mentioned previously in this thread? Or is the implication its alpha and not beta? Must have been a very obvious link to someone that knows the answer
FYI I do have. 2.1 smf setup independently that has no data. I thought it would be a good thing to test it with closer to real life situation.
that is an old topic from before 2.1 went into beta. it is still a good guide in how to use the version on github.
most specifically, the distribution archive on github has the install and upgrade files in a SEPARATE DIRECTORY and they have to be MOVED to be run correctly.
Very much appreciated Kindred
I have read MANY 2.1 threads now and am more up to speed. I get now why the Dev team wouldn't want to make it straight forward to upgrade a site for fear of people applying it to their live site. This is why I created a completely separate copy of my live site including a Dev database Strictly to see how 2.1 would work and integrate with my edits on 2.09. I extracted the 2.1 over my existing site (the Dev copy) and ran upgrade.php from the home url and got the same issue as the op. Doh!
Does anyone have an outline written up of the steps to successfully get 2.09 upgraded to 2.1 Beta? I wish I could overwrite the Source and Themes folder with the 2.1 beta and import some sql which would add any new tables etc to my Dev database and I could then start making the list of mods that I'll need to try to do again when one day RC comes into play. If the steps are to just copy the files over, renaming settings.php to the backup name etc and running upgrade.php then I guess my report is the same primary error that the op has which was the table being missing
I appreciate the hard work the Dev team does. It's highly thankless and judging by how many people ask for when RC will be here "in the same thread" over and over. One would think that running a forum might give us empathy towards other under appreciated folk supporting smf
did you use the archive from GitHub?
Quote from: Kindred on April 23, 2015, 02:13:14 PM
did you use the archive from GitHub?
yes.
https://github.com/SimpleMachines/SMF2.1
edit * am actually going to start over and do it AGAIN.. just to be sure that the same results happen
Update, this time I pulled the files with git versus using the "Download ZIP" button on the page and it got further.
(where smf21.com is my local development website)
smf21.com/upgrade.php
'The upgrader could not find the "Install" language file for the forum default language, english.'
If I figure out more, I'll post more, maybe it'll help someone else...
edit: git details :
IMAC)(webdev)-> git status
On branch release-2.1
Your branch is up-to-date with 'origin/release-2.1'.
nothing to commit, working directory clean
iMac.local [~/www/smf21.com/smf21_github/SMF2.1]
(IMAC)(webdev)-> cat .git/config
[core]
repositoryformatversion = 0
filemode = true
bare = false
logallrefupdates = true
ignorecase = true
precomposeunicode = true
[remote "origin"]
url = https://github.com/SimpleMachines/SMF2.1
fetch = +refs/heads/*:refs/remotes/origin/*
[branch "release-2.1"]
remote = origin
merge = refs/heads/release-2.1
and, I think I figured an error of mine out... I'll update a bit later... prob best to ignore this until I do. Sorry
Ok got it!
Steps that worked
Reminder: DON'T DO THIS ON YOUR LIVE SERVER! IT'S BETA!
Note, ~/www/smf21.com/htdocs is where the cloned version of my live forum is served from with a copy of the database
mkdir ~/www/smf21.com/htdocs/cache
chmod -R 777 ~/www/smf21.com/htdocs/cache
// make sure Settings_bak.php is in the correct format, a copy of the current Settings.php
// make sure your local site is stable prior to attempting the upgrade
// needs a github account
git clone https://github.com/SimpleMachines/SMF2.1 ~/www/smf21.com
cd ~/www/smf21.com/htdocs
// copy all of the files from the cloned Beta over my forum
cp -R ../smf21_github/SMF2.1/* .
// copy the upgrade related files
cp -R other/* .
touch db_last_error.php
chmod -R 777 db_last_error.php
chmod -R 777 attachments
chmod -R 777 avatars
chmod -R 777 custom_avatar
chmod -R 777 Packages
chmod -R 777 Smileys
chmod -R 777 Themes
chmod -R 777 agreement.txt
chmod -R 777 Settings.php
chmod -R 777 Settings_bak.php
http://smf21.com/upgrade.php
// follow the steps..... get paid!
Thanks again Kindred and others for trying to help me. I hope this helps someone else
the upgrade etc files are in the "other" folder, you left out moving them out of that folder.
I had that under the "comment"
// copy the upgrade related files
ah i had missed that. so many steps it is easy to miss one.
do keep in mind that many doing this upgrade will not have ssh access and may not be able to follow your directions easily.
I just thought that it may help "some" (those with SSH access) maybe even me when SMF 2.1 goes RC and I have to do it again. Meanwhile I'm going to plod along, seeing what mods that I need to do to get this upgraded version of my site working like my site and noting what might need tweaking and possible reporting to the dev team. I really can't believe how good of a forum SMF is and that it's free to use. The devs are worthy of many beers in my book.