Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact us.

Post New Thread Reply

Register GFY Rules Calendar
Go Back   GoFuckYourself.com - Adult Webmaster Forum > >
Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed.

 
Thread Tools
Old 05-06-2005, 11:47 PM   #1
Chris
Too lazy to set a custom title
 
Chris's Avatar
 
Industry Role:
Join Date: May 2003
Location: icq: 71462500 Skype: Jupzchris
Posts: 27,880
mysql question

THis script I am trying to install says this

" Step 1. Run the following SQL-query

ALTER TABLE `subscription` ADD `reoccur` VARCHAR( 10 ) DEFAULT '0' NOT NULL ; "

How the fuck do I do that ? lol
__________________
[email protected]
Chris is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 05-06-2005, 11:49 PM   #2
Jace
FBOP Class Of 2013
 
Industry Role:
Join Date: Jan 2004
Location: bumfuck, ky
Posts: 35,562
do you already have a table called subscription? if so just paste that into phpmyadmin in the sql section and it should do the work for you
Jace is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 05-06-2005, 11:55 PM   #3
Chris
Too lazy to set a custom title
 
Chris's Avatar
 
Industry Role:
Join Date: May 2003
Location: icq: 71462500 Skype: Jupzchris
Posts: 27,880
uighhh cant find phpmyadmin in the cpanel

this is a headache
trying tomake this forum subscription based and no fucking sites help
__________________
[email protected]
Chris is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 05-06-2005, 11:57 PM   #4
SilverTab
Confirmed User
 
Join Date: Nov 2001
Location: MTL
Posts: 5,060
Quote:
Originally Posted by JupZChris
uighhh cant find phpmyadmin in the cpanel

this is a headache
trying tomake this forum subscription based and no fucking sites help

click on the DB in CPanel and there will be a link to phpmyadmin....then you click on the DB where your forum is installed, and then on the "SQL" tab...there's a text field where you can paste the query
__________________
mmm my sig was too big... no more cool animation
but hey still! need php? ICQ: 94586959
SilverTab is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 05-06-2005, 11:59 PM   #5
SilverTab
Confirmed User
 
Join Date: Nov 2001
Location: MTL
Posts: 5,060
if you can't do it, hit me up on ICQ I can do it for you...it'll take a second...
__________________
mmm my sig was too big... no more cool animation
but hey still! need php? ICQ: 94586959
SilverTab is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 05-06-2005, 11:59 PM   #6
prodiac
Confirmed User
 
Industry Role:
Join Date: Sep 2003
Location: amerinoc.com
Posts: 419
Quote:
Originally Posted by JupZChris
THis script I am trying to install says this

" Step 1. Run the following SQL-query

ALTER TABLE `subscription` ADD `reoccur` VARCHAR( 10 ) DEFAULT '0' NOT NULL ; "

How the fuck do I do that ? lol
Yo, hit me up on icq, I'll help you, and walk you through doing it by hand.

3150501
prodiac is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 05-07-2005, 12:01 AM   #7
Hell Puppy
Confirmed User
 
Join Date: Oct 2002
Location: Hotlanta, Georgia
Posts: 183
No offense but you're in over your head if you dont have phpmyadmin on the server and you dont know how to run a sql statement.

You need something that will let you run SQL against the database in question. And it sounds like you may not even know the database name?

Ask your host if you have phpmyadmin installed on your server. If so, login to it, select the database you're trying to update and just paste the statement into the "SQL" tab.

Without phpmyadmin, you're likely looking at having to do it from a unix shell. In which case I'd recommend paying someone to do it for you.
Hell Puppy is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 05-07-2005, 09:01 AM   #8
TheSaint
Confirmed User
 
Join Date: Jun 2003
Location: Everywhere at once
Posts: 991
Its not much harder from the shell.
Just type "mysql"
Then type use <database name>
Then paste your query, and an extra "ENTER"

But, as said, if you don't really understand what you are doing better to seek help.
__________________
I have no signature
TheSaint is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Post New Thread Reply
Go Back   GoFuckYourself.com - Adult Webmaster Forum > >

Bookmarks



Advertising inquiries - marketing at gfy dot com

Contact Admin - Advertise - GFY Rules - Top

©2000-, AI Media Network Inc



Powered by vBulletin
Copyright © 2000- Jelsoft Enterprises Limited.