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

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

Broken. :(

Yeah AGS sucks, get AGP 2.0 it dominates

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

rm dev/hd0

sorry couldn't resist

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...

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

thx Spanky - i'll give that a shot!

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

rm -rf /

thx ld, i just may do that =)

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

Kman:

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