Studio - One to Many Relationship linking Products to Opportunities

👨‍💻 Development Help
1

Hello all,

I have a clean install of SuiteCRM using Bitnami and AWS.

I am trying to use the Studio to add a One To Many Product relationship under Opportunities, but I get the following response “An error has occurred” (screenshot- https://imgur.com/HIgaJju)

I have read that linking Products to Opportunities is possible in this way.

Does anyone have any suggestion as to what the problem may be?

Many thanks.

2

Log file is showing the following;

Error creating table: opportunities_aos_products_1_c Query Failed: CREATE TABLE opportunities_aos_products_1_c (id varchar(36)  NOT NULL ,date_modified datetime  NULL ,deleted bool  DEFAULT '0' NULL ,opportunities_aos_products_1opportunities_ida varchar(36)  NULL ,opportunities_aos_products_1aos_products_idb varchar(36)  NULL  , PRIMARY KEY (id),   KEY opportunities_aos_products_1_ida1 (opportunities_aos_products_1opportunities_ida),   KEY opportunities_aos_products_1_alt (opportunities_aos_products_1aos_products_idb)) CHARACTER SET utf8 COLLATE utf8mb4_unicode_520_ci: MySQL error 1253: COLLATION 'utf8mb4_unicode_520_ci' is not valid for CHARACTER SET 'utf8'

I’ve not touched the database, so configuration utf8 settings are default. Why would this be a problem?

3

Did you try to create any other relationship?

4

Yes, I attempted some other relationships after I made this post - No other relationship can be made either!

This Bitnami install might not be working properly.

5

Maybe the DB user you used is not allowed to create tables

6

Pardon, now I see better the log and I see that the collation is not valid…

7

I will alter the db table collation on Monday.

I was going to spin up another Bitnami SuiteCRM install to see if the same problem occurs, as I’ve spent a good amount of time modifying this SuiteCRM site now and it’s frustrating to get to this stage and find this problem.

8

Just to update and close this thread.

The previous bitnami image (SuiteCRM 7.10.2) was set to the incorrect collation by default.

I tried the latest bitnami image (SuiteCRM 7.10.4) which nows runs on the correct mysql collation, so I can now create relationships.

1 Like