Keyword

can't accesss items area - sql error 1191

  • Mark Landry
  • Mark Landry's Avatar Topic Author
  • Offline
  • New Member
More
9 years 2 months ago - 9 years 2 months ago #140259 by Mark Landry
can't accesss items area - sql error 1191 was created by Mark Landry
Hi,
Using the latest k2 and Joomla 3.0
I was in administrator > components > k2 > items and typed something in the search field.

I now get this error when attempting to access the items area:

1191 Can't find FULLTEXT index matching the column list SQL=SELECT COUNT(*) FROM cvyse_k2_items AS i WHERE trash=0 AND MATCH( title ) AGAINST ('+events*' IN BOOLEAN MODE)


edit - can't use the search filter at all without getting this error

Thanx for your help
Last edit: 9 years 2 months ago by Mark Landry.

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

  • Mark Landry
  • Mark Landry's Avatar Topic Author
  • Offline
  • New Member
More
9 years 2 months ago - 9 years 2 months ago #140265 by Mark Landry
Replied by Mark Landry on topic can't accesss items area - sql error 1191
Now anything I try to access in the admin area gives me a 404 - this has happened multiple times over the past six months and i can't get any help on this forum.

I made a database backup before this happened, restored the db but it's not working.

I need you guys to please look at my files, me db, something to help. deadline is today and admin area is doa.

Thank you for your help

Edit - must have been a caching thing? waited about an hour, then re uploaded the good db and things are working again... any idea what's causing this? Also, sorry for my tone above, freaking out a bit over here...
Last edit: 9 years 2 months ago by Mark Landry.

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

More
9 years 2 months ago #140307 by Lefteris
Replied by Lefteris on topic can't accesss items area - sql error 1191
Hi,

The latest K2 does not include this kind of query. So you are either not using the latest version or a third-party plugin is making this query.

JoomlaWorks Support Team
---
Please search the forum before posting a new topic :)

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


Powered by Kunena Forum