Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Help with sql

Quote Reply
Help with sql
Hi everyone,

So I had everything working great. Until my secretary clicked where she wasnt supossed to and now... well...

No aparent erros reported.
Builds all fields fine.
DB is aparently ok.
Search by field works.
Attachments work fine.
But when I go to add a new link, or edit a new one, I get the default add page (the admin one), all my extra fields are gone.

Everything is in the DB, just not showing up.

How do I get them back?

Thanks,

Juan Carlos
Quote Reply
Re: [Gorospe] Help with sql In reply to
Hi Juan,

If all fields are still in mysql view by mysqlman or phpmyadmin, you should 'sync' the table with the def file as below:

Select tab database, then choose 'Links' on the first box on the left, then the 'Properties' on the second one and click 'Go'.

Scroll down to the bottom, ther is a 'Sync' link and click on that.

Hope that help!

Cheers,

Dat

Programming and creating plugins and templates
Blog
Quote Reply
Re: [tandat] Help with sql In reply to
Hi tandat,

Thanks for the reply. Did just that. All filds are now available again.
But now they have all been transformed into text fields.
No radio buttons, no imae uploads, no isThis or isThat, dropdowns...

Went over the simple instructions, didnt miss anything...
What happened? What now?

Thanks

JC
Quote Reply
Re: [Gorospe] Help with sql In reply to
Hi,

How did you add the new fields via admin panel, mysqladmin or other tools?

Cheers,

Dat

Programming and creating plugins and templates
Blog
Quote Reply
Re: [tandat] Help with sql In reply to
admin panel
Quote Reply
Re: [Gorospe] Help with sql In reply to
Hi,

In this case, I think we should change these fields again. If you have any backup file (Links.def), you can upload that file again onto the admin/defs folder.

Cheers,

Dat

Programming and creating plugins and templates
Blog
Quote Reply
Re: [Gorospe] Help with sql In reply to
Hi,

As tandant said, you have 2 options:

1) Restore a backup of your glinks_Links.def file
2) Re- edit each field via Database > Links > Properties, to suite the field type you want.

This is where my Auto_Backup plugin would have helped you, as it backs up this kinda data Tongue

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] Help with sql In reply to
Ok, If I edit these fields again, via admin, I wont loose any data? Any risk of this?
Quote Reply
Re: [Gorospe] Help with sql In reply to
Hi,

Nah, you won't loose those fields. Not sure why you lost them in the first place to be honest though.

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] Help with sql In reply to
Thanks guys.
I did have a backup of that file someplace, and just by replacing it worked great.
Didnt have to edit each field to reassign what each one is... just copied links.def over and poof.. worked. :)

Ill sleep better now.. heh

Juan Carlos
Quote Reply
Re: [Gorospe] Help with sql In reply to
Hi,

Glad to hear it.

In case of something like that ever happening again, you can make an easy backup via SSH:

cd /path/to/admin
tar -cvvf backup.tar *

Then just download the backup.tar file locally (you can use winzip to decompress it, although I prefer WinRAR), and voila - you have the whole admin saved locally Smile)

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] Help with sql In reply to
Just installed your backup plugin... :)

Thanks again
Quote Reply
Re: [Gorospe] Help with sql In reply to
heheh cool. Better safe than sorry =)

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!