phpMyadmin query help

[betts02]

OK i have a mod that i need help with in phpMyadmin area

The author sent me this:

Then go to phpMyAdmin and execute following query:

ALTER TABLE vbclan_games ADD forumsbanner VARCHAR(50) NOT NULL DEFAULT '' AFTER banner

If you use a different prefix than vb for the database tables, you'll have to replace it first.

I use forums as my prefix so anyone help me on how to do this ?

I tried altering the "vbclan_games" to "forumsclan_games" but no luck

I am stuck at the BOLD bit in the quote

[Simon Lloyd]

If you ARE running this in phpmyadmin then

PHP Code:

ALTER TABLE forumsclan_games ADD forumsbanner VARCHAR(50) NOT NULL DEFAULT '' AFTER banner 


but first visit the table forumsclan_games then click the SQL tab then run the query.

is your prefix actually
forumsclan
or
forums_clan

[betts02]

#1142 - ALTER command denied to user 'nextgen6'@'localhost' for table 'clan_games'

That is what i am getting back when i try to run the query mate

--------------- Added [DATE]1358692734[/DATE] at [TIME]1358692734[/TIME] ---------------

Its actually
_forum

I can execute the original code but the alteration on the mod does not work, It does not post the game banner , It just posts the variable as text

[Simon Lloyd]

Then your query should be

PHP Code:

ALTER TABLE _forumclan_games ADD forumsbanner VARCHAR(50) NOT NULL DEFAULT '' AFTER banner 


[betts02]

Cheers for the help but that does not work either

I will have to wait for the coder to reply to me as its not working at all

Cheers for your help though mate

[Simon Lloyd]

Did it at least add the new column for you?

[kh99]

#1142 - ALTER command denied to user 'nextgen6'@'localhost' for table 'clan_games'

This error is showing that the problem is permissions and not the query syntax. Do you have access to the Execute SQL Query function under the Maintenance menu in the admincp? If so you could try it there. If not, then you need to talk to someone who can adjust the permissions (if that isn't you).

Edit: oh, well if you got the column added (as you mentioned below) then maybe it was the syntax, and it was misunderstanding what you wanted to change. never mind.

[betts02]

Originally Posted by Simon Lloyd

Did it at least add the new column for you?

Yes it added the column which i did before but as it was not working still i assumed i was not doing something correctly which is why i asked here

It could be the files i uploaded or it simply does not work correctly
I will have to wait for a reply from the author of this mod