atrocore / atrocore Goto Github PK

Thank you for the wonderful boilerplate, Amazing work.

I have followed the installation guide to install AtroPINE and AtroDAM with demo data, but unfortunately I can see the dump data is not matching the table structure in the database. for example:

INSERT INTO `user` (id,deleted,is_admin,user_name,password,salutation_name,first_name,last_name,is_active,is_portal_user,is_super_admin,title,gender,created_at,default_team_id,avatar_id,created_by_id,email_address,phone_number,portal_id,account_id) ....

**MySQL said**
#1054 - Unknown column 'email_address' in 'field list'

Appreciate, if you please share the latest updated demo data.

Hello,

I have configured atrcore and it is accessible. However mysql is on the same instance and I want to move it to an RDS server.
Is they any place where the steps are documented so that I can make the necessary changes.

Thanks in advance.

Regards
Anil

When I create a sub Asset Category, the Assets in the parent Asset Category are also associated in the sub Asset Category. Can the parent Assets not be made to inherit?

AtroCore v1.4.108
AtroDAM v1.4.6

Hi,
when i try to install atrocore with the following command i have this error:

[RuntimeException]
Could not delete /var/www/coteflux-atrocore-project/vendor/zendframework/zend-stdlib:

Can you help me please ?
Thanks.

Hi,
When I try to add an attribute group to a product family I'm getting a validation error as follows:
Error 400: Validation failed. 'productFamily_name' is required.

I tried to set the "name" field for product family to non-required (just for testing) but I got another error:
Error 400: Validation failed. 'attribute_name' is required.

I tried to create new product family and new attribute group, rebuild the database, clear cache, perform php index.php sql diff --run and php composer.phar restore, but nothing helped.

Hello,
we are struggling to install your project, the composer of php doesn't recongnize some package.
By checking you repository for customer composer.php it doesn't exist.
Could anyone help ?

Hi,
I've installed the "Product Bundles" module. To create a bundled product, in the documentation it says that I should select the "Product Bundle" in the "Product Type" field, but no such field exists. It doesn't list in the fields of the "Product" entity, and also in the layout settings it's missing.

Thanks for your help!

The “Name” field of most entities is usually set as multi-language and required.
When adding a new language for the entities, this new “Name” field is typically empty.
Trying to edit an entity in inline-mode usually throws an error (the toast msg on top of the app) saying something like “'Name / zh_CN' can't be empty” or so.
By using the Mass-Update from the listing, any update fails silently, but I get a success message. It's only obvious in the logs that something went wrong.

I noticed this by using the translation module to mass-translate empty fields, and was wondering why it didn't work (only if there was an entry set in the new language field).

Removing the “required” attribute temporarily allows me to mass-update.

We are adding relationships to products in Atropim for categories. When adding relationships en mass in the product list, the list of available categories displays all leaf categories available (image 1)

When categories are selected in the categories list in the product detail page for the same product which was updated using mass update, the list of available categories is blank (image2)

Following through the install instructions on Ubuntu 18.04

The following command:

sudo git clone https://github.com/atrocore/skeleton-pim-no-demo.git . && php composer.phar self-update && php composer.phar update
Cloning into '.'...
remote: Enumerating objects: 32, done.
remote: Counting objects: 100% (32/32), done.
remote: Compressing objects: 100% (27/27), done.
remote: Total 32 (delta 9), reused 12 (delta 3), pack-reused 0
Unpacking objects: 100% (32/32), done.

Generates this error:

Cannot create cache directory /home/user/.composer/cache/repo/https---repo.packagist.org/, or directory is not writable. Proceeding without cache
Cannot create cache directory /home/user/.composer/cache/files/, or directory is not writable. Proceeding without cache
Failed! The new version of the composer can't be copied. Try to download manually 'https://packagist.atrocore.com/composer/composer.phar'.

I'm confused, any ideas or suggestions are much appreciated.

Thank you.

Originally posted by @baldgzr in #189

After the release of the new release, the system no longer allows for a bulk upload.

AtroDAM v1.5.12
AtroCore v1.6.6

Error from Rebuild database. In data/logs/*.log I see:"
[2023-09-14T07:27:13.150359+00:00] Log.ALERT: Rebuild database fault: PDOException: SQLSTATE[HY000]: General error: 1283 Column 'sku' cannot be part of FULLTEXT index in /var/www/atrocore/vendor/doctrine/dbal/src/Driver/PDO/Connection.php:72
[2023-09-14T07:27:15.863870+00:00] Log.ERROR: API [POST]:/api/v1/Admin/fieldManager/:scope, Params:Array ( [scope] => ProductAsset ) , InputData: {"type":"bool","dynamicLogicVisible":null,"dynamicLogicReadOnly":null,"name":"isMainImageProte","label":"IsMainImageProte","labelRuRu":"IsMainImageProte","tooltipText":null,"tooltipLink":null,"isMultilang":false,"default":false,"audited":false,"readOnly":false,"tooltip":false} - Error while rebuilding database. See log file for details. [] []

What i can do?

Hello
When I have a character for example '--' or '$' as an empty value flag, the import of lists does not work.
For example I have a list field for "Status in ERP", this gets cleared if I use characters for empty value.

I need to use blank value characters if I don't want to import all attributes for all classifications and products.
A classification for a product type can contain 10 attributes, but my import file can contain 50 attributes, then I don't want to get a bunch of empty attributes that have nothing to do with the article.

Hello 👋

I run a security community that finds and fixes vulnerabilities in OSS. A researcher (@deepakkuma24) has found a potential issue, which I would be eager to share with you.

Could you add a SECURITY.md file with an e-mail address for me to send further details to? GitHub recommends a security policy to ensure issues are responsibly disclosed, and it would help direct researchers in the future.

Looking forward to hearing from you 👍

(cc @huntr-helper)

Users are pasting preformatted text from Word and other sources and this always comes with a lot of baggage as we know (mostly inline style attributes, but also useless <div> wrapper etc.)
Pasting with Ctrl+Shift+V helps a bit, but still comes with a lot of crap (like nbsp;)

Summernote WYSIWYG editor has a cleaner plugin https://github.com/DiemenDesign/summernote-cleaner and if AtroCore exposes their config to the AtroCore config and admins were able to tweak that a bit what goes in, that would be wonderful.

    cleaner: {
      keepHtml: true,
      keepTagContents: ['span'], //Remove tags and keep the contents
      badTags: ['applet', 'col', 'colgroup', 'embed', 'noframes', 'noscript', 'script', 'style', 'title', 'meta', 'link', 'head'], //Remove full tags with contents
      badAttributes: ['bgcolor', 'border', 'height', 'cellpadding', 'cellspacing', 'lang', 'start', 'style', 'valign', 'width', 'data-(.*?)'], //Remove attributes from remaining tags
    }

could also help with this part:

Thanks for considering.

Hello.
Then i use field delimiter \t in an export-job, it generates a csv-file with delimiters set to \ not tabb.
Then i try import-job with tabb-delimited file, i get all columns merged in one unused field.

Hi,
I was setting up a template for products (I looked up the EspoCRM example), unfortunately there is some discrepancy with the versions and there is no output.

This pulls in the latest lightncandy version of the 0.x branch (0.95)

And here the file is referenced in all lower case (but it's LightnCandy.php in v0.95 https://github.com/zordius/lightncandy/blob/v0.95/src/LightnCandy.php)

Should I just install 0.22 instead? But I don't want it to be overwritten with the AtroPIM updates :)

Hi,
when i am trying to import categories getting the following error.
An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction.
what is the meaning of this error? and how should i overcome this issue?
Thank you

(Latest version)

Steps to reproduce:

1. Hide right panel in Products view (or any other Entries view)

2. Create New Product (Entry)
3. Main Content area width is not calculated.

This affects all other views, not only Products!

AtroСore: 1.5.80
Ubuntu 20.04.6 LTS

/var/www/my.pim-project# php composer.phar update
or
/var/www/my.pim-project# php composer.phar self-update
or
via Module-Page
nothing works for me. Any idea/
Thanks in advance.

10.08.2023 12:16:08 | Loading composer repositories with package information
10.08.2023 12:16:10 | Creating restore point
10.08.2023 12:16:38 | Updating dependencies
10.08.2023 12:16:46 | Nothing to install or update or delete
10.08.2023 12:16:46 | Generating autoload files
composer/package-versions-deprecated: Generating version class...
composer/package-versions-deprecated: ...done generating version class
10.08.2023 10:16:46 | Clearing cache
10.08.2023 10:16:47 | Done!

Hi,
When i try to install Atrocore,
I face this isssue:

Can you help please.

Apache version: Apache/2.4.53
PHP version: 7.4.29
MySQL version: 10.4.25-MariaDB
Database Charater set : utf8mb4_general_ci
FTP version: 1.0.49
SSH Port: 22778
MySql Port: 3306
Web Servers: nginx-apache

Setting>administration>language> : added language Spanish:spain

logs: /data/logs/atro-2022-05-31.log
[2022-05-31 03:06:11] Log.ERROR: PDO Error: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1' for key 'PRIMARY'. For query 'INSERT INTO locale (id, name, language, date_format, time_zone, week_start, time_format, thousand_separator, decimal_mark) VALUES ('1', 'Main', 'en_US', 'DD.MM.YYYY', 'UTC', 'monday', 'HH:mm', '.', ',')' [] []
[2022-05-31 03:08:51] Log.ERROR: API [GET]:/api/v1/Settings, Params:Array ( ) , InputData: - SQLSTATE[42S22]: Column not found: 1054 Unknown column 'measure.name_es_es' in 'field list' [] []
[2022-05-31 03:08:51] Log.ERROR: Display Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'measure.name_es_es' in 'field list', Code: 42S22 URL: /api/v1/Settings [] []

This issue also existing when add any other language when I tried to install language

The log tells SQLSTATE Maybe is MariaDB not capable for Atrocore, but atrocore installation without any problem

In our case, we do not use en_US as UI language. Instead, we use en_GB and de_DE. With en_GB as default.

First is, there are no translations in Translation table for en_GB it would be nice, if you could provide this.

More of a problem for us is, that you have set en_US as requiered in atrocore/app/Espo/Resources/metadata/entityDefs/Translation.json
This makes it impossible to completely change the UI to en_GB and remove en_US. After doing so, it is impossible to create new labels, because en_US is required.

The simplest solution would be, to remove the required on en_US.
Better solution would be, to set the required language according to the main UI language.

I have the following entity structure:
Entity A (hierarchical):
Item 1 (Top-Level)

• Item 2 (Child-Item)

Entity B (non-hierarchical, normal Entity):
Item 3

Relationship n:m between Entity A and Entity B.

When I create a relationship between Item 1 and Item 3 from Item 1, the relationship is also added via inheritance on Item 2.
In the code this happens after the relationship is created:
$this->createPseudoTransactionLinkJobs($id, $link, $foreignId);

This works absolutely fine and is the expected behaviour.

When I create a relationship between Item 1 and Item 3 on the page from Item 3, the relationship is NOT added via inheritance on Item 2. This is because the method linkEntity in the Record.php is called directly and no createPseudoTransactionLinkJobs is called.

A possible fix would be to also call the createPseudoTransactionLinkJobs if relationships for hierarchical entities are created starting from the foreign non-hierarchical entity.

Hello
I have found that even if you deny (disable) access to export-job, in settings of a role to a user, the user still has access.
Can anyone confirm if there is a bug or what?
My scenario is that i made a role that only has "readonly" access to products, and therefore disabled all 4 related settings to import and export.
All import and export menus and access was disabled as designed, except export-job, is still there in readonly-mode.

I tried to implement associated products into the product layout but found it does not display fields which are "Links" to related entities.

Layout designer:

Missing two fields:

Its not working for either the "out of the box" associated products nor if i rebuild it with an own entity as shown in the screenshots.

Other fields working properly adding them into the layout.

Edit:
It only affects the "List small" layout, others working fine:
List

Details

Fault to rebuild database schema. Details: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'atrocore.attachment' doesn't exist [] []

Hello,
Both Import and Export have this problem.
Amount of Success Export/Import Jobs to be stored is always one more than the setting: "Amount of "Success" Export Jobs to be stored"
If you set it to 1 you get 2 jobs, if it´s set to 10 you get 11.
You can´t set it to 0, so I can´t make it so that only one successful job is left.

Something I´m doing wrong or is there a little bug hiding somewhere?

Hello,
I'm getting an error when I try to generate a PDF using the built-in template (or any other template I tried to create).
In the error log I see this exception thrown:
Uncaught Exception Error: "Call to a member function close() on null" at /public_html/vendor/atrocore/pdf-generator/app/Services/ChromeBrowser.php line 131 {"exception":"[object] (Error(code: 0): Call to a member function close() on null at /public_html/vendor/atrocore/pdf-generator/app/Services/ChromeBrowser.php:131)\n[previous exception] [object] (RuntimeException(code: 0): Chrome process stopped before startup completed. Additional info: sh: 1: exec: google-chrome: not found at /public_html/vendor/chrome-php/chrome/src/Browser/BrowserProcess.php:410)"} []

Any ideas?

There is an issue that if multiple people are working in atro, actions from one user affect other users. If user 1 makes an update the results in items being unselected in a list (mass update), then any selections of the same type made by user 2 in their session are deselected.

This happens on products, so if both users are updating products at the same time. We have tested with categories selected and mass update on products, but the categories were not deselected. Both users have their own account and have logged in seperately.

Video attached shows the issue happening

customize productStatus and widget on main

To run AtroPIM I need to change the .htaccess after every update and add back RewriteBase / else it wouldn't run.

It should not affect other environments, since it seems to be a standard setting for Wordpress that's supposed to run everywhere.

RewriteEngine On
RewriteBase /

I installed successfully all that was needed in your manual, but the installation wizard doesn't start. The /api/v1/Installer/getTranslations cannot be found and indeed, the whole directory /api/ doesn't exist at all. What may I have missed? Thanks.

When you connect several languages, then when creating a catalog there are no name fields with these languages. And there is no saving, since the field is required in all languages.

Product mangers have no insight what attributes got changed

Screenshot from your extended demo

Initially I set Asset Duplicates to Not allow, check by file content

After updating from atrocore/core (1.2.5 => 1.2.30) I couldn't upload files over 2MB.
I got an "Error 400: Such asset already exists." error on this endpoint: /api/v1/Attachment/action/CreateByChunks

That means that the md5 hash of the file is the same - but it was always a different file a bit larger than 2MB and smaller than 4MB.

Long story short something is going on around here:

These are two different files that I uploaded:

and

They both have the same hash as another file already in the database.

the hash is the same, because it consists only of two chunks with the same filename (and the first iteration of $md5 = '')

here is how I debugged it (like a caveman ^^)

    $GLOBALS['log']->debug('$filePat: ' . $filePath);

    $md5 = '';
    file_put_contents($filePath, '');
    foreach ($files as $file) {
        $md5 = md5($md5 . $file);
        $GLOBALS['log']->debug('$file: ' . $file);
        $GLOBALS['log']->debug('$md5: ' . $md5);
        file_put_contents($filePath, file_get_contents($dirPath . $file), FILE_APPEND);
    }

    $attachment->md5 = $md5;
    $attachment->storageFilePath = $destPath;
    $attachment->storageThumbPath = $this->getRepository()->getDestPath(FilePathBuilder::UPLOAD);
    $GLOBALS['log']->debug('$attachment: ', (array) $attachment);

here is a log:

[2021-05-25 21:24:53] Log.DEBUG: $destPath: 06lsx/xjzn3/8tonu/3itw6/zwvcd/4q5sp [] []
[2021-05-25 21:24:53] Log.DEBUG: $filePat: upload/files/06lsx/xjzn3/8tonu/3itw6/zwvcd/4q5sp/rot.png [] []
[2021-05-25 21:24:53] Log.DEBUG: $file: 0 [] []
[2021-05-25 21:24:53] Log.DEBUG: $md5: cfcd208495d565ef66e7dff9f98764da [] []
[2021-05-25 21:24:53] Log.DEBUG: $file: 2097152 [] []
[2021-05-25 21:24:53] Log.DEBUG: $md5: c78f7d2f1137d0cdcd2865b9804a26a6 [] []
[2021-05-25 21:24:53] Log.DEBUG: $attachment:  {"chunkId":"ea9907089e1afa36b7cba91345aaae73",...} - Such asset already exists. [] []
[2021-05-25 21:24:53] Log.ERROR: Display Error: Such asset already exists., Code: 400 URL: /api/v1/Attachment/action/CreateByChunks [] []
[2021-05-25 21:26:22] Log.DEBUG: $destPath: 06lsx/xjzn3/8tonu/3itw6/zwvcd/apt8a [] []
[2021-05-25 21:26:22] Log.DEBUG: $filePat: upload/files/06lsx/xjzn3/8tonu/3itw6/zwvcd/apt8a/blau.png [] []
[2021-05-25 21:26:22] Log.DEBUG: $file: 0 [] []
[2021-05-25 21:26:22] Log.DEBUG: $md5: cfcd208495d565ef66e7dff9f98764da [] []
[2021-05-25 21:26:22] Log.DEBUG: $file: 2097152 [] []
[2021-05-25 21:26:22] Log.DEBUG: $md5: c78f7d2f1137d0cdcd2865b9804a26a6 [] []
[2021-05-25 21:26:22] Log.DEBUG: $attachment:  {"chunkId":"065dc8c83dd368069b73341c7c1f9b11",...} - Such asset already exists. [] []

I didn't test with 3 chunks per file (file >4MB && <6MB) and I didn't test with notAllowByContentAndName.

I suppose the foreach loop should be something like this:

	$md5 = '';
    foreach ($files as $file) {
		$md5 .= md5($md5.md5_file($dirPath . $file)); // Hash the md5 of each chunk
		// or maybe cleaner:
		$md5Arr[] = md5_file($dirPath . $file);
        file_put_contents($filePath, file_get_contents($dirPath . $file), FILE_APPEND);
    }

	$attachment->md5 = $md5;

	// or:
	$attachment->md5 = md5(implode('',$md5Arr));
	
	// or:
	// Hashing the whole file, but with a 50+ MB file this will be too slow
	$attachment->md5 = md5_file($filePath);

I guess to md5 the chunks seems to be the best way (see also: https://www.php.net/manual/en/function.md5-file.php#94494)

But I might be wrong here.

What do you think?

Edit: added the . to $md5 .= md5(...

Hello, All, I am getting error while rebuilding database. see log file for details. Can you tell me how I can fix this error? Also can you please tell me how I can check the logs?

Regards

After updating to atrocore 1.1.* (from 1.0.* from beginning of 2021), I noticed that stored files got moved from the /data/* folder to /upload/* - somehow I had some issues and I had to manually move the files, that worked. But now every new file/image I upload has issues. No thumbnails are being created and download is not possible. It looks like the files are ending up on the server with file permission 0600.
After I change the permission manually I can access the original file in /upload/file/* but I guess thumbnails are created while uploading, so they are still missing.

Any idea how to fix this or is that work in progress?

when i create a portal page,in this portal user page suppose i will create a brand,in this create brand page we click access management field option that will be shown 500 internal server error and do not create brand in this portal page.

https://github.com/atrocore/atrocore/blob/master/README.md?plain=1#L5

A license either is an open-source license, or it restricts usage of the software to certain regions or types of usage. You cannot have both. (See criteria 1 & 5 here: https://opensource.org/osd)

That said, it is not your responsibility as the software creator to forbid people the usage when the law already forbids the usage.
That serves no purpose (law overrides license, always) and would impose an unnecessary restriction when the law changes.
It's the responsibility of the users of software to obey the law and not use unlawful tools.

I'll go one step further and say that from an ethical standpoint, it is very much your responsibility to make your software as free as possible, to help people keep (or regain) the control over their own computing.

You're gonna have to decide whats more important, anti-russia virtue signaling, or remaining true to the nature of open source. Either way, you've been warned.

Hi,
As the title describes, I get an error when I try to upload a company logo, as follows:
Error 400: No asset type provided.

Thank you :)

Hi

Following the instructions: https://github.com/atrocore/docs/blob/master/atrocore/admin-guide/installation.md
Step 3.2 fails

did another installation Tuesday last week with no issues.

Composer diagnose
Checking composer.json: WARNING
No license specified, it is recommended to do so. For closed-source software you may use "proprietary" as license.
require.atrocore/core : unbound version constraints () should be avoided
require.atrocore/pim : unbound version constraints () should be avoided
require.atrocore/dam : unbound version constraints () should be avoided
require.atrocore/export-feeds : unbound version constraints () should be avoided
require.atrocore/import-feeds : unbound version constraints (*) should be avoided
Checking platform settings: OK
Checking git settings: OK
Checking http connectivity to packagist: [Composer\Downloader\TransportException] The "http://repo.packagist.org/packages.json" file could not be down loaded: failed to open stream: Connection timed out
Checking https connectivity to packagist: [Composer\Downloader\TransportException] The "https://repo.packagist.org/packages.json" file could not be do wnloaded: failed to open stream: Connection timed out
Checking github.com rate limit: OK
Checking disk free space: OK
Composer version: 1.10.1
PHP version: 7.4.3
PHP binary path: /usr/bin/php7.4
OpenSSL version: OpenSSL 1.1.1f 31 Mar 2020

Hello
When I try to add or change Classification on a product I get:

Error 200: An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction

Trying to mass-update or if I try to change by import, if I have the Classification field connected, I get the same error.

If I try to create the product with import and have the Classification connected, I get
Import\FieldConverters\LinkMultiple::getForeignEntityName(): Argument #1 ($config) must be of type array, string given, called in /var/www/pim2/vendor/atrocore/import-feeds/app/FieldConverters/LinkMultiple.php on line 40

If I go to the Classification and add the product from there, it works fine.
If I select a Classification before i save when I create a new product, it works.
If I delete Classification from edit product, it works, but can´t add class again.

Same behaviour exists on 2 different sites.

I have tried install latest patches, reboot server, look in the database for any locks, (timeout is set to 50sec).

Anything else I can try to troubleshoot this?

The cronjob script determents the location of php cli version automatically

https://github.com/atrocore/atrocore/blob/master/app/Espo/Core/Utils/System.php#L117

Please provide a config key to set the php binary path manually.

In my case the binary is detected at /usr/bin/php which is a symlink to the wrong php version therefore key functionality fails.

See: https://github.com/atrocore/atropim/discussions/114#discussioncomment-640152

PHP_AUTH_USER/PWD is missing here (

A fallback could be something like this:

        if (isset($_SERVER['REDIRECT_HTTP_AUTHORIZATION'])) {
           list($authUsername, $authPassword) = explode(':' , base64_decode(substr($_SERVER['REDIRECT_HTTP_AUTHORIZATION'], 6)));
        }else{
            $authUsername = $req->headers('PHP_AUTH_USER');
            $authPassword = $req->headers('PHP_AUTH_PW');
        }

As described here: https://github.com/atrocore/atropim/discussions/113#discussioncomment-630207

Failed! Call to undefined method Pricing\Migrations\V1Dot6Dot18::updateComposer()

Any idea to fix this issue?

AtroСore: 1.5.80
PIM: 1.7.35
Ubuntu 20.04.6 LTS

hi...
when im installing with demo data either atroPIM or atroDAM its give me error 500, but if im installing without demo data everything works...is it a bug or im doing something wrong.
i follow your installation instruction
ubuntu 20.04
php 7.4
mysql 5.7

many thanks

There is no option to allow filters on the same field to be added with AND. We have a scenario where we pick products by brand with a word in the name. That may return 50 products. In that set there may be 15 we do not want to pick which have a common word. If we add another filter on name, the filter automatically gets added with OR. Rather than reduce the set, this results in a larger set or products returned.

The user should have the ability to select whether the filter uses AND or OR.

Hello,

I'v read the docs but cannot find how to translate interface language to my language. Also, I cannot find search api from api docs.

Regards,