Features / Usability

Posted by Marc Laporte 29 Jul 2007 00:50 GMT-0000 posts: 1633

Which version of Tiki?

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

M ;-)

Posted by seromine 30 Jul 2007 19:58 GMT-0000 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 02 Aug 2007 22:08 GMT-0000 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 02 Aug 2007 23:18 GMT-0000 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!