Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Category Problems Links 3.2.0

Quote Reply
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
Quote Reply
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
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] 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
Quote Reply
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
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] 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
Quote Reply
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
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] 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
Quote Reply
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
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] 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
Quote Reply
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
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!