Hey guys...
It's been along time since I've been to visit... Links SQL 2.0.4 has been serving us well... As an e-commerce platform of all things. Go figure.
I'm hoping someone thats been in this for the long haul can offer up some quick advice, maybe something like this has happened in the past and I can be pointed in the right direction....
Anyways we've recently had an SQL server issue that fowled up our Links.db (or Products.db in our case). We did a restore of the corrupted database from a backup... and everything seems fine... Except when using the admin browser. Our category tree shows up fine, we're able to browse the tree... but no links (products) show up in any of the categories or sub-categories.
The CatLinks table looks fine, and appears to be properly populated... I never really dove that hard into the browser part of the admin and really don't know what else might make nothing appear in the browser tree.... If I go to the editor, and LIST ALL, it lists all of the links (products), and the proper categories for each after each record...
Unfortunately the store templates were all written hard coded... Dynamic mode unfriendly.... so I can't tell if that portion of the software is picking up the links (products).
We use browser to edit our items regularly... and I'm pretty concerned about doing a rebuild... I really don't want to see our store vanish if the nph-build routine doesn't pick up the links (products) either.
I tried adding a link (product) to see where it would show up in the tree... but it doesn't seem to be functioning properly... Now we don't do that alot and I don't remember if there were issues with that functionality before this issue started... or not...
Any advice where to look progmatically or if there is anything in particular that is known that can cause this issue, please throw out your best guesses... I need this resolved....
Thanks in advance....
AlexJ
It's been along time since I've been to visit... Links SQL 2.0.4 has been serving us well... As an e-commerce platform of all things. Go figure.
I'm hoping someone thats been in this for the long haul can offer up some quick advice, maybe something like this has happened in the past and I can be pointed in the right direction....
Anyways we've recently had an SQL server issue that fowled up our Links.db (or Products.db in our case). We did a restore of the corrupted database from a backup... and everything seems fine... Except when using the admin browser. Our category tree shows up fine, we're able to browse the tree... but no links (products) show up in any of the categories or sub-categories.
The CatLinks table looks fine, and appears to be properly populated... I never really dove that hard into the browser part of the admin and really don't know what else might make nothing appear in the browser tree.... If I go to the editor, and LIST ALL, it lists all of the links (products), and the proper categories for each after each record...
Unfortunately the store templates were all written hard coded... Dynamic mode unfriendly.... so I can't tell if that portion of the software is picking up the links (products).
We use browser to edit our items regularly... and I'm pretty concerned about doing a rebuild... I really don't want to see our store vanish if the nph-build routine doesn't pick up the links (products) either.
I tried adding a link (product) to see where it would show up in the tree... but it doesn't seem to be functioning properly... Now we don't do that alot and I don't remember if there were issues with that functionality before this issue started... or not...
Any advice where to look progmatically or if there is anything in particular that is known that can cause this issue, please throw out your best guesses... I need this resolved....
Thanks in advance....
AlexJ
Crazy 2.0.4 question - need some old timers advice.....