Issue with Database View: Missing datasheets Table

[turhanMust]

I am trying to create a view in my MySQL database, but I am encountering a few issues:

Missing datasheets Table: The view is trying to reference a datasheets table, which does not exist in my database. The data that should be included in the view seems to be stored under attachments with attachment_types. The query fails with the error:
Error Code: 1146. Table 'partdb.datasheets' doesn't exist
How can I adjust the view to pull the correct data from attachments instead of datasheets?

[electronics4fun]

The datasheet.sql (and image.sql) is looking for explicit names of attachments.
In this case "Datasheet" and "Image".

Please try the following:

Add Attachment types with Names to PartDb:

• "Datasheet"
• "Image"

Also make sure that you have also the views:

• images.sql
• datasheet.sql
  installed.

An other solution would be to comment the image/datasheet stuff in the sql script.
Or to rename "Datasheet" and "Image" in images.sql/datasheet.sql that you eventually already have.

If this works, then it is clear that there is something to add to the documentation and/or make a fix to the scripts.

Let me know if that was helpful.

[turhanMust]

Hello Mr. Münzing, thanks for the quick reply!
I think the attachments types are already in database:

I somehow created views but I think they are empty. In Altium I don't see any entries for components.

[electronics4fun]

Check if the content of the files
https://github.com/electronics4fun/PartDb-Altium-Connector/blob/main/src/datasheets.sql
and
https://github.com/electronics4fun/PartDb-Altium-Connector/blob/main/src/images.sql
is correct and if you can see the content.
If something crashes here, allParts.sql will not work.

After that check if
https://github.com/electronics4fun/PartDb-Altium-Connector/blob/main/src/allParts.sql
has the correct content.
Also, if datasheet and image is a problem you can try to comment it as sanity check.

If you want to see what Altium is working with, you can go to "Table Browser" (down at the bottom of the Altium screenshot).
Check if Altium is retrieving the correct data.

[turhanMust]

I can run datasheets and images query without any issue. But when I run allParts.sql I get this error:
SQL Error (1055): Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'partdb.a.internal_path' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
And when I connect the database to DBLib file allparts is there but it's empy and I get "Couldn't get coloumn list for table "allparts".

[electronics4fun]

do you use MySQL as database or something else?

[turhanMust]

Yes I use MySQL.

[electronics4fun]

Is your PartDb version 1.16.1 or 1.17.0?
It will not work with others versions.

[turhanMust]

the partDB version is 1.17.0

[electronics4fun]

is your system running in containers? If not, maybe test an other system (other versions of MySQL) with containers. Right now i have no clue..,

[electronics4fun]

Please check if this issue is related to #3
--> In "Advanced..." under "Source of Connection" make sure that "Quote Tables" is not checked.