[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!
Anti-Spam Guide
User avatar
battye
Extension Customisations
Extension Customisations
Posts: 11048
Joined: Wed Feb 11, 2004 11:02 am
Location: Australia
Contact:

Re: [Tutorial] How to use phpMyAdmin

Post by battye »

There is an "Empty" button in phpMyAdmin in the top right (in recent versions I think it has been highlighted as red). It uses the truncate command, which you can read about at: http://dev.mysql.com/doc/refman/5.0/en/truncate.html

Whenever you truncate a table, it is always a good idea to take a backup of the table first. Just in case :)
Customisations Team Member

https://github.com/battye/php-array-parser - Give it a Star! :D
ahmed dawod
Registered User
Posts: 12
Joined: Tue May 12, 2009 11:18 pm

Re: [Tutorial] How to use phpMyAdmin

Post by ahmed dawod »

Thank you very much
apnaitaly
Registered User
Posts: 323
Joined: Tue Jun 30, 2009 6:13 pm

Re: [Tutorial] How to use phpMyAdmin

Post by apnaitaly »

hey

its realy nice Thread ,, i want to ask i have another MySql Dumper

i add a mod ,, its need this chaning in SQL ,

Code: Select all

CREATE TABLE `phpbb_thanks` (
  `thanks_id` mediumint(8) unsigned NOT NULL auto_increment,
  `thanks_from` mediumint(8) unsigned NOT NULL,
  `thanks_to` mediumint(8) unsigned NOT NULL,
  `post_id` mediumint(8) unsigned NOT NULL,
  `thanks_time` int(11) UNSIGNED DEFAULT '1' NULL,
  PRIMARY KEY  (`thanks_id`)
);
ALTER TABLE `phpbb_posts` ADD `post_thanked` INT(11) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_forums` ADD COLUMN `enable_thanks` TINYINT(1) DEFAULT '1' NOT NULL;
ALTER TABLE `phpbb_users` ADD `user_thanked` INT(11) UNSIGNED NOT NULL DEFAULT '0',
ADD `user_thanks` INT(11) UNSIGNED NOT NULL DEFAULT '0',
ADD `user_thanks_post` INT(11) UNSIGNED NOT NULL DEFAULT '0'; 

i have creat Table phpbb_thanks


but i dont knwo how i can add fileds ,,


can you please guide me how i can add fields in this table ,,

Image
User avatar
imkingdavid
Former Team Member
Posts: 2673
Joined: Sun Jul 26, 2009 7:59 pm
Location: EST
Name: David King

Re: [Tutorial] How to use phpMyAdmin

Post by imkingdavid »

apnaitaly wrote:hey

its realy nice Thread ,, i want to ask i have another MySql Dumper

i add a mod ,, its need this chaning in SQL ,

Code: Select all

CREATE TABLE `phpbb_thanks` (
  `thanks_id` mediumint(8) unsigned NOT NULL auto_increment,
  `thanks_from` mediumint(8) unsigned NOT NULL,
  `thanks_to` mediumint(8) unsigned NOT NULL,
  `post_id` mediumint(8) unsigned NOT NULL,
  `thanks_time` int(11) UNSIGNED DEFAULT '1' NULL,
  PRIMARY KEY  (`thanks_id`)
);
ALTER TABLE `phpbb_posts` ADD `post_thanked` INT(11) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `phpbb_forums` ADD COLUMN `enable_thanks` TINYINT(1) DEFAULT '1' NOT NULL;
ALTER TABLE `phpbb_users` ADD `user_thanked` INT(11) UNSIGNED NOT NULL DEFAULT '0',
ADD `user_thanks` INT(11) UNSIGNED NOT NULL DEFAULT '0',
ADD `user_thanks_post` INT(11) UNSIGNED NOT NULL DEFAULT '0'; 

i have creat Table phpbb_thanks


but i dont knwo how i can add fileds ,,


can you please guide me how i can add fields in this table ,,

Image
Just insert the whole code you posted into the SQL box and it should do all of it. But you will need to remove the phpbb_thanks table first or it will return an error saying that there's already a table with that name. :)
Don't forget to smile today. :)
Please do NOT contact for support via PM or email.
Calman
Registered User
Posts: 339
Joined: Sat Jul 12, 2008 1:01 am
Location: Okanagan Valley, Canada
Contact:

Re: [Tutorial] How to use phpMyAdmin

Post by Calman »

Okay, still having issues with this mod.

One question, if the code below isn't properly executed, could this cause the wraparound issues in the Friends Avatars/Name issue?

INSERT INTO phpbb_config (config_name, config_value) VALUES ('number_friends', '50');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('friend_avatar_size', '50');

Incidentally, most of our members have avatars at 100x100 pixels, should I change the above "friend_avatar_size" to 100???

Cheers!
Cal :)
Visiting, Researching or Relocating to the Okanagan Valley in BC?
http://www.okanaganforum.com
User avatar
tumba25
Former Team Member
Posts: 4430
Joined: Wed Jun 06, 2007 6:42 am
Location: Kokkola, Finland.
Name: Jari Kanerva
Contact:

Re: [Tutorial] How to use phpMyAdmin

Post by tumba25 »

You should ask for support in that MODs support topic. It's located at the same place where you downloaded that MOD from.
Need a mod/extension created/installed, other custom-coded solution or a server admin? https://tumba25.net
chuxy
Registered User
Posts: 68
Joined: Fri Sep 04, 2009 5:18 pm

Re: [Tutorial] How to use phpMyAdmin

Post by chuxy »

How can I add this? I dont see option to add in phpmyadmin..!?

Code: Select all

You gotta add user_lastactivity to your db at the table phpbb_users as an INT with size of 11.
EDIT
Done. :oops:
anthies
Registered User
Posts: 162
Joined: Sun May 17, 2009 10:40 am
Location: Finland, Klaukkala
Name: Janne
Contact:

Re: [Tutorial] How to use phpMyAdmin

Post by anthies »

INSERT INTO phpbb_config( config_name, config_value )
VALUES (
'allow_userbar_upload', '1'
)

What am I supposed to do with this text? Where do I need to copy it? help!
User avatar
DiegoPino
Registered User
Posts: 135
Joined: Thu Oct 27, 2005 1:30 am
Location: Colombia
Contact:

Re: [Tutorial] How to use phpMyAdmin

Post by DiegoPino »

Hi People..
I need a help to a query I want to do...

For Example: I want to change values of a row by the same value using phpMyAdmin

Image

I think that the form must be so with REPLACE , but i am not sure... any help please...

Code: Select all

REPLACE INTO `phpbb_users` (`user_id`, `group_id`) VALUES
(1, 4),
(2, 4),
(3, 4),
(4, 4),
(5, 4),
(6, 4),
(7, 4),
(8, 4),
(9, 4),
(10, 4),
(11, 4),
(12, 4);
thanks in advance :ugeek:
We11World [ Winning Eleven ] , Blog , PinoStudio1 , Archive Forums
asinshesq
Registered User
Posts: 6266
Joined: Sun Feb 22, 2004 9:34 pm
Location: NYC
Name: Alan

Re: [Tutorial] How to use phpMyAdmin

Post by asinshesq »

DiegoPino, that particular query would look like this:

Code: Select all

UPDATE 'phpbb_users'
SET 'group_id' = 4
WHERE 'user_id' <= 12;
That will set group_id to 4 in the users table for all users with a user_id that is anywhere in the range of 1-12.
User avatar
DiegoPino
Registered User
Posts: 135
Joined: Thu Oct 27, 2005 1:30 am
Location: Colombia
Contact:

Re: [Tutorial] How to use phpMyAdmin

Post by DiegoPino »

Hi asinshesq .

I write to thank you ,
works for me, very well !!!!

Thks Alan :ugeek:
We11World [ Winning Eleven ] , Blog , PinoStudio1 , Archive Forums
skycat
Registered User
Posts: 5
Joined: Thu Aug 28, 2008 12:34 pm
Contact:

Re: [Tutorial] How to use phpMyAdmin

Post by skycat »

Useful information.
Thank you very much
Ploute
Registered User
Posts: 4
Joined: Mon Oct 23, 2006 12:13 am
Location: Renton, Washington, USA
Contact:

Re: [Tutorial] How to use phpMyAdmin

Post by Ploute »

Okay I have read all the way through the tutorial and then through all the replies and haven't found a direct answer to what I'm about to ask. If it's there then I apologize in advance.

I am using phpMyAdmin provided by my web host. When I go into it I see 2 different databases:

information_schema (20)
usschinook_org (0)

Now logic would dictate that the one with the name of my site would be the one with the forum tables in it but it says 0. So I thought, okay maybe it just named it weird and put it in the other one but I don't see anything there either.

I'm trying to do a basic:

INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_birthdays_ahead', '7');

I thought about changing maybe the phpbb part but when I looked at the e-mail I got when I set up the forums to begin with it told me:

Prefix for tables in database: phpbb_ (if you are upgrading, use a different prefix)

Now I HIGHLY doubt that I changed it cause I'm not that versed in forums so I wouldn't change the prefix unless I had to.

So when I try to add the code I get:

MySQL said:

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

which tells me I need to make a table or am in the wrong place but seeing as its the only place that makes sense I'm thoroughly confused. Please help in any way you can.
User avatar
tumba25
Former Team Member
Posts: 4430
Joined: Wed Jun 06, 2007 6:42 am
Location: Kokkola, Finland.
Name: Jari Kanerva
Contact:

Re: [Tutorial] How to use phpMyAdmin

Post by tumba25 »

Look in your config.php file, it's in your forum root. It tells you what database is used and the username and password to use when you log in to phpMyAdmin.

If you can't log in using that username and password, talk to your host.
Need a mod/extension created/installed, other custom-coded solution or a server admin? https://tumba25.net
Ploute
Registered User
Posts: 4
Joined: Mon Oct 23, 2006 12:13 am
Location: Renton, Washington, USA
Contact:

Re: [Tutorial] How to use phpMyAdmin

Post by Ploute »

I tried the login and it didn't work, gave me Access Denied so I sent them an e-mail requesting help. The other login that was working is going to the wrong database it appears. I will update here once that problem has been solved.
Locked

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