[Solved] Category view empty

More
12 years 10 months ago - 12 years 9 months ago #35199 by SteP
In my test website I have tried to upgrade from version 2.0.0-r1648 to 2.0.1 - r1659
All seems to work smoothly, except for every Category view: the items previously showing in each category disappeared. I have tried to change some settings, but I can't have items showing up again. I use a custom template, based on a previous FX version, but still working in r1648.
Could you please address me to locate the settings/changes I must do to get items listing in category working again?
Thank you in advance

_________________________________________
MMC Edizioni - www.mmcedizioni.it
Website Developer & Graphics
Last edit: 12 years 9 months ago by SteP.

Please Log in or Create an account to join the conversation.

More
12 years 10 months ago #35210 by ggppdk
Replied by ggppdk on topic [Solved] Category view empty
The only change in v2.0.1 for category view is the added use of Access Level of Content Types (the setting was always there but was not used)

Either
1. some of your content Type have non-public Access e.g. registered
2. or the category view query is broken in some cases

Please check number 1 , and post back

Note that for v2.0.1a , i improved/fixed category view queries regarding Access Levels of Content Types and added them to other views too


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star review. Thanks!

Please Log in or Create an account to join the conversation.

More
12 years 10 months ago #35229 by SteP
Replied by SteP on topic [Solved] Category view empty
It seems that content has regurarly assigned to public.
What I can't get displayed is not the item content, but the item listing in category view.
As sample, this is the page showing item list in previous version FC:
www.mmcedizioni.it/it/hanno-detto-di-noi.html
After upgrading, the same page does not show anything but the text "No items available for this category"

More, if now I try to edit an item and then to save it, I get this error:

saveFields(): SQL QUERY ERROR:
Table 'db-name.j25mmc_flexicontent_advsearch_index' doesn't exist SQL=INSERT INTO j25mmc_flexicontent_advsearch_index VALUES ( 6,10,0,'Fiera Internazionale del Libro (Torino)','0')

_________________________________________
MMC Edizioni - www.mmcedizioni.it
Website Developer & Graphics

Please Log in or Create an account to join the conversation.

More
12 years 10 months ago #35231 by ggppdk
Replied by ggppdk on topic [Solved] Category view empty
Table does not exit ??

Was the installation of v2.0.1 interrupted? (Did it finish successfully?)

Please do this:
-- re-install FC v2.0.1 (without uninstalling)


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star review. Thanks!

Please Log in or Create an account to join the conversation.

More
12 years 10 months ago #35234 by SteP
Replied by SteP on topic [Solved] Category view empty
Reinstalled again, but still the same message when trying to edit, and then save, an item.
No error messages when installing latest version (obviously without uninstalling previous one)

_________________________________________
MMC Edizioni - www.mmcedizioni.it
Website Developer & Graphics

Please Log in or Create an account to join the conversation.

More
12 years 10 months ago #35236 by ggppdk
Replied by ggppdk on topic [Solved] Category view empty
1. Please go to phpmyadmin and check if it reports any corrupted tables and repair them

2. if flexicontent_advsearch_index DB table is missing please execute the following in phpmyadmin

REPLACE #__ with your Joomla DB Prefix
Code:
CREATE TABLE IF NOT EXISTS `#__flexicontent_advsearch_index` ( `field_id` int(11) NOT NULL, `item_id` int(11) NOT NULL, `extraid` int(11) NOT NULL, `search_index` longtext NOT NULL, `value_id` varchar(255) NULL, PRIMARY KEY (`field_id`,`item_id`,`extraid`), KEY `field_id` (`field_id`), KEY `item_id` (`item_id`), FULLTEXT `search_index` (`search_index`), KEY `value_id` (`value_id`) ) ENGINE=MyISAM CHARACTER SET `utf8` COLLATE `utf8_general_ci`;


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star review. Thanks!

Please Log in or Create an account to join the conversation.

More
12 years 10 months ago #35238 by SteP
Replied by SteP on topic [Solved] Category view empty
Table was really missing (also in previous version). Executed the query and added the table.
Now edited item has been correctly saved.

Now it remains for me to understand what makes the items list no more showing up in every category views....

_________________________________________
MMC Edizioni - www.mmcedizioni.it
Website Developer & Graphics

Please Log in or Create an account to join the conversation.

More
12 years 10 months ago #35239 by ggppdk
Replied by ggppdk on topic [Solved] Category view empty
Hello,

please send me a PM with admin login

and with
1. link to frontend category view
2. category id


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star review. Thanks!

Please Log in or Create an account to join the conversation.

More
12 years 10 months ago #35240 by ggppdk
Replied by ggppdk on topic [Solved] Category view empty
You said you have this in localhost

What is your server setup

- Joomla version
- Operating System
- apache, PHP , mysql versions

?


-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star review. Thanks!

Please Log in or Create an account to join the conversation.

More
12 years 10 months ago #35260 by SteP
Replied by SteP on topic [Solved] Category view empty
Those ones are my current local settings (running on Windows 8):
PHP attivo su Windows NT STEFANO-PC 6.2 build 9200 (Unknow Windows version Business Edition) i586
Versione database 5.5.28
Collation database utf8_general_ci
Versione PHP 5.3.21
Web Server Apache/2.2.21 (Win32) mod_fcgid/2.3.6 mod_ssl/2.2.21 OpenSSL/1.0.0e
WebServer interfaccia PHP cgi-fcgi
Versione di Joomla! Joomla! 2.5.9 Stable [ Ember ] 4-February-2013 14:00 GMT
Versione piattaforma Joomla! Joomla Platform 11.4.0 Stable [ Brian Kernighan ] 03-Jan-2012 00:00 GMT
User Agent Mozilla/5.0 (Windows NT 6.2; WOW64; rv:19.0) Gecko/20100101 Firefox/19.0

_________________________________________
MMC Edizioni - www.mmcedizioni.it
Website Developer & Graphics

Please Log in or Create an account to join the conversation.

Moderators: vistamediajoomlacornerggppdk
Cookies user preferences
We use cookies to ensure you to get the best experience on our website. If you decline the use of cookies, this website may not function as expected.
Accept all
Decline all
Essential
These cookies are needed to make the website work correctly. You can not disable them.
Display
Accept
Analytics
Tools used to analyze the data to measure the effectiveness of a website and to understand how it works.
Google Analytics
Accept
Decline
Save