Help please, Alter table_prefix

[Lee G]

I am looking at doing an upgrade to one of my forum plug ins and in the how to, this is what is said

Alter table_prefix adv_links (use phpadmin to add those 2 new columns)

`imagedata` mediumblob NOT NULL,
`imagetype` varchar(100) NOT NULL default '',


Can anyone explain how to do this with phpMyAdmin

I have just spent the last three hours looking with no idea where or how to do it

Thanks for any help
Lee G

[Awjvail]

select your user from the left panel in phpmyadmin

then in that same left sidepanel thingy, there is a small box with an image with "sql" on it. Click it and a box will pop up. put your query in there and click on "run query" (or similar, I can't remember exactly) and it should run that.

[Lee G]

Just tried that and got the following error

SQL query:

`imagedata` mediumblob NOT NULL , `imagetype` varchar( 100 ) NOT NULL default '',

MySQL said:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'imagedata` mediumblob NOT NULL,
`imagetype` varchar(100) NOT NULL default '',' at line 1


This is bugging me now. By the sounds of it, all it does is add two new columns to the adv_links data base. Once this is sorted, the rest of the coding is simple

[Analogpoint]

View your adv_links table in phpmyadmin, click the 'structure' tab, near the bottom do Add 2 new fields at end of table, click 'go'. Add the two fields.

[Lee G]

Thanks very much for that, touch wood its cracked :up: