[Tutorial] How to use phpMyAdmin

A place for MOD Authors to post and receive feedback on MODs still in development. No MODs within this forum should be used within a live environment!
Scam Warning
Big Clucker
Registered User
Posts: 22
Joined: Wed Feb 13, 2008 2:05 pm

Re: [Tutorial] How to use phpMyAdmin

Post by Big Clucker » Mon Feb 25, 2008 7:16 pm

phpbb3.

At the moment I just hit the "back" key and logged - so no damage so far :)

jazzking2001
Registered User
Posts: 424
Joined: Tue Jul 10, 2007 9:10 pm
Contact:

Re: [Tutorial] How to use phpMyAdmin

Post by jazzking2001 » Tue Mar 11, 2008 12:00 am

you are the greatest
it made it so simple
Neocrisis.com- What will you find next

User avatar
battye
Extension Customisations
Extension Customisations
Posts: 10933
Joined: Wed Feb 11, 2004 11:02 am
Location: Australia
Contact:

Re: [Tutorial] How to use phpMyAdmin

Post by battye » Tue Mar 11, 2008 11:16 am

Thanks for the kind words :D
Customisations Team Member

Dark R0gue
Registered User
Posts: 67
Joined: Tue Feb 26, 2008 9:57 am

Re: [Tutorial] How to use phpMyAdmin

Post by Dark R0gue » Tue Mar 11, 2008 1:16 pm

can u help i only get:

Code: Select all

Error
SQL query: 

INSERT INTO phpbb_config( config_name, config_value ) 
VALUES (

'wpm_enable', '1'
);



MySQL said:  

#1146 - Table 'rzerguef_Forums.phpbb_config' doesn't exist 
i am installing pm on firts login. should i edit the files and upload first.
http://www.r0gue-films.org/Forums for exclucive insider info on Hao 3 modding.
http://youtube.com/watch?v=_sy1SZlT6rc for proof of modding.

User avatar
A_Jelly_Doughnut
Former Team Member
Posts: 34457
Joined: Sat Jan 18, 2003 1:26 am
Location: Where the Rivers Run
Contact:

Re: [Tutorial] How to use phpMyAdmin

Post by A_Jelly_Doughnut » Wed Mar 12, 2008 12:17 am

DarkR0gue: That probably means your phpBB installation uses a different table prefix than the default phpbb_.
A Donut's Blog
"Bach's Prelude (Cello Suite No. 1) is driving Indiana country roads in Autumn" - Ann Kish

Dark R0gue
Registered User
Posts: 67
Joined: Tue Feb 26, 2008 9:57 am

Re: [Tutorial] How to use phpMyAdmin

Post by Dark R0gue » Wed Mar 12, 2008 9:40 am

do you know how i could find out what it is?

:twisted:
http://www.r0gue-films.org/Forums for exclucive insider info on Hao 3 modding.
http://youtube.com/watch?v=_sy1SZlT6rc for proof of modding.

User avatar
Peetra
Registered User
Posts: 291
Joined: Mon Jun 04, 2007 1:41 pm
Location: Kokkola, Finland
Contact:

Re: [Tutorial] How to use phpMyAdmin

Post by Peetra » Wed Mar 26, 2008 12:39 pm

DarkR0gue: perhaps by looking in config.php? Take it home by ftp for an example.
I am so hooked on bubbles, that I made a Bubble Witch Saga WP-site! Most addictive game since Tetris!

jazzking2001
Registered User
Posts: 424
Joined: Tue Jul 10, 2007 9:10 pm
Contact:

Re: [Tutorial] How to use phpMyAdmin

Post by jazzking2001 » Wed Mar 26, 2008 2:03 pm

Peetra wrote:DarkR0gue: perhaps by looking in config.php? Take it home by ftp for an example.
that sounds like the solution to your issue
Neocrisis.com- What will you find next

zoldix
Registered User
Posts: 6
Joined: Tue Apr 08, 2008 9:52 pm

Re: [Tutorial] How to use phpMyAdmin

Post by zoldix » Thu Apr 10, 2008 10:07 pm

battye wrote:How to use phpMyAdmin

Many MOD's require users to run a file to apply SQL changes, however, there are some that require you to make manual database changes.

In 2.0.x MOD's, you know you are required to apply SQL changes manually when there is no update file supplied, and you find the following action in the MOD install file:

Code: Select all

#
#-----[ SQL ]------------------------------------------
#
In a MODx file, you will find a similar action.

In the SQL section, you may find many different queries. This tutorial explains how to manually apply these using phpMyAdmin.

For the sake of this tutorial, suppose the SQL query you were required to run was as follows (note: there may be more than one, they will all be listed).

Code: Select all

INSERT INTO phpbb_config (config_name, config_value) values('allow_userbar_upload', '1');
Opening phpMyAdmin

More often than not, a link to phpMyAdmin will be provided, under the databases section, in your webhosts cPanel, Ensim or another sort of control panel. If you are unable to find a link to phpMyAdmin from your control panel, you may need to talk to your webhost and ask if it is preinstalled. If it is not, you will need to install it yourself. Download phpMyAdmin, and find documentation on installation, from http://www.phpmyadmin.net/

What to do once in phpMyAdmin

After opening the program, on the left panel, navigate to your database by clicking the dropdown menu, and clicking the database which your forum resides in.

The right panel will then display a list of tables. Ignoring these, proceed to clicking the "SQL" tab on the top navigation bar.

Image

Paste the query/queries that you need into the large box titled "Run SQL query/queries on database". Ensure the table prefix is correct. In the majority of cases, it will simply be phpbb_, but in this case, it was myforum_. Check the box "Show this query here again" and once satisfied, proceed to click "Go".

Image

You know the queries were executed successfully if no errors appear. You should get a screen similar to this:

Image

If you get any errors, read the error message carefully and rectify the problem. If you are unsure of an error message, and you are not able to find an answer after searching the forum and searching Google, feel free to post it within this topic for further assistance.

Thanks,

The phpBB MOD Team
Thanks much! Big help!! :)

jazzking2001
Registered User
Posts: 424
Joined: Tue Jul 10, 2007 9:10 pm
Contact:

Re: [Tutorial] How to use phpMyAdmin

Post by jazzking2001 » Thu Apr 10, 2008 10:30 pm

this is the easiest Tutorial i have ever used
Neocrisis.com- What will you find next

PowMacP
Registered User
Posts: 28
Joined: Sat Jan 25, 2003 2:42 pm
Contact:

Re: [Tutorial] How to use phpMyAdmin

Post by PowMacP » Thu Apr 17, 2008 8:45 pm

Is there an actual phpmyadmin for dummies book out there? I deleted php_config by mistake :o :oops: & I need to restore it if it is do-able :?: :?: :?: .

Help please

Thanks,

Marc

User avatar
Tripp
Former Team Member
Posts: 1358
Joined: Sun May 20, 2007 5:14 am
Location: G'boro, North Carolina
Name: Tripp
Contact:

Re: [Tutorial] How to use phpMyAdmin

Post by Tripp » Thu Apr 17, 2008 10:43 pm

Only way to restore it is if you have a backup.

I guess you could manually re-enter the table and add any mods back to that table.
The box said 'You need Windows XP or better' .... so I installed linux.

Formerly Drugs

PowMacP
Registered User
Posts: 28
Joined: Sat Jan 25, 2003 2:42 pm
Contact:

Re: [Tutorial] How to use phpMyAdmin

Post by PowMacP » Fri Apr 18, 2008 11:51 am

Thank you for responding.

I did a back up of the database from the forum administration option. Is that good to restore anything lost with that config file?

BTW I am running PHPBB 2.0.23

Also, we have to move our database & all the files to another server within the same host due to a dying server. If I install a brand new version of PHPBB 3.XXX, will I be able to restore the above mention in version 3.xxx of PHPBB?

Thanks

Marc

sibry
Registered User
Posts: 17
Joined: Thu Apr 21, 2005 12:56 am

Re: [Tutorial] How to use phpMyAdmin

Post by sibry » Sat Apr 19, 2008 11:00 pm

Hi

Thanks for the great tutorial!

I was wondering if you could help with the following error i received when trying to install Ajax Chat for my phpBB3 forum. I ran the chat/install.php file and have also tried importing the chat.sql file into the DB but both times i got the following error.

Code: Select all

#1064 - 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 'DEFAULT CHARSET=utf8 COLLATE=utf8_bin' at line 8 
Any advice would be greatly appreciated.

Cheers

Si

nabeelmallick
Registered User
Posts: 89
Joined: Sun Dec 16, 2007 12:02 am

Re: [Tutorial] How to use phpMyAdmin

Post by nabeelmallick » Wed Apr 23, 2008 2:17 am

what if u want to uninstall a mod with sql querry?? how you undo the change in sql?? :?

Locked

Return to “[3.0.x] MODs in Development”