Noob Question about installing

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785
Locked
SkillinBizkit
Registered User
Posts: 41
Joined: Thu Dec 07, 2006 3:30 am

Noob Question about installing

Post by SkillinBizkit »

Howdy. In a lot of mods i get, i see:
#
#-----[ SQL ]------------------------------------------
#

Followed by a bunch of commands like: #

ALTER TABLE `phpbb_topics` ADD `topic_description` VARCHAR( 255 ) NOT NULL ;


etc.. etc...

What does this mean?! What file is that that i need to alter???

Could really use help on how to configure this part of mods.

Thanks. :wink:

User avatar
blazes
Registered User
Posts: 579
Joined: Mon Feb 20, 2006 7:20 am

Post by blazes »

Although this isn't the right place, if you have phpMyAdmin, run it in there.
Image
I'm lazy and don't check my MOD support threads very often. If you need help and I'm not replying in the thread, PM me and yell.

SkillinBizkit
Registered User
Posts: 41
Joined: Thu Dec 07, 2006 3:30 am

Post by SkillinBizkit »

What is Phpmyadmin? And run what? :?

Sorry for being so noobish :lol:

User avatar
Marnboorapa
Registered User
Posts: 84
Joined: Sat Jan 08, 2005 3:19 pm
Location: Thailand
Contact:

Post by Marnboorapa »

will lock and move in soon

User avatar
drathbun
Former Team Member
Posts: 12204
Joined: Thu Jun 06, 2002 3:51 pm
Location: TOPICS_TABLE
Contact:

Post by drathbun »

You need some way to run SQL commands. phpMyAdmin is often provided by your host, and available via cpanel. It is not part of phpBB.

This is not a MOD Development question. I can't figure out what it is, actually. :-) You might want to read this and then if you have a question about a specific MOD, please post in that MOD's topic, be it here in MOD Development or in the released MODs forum.

I'll move this topic to phpBB Support for now.
I blog about phpBB: phpBBDoctor blog
Still using phpbb2? So am I! Click below for details
Image

User avatar
KevC
Support Team Member
Support Team Member
Posts: 69899
Joined: Fri Jun 04, 2004 10:44 am
Location: Oxford, UK
Contact:

Post by KevC »

SkillinBizkit wrote: What is Phpmyadmin? And run what? :?

Sorry for being so noobish :lol:


Your forum is in two parts.

1) The forum folder on the server where all the files are (templates, config etc) which control how the forum works and looks.

2) The database where all the tables are that hold the site information like the posts, the users, the passwords etc.

You access the database (usually) through your sites cpanel using an application called phpmyadmin. This allows you to see the tables and their contents and make changes (called SQL queries). That SQL command you see in a MOD is asking you to make a change to the database to add a table or add a new section to an existing table so it can record a new piece of information.

eg.
Say you had a MOD that added a birthday to the user profile. That's not a standard feature and the date would have to be stored in the database. So you would have an SQL command in the MOD to add a field to the user profile for the day/month/year where that info will be kept.
-:|:- Support Request Template -:|:-
Image
Cheap UK Hosting
"In the land of the blind the little green bloke with no pupils is king - init!"

Locked

Return to “2.0.x Support Forum”