PDA

View Full Version : how to run this query?!!?!?!?!!?!


readyforwar
07-30-2005, 02:25 AM
########
# Run Query:
########

ALTER TABLE `df_forum`.`PREFIX_user` ADD `avatar2` TEXT NOT NULL;

Replace “df_forum” with the name of the database where your ‘user’ table is stored
Replace “PREFIX_” with the prefix of your tables, (or just remove it)

################################################## ############################## ####
Done!

i got access to the query thing in the admin cp

and i put this
ALTER TABLE `df_forum`.`PREFIX_user` ADD `avatar2` TEXT NOT NULL;
in the manual and ran it

and now i got database error sent to my email

help!!!!!!!!!!

Adrian Schneider
07-30-2005, 02:28 AM
df_forum is your database name [varies, but is optional (i think) ]
prefix_user is your user table name [usually "user"]

ALTER TABLE user
ADD avatar2 TEXT NOT NULL should work unless you manually setup table prefixes

readyforwar
07-30-2005, 02:30 AM
df_forum is your database name [varies, but is optional (i think) ]
prefix_user is your user table name [usually "user"]

ALTER TABLE user
ADD avatar2 TEXT NOT NULL should work unless you manually setup table prefixes

hey specialist

thanx for the quick reply

it went through


do i restart


or thats it?

Adrian Schneider
07-30-2005, 02:47 AM
That's it. :)

readyforwar
07-30-2005, 02:51 AM
That's it. :)

thanks alot it works

;)