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

Re: [Tutorial] How to use phpMyAdmin

Post by JezUK1 » Tue Jun 03, 2008 11:40 am

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
Contact:

Re: [Tutorial] How to use phpMyAdmin

Post by Tripp » Tue Jun 03, 2008 1:50 pm

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
Contact:

Re: [Tutorial] How to use phpMyAdmin

Post by achievehigh.org » Tue Jun 17, 2008 7:21 am

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: 10940
Joined: Wed Feb 11, 2004 11:02 am
Location: Australia
Contact:

Re: [Tutorial] How to use phpMyAdmin

Post by battye » Tue Jun 17, 2008 8:53 am

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
Contact:

Re: [Tutorial] How to use phpMyAdmin

Post by Jord070 » Sun Jun 22, 2008 1:53 pm

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: 10940
Joined: Wed Feb 11, 2004 11:02 am
Location: Australia
Contact:

Re: [Tutorial] How to use phpMyAdmin

Post by battye » Mon Jun 23, 2008 11:11 am

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 » Sat Jun 28, 2008 4:35 am

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: 10940
Joined: Wed Feb 11, 2004 11:02 am
Location: Australia
Contact:

Re: [Tutorial] How to use phpMyAdmin

Post by battye » Sun Jun 29, 2008 3:58 am

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 » Mon Jun 30, 2008 3:00 pm

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 » Mon Jun 30, 2008 6:25 pm

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 » Tue Jul 01, 2008 8:34 am

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
Contact:

Re: [Tutorial] How to use phpMyAdmin

Post by Tripp » Tue Jul 01, 2008 10:20 am

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 » Tue Jul 01, 2008 10:54 am

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 » Sun Jul 06, 2008 1:37 pm

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
Contact:

Re: [Tutorial] How to use phpMyAdmin

Post by nadalbg » Sat Jul 19, 2008 4:45 pm

MySQL said:

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

What happens when I receive this error ?

Locked

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