Loading...
 
Skip to main content

Features / Usability

Forum List Topic List

Forums » Features / Usability » File Galleries - Error during create
 
Thread actions
Print this page
  • Print all pages

    • File Galleries - Error during create

    Posted by seromine posts: 130

    I am trying to create a file gallery....I have it set for a path directory, not a database....

    After I click on create I receive a "An error occured in a database query!" with alot of info, and at the bottom I receive a "Column 'type' cannot be null" message....

    Can anybody help me across this hurdle? Thanks!

    Reads: 1129
    Posted by Marc Laporte posts: 1643 Canada

    Which version of Tiki?

    If it's been upgraded recently, did you run the sql upgrade script?

    M 😉


    Posted by seromine posts: 130

    It is running 1.10 I believe and this is in fact an upgrade. I thought I did use the upgrade script....would it hurt anything to run it again?

    > I am trying to create a file gallery....I have it set for a path directory, not a database....
    >
    > After I click on create I receive a "An error occured in a database query!" with alot of info, and at the bottom I receive a "Column 'type' cannot be null" message....
    >
    > Can anybody help me across this hurdle? Thanks!


    Posted by seromine posts: 130

    I think I found a piece of the puzzle....when I am on the Create A File Gallery under Listing Configuration, File Type is not listed....

    It is configured under Administration:File Galleries, meaning I have all the listing configurations checked......

    Does this help troubleshoot at all? I am on version 1.10.....




    > I am trying to create a file gallery....I have it set for a path directory, not a database....
    >
    > After I click on create I receive a "An error occured in a database query!" with alot of info, and at the bottom I receive a "Column 'type' cannot be null" message....
    >
    > Can anybody help me across this hurdle? Thanks!


    Posted by seromine posts: 130

    I noticed in the mysql database file-galleries that file type and parentid were set to not allow null....i changed this and i got a little bit farther, but now on another portion it is saying it does not allow sort-mode to be empty.....

    does anybody have a working file-galleries feature working in version 1.10....just so I know it is not a version issue?

    > I am trying to create a file gallery....I have it set for a path directory, not a database....
    >
    > After I click on create I receive a "An error occured in a database query!" with alot of info, and at the bottom I receive a "Column 'type' cannot be null" message....
    >
    > Can anybody help me across this hurdle? Thanks!