Joomla URL Rewriting Issues

[joseya]

I apologize if this has already been solved, I couldn't find anything in the forum that quite matched this. I am finally upgrading a joomla 2.5 site to 3.3. I have the same settings that I had in 2.5, but when I turned on the url rewrite in the joomla global configuration, the phocagallery will not work past the categories view. When I try to click into a category i get a "1054 - Unknown column '3commercial' in 'where clause' SQL=SELECT parent_id FROM we3x9_categories WHERE id=3commercial" error. Before I turned on the url rewrite, everything worked great going into the category and playing the slideshow. I'm wondering if the database was created based on the settings before url rewrite was turned on... now that I have turned it on, the phocagallery sql entries are now incorrect? I need a little direction to get this up and running like it was on 2.5. Thanks.

[Jan]

Hi, this SQL is not a Phoca SQL. Phoca Gallery does not ask Joomla! categories table (we3x9_categories), so this is some error e.g. in some plugin (maybe system), maybe in some module or template

Jan

[joseya]

Hi, this SQL is not a Phoca SQL. Phoca Gallery does not ask Joomla! categories table (we3x9_categories), so this is some error e.g. in some plugin (maybe system), maybe in some module or template

Jan

It is a phoca sql, we3x9_categories is just the sql for categories on my current site... but I found the fix. For some reason, when I clicked on the url rewrite... after I had already setup phoca gallery, that messed something up. I was only using the native joomla install for that, no 3rd party. So, I uninstalled phocagallery, then reinstalled... after I have already done the url rewrite. Now it works!

[joseya]

I am wrong... it did not fix the problem... After I reinstalled, it seemed to have fixed the problem because I could enter a category and view all the images... I did notice that when I went into the category, the breadcrumbs would not have "Gallery" listed, it would only have "Home". So basically the categories page was bypassed in the breadcrumb. So, I went to the menu and noticed that phoca gallery was still attached to the menu, but it had a red "x" in the status as if it was unpublished, so I went into it, and re saved the menu item. After I did that, I got the same error I was getting yesterday. Attached is a screen shot of the entire error. If you have any ideas, please help...
https://picasaweb.google.com/1070443548 ... directlink

[Jan]

Hi, as written above, you can get this error on Phoca Gallery page but it does not come from Phoca Gallery.

When Phoca Gallery is displayed, in the same time: system plugins, modules and templates are rendered too. Phoca Gallery does not have any SQL query which ask Joomla! categories table, see the difference:

In Phoca Gallery, there is Phoca Gallery categories table, in your case: "we3x9_phocagallery_categories"
But you get the error in SQL clause which asks standard Joomla! catgories table: "we3x9_categories"

So, you need to find the part which is asking the SQL query - which is asking something from standard Joomla! categories table - even it is on Phoca Gallery page, it is not asked by Phoca Gallery as in the same time, system plugins, modules and template code is running.

So try to disable possible system plugins, modules, etc. or try to check the template (switch to standard) to find, which part ask the categories table

Anyway can you paste the whole screen (including URL bar, to see in which place you get the problem)?

Jan

[joseya]

Jan,

I have posted 2 more pictures that you can access on the previous link I attached. This is a test site for a new company website. If you have any insights on this that will help me, or send me in the right direction, I would like to make a contribution. This is by far the best gallery available, and it is a perfect fit for us. That's why I really really want to get this working. Thanks in advance.

[joseya]

I have added additional images to the same link listed above. Any help is greatly appreciated. Specific instructions would be very helpful. Thanks in advance.

[Jan]

Hi, on the screenshot I see this error:

Unknown column "2bridge" in "where clause" SQL=SELECT parent_id FROM we3x9_categories WHERE id=2bridge-pics

This is not an SQL query from Phoca Gallery:

1) Phoca Gallery does not work with categories table
2) In Phoca Gallery when we ask for ID, we always ask with integer not with string

But see similar posts in this forum. I don't know exactly which plugin (or template) but users who got similar problems - they run some specific system plugin which asks for the categories table and which has some problems.

So you need to detect which plugin makes this query. Check the plugins you have installed (or other users managed this site) and enable debug mode in your Joomla! global configuration - then you will see in debug information which extension makes this SQL query.

This has nothing to do with Phoca Gallery so it is really hard to give you clue advice which extension this can do as nobody here knows which plugins you have installed. But as I wrote, enable debug mode and you should see which part calls this SQL query.

It should be displayed in debug but I think you get error screen where the extension which call this query will be listed - so you can then paste new screenshot with the full debug error here (but please paste it to new post)

Jan

Jan

[joseya]

Jan,

You are a genius. I didn't think it could be a problem with another module as I used the same modules I had on my Joomla 2.5 and everything worked well. Same modules on Joomla 3.3 and I was having issues with the category view. After I read your last post I decided I might as well disable the few modules I have... one at a time. Turns out, when I disable the Flexheader3 module, everything with the PhocaGallery works. Thank you. I will need to use a different header module for my phocagallery pages. This is fixed.

[Jan]

Ok, great to hear it.

Jan