View Full Version : vBulletin 2.0 BETA 4 Released
John
Tue 3rd Apr '01, 4:19pm
Come and discuss it here. The usual forums are open for discussion too...
John
Me2Be
Tue 3rd Apr '01, 4:28pm
Yay! I'm first!!
Craig Antill
Tue 3rd Apr '01, 4:31pm
Well I was gonnna update right away, but there's like hundreds of templates to update :( It'll have to wait... Good to see it out though. :)
fastforward
Tue 3rd Apr '01, 4:31pm
Well it's about bloody time! :D
Lost
Tue 3rd Apr '01, 4:56pm
Great job guy's...
Like the extra features...
Well donr to all involved:):)
klisis
Tue 3rd Apr '01, 4:59pm
Upgrade went smoothly.
klisis
Tue 3rd Apr '01, 5:03pm
hmm, is it just me?
It's taking longer to load newreply.php.
Dream
Tue 3rd Apr '01, 5:31pm
thanks guys
i got some warnings in the forumdisplay.php using the default style
Warning: Using scalar variable $frmjmpsel as an array or object in ./admin/functions.php on line 1073
Warning: Using scalar variable $frmjmpsel as an array or object in ./admin/functions.php on line 1073
Warning: Using scalar variable $frmjmpsel as an array or object in ./admin/functions.php on line 1073
Warning: Variable passed to reset() is not an array or object in /u/local/etc/httpd/htdocs/webpoint/jogosonline/vb/forumdisplay.php on line 139
Warning: Variable passed to each() is not an array or object in /u/local/etc/httpd/htdocs/webpoint/jogosonline/vb/forumdisplay.php on line 140
and i got a parse error while logging to make a reply in a topic...
Parse error: parse error in ./admin/functions.php on line 1582
i think im going to do a fresh install; maybe theres something wrong with my database. only change on that was kiers maxonline users, i think..
jojo85
Tue 3rd Apr '01, 5:34pm
Will install it now :)
Thx!!:p
Chris Schreiber
Tue 3rd Apr '01, 5:38pm
Just wanted to say that my upgrade went very well. I also wanted to say what a wonderful job everyone involved did on this release, I love it! :)
klisis
Tue 3rd Apr '01, 5:39pm
I had to remove the Smiles Box on right. It wouldn't fit with my 770 width layout.
And I think this new vB code function above the message box is casuing more time to loaded. Is there anyway to disable this vB code? Do I just remove it from template?
Thanks.
Dream
Tue 3rd Apr '01, 5:47pm
i did a fresh install (resetting the database) and im still getting those warning. this may be my php version, perhaps? where can i view my php version?
edit: and yes, i felt the newreply taking a bit more time to load... and the fresh install came with no vbcode+smilies.
klisis
Tue 3rd Apr '01, 5:50pm
Run a simple script with phpinfo command.
<?php
phpinfo();
?>
Dream
Tue 3rd Apr '01, 5:56pm
ouch. im running PHP Version 3.0.16 O_O
time to talk to some people
thanks klisis.
klisis
Tue 3rd Apr '01, 5:59pm
Originally posted by Dream
ouch. im running PHP Version 3.0.16 O_O
time to talk to some people
thanks klisis.
Np,
Ouch, 3.0.16 :eek:
Kier
Tue 3rd Apr '01, 6:06pm
I have just found that there were some missing queries in the install/upgrade scripts.
If you ran upgrade1.php or install1.php to install beta 4, you will need to download the attachment to this message, unzip it, upload it to your admin folder and run it.
DO NOT RUN THIS SCRIPT IF YOU RAN UPGRADE4.PHP
Sorry about that.
rebby
Tue 3rd Apr '01, 6:06pm
Originally posted by klisis
Upgrade went smoothly.
ditto... hopefully all will be well in the long run after my update of nearly all my software (apache, mysql, zend optimizer, mod_ssl, mod_gzip, etc...) :)
Wally Hartshorn
Tue 3rd Apr '01, 6:45pm
Originally posted by Kier
I have just found that there were some missing queries in the install/upgrade scripts.
If you ran upgrade1.php or install1.php to install beta 4, you will need to download the attachment to this message, unzip it, upload it to your admin folder and run it.
DO NOT RUN THIS SCRIPT IF YOU RAN UPGRADE4.PHP
Sorry about that.
Is the oops.zip file needed if we didn't download the beta4 file until after you posted this message? (i.e. is the beta4 file now fixed?)
Kier
Tue 3rd Apr '01, 6:47pm
I can't access the members area to alter the vbulletin2.zip file, so you will need to run the oops.php script if you have run install1.php or upgrade1.php until further notice.
White Knight
Tue 3rd Apr '01, 6:58pm
The upgrade was successful for me.. I went from Beta 3 to Beta 4.. No problems at all. :)
klisis
Tue 3rd Apr '01, 7:21pm
I removed $vbcode_buttons then the newreply and newthead is loading much faster.
Sean
Tue 3rd Apr '01, 7:22pm
I'm getting an error on step 2. Right after it wanted to alter the Avatars table. Got an e-mail saying I don't have access? I can log into my database. Now, I can't retry, cause it says it's already completed. Umm, help?:(
Sean
Tue 3rd Apr '01, 7:31pm
I could really use some help, as my board is currently screwed up.............
Jaxsdad
Tue 3rd Apr '01, 7:57pm
How do I get the birthdays to show at the top of the forum like they do here?
And how do I get the smilies to show on the right of the text box?
Sharg
Tue 3rd Apr '01, 8:05pm
From what Chris Shreiber told me, you DON'T need to run the oops.zip if you install VB 2.0 from now time.
Brent
Tue 3rd Apr '01, 9:25pm
Ok, there I installed vB 2.0 Beta 4 earlier today as SOON as it came out, just now writting a post about it :D
I went from Beta 3 to Beta 4 so I used the upgrade4.php one so no problems here on my end. It went in smooth as silk like a hot knife through butter! And i love it! vB is just SO MUCH BETTER then UBB yum yum.
I'm just having one slight annoying thing, nothing major, but it just 'feels' like the forum is a little more sluggish/slower after the upgrade. I've disabled as many cpu intensive things as I could in the control panel, but it still seems a little itty bit more slugish then before. But also Note I do NOT have GZip running as our host does not have the Zlib library compiled correctly into PHP4, so i'm running WITHOUT the GZip optimization. So perhaps with GZip it Could be much faster.
Brent
Tue 3rd Apr '01, 9:32pm
Originally posted by klisis
I removed $vbcode_buttons then the newreply and newthead is loading much faster.
elaborate
what you say?
this sounds interesting on increasing performance, but what are the drawbacks?
Kier
Tue 3rd Apr '01, 9:37pm
Originally posted by Brent
I'm just having one slight annoying thing, nothing major, but it just 'feels' like the forum is a little more sluggish/slower after the upgrade. Pages will take a little longer to render now that we use tables to display the last post time/date on forumhome and forumdisplay... try customizing the appropriate templates to remove the tables for the last post bits, and see if that speeds up your pages much.
In the meantime, I'm looking for an alternative to using the tables.
Dream
Tue 3rd Apr '01, 9:50pm
i think the warnings some people are getting are showing only on servers running php3, not php4
i created a thread to discuss upgrading from php3 to php4 as im curious about it, if anyone is interested
http://www.vbulletin.com/forum/showthread.php?s=&threadid=12998
any imput is higly appreciated :)
freaky
Tue 3rd Apr '01, 9:51pm
Ok, run this oops.php after I install the board or before ? I am doing a fresh install and it's giving me this error in step5 of install1.php:
Database error in vBulletin Installer: Invalid SQL: INSERT INTO usergroup VALUES ( '1', 'Unregistered / Not Logged In', 'Guest', '0', '1', '1', '1', '1', '1', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0')
mysql error: Column count doesn't match value count at row 1
mysql error number: 1136
Date: Tuesday 03rd of April 2001 07:51:08 PM
Script: /admin/install1.php?step=5
eva2000
Tue 3rd Apr '01, 10:00pm
Arrrrgh late on the announcement again :(
Originally posted by Kier
Pages will take a little longer to render now that we use tables to display the last post time/date on forumhome and forumdisplay... try customizing the appropriate templates to remove the tables for the last post bits, and see if that speeds up your pages much.
In the meantime, I'm looking for an alternative to using the tables. huh ? last post bits are enclosed in a table now ? why ?
glenv
Tue 3rd Apr '01, 10:14pm
Regarding: "When a user has enabled the clickable vbcode/smilies how many smilies do you want to show per row?"
I have over 12,000 members and I want to know how I let them know this feature is available without emailing them? I notice when I log in here, it is automatically there, yet I have not set up my personal profile to show it.
Am I missing something? Isn't this feature enabled only if the member wants it?
Kier
Tue 3rd Apr '01, 10:21pm
the feature is automatically enabled for every user when you run the upgrade script.
Jaxsdad
Tue 3rd Apr '01, 10:22pm
Then why cant I see it on my board?
Kier
Tue 3rd Apr '01, 10:22pm
Originally posted by eva2000
huh ? last post bits are enclosed in a table now ? why ? Look at forumhome and forumdisplay on this board and you'll see.
Freddie Bingham
Tue 3rd Apr '01, 11:01pm
Originally posted by Jaxsdad
Then why cant I see it on my board?
Have you modified your newreply and newthread templates? If so you will need to make the changes or revert the templates.
glenv
Tue 3rd Apr '01, 11:03pm
I sort a got lost here but I haven't modifed those templates Freddie and this feature is not viewable on my board
glenv
Tue 3rd Apr '01, 11:07pm
take that back
I must have edited it earlier
I figured it out
Thanks
Freddie Bingham
Tue 3rd Apr '01, 11:17pm
I registered and see it, verify that it is enabled in your user profile.
Jaxsdad
Tue 3rd Apr '01, 11:23pm
Well...
I reverted to the original and now I cant see ANY of the new stuff like the buttons at the top and the smilies on the right. Looks JUST like my board before the upgrade!
What now?
Jaxsdad
Tue 3rd Apr '01, 11:26pm
NEVERMIND!!!
Works perfect now!
Thanks!!!!!!!
jamez
Wed 4th Apr '01, 12:54am
Upgrade installed perfectly..... :)
Kier
Wed 4th Apr '01, 12:57am
If you have not yet installed beta 4, make sure you grab the newest version (beta 4.1) from the members area, rather than using the older version (beta 4.0)
Brent
Wed 4th Apr '01, 1:22am
you say in the annoucemnts page only upload the 'new files'
how do we know which files are the new files?
so all that i will have to do is just upload them to the server and then that's it? no script to run or anything?
Kier
Wed 4th Apr '01, 1:34am
Upload all the files from the upload folder in the zip.
Brent
Wed 4th Apr '01, 1:59am
Originally posted by Kier
Upload all the files from the upload folder in the zip.
ok, whew, thanks! worked like a charm i think
the version # at the bottom still says 4 but i'm guessing ya'll just didn't update that to display 4.1 hehe
i uploaded all files and the forum is working great, thanks
Jake Bunce
Wed 4th Apr '01, 2:58am
Mac platform checking in! :p
I upgraded from beta 3 to beta 4 using the 4.1 package first (I saw the announcement late). The upgrade went smoothly without any issues or hang ups. I had to reset my table border color back to black as it defaulted to purple with the upgrade. Besides that everything else looks good! I love all the new "clickable" vB code stuff! Good job guys!
gjgjgj
Wed 4th Apr '01, 3:20am
in which php file will i find $templateversion. My version refuses to change !!
julius
Wed 4th Apr '01, 4:59am
Is it always the same thing?
I have to change all file extentions to php3 and all .php inside files to .php3?
Thanks
WildWayz
Wed 4th Apr '01, 7:01am
Julius,
When I had a shared account that only supported PHP3, all I did was this.
Create a file called .htaccess and put it in my www or public_html folder.
In the file I have these lines
DirectoryIndex index.html index.htm index.shtml index.php3 index.php
THEN
If you have PHP4 then add this
AddType application/x-httpd-php .php .phtml .php3
AddType application/x-httpd-php-source .phps
If you have PHP3 then add this
AddType application/x-httpd-php3 .php .phtml .php3
AddType application/x-httpd-php3-source .phps
This will then make .php3 files parse as .php for the whole of your site.
--James
PS - vB 2 beta 4.1 installed fine :)
jojo85
Wed 4th Apr '01, 8:06am
Don't know that :)
Thx guy
Mika
Wed 4th Apr '01, 10:11am
Schema changes
There are two more indexes to add. These are not crucial:
ALTER TABLE search ADD INDEX (querystring), ADD INDEX (userid)
If you have not yet upgraded to beta 4(.1), then these will be added when you do. If you have already upgraded to beta 4 then you should add these in manually by phpmyadmin or telnet. On no account should you try to run upgrade4.php again. Ok, let's suppose that I don't know anything about phpadmin etc. How do I run that query?
freaky
Wed 4th Apr '01, 10:55am
I did the upgrade but do not see the clickable stuff.....seems like I upgraded to beta 4 but some of the stuff still looks like beta3 ; when i come here, the same pages look different....am i doing something wrong ?
klisis
Wed 4th Apr '01, 10:57am
Originally posted by Mika
Ok, let's suppose that I don't know anything about phpadmin etc. How do I run that query?
If you don't have phpadmin, then you could use telnet.
If you don't have telnet access, ask your host to run the query.
Freddie Bingham
Wed 4th Apr '01, 11:24am
You need to verify that you have not modified any templates that were changed by beta 4. You can find the list in the announcements forums. If you have you will need to put in the changes or simply revert the templates that were changed.
Dream
Wed 4th Apr '01, 11:37am
install1.php is placing "beta 3" version number in the database
so is upgrade1.php
and i think upgrade3 is doing this too:
$DB_site->query("UPDATE setting SET value='2.0.0 beta 3' WHERE varname='templateversion'");
echo "<p>Upgrade to 2.0 beta 3 completed successfully";
i found this in upgrade2
$DB_site->query("UPDATE setting SET value='2.0.0 beta 2' WHERE varname='templateversion'");
echo "<p>Upgrade to 2.0 beta 2 completed successfully";
weird is that upgrade1 isnt trying to upgrade to 1, its trying to upgrade to 3.
JamesUS
Wed 4th Apr '01, 11:57am
Actually that is how it is supposed to be
upgrade1.php = 1.1.x -> 2.0 beta 1
upgrade2.php = 2.0b1 -> 2.0 beta 2
upgrade3.php = 2.0b2 -> 2.0 beta 3
upgrade4.php = 2.0b3 -> 2.0 beta 4
Mika
Wed 4th Apr '01, 12:16pm
Originally posted by klisis
If you don't have phpadmin, then you could use telnet.
If you don't have telnet access, ask your host to run the query.
I do have telnet-access but I don't have phpadmin. I guess I could use mysqladmin ?
But can someone give me newbie-help since I don't know mysql. How do I add the following?
ALTER TABLE search ADD INDEX (querystring), ADD INDEX (userid)
klisis
Wed 4th Apr '01, 12:24pm
Originally posted by Mika
I do have telnet-access but I don't have phpadmin. I guess I could use mysqladmin ?
But can someone give me newbie-help since I don't know mysql. How do I add the following?
ALTER TABLE search ADD INDEX (querystring), ADD INDEX (userid)
mysqladmin should have a textbox for running query.
Put ALTER TABLE search ADD INDEX (querystring), ADD INDEX (userid) in the query box and click go, submit or anything.
jojo85
Wed 4th Apr '01, 2:47pm
Originally posted by klisis
mysqladmin should have a textbox for running query.
Put ALTER TABLE search ADD INDEX (querystring), ADD INDEX (userid) in the query box and click go, submit or anything.
Yes,a lot of thing don't work
bigsoccer tech
Wed 4th Apr '01, 3:40pm
Step three keeps timing out for me. Any advice??
Dave G..
Wed 4th Apr '01, 5:01pm
After upgrading from Beta 3 to Beta 4.1 I am getting the following error when I try to go to my Forum..
Forum address: www.63rd.co.uk/forum/index.php
Parse error: parse error in ./admin/functions.php on line 1193
Anyone Help !!!!!!
And how do you know which is line 1193 ?
Freddie Bingham
Wed 4th Apr '01, 5:08pm
Dave: http://vbulletin.com/forum/showthread.php?s=&threadid=12971
Dave G..
Wed 4th Apr '01, 5:22pm
Thanks there Freddie, done when replacement lines you sent me to and I'm now getting another error !!
When I try to visit Forum now I get;
Parse error: parse error in /home/sites/site158/web/forum/index.php on line 314
Also now Im getting; (when I try the admin panel)
Parse error: parse error in /home/sites/site158/web/forum/admin/index.php on line 382
Wishing I never upgraded :)
BTW - Whats the best editor for the php files so you know which line number there talking about ?
julius
Wed 4th Apr '01, 5:33pm
Thanks
Freddie Bingham
Wed 4th Apr '01, 5:45pm
Dave I think you may have edited functions.php wrong now. Does every page give you an error, i.e. showthread?
Dave G..
Wed 4th Apr '01, 6:06pm
Freddie, nope format looks correct but still getting errors.. Yes it is effecting all pages.
Could I send you the .php file to check the format as I'm using notebook to edit..
SystemLogic
Wed 4th Apr '01, 6:17pm
Did the installation locally before upgrading to the actual site, this way I could edit all the templates and just upload the new template in on the server with the upgrade, and everything is clean as can be :)
All went flawlessly! http://www.systemlogic.net/boards if you'd like to take a look.
Dave G..
Wed 4th Apr '01, 6:35pm
Freddie, thanks for the file, all is now working fine...
Panic over (for now), many thanks..
BTW - the vB Code area above this text box (when typing message) is that a hack or part of 4.1 ?
I ask as my message typing area looks nothing like this one !?
MovieJeff
Wed 4th Apr '01, 6:41pm
I have upgraded from beta 3 to beta 4 without a problem, but haven't yet gone to beta 4.1. My questions are:
1. Upload ALL files in the "upload" directory again from the 4.1 zip correct?
2. I don't know anything about PhpMyAdmin, but I do have it. What are the exact steps and how do I update it as specified? I'm confused on this step totally. If this is not done, while it mess things up?
3. I'm afraid of goofing up the board now since it requires editing by hand and not upgrading using the script called from a browser. Can the update be done without code editing in PhpMyAdmin if a new script was done from 4.0 to 4.1 and is one planed?
Thanks for any help.
Jeff
fastforward
Wed 4th Apr '01, 6:52pm
I've downloaded the 4.1 beta three times today and the files within the zip have had a different timestamp each time. It's impossible to determine which fixes posted in the bug thread need to applied and there's no indication of what exactly is different with these files. Any chance of a some version control or at least a change log?
Mika
Wed 4th Apr '01, 7:25pm
MovieJeff,
I don't know anything about phpmyadmin either so I did that Alter table-thing manually using mysql:
BACK UP YOUR DATABASE BEFORE DOING ANYTHING
1) from commandline:
mysql -uusername -ppassword yourdatabase
example: mysql -ujohn -psmith vbforum
then you will see:
>
now.. copy & paste this: ALTER TABLE search ADD INDEX (querystring), ADD INDEX (userid)
and add ; to the end of that line so it will look like:
ALTER TABLE search ADD INDEX (querystring), ADD INDEX (userid);
hit enter and it will say something like xyz rows affected ...
if it looks ok just write exit and hit enter.. that' s it.
RobAC
Wed 4th Apr '01, 7:56pm
I'm a little confused here. I want to upgrade from beta 3 to beta 4. According to the instructions....."Upload all the files, then run the upgrade4.php script in the admin area. When you are done, be sure to delete install1.php and all the upgradex.php scripts."
How does uploading all the files NOT overwrite all the templates, etc???
Mike Sullivan
Wed 4th Apr '01, 8:05pm
The templates aren't in files -- they're in the database.
RobAC
Wed 4th Apr '01, 8:21pm
Yeah I just figured that how after having a brain lapse. The upgrade instructions really need to be a little more specific for those of us that aren't familiar with doing this.
There's way too much room for assumption. I assume, I am supposed to unzip the zip file on my desktop and upload the two folders: "upload" and "extras" and then call the upgrade4.php script that's in that admin folder through a web browser??
eva2000
Wed 4th Apr '01, 11:35pm
another beta release ? http://vbulletin.com/forum/showthread.php?s=&postid=86960#post86960
now ya tell me just after i rehacked things in :p
MovieJeff
Thu 5th Apr '01, 12:19am
Mika:
Thanks for the detail post on this, I don't know much about programming php or mysql or telnet. I'll give what you said a shot though. One thing, I do this after I upload ALL files in the "upload" folder of 4.1 zip correct?
No one has stated for certain rather or not to upload ALL files again in the 4.1 zip. It's rather confusing statments they make about changed files. What files needs to be uploaded again?
Thanks,
Jeff
--------------------------------------------------------
RobAC:
I'm confused on their statments too and agree there needs more detailed instructions and even a 4.0 to 4.1 script made without any telnet, php stuff. However, I believe you only need to upload all the files in the "upload" directory only, not the extras, just like you did the first time.
Hope more details are posted and fixed on this.
Jeff
Brent
Thu 5th Apr '01, 1:05am
man, sounds like a LOT of suggestions/complaints/concerns/questions after the Beta 4.0 and 4.1 release....
whew, we sure are keeping these guys busy! I can only imagine the stress they are going through right now to answer and help and get this thing working good for everyone.
I hope the developers here take a moment to relax and reflect on what a kick ass program they have created, it's WAY better then UBB for sure, i never even heard of PHP before i got into vB and man it's cool stuff.
I hope ya'll can take a breath of fresh air, and look at things fresh, and not get too stressed out at all our posts!
It's a tough job i'm sure, but ya'll really do make an AWESOME forum!
RobAC
Thu 5th Apr '01, 7:38am
Well, what I find to be the most aggravating, and maybe, it's me because I don't have a full understanding of something, but, the fact that the upgrade script can only be run once is ridiculous.
Unfortunately, during the upload of the files, I lost my ftp connection and didn't realize it. When I ran the upgrade script, it basically added a few options in the control panel and changed the version number at the bottom of the forums. That was it.
When I realized what happened, I deleted the old files, added everything back from my backup and started over again. Now when I run the script, it tells me that it appears I've already run the script and that it cannot go any further......any changes will have to be manually added.
Well....now I have two choices....delete all the templates that I made changes to and start over fresh, or go down John's list of template changes (20+ templates???) and manually make all the changes, which still aren't clear.
Basically, I've given up and I'm just going to wait for the next beta release, because there's no way in hell, I'm going to sit here and make changes that are not clearely stated to all those templates when I can run a simple script and in 30 seconds, be finished with the whole thing.
So basically, that script is a one shot deal. If you mess something up prior to running that script, you're screwed. At least that's the way it appears to me.
WildWayz
Thu 5th Apr '01, 10:31am
Originally posted by Mika
mysql -uusername -ppassword yourdatabase
Noooooo - never put the password in the command line, always use
mysql -uusername -p databasename
then enter the password - otherwise people can see the process with your password on full display.
--James
MovieJeff
Thu 5th Apr '01, 7:58pm
Does anyone know if there are solutions coming for our 4.1 issues and questions? It's been a while now and no official word from the VB staff has come forward. We certainly need to get a FULLY DETAILED post on the exact steps and how to make the changes to 4.1 from Beta 4.0. As of yet, the posts still remain confusing on what to upload, change, how to change, etc.
We need to get another detailed post as well that outlines the steps for PhpMyAdmin too. I have it but don't know how to use it or what to do. You can do it from MySql telnet, but there really needs to be an outline on how to do it the other way. Could an official VB developer provide this along with a new post on the PRECISE details?
--------------------------------------------------------------------
RobAC:
I too share your concerns about the new upgrade issues. Right now my board is fine and with the lack of exact details and how to for editing the database its risky to make those changes (especially for beginners). Since it's no major issue, I've decided to wait until new outlines for upgrading are posted or not to do it at all until a new beta.
Also, I share your comments about the script issues. While I understand why a script can't be run more than once, uploading the files again and running it (upgrade script) should not matter if they are a fresh upload.
We certainly need them to make a 4.1 script that requires no code editing. With the posts here, it would seem others are having trouble too.
---------------------------------------------------------------------
Hope things work out for all of us, thanks.
Jeff
tubedogg
Fri 6th Apr '01, 2:00am
Originally posted by RobAC
So basically, that script is a one shot deal. If you mess something up prior to running that script, you're screwed. At least that's the way it appears to me.
The reason for this, at least my understanding of it, is the upgrade script sets the templateversion in the database and I believe if you try to run a future script, it checks that number to be sure you aren't trying to reinstall the same version. Reason this would be bad is you would get errors out the a$$ when MySQL trys to add columns that are already there, repopulate stuff, etc. It's just easier to tell the user (especially for those who aren't as familiar with MySQL and PHP) that they can't do it again, they come here, post a message, and someone helps them. ;) At least that's the way I would think it was supposed to work.
tubedogg
Fri 6th Apr '01, 2:13am
Originally posted by MovieJeff
[B]While I understand why a script can't be run more than once, uploading the files again and running it (upgrade script) should not matter if they are a fresh upload.[B]
But it is not a fresh database. The upgrade script makes changes to your database that would produce errors if you tried to make the same changes again, or possibly corrupt your database. That's why.
tubedogg
Fri 6th Apr '01, 2:25am
Originally posted by MovieJeff
We certainly need to get a FULLY DETAILED post on the exact steps and how to make the changes to 4.1 from Beta 4.0.
Fully detailed. I'll try my best. Let me know if you need more on something.
To upgrade to beta 4.1 from beta 4, rephrased from John's post here (http://www.vbulletin.com/forum/showthread.php?threadid=13013).
First, upload the files in the beta 4.1 zip file under the "upload" directory, overwriting your current forum files on your website. If you've done this before, you know how it goes. You don't need to upload the images directory.
Second, use your control panel to import the vbulletin.style file from the zip (under the "admin" directory). To do this, go into your control panel, click on "Download/upload", then find where it says "Import existing style set (from local file)". Choose to overwrite "default", and understand this: vBulletin will recognize the file as a "Master" style set and WILL NOT overwrite the default templates. It will overwrite the Master templates which you cannot edit (that's how when you are editing the Default templates you can revert to the original. They are stored in a special Master style that is not editable). It will tell you that the master style was correctly overwritten.
To perform the queries that John said to (involving searches), do the following:
Via telnet:
Login to telnet. Once at the bash$ or similar prompt, type mysql -uUSERNAME -pPASSWORD DATABASENAME substituting your info where appropriate, and press Enter. (If you need a refresher, this info is in your config.php file in the "admin" directory of your forums).
Then, type the following:
ALTER TABLE search ADD INDEX (querystring), ADD INDEX (userid); and press enter. *Make sure you have the semicolon on there or it won't work! It should tell you XX rows were affected. Once it does, simply type exit and press Enter.
Via phpMyAdmin:
Go to phpMyAdmin. Click on the database name you use for vBulletin on the left. Then, on the right, scroll down and you should see a multi-line text field that says "Run SQL Query/queries on databasename". In that box, type the following:
ALTER TABLE search ADD INDEX (querystring), ADD INDEX (userid)
*No semi-colon this time! It will reload the main page; it will not prompt for confirmation. If it produces an error, double-check that you didn't copy any spaces or anything into there.
DO NOT RUN upgrade4.php AGAIN! That's crucial.
This should upgrade you from beta 4 to beta 4.1. If you did not upgrade to beta 4, do not follow these directions! Read John's thread about how to upgrade directly to beta 4.1 from beta 3 or earlier.
Edit: It will still say beta 4 at the bottom. They did not increment the version number as far as that goes (someone said they decided that the first beta 4 should have been called 3.9, and this (beta 4.1) should actually be called beta 4).
MovieJeff
Fri 6th Apr '01, 11:21am
Tubedogg:
Thanks for the excellent and detailed post on the upgrade. Following YOUR instructions it was easy for me to do it. I was a bit concerned because I used PhpMyAdmin to do it. In the line of code you had, there was no semicolin at the end. So, I figured since you put it in the first one, you wouldn't forget it there if it was to be put in.
I pasted that line exactly, it didn't prompt for confirmation though and it re-loaded the phpmyadmin screen with no errors or any messages. So, I assume that ment it went ok. :)
After this, I logged into my control panel and forum and everything appears to work just fine. As you said, it doesn't say 4.1 at the bottom but since I did all those steps it must have worked.
You should write their instructions, it sure does help those not quite as technical. :rolleyes:
Thanks,
Jeff
vBulletin® v3.8.0 Beta 4, Copyright ©2000-2008, Jelsoft Enterprises Ltd.