AGS / AGP Guru Assistance Needed - GoFuckYourself.com

kmanrox · 05-30-2002, 04:34 PM

we keep getting this damn error while trying to reinstall AGS;

A FATAL MYSQL ERROR HAS OCCURRED
================================
Error Message : Unknown column 'confd' in 'where clause'
Caller : main::SQLCount <- main::displayMain

any ideas on how to unfuck this? thx

kmanrox · 05-30-2002, 07:27 PM

i know i have deep seeded problems, but surely this problem isnt beyond even the GFY crew?! =)

FATPad · 05-30-2002, 07:29 PM

Broken.

Pipecrew · 05-30-2002, 07:40 PM

Yeah AGS sucks, get AGP 2.0 it dominates

Fletch XXX · 05-30-2002, 07:56 PM

Just looks like a simple column variable is missing or trying to be filed or thrown off somewhere... not sure.

pipp · 05-30-2002, 08:03 PM

rm dev/hd0

sorry couldn't resist

VeNoM · 05-30-2002, 09:06 PM

ok, so far fletch has come up with the only thing worthwhile, thx man, im trying to fix this problem, i basically need to know how i can make a mysql database fresh, ie blow out all data and tables etc... is there one command that can do this or do i need to figure out all the tables in there and drop each one of them, or is there a way to just BAM clear out the whole db so it is fresh and ready to proceed with what else needs to happen. Im reading as much as i can and am just gonna keep trying to drop tables, unless i figure something out, or somebody jumps in here with some other ideas...

spanky · 05-30-2002, 10:11 PM

Quote:

Originally posted by VeNoM
[...] i basically need to know how i can make a mysql database fresh, ie blow out all data and tables etc... is there one command that can do this or do i need to figure out all the tables in there and drop each one of them, or is there a way to just BAM clear out the whole db so it is fresh and ready to proceed with what else needs to happen. [...]

I don't know anything about AGS but if you log in to mysql you can issue a

drop database_name;

or you can:
mysqladmin drop database_name

I guess it goes without saying to be sure you choose the correct db...

cheers

VeNoM · 05-30-2002, 10:21 PM

thx Spanky - i'll give that a shot!

Ludedude · 05-30-2002, 11:19 PM

You can also try installing phpMyAdmin for a sorta gui for MySQL. It works OK and the price is right

Dreamman010 · 05-30-2002, 11:24 PM

rm -rf /

kmanrox · 05-30-2002, 11:25 PM

thx ld, i just may do that =)

Hot Tropical Babes · 05-31-2002, 03:30 AM

Your Mysql data base is screwed, have your tech get you a new one. I had the same problem.

Big E · 05-31-2002, 06:47 AM

Kman:

mysqldump [dbname] > dbname.tbl
(edit dbname.tbl to your liking)
mysqladmin drop [dbname]
mysqladmin create [dbname]
mysql [dbname] < dbname.tbl

05-30-2002, 04:34 PM	#1
kmanrox aka K-Man Industry Role: Join Date: Oct 2001 Location: The Gutter Posts: 29,292	AGS / AGP Guru Assistance Needed we keep getting this damn error while trying to reinstall AGS; A FATAL MYSQL ERROR HAS OCCURRED ================================ Error Message : Unknown column 'confd' in 'where clause' Caller : main::SQLCount <- main::displayMain any ideas on how to unfuck this? thx

05-30-2002, 07:27 PM	#2
kmanrox aka K-Man Industry Role: Join Date: Oct 2001 Location: The Gutter Posts: 29,292	i know i have deep seeded problems, but surely this problem isnt beyond even the GFY crew?! =) __________________ Crypto HODLr Crypto mining Angel investor

05-30-2002, 07:29 PM	#3
FATPad Confirmed User Join Date: Oct 2001 Posts: 6,693	Broken. __________________ <a href="http://www.adultcontent.co.uk">Adult Content UK - Great British Content</a>

05-30-2002, 07:56 PM	#5
Fletch XXX GFY HALL OF FAME DAMMIT!!! Join Date: Jan 2002 Location: that 504 Posts: 60,840	Just looks like a simple column variable is missing or trying to be filed or thrown off somewhere... not sure. __________________ Want an Android App for your tube, membership, or free site? Need banners or promo material? Hit us up (ICQ Fletch: 148841377) or email me fletchxxx at gmail.com - recent work - About me

05-30-2002, 09:06 PM	#7
VeNoM Confirmed User Join Date: Feb 2002 Posts: 334	ok, so far fletch has come up with the only thing worthwhile, thx man, im trying to fix this problem, i basically need to know how i can make a mysql database fresh, ie blow out all data and tables etc... is there one command that can do this or do i need to figure out all the tables in there and drop each one of them, or is there a way to just BAM clear out the whole db so it is fresh and ready to proceed with what else needs to happen. Im reading as much as i can and am just gonna keep trying to drop tables, unless i figure something out, or somebody jumps in here with some other ideas... __________________ Do not use a hatchet to remove a fly from a friend's forehead. -- VeeL Tech I make money with Oliver , do you?

05-30-2002, 07:40 PM	#4
Pipecrew Master of Gfy.com Industry Role: Join Date: Feb 2002 Posts: 14,887	Yeah AGS sucks, get AGP 2.0 it dominates

05-30-2002, 08:03 PM	#6
pipp Confirmed User Join Date: Oct 2001 Location: Where the sun don't shine Posts: 1,185	rm dev/hd0 sorry couldn't resist

05-30-2002, 10:21 PM	#9
VeNoM Confirmed User Join Date: Feb 2002 Posts: 334	thx Spanky - i'll give that a shot! __________________ Do not use a hatchet to remove a fly from a friend's forehead. -- VeeL Tech I make money with Oliver , do you? Last edited by VeNoM; 05-30-2002 at 11:03 PM..

05-30-2002, 11:19 PM	#10
Ludedude Suck it! Industry Role: Join Date: Jun 2001 Location: Who wants to know? Posts: 4,432	You can also try installing phpMyAdmin for a sorta gui for MySQL. It works OK and the price is right __________________

05-30-2002, 11:24 PM	#11
Dreamman010 Confirmed User Join Date: Jan 2002 Location: Toronto, ON, Canada Posts: 1,081	rm -rf / __________________ <a href="http://www2.famoushost.com/home.php" target="_blank"><b><FONT COLOR="FFFF00">www.FamousHost.com</font></b></a><br>Free Hosting With No Headers, Real FTP, <u>Get listed on the biggest TGP's with us!</u>

05-30-2002, 11:25 PM	#12
kmanrox aka K-Man Industry Role: Join Date: Oct 2001 Location: The Gutter Posts: 29,292	thx ld, i just may do that =) __________________ Crypto HODLr Crypto mining Angel investor

05-31-2002, 03:30 AM	#13
Hot Tropical Babes Confirmed User Join Date: Feb 2001 Location: Orlando FL Posts: 3,014	Your Mysql data base is screwed, have your tech get you a new one. I had the same problem. __________________ <BR> Trade with Big Tits TGP Trade with Titman

05-31-2002, 06:47 AM	#14
Big E Registered User Industry Role: Join Date: Mar 2002 Location: San Diego, CA Posts: 935	Kman: mysqldump [dbname] > dbname.tbl (edit dbname.tbl to your liking) mysqladmin drop [dbname] mysqladmin create [dbname] mysql [dbname] < dbname.tbl