Keyword

Field "fulltext" in table "jos_k2_items" can't ..

  • vienleuy
  • vienleuy's Avatar Topic Author
  • Offline
  • New Member
More
12 years 9 months ago #61153 by vienleuy
Hi all,
I made 1 component :
have sql:
INSERT INTO `#__k2_items`(title,introtext,created_by)VALUES('{$title}','".$content."',62)";
OK. it's save in database table "#__k2_items": OK.
But change sql : introtext -> fulltext:
INSERT INTO `#__k2_items`(title,fulltext,created_by)VALUES('{$title}','".$content."',62)";
It's not save database. :(
Please everyone help me,

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

  • Aristos Aristodemou
  • Aristos Aristodemou's Avatar
  • Offline
  • New Member
More
12 years 9 months ago #61154 by Aristos Aristodemou
Replied by Aristos Aristodemou on topic Re: Field "fulltext" in table "jos_k2_items" can't ..
i think you must have first fill in the introtext and then fulltext. Try put bith values and let me know if it works.

INSERT INTO `#__k2_items`(title,introtext,fulltext,created_by)VALUES('{$title}',',"intro",".$content."',62)";

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

  • vienleuy
  • vienleuy's Avatar Topic Author
  • Offline
  • New Member
More
12 years 9 months ago - 12 years 9 months ago #61155 by vienleuy
Thank Aristodemou Aristos,
I did it your way, but failed. Failed to save the table jos_k2_items be.
Now, I would like to be presented more clearly.
The Field of jos_k2_items table like this:
jos_k2_items:
jos_k2_items:


......
In my components , have sql:
$query="INSERT INTO `#__k2_items`(title,alias,catid,published,introtext,created_by)VALUES('title','tie-ude',1,1,'text tom tat',62)";
when:
$db->setQuery($query);
$db->query();
the OK. Save to table jos_k2_items.
But if change $query -> $query="INSERT INTO `#__k2_items`(title,alias,catid,published,introtext,fulltext,created_by)VALUES('tieu de','tie-ude',1,1,'text tom tat','text chi tiet',62)";
not save table jos_k2_items; :(
Generally speaking , when have "fulltext" then not save tables.
haven't "fulltext" then ok, save to table.
Not understand.
I think field "filltext" have problems.
Do not know what to do before.
Aristos Aristodemou and everyone help me.

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

  • Aristos Aristodemou
  • Aristos Aristodemou's Avatar
  • Offline
  • New Member
More
12 years 6 months ago #61156 by Aristos Aristodemou
Replied by Aristos Aristodemou on topic Re: Field "fulltext" in table "jos_k2_items" can't ..
Why you need to save data on fulltext? I try to find a way but i can't.

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

More
12 years 2 months ago #61157 by applied
I also have the same problem, data is not getting insert to the fulltext filed . do you find the solution if so please let me know . thnaks

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


Powered by Kunena Forum