OVH Community, your new community space.

HELP. mySQL, PHP/myadmin and phpBB update.


blacklogic.112
09-06-2014, 15:27
Step 1 - Download
*Link: phpmyadmin

Step 2 - Untar or unzip the distribution
*be sure to unzip the subdirectories
*after that rename folder to phpmyadmin

Step 3 - Configuration
*open config.inc.php and set the values to access your database
$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname
$cfg['Servers'][$i]['user'] = ''; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // MySQL password
$cfg['Servers'][$i]['only_db'] = ''; // Database name


Step 4 - Upload and..
*upload /phpmyadmin to your server
*point your browser to phpmyadmin (e.g. http://www.domain.com/phpmyadmin/)
*if you see a red error message (The $cfg['PmaAbsoluteUri'] directive MUST be set in your configuration file!) you have to set the directive in config.inc.php
*open config.inc.php and find/change (change the path to phpmyadmin)

chopper
03-01-2014, 19:36
Thank you all for your help. I have now successfully updated my site and even installed a mobile style. Just need to make sense of the mobile auto detect instructions now.

chopper
01-01-2014, 19:02
Thanks. I have downloaded FTP and will have a play when i'm not so hung over haha.

Jasgriff
01-01-2014, 09:34
To Upload your phpBB folder you will need to FTP it there from your own PC.

chopper
01-01-2014, 01:49
Ok. i have had a read from that link and this was the instructions.

I am on 3.0.x and I want to update to the latest stable version.
The first question you need to ask is, do I have any modifications (MODs) installed?

No, I do not have MODs.
Your update is very easy.

From the download page go to the stable release section and get the changed files version.
Decompress that file.
Inside it you will see a folder called install and zip files for several of the previous versions to the current version. eg (at the time of writing) phpBB-3.0.9_to_3.0.10.zip
Decompress the zip file relating to the version you want to update from.
Upload those files to your phpBB folder, overwriting the files on the server.
Upload the install folder from the original download you got.
Go to yoursite.com/forumfolder/install/database_update.php
Let that run and then delete the install folder.
You are now up to date.
I understand up until this.

Upload those files to your phpBB folder, overwriting the files on the server.
Upload the install folder from the original download you got.
Go to yoursite.com/forumfolder/install/database_update.php
Let that run and then delete the install folder.
You are now up to date.
How do i upload to me phpBB folder, what program do i use, is it the phpMyAdmin in the OVH manager or FTP on my own pc ?

chopper
31-12-2013, 20:54
Quote Originally Posted by Myatu
I'm not sure if this is currently the case, but in the past you could upgrade the software through the OVH Manager. However, it had always been a bit behind with the latest version, so it might be the case they don't have the upgrade available to you yet.

An alternative would be to follow the instructions as outlined in the following phpBB Knowledge Base:

https://www.phpbb.com/kb/article/how...ion-of-phpbb3/

I would recommend that you backup your files before doing so, which can be as simple as accessing your files through FTP and downloading them to your own computer. This will ensure you have a method for restoring these files should things go awry. Note that this does not include your database (which you may have to export using phpMyAdmin).

With regards to phpMyAdmin itself, you need to make sure that you select the correct database server, which should be noted in the e-mail you've received from OVH and should also be available on your control panel. If you do not do this, you might be trying to login to the wrong server, which doesn't have your details (and thus gives that error).
Thank you for the reply. I will read the info on the link you supplied and see if i can learn from it. I contacted OVH tech support who said i would be better updating through their module manager, but they have not updated the phpBB to the later 3.12 yet. While that is probably the most simple way it did not answer the second part to my question about adding extra features, like a better mobile skin.
I have so much to learn and it is fun, i just need to find the *****s guide to get me going.

Happy New year.

Myatu
31-12-2013, 14:16
I'm not sure if this is currently the case, but in the past you could upgrade the software through the OVH Manager. However, it had always been a bit behind with the latest version, so it might be the case they don't have the upgrade available to you yet.

An alternative would be to follow the instructions as outlined in the following phpBB Knowledge Base:

https://www.phpbb.com/kb/article/how...ion-of-phpbb3/

I would recommend that you backup your files before doing so, which can be as simple as accessing your files through FTP and downloading them to your own computer. This will ensure you have a method for restoring these files should things go awry. Note that this does not include your database (which you may have to export using phpMyAdmin).

With regards to phpMyAdmin itself, you need to make sure that you select the correct database server, which should be noted in the e-mail you've received from OVH and should also be available on your control panel. If you do not do this, you might be trying to login to the wrong server, which doesn't have your details (and thus gives that error).

chopper
30-12-2013, 13:19
Firstly I have to admit to call me a complete novice in administering a forum and hosting it ect is to exaggerate my knowledge but I am very keen to learn.
What I set out to do was set up a forum that my friends and me could actively debate a shared passion. A friend directed me to OHV and said the phpBB board software would be pre installed. Up to this point I found the process relatively trouble free and now have the forum up and running.

Now the issue I now have is, firstly in updating the software. The version that was pre-installed is 3.09 and my admin CP is telling me to update to 3.12. I have no idea how to do this and can not find instructions in layman terms. I thought if I opened php/myadmin in the ohv manager I would be able to work it out as a friend said he believed this was the program that would install or modify the phpbb program on the server.

I put my user name and password into php/myadmin and got a #1045 cannot log into the my SQL server message. I followed a link that said I needed to create a My SQL base. I followed the instructions in how to do this in the OHV manager. I entered my database name and password but got a message saying, Action not available for ****.com.

I saw some downloads on the phpBB website that I would like to add to my forum to enhance it . I now find myself at a complete loss and feel way out of my depth in understanding how to update or customise my forum. I have scanned the net trying to find an *****s guide but found no information that helped me.

Is there anyone here that could spare some time in posting an easy to follow step by step guide in what I should do and in which order?

Thank you in anticipation..