151 Posts
pixelpixel
11 years ago
12
Topic

Hi everyone,

when i try to duplicate a related article field with fieldx i get these error after saving my article:

1146 Table 'joomla303.geg6l_cck_store_join_introtext' doesn't exist SQL=DELETE a.* FROM geg6l_cck_store_join_introtext AS a WHERE a.id = 5 

It still works, so i get my related article fields in the frontend and it is also saved in my article but everytime i save it again or save a new article, the error above appears.

Tested with Joomla 3.0.3 and Seblod 3.0.4.

With 2.5.10 and Seblod 3.0.4 it seems to work without any problems.


Kind regards

pixelneco


Get a VIP membership
11 years ago
0
Level 1

Hello,

Try to recreate the xfield... Looks like the it did not create the proper database column on the table.

215 Posts
iliil
11 years ago
0
Level 1

hello

I have the same problem here. I tried to recreate the x field (even the related article field) but no luck.

still:

1146 - Table 'freesam.jos_cck_store_join_introtext' doesn't exist SQL=DELETE a.* FROM jos_cck_store_join_introtext AS a WHERE a.id = 9

Seblod 3.1.3 - Joomla! 3.1.1 Stable

Thanks for possible help

Best Regards

Michal


11 years ago
0
Level 1

Got the same problem:

1146 Table 'jstev.y9icl_cck_store_join_products' doesn't exist SQL=DELETE a.* FROM y9icl_cck_store_join_products AS a WHERE a.id = 13 

Joomla 3.1.1 

Seblod 3.1.1 

Dont know how to fix that problem.

The article will be created and everything would be stored - any solution for that?

Thanks in advance & best regards

Sebastian

151 Posts
pixelpixel
11 years ago
1
Level 1

Hi Folks,


good to know that i am not alone with this issue :) Seblod/ Joomla is complaining about a missing table? So i give it a table hahahah. I created one manually so it stopped complaining. But i dont have the slightest idea how my "solution" will effect the system :)


Kind regards

pixelneco

11 years ago
0
Level 2

Hi Pixelneco,

yepp that sounds interesting - but where the hell does seblod/ joomla store it at the moment - and is it a bug, would it be fixed... or do we have to do a such a workaround (create the table manually)...

251 Posts
Viktor Iwan
11 years ago
0
Level 1

"joomla303.geg6l_cck_store_join_introtext"... introtext supposed to be in #__content.. not in additional table.. are you sure you set the right storage location ?

151 Posts
pixelpixel
11 years ago
1
Level 1

Hi,


@Viktor

storage of my FieldX is custom|article|introtext so i did not change it. But thanks i guess i fixed it :)


@ michalmarianek and s16f

could you please try this: do not put the "original" Article Related Field in your form. Just the Fieldx field, which references to your related field. For me it works now. So creating an additional table is of course nonsense :D


Kind regards


11 years ago
0
Level 2

Hi pixelneco,

you got it it - tried your solution with fieldX for the related Article and it helped - no failure on saving my GroupX Article anymore.

Thanks a lot :)

Have a nice weekend

Kindly regards

Sebastian

151 Posts
pixelpixel
11 years ago
0
Level 1

OK a little update:


Solution was not to remove the article related field as i mentioned above, but changing the storage of this field to custom|article|introtext. This was the step i have done before but thought that it has no effect.

215 Posts
iliil
11 years ago
0
Level 1

Thanks pixelneco and everybody!

It's great how this formum works!

michal

151 Posts
pixelpixel
11 years ago
0
Level 1

Hi Griiettner

i am getting the same error after recreating fieldx. Is there maybe something wrong with the storage-settings of my fieldx? I am using the default settings custom|article|introtext

Kind regards

pixelneco

11 years ago
0
Level 1

Hi

we had a number of problems with J and S in v3.0 when upgrading from j2+

once went to J and S 3.1.1 most solved.

if did not update seblod then joomla was also getting some problems with 3.1.1

one problem have to look at is when disabling/enabling articles in admin with 3.1.1 produces missing table message when done from article list, if do within article all is OK

have not tried duplicating article yet.

Get a VIP membership