Ip Board Update

**OmicronLab** · 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?

**TCH-Sales** · 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.

**charlotteriders.com** · 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:

**TCH-Don** · 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

**charlotteriders.com** · October 7, 2003

Thanks. :dance: 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.

**TCH-Don** · October 7, 2003

Which config files do you mean?

**charlotteriders.com** · 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."

**charlotteriders.com** · 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"

**TCH-Don** · 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?

**charlotteriders.com** · 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?

**charlotteriders.com** · 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.

**TCH-Don** · October 7, 2003

did you ftp

Skin/s1/*.php (All PHP files. Create the directory if it's not there and upload into it)

**charlotteriders.com** · 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?

**TCH-Don** · October 7, 2003

Did you have a custom skin?

the instruction say to change to the default skin before upgrading.

**charlotteriders.com** · October 7, 2003

Well, that's where I f'ed up then. Mad!!!

**TCH-Don** · October 7, 2003

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

**charlotteriders.com** · October 7, 2003

Yup ... got the backup ready to go.

**TCH-Don** · October 7, 2003

in phpadmin

select the database on the left,

SQL,

browse to your file.

Yep it works.

**charlotteriders.com** · 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".

**TCH-Don** · October 7, 2003

Did you reinstall from the cpanel and see a working forum?

**charlotteriders.com** · October 7, 2003

Yes and yes and it's a working (albeit empty) forum:

forums.charlotteriders.com

**TCH-Don** · October 7, 2003

Its offline.

How did you make the backup, cpanel>backup>database

**charlotteriders.com** · October 7, 2003

IPB Admin CP -> SQL Management -> mySQL Backup -> Yes, Yes, Yes -> Start Backup -> Save to local HD

**TCH-Don** · 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.

**charlotteriders.com** · October 7, 2003

I'm over there with you hunting around ...

**charlotteriders.com** · October 7, 2003

Yikes ... I"m starting to get nervous ....

**TCH-Don** · October 7, 2003

Is your backup .gz or .sql ?

**charlotteriders.com** · 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

**TCH-Don** · 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.

**charlotteriders.com** · October 7, 2003

Ticket # TNX-12830 ... thanks for all of your help I really appreciate it. Thumbs Up

**TCH-Don** · 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.

**charlotteriders.com** · 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

**TCH-Don** · October 7, 2003

Congrats

I could not restore a backup while the board is off line.

**charlotteriders.com** · 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.

**TCH-Don** · 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.

**Dennis** · 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

**OmicronLab** · 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

Sign In

Ip Board Update

Recommended Posts

Join the conversation