10 years ago
Topic

Hey guys,

I'm getting a SQL error (1146 Table 'bc-joomla-2014b.hxm2v_cck_store_join_introtext' doesn't exist SQL=INSERT IGNORE INTO hxm2v_cck_store_join_introtext VALUES (6, 5) ) when saving an article on the admin form that has a Article Related field in a fieldx. Does anyone known if this is a know issue?

Thanks.

Get a Book for SEBLOD
9 years ago
0
Level 1

Hi Dazza,

I have the same issue with Group X and Article Related. I got "Error: 1146 Table dbname.abcd_cck_store_join_properties' doesn't exist SQL=DELETE a.* FROM abcd_cck_store_join_properties AS a WHERE a.id = 252". I hope someone a way to solve this problem or some work around. These two would make a very powerfull combination.

Regards,

Richard

45 Posts
Sven
7 years ago
0
Level 1

Hello,

I sometimes have the same issue. It happens if my field X or group X contains an related article. But as I mentioned: It only happens sometimes and I can't figure out why it does sometimes work. The storage settings for the field X / group X: are always the same: Custom > Article > fieldname

I hope someone can help us. 

Regards
Sven

4229 Posts
Kadministrator
7 years ago
1
Level 1

Most likely your storages are not set correctly for GroupX and fields inside group, you should not use introtext in any of those fields:

https://www.seblod.com/resources/extensions/plug-ins/group-x-field

Same goes for FieldX

https://www.seblod.com/resources/extensions/plug-ins/field-x


45 Posts
Sven
7 years ago
0
Level 2

Dear Klas, thanks for your reply.

As I mentioned in my last post, I don't use the introtext for storage. My storage is set to "Custom > Article > fieldname" and I have the same issue.

Regards
Sven

4229 Posts
Kadministrator
7 years ago
1
Level 1

Hi,

if possible try to find a way to reproduce this problem

45 Posts
Sven
7 years ago
0
Level 2

Hi Klas,

I reproduced this issue with a fresh joomla / seblod / related article field installation:

  1. For testing I edited the default "Article" Form & Content-Type
  2. Create a field "Related Article" (Joomla! Article) - It makes no difference if I set this fields storage to None or if I use its default storage settings
  3. Create a field "Related Articles" (Field X) - I entered "related_article" in the field "Field". I used as storage "Custom > Article > related". 
  4. I only display the field X within my form. If I save the article I get the Error 1146 warning.
  5. The data itself seems to be correctly stored.

The strange thing is, that I have a Content Type on my live-site where it works well. But within the same installation I get this error for a similar set up Field X / Group X.

Sven

4229 Posts
Kadministrator
7 years ago
1
Level 1

I can't reproduce this if I set storages as described in the tutorial. 

Which is not the same as your setup - article related storage should NOT be empty or default, it should be custom-article-fieldxname[article_related_name] (with fieldX storage set to custom-article-fieldxname )

Please note that you need to create new field to have storage successfully set, if you change it e.g. from None to something else it won't work correctly. Also take care that you don't include aritcle related field anywhere in the form&content type, you should only use fieldX (with reverse being true on searches)

45 Posts
Sven
7 years ago
0
Level 2

Hi Klas,

thank you for you answer and your support! This solves my isse: If I change the storage of the related article field the way you described it works. 

Sven

Get a VIP membership