venekamp
Member
Hi ,
I created SQLviews in PhpMyAdmin. I figured out that I need a unique key named "id" to access the list-data via fabrik.
Once I save the new fabrik returns the error code 1347 .
<<
1347 'venekamp.qry_#__maandanalyse' is not BASE TABLE
C:\wamp64\www\gezin\libraries\joomla\database\driver\mysqli.php:665
>>
I can see the data in the list and forms. However changes in the list definitions like access permission, sorting, grouping and joins show the same errocode and are ignored. I really want to change at least permissions so the data in the views can not be changed and icons are not shown. Tips and tricks are welcome
The behaviour of fabrik is confusing regarding to the elements in database queries:
I can change elements in the views . Saving elements returns the messages, between << and >> however I can change everything I need in fabrik without changing the database query
<<
Bericht
A join or list has been added which has no Primary Key (PK). Most likely cause is you are creating a new List on a MySQL view, or a join element joining to a MySQL view. Views don't have PKs, but as we found a field called 'id' we are assuming this is the PK. If this is the PK, you can ignore this message. If not, if you are creating a list you should manually designate the PK in the list settings now, in the 'Data' tab. If you are adding a join element, you should create a Fabrik List based on the view you are joining to, in order to specify which element to use as the PK, then edit and save the join element again
Item opslaan geslaagd.
Attentie
De tabel die je wil updaten heeft een prefix van je joomla database, hoewel het geen core Joomla of Fabrik tabel is, kan hij wel gebruikt worden door andere componenten
The first part "Bericht" I understand and can be ignored because I use id as Primary Key. I expect this when I create a list and not change an element.
The second part I don't understand because is says I use the prefix of my joomla database. My standard prefix is : "vene" for the joomla tables and in the queryviews I prefix with "qry". This is confusing.
The third part (5th bullet) is weird as I choose cancel (I don't want to change database table) and see after closing the element that my changes seem to be saved in fabrik. For me thjs flexibility is fine however buttons and text are confusing.
I created SQLviews in PhpMyAdmin. I figured out that I need a unique key named "id" to access the list-data via fabrik.
Once I save the new fabrik returns the error code 1347 .
<<
1347 'venekamp.qry_#__maandanalyse' is not BASE TABLE
C:\wamp64\www\gezin\libraries\joomla\database\driver\mysqli.php:665
>>
I can see the data in the list and forms. However changes in the list definitions like access permission, sorting, grouping and joins show the same errocode and are ignored. I really want to change at least permissions so the data in the views can not be changed and icons are not shown. Tips and tricks are welcome
The behaviour of fabrik is confusing regarding to the elements in database queries:
I can change elements in the views . Saving elements returns the messages, between << and >> however I can change everything I need in fabrik without changing the database query
<<
Bericht
A join or list has been added which has no Primary Key (PK). Most likely cause is you are creating a new List on a MySQL view, or a join element joining to a MySQL view. Views don't have PKs, but as we found a field called 'id' we are assuming this is the PK. If this is the PK, you can ignore this message. If not, if you are creating a list you should manually designate the PK in the list settings now, in the 'Data' tab. If you are adding a join element, you should create a Fabrik List based on the view you are joining to, in order to specify which element to use as the PK, then edit and save the join element again
Item opslaan geslaagd.
Attentie
De tabel die je wil updaten heeft een prefix van je joomla database, hoewel het geen core Joomla of Fabrik tabel is, kan hij wel gebruikt worden door andere componenten
- Update de veldstructuur voor `subcode` van INT(11) naar INT(4).
- Please read carefully any notifications that may appear regarding the update you are about to perform.
- Then check that the database field's structure and or name are desired.
- If you are happy to continue press 'Save'
- Otherwise press 'Cancel', this will revert the element name and plug-in type to the element's setting previous to being edited
The first part "Bericht" I understand and can be ignored because I use id as Primary Key. I expect this when I create a list and not change an element.
The second part I don't understand because is says I use the prefix of my joomla database. My standard prefix is : "vene" for the joomla tables and in the queryviews I prefix with "qry". This is confusing.
The third part (5th bullet) is weird as I choose cancel (I don't want to change database table) and see after closing the element that my changes seem to be saved in fabrik. For me thjs flexibility is fine however buttons and text are confusing.