Gossamer Forum: Products: Gossamer Links: Discussions: Category Problems Links 3.2.0

Apr 24, 2007, 11:54 PM

qix

Novice (45 posts)

Apr 24, 2007, 11:54 PM

Post #1 of 10

Shortcut

Category Problems Links 3.2.0

Hello again,

i have a Problem with building Categories.
For Example my Catrgory Tree:

- Home
- Car
- Audio
- Subwoofer
- Speaker
.....

When I Looked on my Server, there will be Directories like this:

./Car
./Car/Audio/Subwoofer
./Car/audio/Speaker

So I found in the Links SQL Admin the Function "Rebuild Gossamer Links Category Tree"

Can I used this to fix the Category Problem ???

Thanx
qix

Apr 25, 2007, 1:10 AM

Andy

Veteran / Moderator (17366 posts)

Apr 25, 2007, 1:10 AM

Post #2 of 10

Shortcut

Re: [qix] Category Problems Links 3.2.0 In reply to

Hi,

Mmm.. I'm not sure what your asking? Is it the lowercase "a" in "audio" that you are on about?

./Car/audio/Speaker

..or was that just a typo =)

Cheers

Andy (mod)
andy@ultranerds.co.uk

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates

Apr 25, 2007, 1:27 AM

qix

Novice (45 posts)

Apr 25, 2007, 1:27 AM

Post #3 of 10

Shortcut

Re: [Andy] Category Problems Links 3.2.0 In reply to

In Reply To:

Hi,

Mmm.. I'm not sure what your asking? Is it the lowercase "a" in "audio" that you are on about?

./Car/audio/Speaker

Yes, this is exactly the problem ... Links SQL build Directories as "audio" and "Audio" ?? Greets, qix100

Apr 25, 2007, 1:55 AM

Andy

Veteran / Moderator (17366 posts)

Apr 25, 2007, 1:55 AM

Post #4 of 10

Shortcut

Re: [qix] Category Problems Links 3.2.0 In reply to

Ok, if you go into Database > MySQLMonitor, and enter:

Code:
SELECT Full_Name FROM glinks_Category WHERE Full_Name LIKE '%Car/audio%'

..what does it show?

Cheers

Andy (mod)
andy@ultranerds.co.uk

Apr 25, 2007, 2:17 AM

qix

Novice (45 posts)

Apr 25, 2007, 2:17 AM

Post #5 of 10

Shortcut

Re: [Andy] Category Problems Links 3.2.0 In reply to

In Reply To:

Code:
SELECT Full_Name FROM glinks_Category WHERE Full_Name LIKE '%Car/audio%'

..what does it show?

#1146 - Table 'db65711397.glinks_Category' doesn't exist

Apr 25, 2007, 2:18 AM

Andy

Veteran / Moderator (17366 posts)

Apr 25, 2007, 2:18 AM

Post #6 of 10

Shortcut

Re: [qix] Category Problems Links 3.2.0 In reply to

Hi,

Ah ok, what prefex do you use? lsql_ ?

Cheers

Andy (mod)
andy@ultranerds.co.uk

Apr 25, 2007, 2:43 AM

qix

Novice (45 posts)

Apr 25, 2007, 2:43 AM

Post #7 of 10

Shortcut

Re: [Andy] Category Problems Links 3.2.0 In reply to

In Reply To:

Hi,

Ah ok, what prefex do you use? lsql_ ?

Cheers

Hi,

the Field in the SQL Setup is empty ?!?

Thanks,
qix

Apr 25, 2007, 2:49 AM

Andy

Veteran / Moderator (17366 posts)

Apr 25, 2007, 2:49 AM

Post #8 of 10

Shortcut

Re: [qix] Category Problems Links 3.2.0 In reply to

Hi,

Ok, try this then:

SELECT Full_Name FROM Category WHERE Full_Name LIKE '%Car/audio%'

Cheers

Andy (mod)
andy@ultranerds.co.uk

Apr 25, 2007, 2:55 AM

qix

Novice (45 posts)

Apr 25, 2007, 2:55 AM

Post #9 of 10

Shortcut

Re: [Andy] Category Problems Links 3.2.0 In reply to

In Reply To:

Hi,

Ok, try this then:

SELECT Full_Name FROM Category WHERE Full_Name LIKE '%Car/audio%'

Cheers

Hi,

I got: Car/Audio

Thanks,
qix

Apr 25, 2007, 3:06 AM

Andy

Veteran / Moderator (17366 posts)

Apr 25, 2007, 3:06 AM

Post #10 of 10

Shortcut

Re: [qix] Category Problems Links 3.2.0 In reply to

Hi,

Mmm.. odd - if its building a lower-case "audio" folder, then I would have expected to see it in the Full_Name field.

Are you sure that folder isn't just an old one, that isn't being used any more?

Cheers

Andy (mod)
andy@ultranerds.co.uk