OmicronLab Posted October 3, 2003 Share Posted October 3, 2003 I expected that a new version of Invision power Board would come with the new cpan, alas! Can anybody help me how to update the current v1.1.2 to an updated version? Quote Link to comment Share on other sites More sharing options...
TCH-Sales Posted October 3, 2003 Share Posted October 3, 2003 If you download their upgrade from their official site, it pretty much explains what you must to do upgrade from any of their previous versions. Not much we can do about not being the latest version, since cPanel controls that end of things. Quote Link to comment Share on other sites More sharing options...
charlotteriders.com Posted October 7, 2003 Share Posted October 7, 2003 CK, I'd like to upgrade my board to 1.2. I've got my grubby little hands on 1.2 Final, and the upgrade instructions for 1.1.2 -> 1.2. However, upgrading requires that I execute a script on the server. How do I do that without a shell account? Thanks for your help. :Nerd: Quote Link to comment Share on other sites More sharing options...
TCH-Don Posted October 7, 2003 Share Posted October 7, 2003 If you are referring to Running the upgrade script Open up a new browser window and enter the URL to the upgrade5.php script (example: www.board.com/forums/upgrade5.php) Follow the on screen instructions to update your database. If you get an error during the upgrade, try hitting back in your browser and try again. This script will upgrade your database, install new templates and perform a clean up. just type the address www.yoursite.com/forum/upgrade5.php in your browser url window, if it is in a folder called forum, and after you have followed the upgrade instructions, remember IMPORTANT: PLEASE REMOVE THE SCRIPT WHEN THE UPGRADE IS COMPLETED! so in file manager goto the forum folder and delete upgrade5.php Quote Link to comment Share on other sites More sharing options...
charlotteriders.com Posted October 7, 2003 Share Posted October 7, 2003 Thanks. I followed the upgrade instructions on the IPB website (being careful not to upload the configuration files) and now have this: http://forums.charlotteriders.com/ Ack. Quote Link to comment Share on other sites More sharing options...
TCH-Don Posted October 7, 2003 Share Posted October 7, 2003 Which config files do you mean? Quote Link to comment Share on other sites More sharing options...
charlotteriders.com Posted October 7, 2003 Share Posted October 7, 2003 onf_global.php and sm_install.php "Upload all files as normal from the "upload" directory from your 1.2 download package up to your FTP, overwriting the old 1.1.x board files, except conf_global.php and sm_install.php." Quote Link to comment Share on other sites More sharing options...
charlotteriders.com Posted October 7, 2003 Share Posted October 7, 2003 Here's exactly what I did: "From: 1.1.x To: 1.2 Upload all files as normal from the "upload" directory from your 1.2 download package up to your FTP, overwriting the old 1.1.x board files, except conf_global.php and sm_install.php. In 1.2, the upgrade script is located elsewhere in the package distribution, so look in your download package for a directory labled "otherscripts". In here will be the file upgrade5.php. Take this file, and upload it to where your forums are installed (Where admin.php, conf_global.php, index.php, etc is.) Once you have done this, run upgrade5.php in your web browser by visiting the URL to it directly by typing it into your web browser. Example: http://www.******/forums/upgrade5.php Once you have visited the upgrade script in your browser, you will automatically load the upgrade script's contents. Follow the on-screen instructions all the way through to the end. When you have reached the end, and are done with the upgrade script, go back into your FTP and delete upgrade5.php off of the server. After you have done this, the upgrade is done and you should now be upgraded to 1.2. Upgrade script(s) used: upgrade5.php" Quote Link to comment Share on other sites More sharing options...
TCH-Don Posted October 7, 2003 Share Posted October 7, 2003 Your instructions look a little different then mine (1.2rc) Did you get any errors when upgrading, and did you try to run it again? Quote Link to comment Share on other sites More sharing options...
charlotteriders.com Posted October 7, 2003 Share Posted October 7, 2003 I'm thinking this may be a skin problem. Can I nuke the current install, reinstall 1.1.2, restore my database, then do an upgrade, without losing all my data? Quote Link to comment Share on other sites More sharing options...
charlotteriders.com Posted October 7, 2003 Share Posted October 7, 2003 Your instructions look a little different then mine (1.2rc)Did you get any errors when upgrading, and did you try to run it again? No errors, yes I tried it again but it says the new tables are already created. Quote Link to comment Share on other sites More sharing options...
TCH-Don Posted October 7, 2003 Share Posted October 7, 2003 did you ftp Skin/s1/*.php (All PHP files. Create the directory if it's not there and upload into it) Quote Link to comment Share on other sites More sharing options...
charlotteriders.com Posted October 7, 2003 Share Posted October 7, 2003 Yes, the complete package was FTP'd up. I've already nuked the old install. How do I restore the saved backup database? Quote Link to comment Share on other sites More sharing options...
TCH-Don Posted October 7, 2003 Share Posted October 7, 2003 Did you have a custom skin? the instruction say to change to the default skin before upgrading. Quote Link to comment Share on other sites More sharing options...
charlotteriders.com Posted October 7, 2003 Share Posted October 7, 2003 Well, that's where I f'ed up then. Mad!!! Quote Link to comment Share on other sites More sharing options...
TCH-Don Posted October 7, 2003 Share Posted October 7, 2003 (edited) Well you have a back up, thats good. You can always reinstall from cpanel then in cpanel mysql admin restore your database (wait a minute while look) in phpadmin select the database on the left, SQL, browse to your file. Yep it works. Edited October 7, 2003 by turtle Quote Link to comment Share on other sites More sharing options...
charlotteriders.com Posted October 7, 2003 Share Posted October 7, 2003 Yup ... got the backup ready to go. Quote Link to comment Share on other sites More sharing options...
TCH-Don Posted October 7, 2003 Share Posted October 7, 2003 in phpadmin select the database on the left, SQL, browse to your file. Yep it works. Quote Link to comment Share on other sites More sharing options...
charlotteriders.com Posted October 7, 2003 Share Posted October 7, 2003 Agh " Database charlot2_ivbd3 running on localhost Error There is a chance that you may have found a bug in the SQL parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:" I went into phpmyadmin, clicked on the database on the left, then clicked on the SQL tab above, then clicked browse, pointed it to my file, and clicked "Go". Quote Link to comment Share on other sites More sharing options...
TCH-Don Posted October 7, 2003 Share Posted October 7, 2003 Did you reinstall from the cpanel and see a working forum? Quote Link to comment Share on other sites More sharing options...
charlotteriders.com Posted October 7, 2003 Share Posted October 7, 2003 Yes and yes and it's a working (albeit empty) forum: forums.charlotteriders.com Quote Link to comment Share on other sites More sharing options...
TCH-Don Posted October 7, 2003 Share Posted October 7, 2003 Its offline. How did you make the backup, cpanel>backup>database Quote Link to comment Share on other sites More sharing options...
charlotteriders.com Posted October 7, 2003 Share Posted October 7, 2003 IPB Admin CP -> SQL Management -> mySQL Backup -> Yes, Yes, Yes -> Start Backup -> Save to local HD Quote Link to comment Share on other sites More sharing options...
TCH-Don Posted October 7, 2003 Share Posted October 7, 2003 Let me look at IPB site to see if they show how to restore that type of back up I know I have seen it, back in a bit. Quote Link to comment Share on other sites More sharing options...
charlotteriders.com Posted October 7, 2003 Share Posted October 7, 2003 I'm over there with you hunting around ... Quote Link to comment Share on other sites More sharing options...
charlotteriders.com Posted October 7, 2003 Share Posted October 7, 2003 Yikes ... I"m starting to get nervous .... Quote Link to comment Share on other sites More sharing options...
TCH-Don Posted October 7, 2003 Share Posted October 7, 2003 Is your backup .gz or .sql ? Quote Link to comment Share on other sites More sharing options...
charlotteriders.com Posted October 7, 2003 Share Posted October 7, 2003 I've got it in the .gz I backed up and unzipped via WinZip to a .sql. I tried restoring both via the phpmyadmin steps you posted but both gave errors. Restoring the .sql gives this: Error SQL-query : CREATE TABLE ibf_admin_logs( id bigint( 20 ) NOT NULL AUTO_INCREMENT , act varchar( 255 ) default NULL , code varchar( 255 ) default NULL , member_id int( 10 ) default NULL , ctime int( 10 ) default NULL , note text, ip_address varchar( 255 ) default NULL , PRIMARY KEY ( id ) ) TYPE = MYISAM MySQL said: Table 'ibf_admin_logs' already exists Back Quote Link to comment Share on other sites More sharing options...
TCH-Don Posted October 7, 2003 Share Posted October 7, 2003 I think you will need to sbmit a support ticket https://ssl.totalchoicehosting.com/supportdesk/ I am sure I saw this on the IPB forum, but am not finding it. Sorry, will keep looking. Quote Link to comment Share on other sites More sharing options...
charlotteriders.com Posted October 7, 2003 Share Posted October 7, 2003 Ticket # TNX-12830 ... thanks for all of your help I really appreciate it. Thumbs Up Quote Link to comment Share on other sites More sharing options...
TCH-Don Posted October 7, 2003 Share Posted October 7, 2003 You are welcome, sorry I could not help. It does work for a backup from cpanel>backup select database I do this every week. good luck. Quote Link to comment Share on other sites More sharing options...
charlotteriders.com Posted October 7, 2003 Share Posted October 7, 2003 Whoa ... I deleted the default database, created a new one with the same name, then uploaded the .sql file and it worked. Naughty Now I'm gonna try the 1.2F upgrade ... wish my luck Quote Link to comment Share on other sites More sharing options...
TCH-Don Posted October 7, 2003 Share Posted October 7, 2003 Congrats I could not restore a backup while the board is off line. Quote Link to comment Share on other sites More sharing options...
charlotteriders.com Posted October 7, 2003 Share Posted October 7, 2003 Ahh maybe that's it. If I ever have to do this again, and good God I hope I don't, I'll put the board online before attempting a restore. Quote Link to comment Share on other sites More sharing options...
TCH-Don Posted October 7, 2003 Share Posted October 7, 2003 Dont forget to make a backup from cpanel>backup select database> save to your computer. the you can restore frome the same cpanel>backup Restore>Restore an SQL DB browse to your backup. Quote Link to comment Share on other sites More sharing options...
Dennis Posted October 7, 2003 Share Posted October 7, 2003 Good to see that you have managed to get the restore going. Actually you did not have to delete and create the database, you can just drop the tables and when you run the .sql file you have saved previously, there wouldn't be any more problem for MySql to recreate the back-up database. I have installed Invision a few times from 1.1x till the current 1.2 and I find that its easier to just do a backup, then do a clean install (similiar to the way that you had did but by just dropping the tables in my existing database). Dennis Quote Link to comment Share on other sites More sharing options...
OmicronLab Posted October 8, 2003 Author Share Posted October 8, 2003 I am facing this problem Mad!!! Mad!!! Mad!!! Mad!!! Fatal error: Call to undefined function: boardinformation() in /home/****/public_html/forum/sources/Boards.php on line 359 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.