GoFuckYourself.com - Adult Webmaster Forum

GoFuckYourself.com - Adult Webmaster Forum (https://gfy.com/index.php)
-   Fucking Around & Business Discussion (https://gfy.com/forumdisplay.php?f=26)
-   -   mysql question (https://gfy.com/showthread.php?t=464654)

Chris 05-06-2005 11:47 PM

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

Jace 05-06-2005 11:49 PM

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

Chris 05-06-2005 11:55 PM

uighhh cant find phpmyadmin in the cpanel

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

SilverTab 05-06-2005 11:57 PM

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

SilverTab 05-06-2005 11:59 PM

if you can't do it, hit me up on ICQ I can do it for you...it'll take a second...

prodiac 05-06-2005 11:59 PM

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

Hell Puppy 05-07-2005 12:01 AM

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.

TheSaint 05-07-2005 09:01 AM

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.


All times are GMT -7. The time now is 01:31 AM.

Powered by vBulletin® Version 3.8.8
Copyright ©2000 - 2025, vBulletin Solutions, Inc.
©2000-, AI Media Network Inc123