Where are my categories?

[Daniel Svanda]

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]

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]

Great JOB! Thank you! Now is problem solved! :dance2:

[Greg]

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]

Hi there,

I meant
You should replace in that query

{prefix} to dir_

for example.

Hope it helps.

[bunny]

But why does it do that in the first place, its like it makes phpmyadmin useless.

[Dave Baker]

@ 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.