- Posts: 2
COMMUNITY FORUM
Field "fulltext" in table "jos_k2_items" can't ..
- vienleuy
- Topic Author
- Offline
- New Member
Less
More
12 years 9 months ago #61153
by vienleuy
Field "fulltext" in table "jos_k2_items" can't .. was created 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,
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
- Offline
- New Member
Less
More
- Posts: 12
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)";
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
- Topic Author
- Offline
- New Member
Less
More
- Posts: 2
12 years 9 months ago - 12 years 9 months ago #61155
by vienleuy
Replied by vienleuy on topic Re: Field "fulltext" in table "jos_k2_items" can't ..
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.
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
- Offline
- New Member
Less
More
- Posts: 12
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.
- applied
- Offline
- New Member
Less
More
- Posts: 5
12 years 2 months ago #61157
by applied
Replied by applied on topic Re: Field "fulltext" in table "jos_k2_items" can't ..
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.