What is slug field?
|
Serge D
Joined: 2009-06-11
Posts: 2139 |
Posted: Fri, 2009-09-18 04:41
|
|
New field has been added in B3 - items.slug. May be I just need to reimport all the images from G2. Then how to flash G3 database? |
|
Posts: 16503
If you click on Options > Edit Photo (or album), you'll see a new field there called "Internet Address". I'm pretty sure that's what the slug is. We just called it "Internet Address" on the form for a friendlier name than "slug", which is what I believe WP calls it.
I'm not sure what you're doing with git updates and maintaining all your data manually though. I stay very current with git, doing several pulls a day and have had no issue with images I've added with either Server Add or G2 Import.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Posts: 2139
If I am to import images again, it probably would be fine. I am talking about existing records. There is something missing somewhere preventing proper path to albums being shown - it just "/" on the page.
This is why I was looking for easy way to reimport G2 content from scratch.
Posts: 16503
In your database, if you go to your g3_items (assuming g3_ is your table prefix) table, then browse the 'slug' row what do you see?
I think at this point the only "easy" way to reimport is delete, which to do mass deletes right now involves creating a temporary album, using Organize to move items into that temporary album and deleting that temporary album.
Then reimporting your G2 stuff.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Posts: 2139
I see NULL...
Can I just delete all albums? or I have to actually move items?
Posts: 16503
You can delete them one by one.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Posts: 128
Or you could just do a sql UPDATE via mysql or phpMyAdmin to fix those fields.
I just did something like that a few minutes ago: I loaded a new album of 919 pictures and my fat fingers cause it to all go into the root Gallery instead of the album I had planned.
By physically moving the actual pictures in the thumbs, resizes etc folders, then updating the parent_id, relative_path_cache and relative_url_cache fields in the items table to match the new location, problem solved.
And this all took about 10 minutes to figure out and do, compared to the several hours of deleting and reloading!
Martyn T. Griffin
Posts: 2139
@griffinmt: problem was no a wrong location, inability to migrate between git rollouts. There is no migration path for it.
@nivekiam: did not help, I just reinstalled the whole thing. Took me about the same time... in the end.
G3 need maintenance module (like in G2) - one which would knowing physical and database data, reconile both.
Posts: 22892
Please file a feature request.
Dave
_____________________________________________
Blog & G2 || floridave - Gallery Team
Posts: 16503
Which maintenance module in G2 does that? I know there's a few to help, but I haven't seen one that goes in and fixes stuff.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here
Posts: 2139
@nivekiam: Integrity check part of maintenance. There were 16 options there versus 4 today...