Issue Since Upgrading MySQL From 4.x.x To 5.0.24
I am not sure where to begin with this, but basically my host server upgrade our MySQL version from 4.x.x to 5.x.x and since some of my scripts have changed the way in which data is drawn from the database.
It seems to be a division issue when dealing with averages it extracts the data from the database different than it has on all previous versions of MySQL and I hope someone here can help me in the direction in which to solve this.
Here are a few examples of the issue I am having....
View Complete Forum Thread with Replies
See Related Forum Messages: Follow the Links Below to View Complete Thread
Issue When Upgrading MySQL From Version 4.1 To 5.0
I got the following message when I upgrade MySQL from 4.1 to 5.0, and unable to continue,? [root@wl-jzarley ~]# rpm -i MySQL-server-community-5.0.45-0.rhel4.i386.rpm warning: MySQL-server-community-5.0.45-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 error: Failed dependencies: MySQL conflicts with mysql-4.1.12-2.RHEL4.1.i386
Upgrading Mysql To 4.1.7
I currently run mysql 3.23.58 on a Linux daffy.perf.redhat.com 2.4.18-11 I wanted to update to mysql 4.1.7 and was wondering how easy it? Is it worth it? What are the benifits. What will it do to my current queries that I have written. Most are simple SELECT statements with some INSERT Statements. Lastly if I should upgrade, what is the best way to do it.
Upgrading To MySQL 4.0
Currently, I'm running 3.23.51 on Red Hat 7.1, and I'm contemplating upgrading to MySQL 4.0, but I'm not sure what to expect. I don't know if MySQL 4.0 is fully backwards-compatible with 3.23.x versions, or if something is going to break if I upgrade. What are the main advantages of upgrading to 4.0? Speed? Features? I can go through the whole changelog if need be, but I'd prefer to hear what actual users are reporting as far as benefits and disadvantages.
Upgrading MySql
I have MySql installed on Win2k Pro. Recently I downloaded the latest version of MySql, wanted to upgrade the previous alpha version. So any one here can help me guide to upgrade MySql, step by step, so that I do not loose any of my current MySql settings and databases.
Upgrading Mysql To 4.0.24
I have just followed MYSQL reference manual 2.3.15 to upgrade mysql from 4.0.20 to 4.0.24. Everything appeared to upgrade correctly, but the version is still showing 4.0.20. I have searched everywhere for documentation that would point out my error, but have been unable to find the solution.
Upgrading MySQL
I recently upgraded my Mac (running OS 10.4.8) to Apache 2.0.52, MySQL 5.0.24 and PHP 4.3.9. While I seem to be accessing the latest MySQL from the Terminal, Apache seems to continue to use the previous install of MySQL. Is there some config file I need to edit so the new install of MySQL is used by my Web server? While I'm at it, my PHP seems to no longer be able to send email, though I added "sendmail_path = /usr/sbin/postfix" to the php.ini file.
Mysql Upgrading From 3.23 To 4.1
I have linux RH AS 3 server with these installations: #rpm -qa | grep mysql libdbi-dbd-mysql-0.6.5-5 mysql-3.23.58-1 mysql-devel-3.23.58-1 How can I upgrade to mysql 4.1 ? Should I try uninstalling the above first with all their dependencies or should I do a FORCE upgrade over it ?
Upgrading From MySQL V3 To V4
I have MySQL datbase running on a Mac Powerbook with MySQL v4.1.14 installed (upgraded from v3). I cannot get the syntax correct when trying to SELECT a record that meet a predefined criteria. $query = "select * from members where member_ID = $ID and cat = type_ID"; I get the following error message: 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 'and cat = type_ID' at line 1 This SQL query works in phpMyAdmin (when I specify the 'member_ID' and 'cat' numners: select * from members where member_ID =1 and cat = 5 It seems that the $ID and type_ID variables have no values when trying to execute the $query.
Upgrading MySQL From 4.0 To 5.0
I am running almost every 4.0 query/syntax possible, and I can not afford one query to be faulty because it's changed in 5.0.
Upgrading To MySQL 5.x
I wish to upgrade my version of MySQL (currently stuck to version 3.23) and I am wondering if to upgrade to the most stable 4.x or 5.x version. I am concerned about any possible retro-compatibility issue with SQL queries written for the 3.x version. In particular I am inquiring about: 1. Is there any incompatibility issue between the very latest stable 5.x version and SQL queries written for 3.x MySQL versions? 2. Is there any compatibility issue with PHP 4.x or PHP 5.x ?
Upgrading Mysql From 4.0 To 4.1
i'm trying to upgrade mysql from 4.0 to 4.1. mysql_fix_privilege_tables reporting 'Access denied' and man says to use root pass as argument. so how to use it? '$ mysql_fix_privilege_tables -ppass' doesn't work
Upgrading MySQL
I'm having a hard time figuring out how to upgrade to MySQL 4.1 on my FreeBSD server. I've been trying to use the ports, like I do whenever I upgrade all my other software. The install runs without any problems, but the MySQL binary (in usr/local/bin) is never replaced with the new version. Does anyone have any advice on how to go about upgrading to 4.1 on a FreeBSD server. Am I missing something? Can you point me towards any good articles on how to go about doing this?
Upgrading To MySQL 4 Or 5
A person I am working wth is running My SQL 3.23.58. He needs to upgrade, so that we can use the UNION statement, among other things, but I was wonderting if it were better to upgrade to 4 or 5. By better, I mean working well with PHP 4.3.11, and Apache 2.0.51 on Linux. I am asking because I know there are some issues with Windows, Apache 2, and PHP 5, and I want tomake this upgrade as smooth as possible. It seems that most web hosts are using MySQL 4 currently, so I'm guessing that is the one I should go with? It appears, according to MySQL.com, that the stable version of MySQL 4 is 4.1.20. Please let me know if there are any issues that exist with this version of MySQL and the versions of PHP and Apache I mentioned above. Also, can you upgrade smoothly without losing your database or data? I'm going to back it up just in case, but I'm just curious to know if you can upgrade without losing data, or if the database will absolutely need to be saved and re-uploaded.
Upgrading To Mysql 4.1
I have just upgraded to mysql 4.1...which is great...what isn't great is that it's not working. I keep getting an error message when I try to start it that it cannot find 'localhost'. My last version was 3.23 and I had no problems at all getting it to work.I've gone through the help file and changed the my.ini file and moved it to c:windows and checked everything but stil no joy...anyone had this problem and sorted it? I'm running: winxp mysql 4.1 php 5.0 apache 2
Upgrading From MySQL 3.23 To 4.1 - Need To Upgrade To 4.0 First, But Can't...
I just realised that MySQL on my local server is MySQL 3.23....whoops. I'm looking to go to 4.1 for the time being. However the manual says that in order to get there I should upgrade to 4.0 first, and then on to 4.1. But the 4.0 download has been discontinued! So where do I go from here. A completely fresh install (not sure what effect inserting my 3.23 database SQL backup in the 4.1 database will have...nothing?) or do I just upgrade to 4.1 straight?
Upgrading MySQL On Windows/IIS- Help?
I am running MysQL Version 3.23.49 on a Windows IIS machine. I need to upgrade it to at least 4.0.16 (to install vBulletin 3.6). Is there a good tutorial on how to do this? I look at the documentation on the MySQL site but I'm hoping there is more out there to help me. As well, the docs say instead of upgrading to V5 I should upgrade to V4 instead. I'd like to have the most up to date MySQL if I can so I won't have to do the another upgrade for a while.
Fedora C3 And Upgrading Mysql 3.23 To 4.1
How do I upgrade the standard version of mysql on FC3, 3.23, to 4.1 ? I already looked up some info on the internet, but it isn't quite clear to me. I can backup my data, it isn't that much, just personal stuff. Do i just rpm the client and server, first 4.0 and then 4.1 or do I have to give special options with the rpm command ? Will this affect my webserver ? Do I have to adjust settings for apache or PHP ?
Error Upgrading MySQL
I began preparations for upgrading MySQL. I downloaded the binary RPMs for Red Hat Enterprise 4 (we're running CentOS, a clone) for MySQL 5.0.13 from the MySQL AB web site. Running a test, I got this: [root@seabass ~] rpm -hUv MySQL* --test warning: MySQL-client-standard-5.0.13-0.rhel4.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5 error: Failed dependencies: libmysqlclient.so.14 is needed by (installed) mod_auth_mysql-2.6.1-2.2.i386 libmysqlclient.so.14 is needed by (installed) php-mysql-4.3.9-3.6.i386 libmysqlclient.so.14 is needed by (installed) dovecot-0.99.11-2.EL4.1.i386 libmysqlclient.so.14 is needed by (installed) perl-DBD-MySQL-2.9004-3.1.i386 Has anyone else encountered this dependency problem? What would happen if I --force'd RPM to do the upgrade?
Upgrading MySQL With RPMs
I'd like to upgrade to v 4.1 as painlessly as possible (mainly I want to avoid problems with the php-mysql RPM which requires the dynamic libraries that include 3.23.x libraries). Is there an easy way to upgrade my RPM install without breaking a lot of things?
Upgrading MySQL On Linux Server
I need to upgrade MySQL on my server. I've tried to find some tutorial, but Google found nothing interesting. I wonder what is the easiest and most safe way to upgrade MySQL? I'd like to keep configuration (./configure params, configuration files etc) as is and to not hurt anything.
Steps For Upgrading MySQL 4.1 To MySQL 5.x?
I desperately searched the web for a list of steps to be followed to upgrade existing MySQL 4.1 installation to MySQL 5.x. This is the first time I am performing a MySQL upgradation and I don't know how to upgrade without losing any of the current user/system data. Can anyone pl. provide or direct me to a link that provides a step-by-step procedure to upgrade an existing MySQL 4.1 installation to MySQL 5.x?
Mysql Comma Issue
I want to show show float and int values with comma in mysql database. Like if i enter 1000 or 1000.00 it should take it as 1,000 or 1,000.00 is there any way to do this?
Mysql Order By Issue
I was with a problem with order by clause, sample: CREATE TABLE CLIENT (ID INT(3) NOT NULL AUTO_INCREMENT, NAME VARCHAR(15), PRIMARY KEY(ID) ); CREATE TABLE CLIENT_MAIL(IDMAIL INT(3) NOT NULL AUTO_INCREMENT, ID INT(3) NOT NULL, MAIL VARCHAR(15), PRIMARY KEY(IDMAIL) ); INSERT INTO CLIENT VALUES (NULL,'A'); INSERT INTO CLIENT VALUES (NULL,'B'); INSERT INTO CLIENT_MAIL VALUES (NULL,1,'A'); INSERT INTO CLIENT_MAIL VALUES (NULL,1,'B'); INSERT INTO CLIENT_MAIL VALUES (NULL,2,'D'); INSERT INTO CLIENT_MAIL VALUES (NULL,2,'F'); INSERT INTO CLIENT_MAIL VALUES (NULL,2,'C'); and one query: SELECT CLIENT.ID,CLIENT_MAIL.ID,CLIENT.NAME,CLIENT_MAIL.MAIL FROM CLIENT,CLIENT_MAIL WHERE CLIENT.ID=CLIENT_MAIL.ID ORDER BY CLIENT.NAME,CLIENT_MAIL.MAIL DESC; show is: +----+----+------+------+ | ID | ID | NAME | MAIL | +----+----+------+------+ | 1 | 1 | A | B | | 1 | 1 | A | A | | 2 | 2 | B | F | | 2 | 2 | B | D | | 2 | 2 | B | C | +----+----+------+------+ in resume i need show the result NAME MAIL B F B D B C A B A A
PHP/MySQL Interaction Issue?
PHP session_start();ob_start();$item = $_GET['item'];$user = $_POST['username'];$pass = $_POST['password'];mysql_connect('localhost', 'mysqluser', 'mysqlpass');mysql_select_db("mysqldb");$result = mysql_query("SELECT * FROM users WHERE user = $user AND password = $pass");$row = mysql_fetch_row($result);if ($row <= 0) { header("Location:item.php?item=failed");} else { $_SESSION['login'] = 1; $_SESSION['user'] = $user; header("Location:item.php?item=$item");}ob_flush(); I think it should work, but it's repeatedly telling me Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /my/directory/html/item.php on line 10. I can't figure out for the life of me why it won't work. It connects properly, I've been doing SQL queries all over the site. The variables POST correctly, and the SQL variables are all correct as well. Can anyone tell me what's going on with my query?
MYSQL Performance Issue
The following prg keeps cpu usage as 79% always .When i kill/stop the prg,then cpu comes down. main() { //code for mysql conn while(1) mysql_real_query (&mysqlcon, "SET CHARACTER SET 'utf8';", 25); } What might be the reason? Wil it be any config issues?
MySQL Select Issue
Okay, my table is setup like so: carId int(11) carName varchar(50) category varchar(50) Now, A field in it would be like this: 1 BWM IMPORTS Now in phpmyadmin and my scripts. SELECT * FROM cars WHERE category='IMPORTS'; It pulls up 0 result where there are about 200. it makes no sense. My phpmyadmin version is 2.6.4-pl2 .
Flash / Php / MySQL Issue
I am trying to create a web site which will have a mysql database that will store an empty xml file for a user. Question 1: How do i store an XML file into mySQL database? do i have to create a table etc... (probably the dumbest question on this forum i know!!) In addition: I have a flash program which i am hoping (via php) will load the users xml file (from the mySQL database). Question 2: Does anyone know how i can do this? (I can import an xml file - but independently not from an mySQL database. Then i can attach Comments to the xml. I neeed then to store the ammended xml back in the database (via php). Question 3: Again does anyone have any help on how to do this? I Then will need to enable the admin user of the web site to access the users xml files and get them displayed with XSLT associated with the xml. The xslt is a formatting style sheet that tells the browser how to output (display) the xml.
DateTime Issue With MySQL 3.23
I'm trying to use datetime with a MySQL 3.23 DB to record the date that each record is created, I've tried creating a table using `date` datetime NOT NULL default 'NOW()', `date` datetime NOT NULL default 'CURRENT_DATE', `date` datetime NOT NULL default 'CURRENT_TIMESTAMP', Anyone an idea how to do this with MySQL 3.23 each time I tried the default value reverted back to 00-00-00 00:00:00 and the current date/time is not recorded when records are created ????
Lock Issue In Mysql
i have a big application developed in visual basic 6 and mysql. what happens if more than one user is trying to update the same row in a table? like 2 users are trying to update the same record at the same time. How to handle such a situation?
MySQL Performance Issue
Im running mysql4.0.13 on FrreBSD 5.1-release. The problem is MySQL is using 95% of the cpu leaving 0% idle and pushing the load avg up to > 1. This is the output of mysqladmin processlist.. $ mysqladmin -uroot -p processlist; Enter password: +--------+------+-----------+----+---------+------+-------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +--------+------+-----------+----+---------+------+-------+------------------+ | 387980 | root | localhost | | Query | 0 | | show processlist | +--------+------+-----------+----+---------+------+-------+------------------+ $ uptime 8:51PM up 82 days, 5:18, 2 users, load averages: 1.03, 1.07, 1.23 I normally would expect a slow query or a table that requires optimisation, but without any hints from the processlist, where can i start looking?
Mysql Comma Issue
I want to show show float and int values with comma in mysql database. Like if i enter 1000 or 1000.00 it should take it as 1,000 or 1,000.00 is there any way to do this?
MySQL Routing Issue
I'm trying to route packets from 2 locations to a MySQL server sitting behind a firewall running iptables. The MySQL server has a ip address of 192.168.1.12. Basically I want packets destined to port 3306 to be forwarded or redirected to 192.168.1.12. # MySQL /sbin/iptables -A PREROUTING -t nat -i ppp0 -p tcp --dport 3306 -j DNAT --to-destination 192.168.1.12 iptables -A INPUT -p tcp --dport mysql -j ACCEPT iptables -A FORWARD -p tcp -s 192.168.1.12 --sport mysql -j ACCEPT iptables -A FORWARD -p tcp -s $PRIVIP_1 --dport mysql -j ACCEPT iptables -A FORWARD -m state --state ESTABLISHED,RELATED -j ACCEPT iptables -A FORWARD -p tcp -s $PRIVIP_2 --dport mysql -j ACCEPT
Mysql Upgrade Issue
Recently i have upgraded from 4.1 to 5.0.27 and now expiriencing issues with my database. I cant post topics/PMs/or login with Russian logins to the forum. The forum simply doesnt recognize text in Russian. Can anyone please advice whether if default 4.1 and 5.0.27 collation/chartsets are different and what collation/chartsets i should use in order for my forum to work correctly?
Mysql Administrator Issue
I have installed MYSQL 4.1.7, administrator & control center on Windows XP. Mysql server runs fine, I can connect to Mysql administrator or windows command line client. My problem is: 1] While trying to connect in MYSQL Control Center , I get error: === Error 2003: Can't connect to Mysql server on 'THESERVER' (10061) === [host name is fine, port no is also fine, then where I am doing wrong.... ???] 2] I can connect to Mysql Administrator , BUT.. 1) Startup Variables are disabled [I can't alter them...] 2) Clicking SERVICE CONTROL page stops the service and then I could not restart the service again. [seems goophy to me... why its like that ???] 3) While surfing in Mysql Administrator, after a while I get error message: === Mysql Error Number 1226 User 'root' has exceeded the 'max_questions' resource (Current value 100)=== [I set max question value to default (0) or any number, it dosent make difference, and I can't work on administrator unless I re-login] 3] I have created a .sql file containing all tables & relationships I want. How can I load that file in Mysql database. [How can I call/import that .sql file to create tables in Mysql database ??] I am stuck in above little mess, would you please help me out from above problem ?
Connection Issue To Mysql
I got a setup of mysql/apache/php running on my home server. The server is not the most powerfull 1Go of memory 2.66 Ghz cpu, and a 2Mbits bandwith. It is running under Fedora core 3. This should still be enough for the hosting of my home website and forum... the issue I have is that often during the evening the connection to mysql failed for some users and for me as well from time to time. It is happening mainly when there is many visitors on the forum (100 or more) The error message is the following : PHP Warning: mysql_connect(): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (11) in /var/www/html/lib/init_variables.php on line 30 Do you have any idea of the reason of this problem? to reproduce the issue it is easy i just have to try running the apache benchmark : ab -c 50 -n 5000 -A "admin:btd3txwn" http://192.168.0.1/testPage.phpl" this is really annoying for the visitors of my website and it seems that this is also happening on some other website : doing a google search with mysql.sock' (11) show many results ...
Mysql Query Issue
Have attempted to search the forum but not exactly sure what I need, a basic query is causing me some issues, I need to get columns x, y, z from database/table, where status is not closed. Status being a varchar field.This should be easy but there where command I was using was not working, please could someone advise me of the code?
MYSQL Spamming Issue
I have built a guestbook in PHP and MySQL and everything works fine, however, recently, someone has been posting spam with links to sites in the comments field and I have to manually remove them every couple of days using PHPMyAdmin. Currently, the comments field is "longtext". Not being an expert in MySQL, I was wondering if I can change the structure of the table without causing any problems with the data. If so, what should I use to allow a paragraph of text, but eliminate the ability to post links? and long strings of text?
Mysql Decimal Point Issue
I have build a database to display data about credit card information. I have one field that needs to be able to show interest rates and I want it to be able to show interest rate as 27.20 but it always removes the 0 at the end so it shows 24.2. I know very little about database design but I have the field set up as "type - double" with no set length or attributes.
Wierd Database Issue (mysql)
Something has happened to my Mysql database recently which has broken some of my search functions and the such. I've been reading up on it, but I don't really understand what happened or why it changed, (I'm thinking maybe an automatic update) but anyway, I'll explain. A new row has recently appeared in all of my tables. This row is called "Collation" and is currently set to "latin1_swedish_ci". This was never there before but it is now and all of the querys I run from inside phpMyadmin have this format now: SELECT * FROM `some_table` WHERE `row` LIKE CONVERT( _utf8 'word match' USING latin1 ) COLLATE latin1_swedish_ci LIMIT 0 , 30 Now since this happened I have looked into what collation is and how it has to do with character encoding or something like that, but I don't understand why it just appeared and what it should be set to for an english only database. All of my search functions are failing now and I assume it's because of this collation thing.
ODBC / MySQL Connection Issue
I'm trying to allow someone from a specific IP to connect to a mySQL db w/OBDC. I've run several GRANT queries on the mysql db i.e. GRANT select,update,insert,delete,create,drop,alter,inde x on ESdemo.* to 'aname'@'24.55.41.125' identified by 'pwd232123'; GRANT select,update,insert,delete,create,drop,alter,inde x on ESdemostore.* to 'aname'@'santamonica-cuda4-24-55-40-1.vnnyca.adelphia.net' identified by 'pwd232123'; but when I try to connect I get "Request returned with SQL_ERROR." Any ideas? Does it sound like a GRANT issue?
SECURITY ISSUE On MySQL Users ?
I have a .asp application in which certain parts, clients can now edit/update/add information to their records in our DB. I basically use an include statement at the top of each page. The include .asp page has my connection data within .asp tags. The general 'user' to which the connection belongs only has 'select' facilities within the db. If I now want to let a client update/delete/add information, then surely giving them access to Update/Delete & Add is very high risk ?. If they manage to gain access to our Username & password, then they could delete all our information ?.
Issue MySql Line Command
do i have to cd to the MySql Server 5.0 folder to execute MySql? How do i make MySql a 'Universal command',which could be issued at any directory level?
Bizarre MySQL Connectivity Issue
I'm connected to the internet using Rogers Cable, going directly through the Cable Modem. I'm getting error 1044 on 3 machines in my home (I cannot connect to the database server). However, if my buddy brings his ACER laptop over he connects using MySQL front to the database server. But my 3 Dells cannot connect using MySQL front at my place. But if I take my Dell Inspiron 6000 to his place, using Bell DSL, I can connect to the database using MySQL front.
Mysql_connect(): Client Does Not Support Authentication Protocol Requested By Server; Consider Upgrading MySQL Client
Basically I am setting up php,mysql and apache to run an application. While trying to connect I get the following error: Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in c:sudhirapachehtdocssvgmap est4.php on line 14 Cannot connect to the database. Client does not support authentication protocol requested by server; consider upgrading MySQL client I have tried the following message posted earlier by many of you guys i.e "SET PASSWORD FOR peter@localhost = OLD_PASSWORD('something') flush privileges I am trying this from a long time and do not find a way to fix this problem I request you guys to help me in soughting this out and I appreciate your patience in reading my post.
Mysql_connect(): Client Does Not Support Authentication Protocol Requested By Server; Consider Upgrading MySQL Client
I am having an awkward problem with my MySQL installation. I have a number of scripts that access the database from a few different web hosting sites. I have no problem accessing the database from the scripts that I host locally. The scripts that are on an outside server accessing the database gives me a mysql_connect() error. Locally I use MySQL 5.0 and PHP 5.0. I am assuming that the 3rd party web host uses an older version of PHP and thinking that may be the problem. Is this the possible problem and if so is there a way to fix it without ruining the scripts that are currently working?
MySQL ODBC Connector Username Issue
I am having trouble connecting to a MySQL db using the ODBC Connector. I've tried 2.5, 3.51, and even an alpha of v5 and all get the same error. The error says [MySQL][ODBC 3.51 Driver]Domain (xxx@xxxxxxxxxx.x) not found Disconnecting. It appears that the username only accepts 16 characters. I am trying to connect to a hosted db and I can't control the username. I've seen this happen on some machines but not others. What is going on and how can I get connected?
Upgrading MySQL 3.23 To MySQL 4.1
I use RHEL 2.1. It's old and so are the packages that goes with it. It does have MySQL 3.23 and I would like to upgrade it to a later version, 4.1 would be nice. But then MySQL website says one should use his/her distro's RPM. This is now a stalemate for me because there seems to be no MySQL 4.1 RPM for that distro. I did try using RHEL 3 RPM and I was stopped by GlibC 2.3 dependency. I only have Glibc 2.2. My belief is RHEL 2.1 could work MySQL 4.1. Just it's a puzzle for me how to do it.
Upgrading To 5 From 3.23
I am considering upgrading to MySQL 5 from version 3.23. My applications have no clients yet but expect them in a few weeks so now is a good time to upgrade. I use some left joins, outer joins, inner joins but, of course, no sub-selects. I also use as column types; tinytext, text, date, char and varchar. If I just do a data dump from 3.23 and load it to version 5, should it work? What do I need to investigate, if anything, before upgrading?
|