Gossamer Forum
Home : Products : Gossamer Links : Discussions :

How to change the admin field order?

Quote Reply
How to change the admin field order?
Its not very often I post a question, but here goes Tongue

I am trying to modify the field order that the fields are shown (in the admin panel). Currently it has the default fields, and then;

Admin_Comments
Image_4
Recip_URL
Image_2
Image_1
Image_3

I want to change it to;

Admin_Comments
Recip_URL
Image_1
Image_2
Image_3
Image_4

I have tried manually editing the lsql_Links.def file, but that seems to mess up the search results? Unsure

TIA

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!
Quote Reply
Re: [Andy] How to change the admin field order? In reply to
Here's some discussions.

http://www.gossamer-threads.com/...i?post=208538#208538
http://www.gossamer-threads.com/...i?post=235628#235628

This seems like the best solution from Alex if you can get it to work:
http://www.gossamer-threads.com/...i?post=236501#236501
Quote Reply
Re: [Andy] How to change the admin field order? In reply to
Andy

Here's another by Alex:

"Reorganize the columns in a LinksSQL table"
http://www.gossamer-threads.com/...?post=261410;#261410

If you can get this to work I'd like to know.

Regards

minesite
Quote Reply
Re: [minesite] How to change the admin field order? In reply to
In Reply To:
Andy

Here's another by Alex:

"Reorganize the columns in a LinksSQL table"
http://www.gossamer-threads.com/...?post=261410;#261410

If you can get this to work I'd like to know.

Thanks. I ended up manually editing the .def file again, so they were in the order that I wanted. As far as I can see, its working ok... but I'm gonna keep a look out anyway.

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!
Quote Reply
Re: [minesite] How to change the admin field order? In reply to
It works! I tried this when Alex wrote the post originally and couldn't get it to work - but since then I've upgraded mysql so that might be why. I have a nice tidy Links table now Cool
Quote Reply
Re: [afinlr] How to change the admin field order? In reply to
Hi afinir

Could you post the exact query you used.Smile

Did it change any of the table info or is all still the same ?

Thanks

Regards

minesite
Quote Reply
Re: [minesite] How to change the admin field order? In reply to
Example

alter table Links change Mod_Date Mod_Date date after Description;

I tried it in an unimportant table first just to check it worked. Make sure that the value in red is the exact type of the field that you want to move (best to copy this from Properties in MySQLMan).

All data appears to be there - but you should probably back up the table first.
Quote Reply
Re: [afinlr] How to change the admin field order? In reply to
Thanks for that.

Seems to work on the test site at home.
This has been driving me crazy for weeks now.Crazy

Regards

minesite
Quote Reply
Re: [afinlr] How to change the admin field order? In reply to
Doesn't seem to work for me :(

Code:
Error

MySQL said: You have an error in your SQL syntax near 'AFTER Mod_Date' at line 1.

Query: ALTER TABLE lsql_Links CHANGE Hits Hits int AFTER Mod_Date

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!
Quote Reply
Re: [Andy] How to change the admin field order? In reply to
I think that INT fields need a length? Try

Query: ALTER TABLE lsql_Links CHANGE Hits Hits int (11) AFTER Mod_Date

Also, the only problem I've encountered since doing this is that some of my defaults disappeared so you may need to put your defaults in the query as well if you want to save them.

Edit: Andy - you need to look in the properties in mysql man to get the correct properties of the field. I've just checked and Hits should be int (11).

Last edited by:

afinlr: Apr 3, 2004, 1:18 AM
Quote Reply
Re: [afinlr] How to change the admin field order? In reply to
Thanks.

There must be an easier way? I have over 70 fields to do Unsure

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!
Quote Reply
Re: [Andy] How to change the admin field order? In reply to
I think the only other way is to dump your whole table, move the fields about and the reimport it - I'm sure there's a discussion about this in one of the threads I suggested above.
Quote Reply
Re: [afinlr] How to change the admin field order? In reply to
This looks promising;

http://www.mysqlfront.de/download.html

Aparantly you can use it to reorder the fields. Just downloading it now :)

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!
Quote Reply
Re: [Andy] How to change the admin field order? In reply to
phpMyAdm used to let you do that, but I haven't used it in awhile.


PUGDOG´┐Ż Enterprises, Inc.

The best way to contact me is to NOT use Email.
Please leave a PM here.
Quote Reply
Re: [pugdog] How to change the admin field order? In reply to
Thanks, I'll take a look at that then.. this MySQL-Front thing doesn't seem to be doing so well ... its giving me a German error message, most likely a MySQL error, as I'm not sure if the login details for the database are setup to allow 'off-site' login :(

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!
Quote Reply
Re: [pugdog] How to change the admin field order? In reply to
In Reply To:
phpMyAdm used to let you do that, but I haven't used it in awhile.

I can't see a feature in there that does this? Unsure

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!
Quote Reply
Re: [Andy] How to change the admin field order? In reply to
This thread may help: http://faq.ozoneasylum.com/993/visits/

Alex



Indigo Clothing is a t-shirt printing company based in the UK.
Indigo Clothing | Promotional Clothing | T-Shirt Printing | Embroidery
Quote Reply
Re: [afinlr] How to change the admin field order? In reply to
In Reply To:
I think that INT fields need a length? Try

Query: ALTER TABLE lsql_Links CHANGE Hits Hits int (11) AFTER Mod_Date

Also, the only problem I've encountered since doing this is that some of my defaults disappeared so you may need to put your defaults in the query as well if you want to save them.

Edit: Andy - you need to look in the properties in mysql man to get the correct properties of the field. I've just checked and Hits should be int (11).


Hi, I have done

ALTER TABLE lsql_Links CHANGE Hits Hits int (11) AFTER Mod_Date

From sql monitor and from phpmyadmin...

I still and always have the following error message "MySQL said: You have an error in your SQL syntax near 'AFTER Mod_Date' at line 1."

Any idea ? do I miss someting ? it makes me crazy ;(


regards
FMP
Quote Reply
Re: [fmp] How to change the admin field order? In reply to
Sorry - not sure what the problem could be. I've just checked it on my site and this does work.