Loading...
 
Features / Usability

Features / Usability


File Galleries - Error during create

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!

posts: 1630 Canada

Which version of Tiki?

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

M ;-)


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!


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!


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!


Upcoming Events

1)  18 Apr 2024 14:00 GMT-0000
Tiki Roundtable Meeting
2)  16 May 2024 14:00 GMT-0000
Tiki Roundtable Meeting
3)  20 Jun 2024 14:00 GMT-0000
Tiki Roundtable Meeting
4)  18 Jul 2024 14:00 GMT-0000
Tiki Roundtable Meeting
5)  15 Aug 2024 14:00 GMT-0000
Tiki Roundtable Meeting
6)  19 Sep 2024 14:00 GMT-0000
Tiki Roundtable Meeting
7) 
Tiki birthday
8)  17 Oct 2024 14:00 GMT-0000
Tiki Roundtable Meeting
9)  21 Nov 2024 14:00 GMT-0000
Tiki Roundtable Meeting
10)  19 Dec 2024 14:00 GMT-0000
Tiki Roundtable Meeting