PDA

View Full Version : Where are my categories?


Daniel Svanda
12-20-2006, 09:07 AM
Hello,
I am just upload files and database of script on server from my localhost. But as soon as I put URL of my page into browser, I was very supprised, becouse I do not see nothing categories... Categories are in database, I am check it with myadmin if are in database. In admin pannel I see them too. But on front page categories are not here... :(
I realy do not know where can by problem.... Have a look on my page:
http://www.1shopy.cz/
Please can hepl me!
Best regards! Rodman

John Turner
12-20-2006, 09:26 AM
Hello Daniel Svanda,

Please try this query via Admin Panel » Manage Database » SQL Management

UPDATE `{prefix}categories` SET `id` = '0' WHERE `title` = 'ROOT'


Don't forget to change {prefix} to correct value of your prefix for eSyndiCat tables.

It might helps.

Daniel Svanda
12-20-2006, 08:12 PM
Great JOB! Thank you! Now is problem solved! :dance2:

Greg
12-20-2006, 10:37 PM
Hello Daniel Svanda,

Please try this query via Admin Panel » Manage Database » SQL Management

UPDATE `{prefix}categories` SET `id` = '0' WHERE `title` = 'ROOT'


Don't forget to change {prefix} to correct value of your prefix for eSyndiCat tables.

It might helps.

Stupid question. :blink: When adding the "correct value of your prefix for eSyndiCat tables" do I use the {} thingies? And put the value between them. Or just in my case use "dir_"

Thanks :)

John Turner
12-21-2006, 05:08 AM
Hi there,

I meant
You should replace in that query

{prefix} to dir_

for example.

Hope it helps.

bunny
01-06-2007, 12:37 AM
But why does it do that in the first place, its like it makes phpmyadmin useless.

Dave Baker
01-07-2007, 12:18 AM
@ bunny
It enables to use Admin Panel » Manage Database » Import to all users without dependence from their prefix (users should not make changes in a sql file). " {prefix} " will be automatically replaced with a prefix used in their database.