Hi,

I must rename a column of the Link table (City => Contact_City).

I tried to modify the name with MySQLMan and the glinks_Links.def file, but that does not function.

Would somebody have a suggestion?

Thanks!

Mick

Hi Mick,

what does not work? If you are able to rename the column in MySQLMan it should be O.K. to rename the same in Links.def.
Although in this case you should be fine with the Web-Admin:
Database -> Links and Properties in the right dropdown and then the link to "Resync Database".

If you are not able to rename with MySQLMan I would suggest to use the following mySQL command:

ALTER TABLE glinks_Links CHANGE City Contact_City VARCHAR(50);

I do not know what properties your column has so you should change VARCHAR(50) with the appropriate and glinks_Links with your prefix.
After that like above try to "Resync Database".

And: always make a backup before you take hints from strangers.

Hope that helps.

Regards

n||i||k||o

Hi,

Ah Niko said... what "doesn't work" ? If you renamed it in the DB, and also the .def file - it should be fine. As also suggested, try running Database > Links > Properties > Resync, and that should bring the .def file up to date with the database.

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!

Hi,

I apologize for the delay.

That functioned correctly!

Thanks again!

Mick