[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!
Suggested Hosts
User avatar
JezUK1
Registered User
Posts: 735
Joined: Wed Jul 27, 2005 11:12 pm
Location: England, Somerset

Re: [Tutorial] How to use phpMyAdmin

Post by JezUK1 »

Ok Im new when it comes to mods and installing them. How do I install the sql part m8?
Jez

ControlThis.co.uk - Your online model shop
User avatar
Tripp
Former Team Member
Posts: 1358
Joined: Sun May 20, 2007 5:14 am
Location: G'boro, North Carolina
Name: Tripp

Re: [Tutorial] How to use phpMyAdmin

Post by Tripp »

JezUK1 wrote:Ok Im new when it comes to mods and installing them. How do I install the sql part m8?
Did you even look at the first post.....
The box said 'You need Windows XP or better' .... so I installed linux.

Formerly Drugs
achievehigh.org
Registered User
Posts: 300
Joined: Sat Apr 01, 2006 3:08 am

Re: [Tutorial] How to use phpMyAdmin

Post by achievehigh.org »

Battye, thanks for this tutorial. Usually tutorial threads are locked and when I wanted to ask about some part(s) in the tutorial, I could not! Please don't ever lock this topic. It's more useful to leave it open.
User avatar
battye
Extension Customisations
Extension Customisations
Posts: 11056
Joined: Wed Feb 11, 2004 11:02 am
Location: Australia

Re: [Tutorial] How to use phpMyAdmin

Post by battye »

achievehigh.org wrote:Battye, thanks for this tutorial. Usually tutorial threads are locked and when I wanted to ask about some part(s) in the tutorial, I could not! Please don't ever lock this topic. It's more useful to leave it open.
Thanks, and I agree. :)
Customisations Team Member

https://github.com/battye/php-array-parser - Give it a Star! :D
Jord070
Registered User
Posts: 21
Joined: Mon Jun 16, 2008 7:52 am
Location: Perth, West Australia

Re: [Tutorial] How to use phpMyAdmin

Post by Jord070 »

Hi every one,

I was wondering if there is a query to do a mass delete/ removal,

i need to remove all "phpbb_" for they are not used anymore instead i use forum_ ,i also need to remove all copper_ and cpg14x_

and there is over 200 in total and i dont really wanna spend hours on somthing i could do with a query/.\

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

Re: [Tutorial] How to use phpMyAdmin

Post by battye »

If you want to delete everything to do with phpBB, just use a program like phpMyAdmin, click all of the checkboxes for the phpbb_ tables and then click drop.

It's permanent though, don't do it unless you're absolutely sure.
Customisations Team Member

https://github.com/battye/php-array-parser - Give it a Star! :D
thelazynarakid
Registered User
Posts: 113
Joined: Mon May 26, 2008 10:10 pm

Major Help!

Post by thelazynarakid »

Whenever I try to install a MOD with an SQL code something like this shows up:
General Error
SQL ERROR [ mysql4 ]

Table 'kaoticbb.phpbbadr_general' doesn't exist [1146]

SQL

SELECT * FROM phpbbadr_general

BACKTRACE

FILE: includes/db/mysql.php
LINE: 158
CALL: dbal_mysql->sql_error()

FILE: includes/mods/adr/adr_functions_cache.php
LINE: 984
CALL: dbal_mysql->sql_query()

FILE: adr_forge.php
LINE: 44
CALL: adr_get_general_config()
Am I suppossed to change the SQL code before I paste it?
User avatar
battye
Extension Customisations
Extension Customisations
Posts: 11056
Joined: Wed Feb 11, 2004 11:02 am
Location: Australia

Re: [Tutorial] How to use phpMyAdmin

Post by battye »

You may need to alter the table prefix in the code, yes.
Customisations Team Member

https://github.com/battye/php-array-parser - Give it a Star! :D
zeeshan-HU
Registered User
Posts: 3
Joined: Mon Jun 30, 2008 2:53 pm

Re: [Tutorial] How to use phpMyAdmin

Post by zeeshan-HU »

i am facing a problem.Following error occured :
When i check the registration page it gives the following error when i try to open registration page:

...phpBB3/includes/template.php(175) : eval()'d code on line 122


Everything else is set but abbove problem is still there.I am a newbie so kindly help me.
Last edited by zeeshan-HU on Tue Jul 01, 2008 8:33 am, edited 1 time in total.
User avatar
KeithR
Former Team Member
Posts: 750
Joined: Mon Jun 16, 2008 6:59 pm
Location: Manchester, UK
Name: Keith R

Re: [Tutorial] How to use phpMyAdmin

Post by KeithR »

Thankyou so much for this tutorial battye :D . I followed it last night to install a MOD using this method and it worked like a charm.
zeeshan-HU
Registered User
Posts: 3
Joined: Mon Jun 30, 2008 2:53 pm

Re: [Tutorial] How to use phpMyAdmin

Post by zeeshan-HU »

Any help regarding my problem ?
When i check the registration page it gives the following error when i try to open registration page:

...phpBB3/includes/template.php(175) : eval()'d code on line 122


Everything else is set but abbove problem is still there.I am a newbie so kindly help me.
User avatar
Tripp
Former Team Member
Posts: 1358
Joined: Sun May 20, 2007 5:14 am
Location: G'boro, North Carolina
Name: Tripp

Re: [Tutorial] How to use phpMyAdmin

Post by Tripp »

What version are you using?
The box said 'You need Windows XP or better' .... so I installed linux.

Formerly Drugs
zeeshan-HU
Registered User
Posts: 3
Joined: Mon Jun 30, 2008 2:53 pm

Re: [Tutorial] How to use phpMyAdmin

Post by zeeshan-HU »

My previous problem is solved ,now the main problem is that the question is not showing on the registration page.I am using phpBB version 3.The "user registration setting" shows the question field,answer...everything...and its enabled but when i test by registering the registration page doesnot show any question.

I have also updated these files :
ucp_register.php
acp_board.php
board.php
ucp.php
common.php
ucp_register.html

( i am using prosilver style)

but the problem mentioned above is still there.Please help.I am a newbie.
opalelement
Registered User
Posts: 315
Joined: Wed Dec 27, 2006 4:05 am

Re: [Tutorial] How to use phpMyAdmin

Post by opalelement »

If you want a more advanced way of running queries straight from the ACP without having to open phpMyAdmin you can use my database explorer, it is like phpMyAdmin but without all the icons next to it to drop something (because I don't want to be responsible for stupidity :O)

I hate having to open phpMyAdmin and someone requested it, plus I like the one included in IP.Board, so I made one :)

Warning, not for beginners.
nadalbg
Registered User
Posts: 273
Joined: Wed Jul 16, 2008 12:58 pm

Re: [Tutorial] How to use phpMyAdmin

Post by nadalbg »

MySQL said:

#1146 - Table 'morethb8_pbb03.phpbb_config' doesn't exist

What happens when I receive this error ?

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