Search Results - Searched for: K2 Database Structure

29 Sep 2014 11:56
mohammad

Re: Not installed K2 1 month 4 weeks ago

Hi

When I'm Import database, the following error is displayed:



--

--
-- Table structure for table `floyd18_k2_items`
--

CREATE TABLE IF NOT EXISTS `floyd18_k2_items` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) NOT NULL,
`alias` varchar(255) DEFAULT NULL,
`catid` int(11) NOT NULL,
`published` smallint(6) NOT NULL DEFAULT '0',
`introtext` mediumtext NOT NULL,
`fulltext` mediumtext NOT NULL,
`video` text,
`gallery` varchar(255) DEFAULT NULL,
`extra_fields` text CHARACTER SET...
17 Jun 2014 17:14
Marc Wensauer
Hello,
I have the following setup:

K2:
category
... ProducerA
... ProducerB

I have some Extra fields and I am trying to filer the products with JA K2 Search which I bought some days ago.

As far as I hit the search button I gt such ugly URL:
capesideport.de/component/jak2filter/?Itemid=114&theme=ja_k2filter&isc=1&ordering=alpha

Any idea how to remove "component/jakfilter"?

Some thing else:
The search Result Item Links look even more confuse, eg::...
24 May 2014 14:27
shoulders
Sylvias wrote:
Lefteris, Thank you, but if you don't mind, allow me one more question.

To each of the above mentioned k2 tables that would not convert to InnoDB i did the following in phpMyAdmin:

1 - I chose the K2 table >> "Structure" >> "+ Indexes"
2- I dropped all "FULLTEXT" indexes types.
3- Under "Operations" I was now able to change database table from MyISAM to InnoDB

So now all k2 tables are InnoDB and k2 is working great!

My, question, does it look like all is good with what i did?

I am not a...
20 May 2014 10:20
dtronvig
I might easily be confused, but it seems that when a K2 Item is set to Show Extra Fields, then at least in item.php the extra_fields show up in the K2ViewItem Object in a form like:
[extra_fields] => Array
(
  [1] => stdClass Object
  (
     [id] => 2
     [name] => Image URL
     [value] => images/Music/BBKingMontreaux360x540.jpg
     [type] => textfield
     [group] => 1
     [published] => 1
     [ordering] => 2
     [alias] => ImageURL
  )
  .
  .
  .
but when a K2 Item is set...
07 May 2014 09:24
Individual IT
Hi the format "Gold,Teal,Purple" should be fine.
Thank you for the screen-shots. But the items I can see in k2_extra_fields are all of the type textfield and before you were talking about multi select fields
And I see that you have extra tables that I don't have. That might be because of the k2fields extension. If this extension changes the database structure my tool will not be able to export/import correctly.
24 Apr 2014 03:40
Sylvias
Lefteris, Thank you, but if you don't mind, allow me one more question.

To each of the above mentioned k2 tables that would not convert to InnoDB i did the following in phpMyAdmin:

1 - I chose the K2 table >> "Structure" >> "+ Indexes"
2- I dropped all "FULLTEXT" indexes types.
3- Under "Operations" I was now able to change database table from MyISAM to InnoDB

So now all k2 tables are InnoDB and k2 is working great!

My, question, does it look like all is good with what i did?
Displaying 1 - 6 out of 6 results.

Who Is Online

Total users online: 21 Members and 8284 Guests Online
Caroline Gallagher Charlie taillard Emanuel Caminos Fedelo Giorgos Gazepidis Jaider José Mengual John Roy Lefteris Luca Morè Michael Skagen Morrice Blackwell MuART Orhan Koçdemir Paul Shawn Scanlan Steven Trooster Ted Troy Stanley al1 krtrueske sadegh
Legend ::   Site Administrator Global Moderator Moderator Banned User Guest
  • Total Messages: 134492 | Total Subjects: 36679
  • Total Sections: 4 | Total Categories: 26
  • Today Open: 4 | Yesterday Open: 11
  • Today Total Answer: 26 | Yesterday Total Answer: 54
Powered by Kunena Forum