Recent content by darren

  1. D

    Dadabik upgrade violating unique constraint

    Thank you, what i ended up doing was deleting all the dadabik tables, installing a fresh dadabik 12.0 then truncating the tables and inserting the old data from my previous dadabik tables into the new ones, fixing errors if there were any, this way whatever new constraints or table alterations...
  2. D

    Dadabik upgrade violating unique constraint

    I can see that, I ended up truncating all the dadabik tables and reinserting the data into the new one, going line by line on the ones that may be violating the constraint. I still have no idea why i had a "failed to copy" error. there was no permissions issue and the error: "PHP Warning...
  3. D

    Dadabik upgrade violating unique constraint

    Yes the unique constraint was actually set, it seems the unique constraint for the _beta version of the table is a different requirement than the non beta version where the only constraint was the unique primary key. the additional constraint of having "id_subject, object_type_permission...
  4. D

    Dadabik upgrade violating unique constraint

    I went through each duplicate and deleted one of them, now the error im facing is "Error during file copy" when looking at the php error log it outputs this " PHP Warning: copy(): The first argument to copy() function cannot be a directory in /var/www/html/natcat/up2.php on line 0"
  5. D

    Dadabik upgrade violating unique constraint

    Hi i am trying to upgrade my dadabik but i am getting this error on step 3/4 [08] Error: during query execution. INSERT INTO "dadabik_permissions_beta" (id_permission,subject_type_permission,id_subject,object_type_permission,object_permission,id_permission_type,value_permission) SELECT...
  6. D

    Problem with 'required' in custom_required_functions.php

    your response seems to disagree with your code if you want the radio to be require if deelnemen = 'Ja' and type_boot = 'Opduwer' then $params['deelnemen'] <> 'Ja' or $params['type_boot'] <> 'Opduwer' would not get you that. and should be $params['deelnemen'] == 'Ja' and $params['type_boot'] ==...
  7. D

    Problem with 'required' in custom_required_functions.php

    If i am understanding this correctly, you have a radio field that hides unless the user selects 'ja' or 'opduwer'. if they do, a radio field appears and is supposed to be required to fill out, however, the radio field is appearing but is not showing as being required?
  8. D

    Storing IP addresses & URLs & Emails

    for Q 1 im not sure what you mean by "track down and existing custom_validtion function" are you asking for an example? im assuming thats what you mean. since we are writing in php, php actually already has an inbuilt function for validating ipv4 addresses using filter_var function...
  9. D

    Storing IP addresses & URLs & Emails

    Upon re reading your quesiton I think i understand what you are asking, there is no way to store a "clickable" URL or email. unless you want to store the html version of a clickable link, which i would not recommend. This is entirely dependent on how your data is presented to the end user. you...
  10. D

    Storing IP addresses & URLs & Emails

    Your question is somewhat strange, storing data is the purpose of a database, are you asking how to store data in a database? It wouldn't matter if its a URL or IP or email. Can you rephrase your questions because its hard to understand if your asking for a basic understanding of how databases...
  11. D

    Automate User Account Creation

    1 other way i can think is you can write a csv file with that follows the format of the dadabik_users table in the database. maybe create a user through dadabik that would have have all the permissions and groups, etc of the users you want to put in and put that into the csv file and then inport...
  12. D

    Getting error when updating a record

    I recently (within the last day) upgraded to PostgreSQL 13 and the error hasn't happened since, I will let you know if it happens again.
  13. D

    Getting error when updating a record

    Yes I understand the error, it just doesn't make sense. In my case i have a a record for a person named Mary I have her address, name, contact info all filled out and successfully submitted. This city field is and ajax-friendly search field, where the only choice allowed is from the list of...
  14. D

    Getting error when updating a record

    When updating a record, after hitting submit, I get an error: Dropdown validation error: attempt to insert a value that is not one of the available options I found the fix to the error is to reselect the selection for the select_single field that is using the ajax friendly search function...
  15. D

    Send an email to a selected group

    using the template for the hook provided $hooks['accounts']['insert']['after'] = 'dadabik_send_notice_after_accounts_insert'; function dadabik_send_notice_after_accounts_insert($id_account) { global $conn; // get the ID of the group $sql = "SELECT email_accounts FROM...
Top