Page 5 of 12

Re: [Tutorial] How to use phpMyAdmin

Posted: Tue Jun 03, 2008 11:40 am
by JezUK1
Ok Im new when it comes to mods and installing them. How do I install the sql part m8?

Re: [Tutorial] How to use phpMyAdmin

Posted: Tue Jun 03, 2008 1:50 pm
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.....

Re: [Tutorial] How to use phpMyAdmin

Posted: Tue Jun 17, 2008 7:21 am
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.

Re: [Tutorial] How to use phpMyAdmin

Posted: Tue Jun 17, 2008 8:53 am
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. :)

Re: [Tutorial] How to use phpMyAdmin

Posted: Sun Jun 22, 2008 1:53 pm
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

Re: [Tutorial] How to use phpMyAdmin

Posted: Mon Jun 23, 2008 11:11 am
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.

Major Help!

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

Re: [Tutorial] How to use phpMyAdmin

Posted: Sun Jun 29, 2008 3:58 am
by battye
You may need to alter the table prefix in the code, yes.

Re: [Tutorial] How to use phpMyAdmin

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

Re: [Tutorial] How to use phpMyAdmin

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

Re: [Tutorial] How to use phpMyAdmin

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

Re: [Tutorial] How to use phpMyAdmin

Posted: Tue Jul 01, 2008 10:20 am
by Tripp
What version are you using?

Re: [Tutorial] How to use phpMyAdmin

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

Re: [Tutorial] How to use phpMyAdmin

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

Re: [Tutorial] How to use phpMyAdmin

Posted: Sat Jul 19, 2008 4:45 pm
by nadalbg
MySQL said:

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

What happens when I receive this error ?