Сообщений в теме: 10

[seabusch]

Hello,

 

during the last week i tried zu migrate my 2.5.18 joomla website to 3.2.2 - that wont work - so I decide to generate a new application and integrate the contents during export and import function.

 

Now I am done - in the first moment very happy - but then i noticed, that every time i try to filter the content with the jbzoo search list, there there are only error messages...

 

I think - the error must be generated by checkbox elements and/or select elements... 

 

..............

 

1054 Fehler: 1054 Unknown column 'tIndex.e_3853916faee54ffeb4443ee743ead803_s' in 'where clause' SQL=SELECT tIndex.e_5293052dd5e7413c967b953fa35281a9_s AS value, tIndex.e_5293052dd5e7413c967b953fa35281a9_s AS text, COUNT(tIndex.e_5293052dd5e7413c967b953fa35281a9_s) AS count FROM XXX_zoo_item AS tItem INNER JOIN XXX_zoo_jbzoo_index_destination AS tIndex ON tIndex.item_id = tItem.id WHERE tItem.access IN (1,2,3,6,7,9,10,11,13,14,16,17,18,19,20,21) AND tItem.state = '1' AND (tItem.publish_up = '0000-00-00 00:00:00' OR tItem.publish_up <= '2014-03-19 11:27:34') AND (tItem.publish_down = '0000-00-00 00:00:00' OR tItem.publish_down >= '2014-03-19 11:27:34') AND tItem.searchable = '1' AND tItem.type = 'destination' AND tItem.application_id = '1' AND tIndex.e_5293052dd5e7413c967b953fa35281a9_s <> "" AND tIndex.e_5293052dd5e7413c967b953fa35281a9_s IS NOT NULL AND tIndex.e_3853916faee54ffeb4443ee743ead803_s = 'Familienurlaub' GROUP BY tIndex.e_5293052dd5e7413c967b953fa35281a9_s

.............................................

perhaps, someone can help me with that, i am totally devastated

[Sliapy]

What versions of Jooma, Zoo, JBZoo do you use?

 

Did you try to make the Database re-index and cleaning?

 

[seabusch]

I use 

 

Joomla: 3.2.3     JBZoo: 2.1.2 Pro     Zoo: 3.1.6     WidgetKit: 1.4.7

 

and yes, after your post i tried the database re-index and cleaning!

 

But the error still exists...

 

By the way you will find the error if you go to

 

http://test.travel-c...en-haeuser.html

 

and press one of the sidebar-b options...

[SmetDenis]

Hello seabusch,

 

I think, your database is corrupted, but I don't know why

 

Please, can you give me temporary ftp access for your website ?

I would like to see structure of your website.

 

Thanks.

Best regards

[seabusch]

how I can send the data to you, that nobody but you can see the access data...

[SmetDenis]

how I can send the data to you, that nobody but you can see the access data...

 

Hi,

 

You can send it via forum's private messages

 

I promise you that private messages no one will see.

 

Thanks.

[seabusch]

Ok,

 

seems to work again...

can you tell me, what the problem was?!

For the next site with similar configuration...

 

Thank you...

[SmetDenis]

Hello,

 

I found mistake, which appeared only your website.

File media\zoo\applications\jbuniversal\framework\helpers\jbfilterprops.php was fixed

 

This fix will include in future JBZoo version.

[seabusch]

I dont know, if the problem relates to the former problem,... 

 

but if i try to choose accordion style in the jbzoo search list - it is not working any more.

 

I can use the default style, but if i try to set the module to accordion, only the first tap is shown in the module - and no tab title...

 

http://test.travel-c....de/wohnen.html

 

Now in tab 1 i put the element "item category" in...

 

The other tabs:

Land

Ferienregion Deutschland

Ferienregion Österreich

Barrierefreies Wohnen

Markieren Sie die zutreffenen Punkte für die Schnellsuche

max. Belegung

Anzahl Schlafzimmer

 

are not shown...

Сообщение отредактировал seabusch: 26 March 2014 - 14:00

[seabusch]

ah,.. i sent the ftp access to you last time - title "ftp-user" or something like that...