Loading...
 
Skip to main content

Features / Usability


Secound File Gallery Creation - Error

v9. LTS
Intranet Website
Profile: Company_Intranet_9x

I created the first File Gallery to store files on the server but wanted to create more galleries to separate out to have a cleaner file structure. They are not part of the root, but stored off in their own file path. I've been able to save files with my current setup so I'm not sure if it's a permission issue. When I try to create a 2nd file Gallery, I received the following error message.

__An error occurred while performing the request
__
Things to check
1. Did you complete the Tiki Installer?
2. Is your database corrupt? Please see how to repair your database
3. Are you database credentials accurate?

not sure why I'm receiving this error, I found a different entry here with the same issue, but no resolution and it was for an older version. I think 5.x
Is there a log file or anything that I can check to determine what's preventing me from creating another file gallery.
Thanks,

Update

I should have done this earlier, but I turned on or up the error message and received the following when attempting to create 2nd File Gallery

Isn't it suppose to increment the integer by 1 for the column 'icon_fileID'?

The following error message was returned:

Incorrect integer value: '' for column 'icon_fileId' at row 1The query was:

INSERT INTO `tiki_file_galleries` (`name`, `description`, `visible`, `type`, `parentId`, `lockable`, `archives`, `quota`, `image_max_size_x`, `image_max_size_y`, `backlinkPerms`, `show_backlinks`, `show_deleteAfter`, `show_lastDownload`, `sort_mode`, `maxRows`, `max_desc`, `subgal_conf`, `show_id`, `show_icon`, `show_name`, `show_description`, `show_size`, `show_created`, `show_modified`, `show_creator`, `show_author`, `show_last_user`, `show_comment`, `show_files`, `show_hits`, `show_lockedby`, `show_checked`, `show_share`, `show_explorer`, `show_path`, `show_slideshow`, `show_source`, `wiki_syntax`, `default_view`, `template`, `icon_fileId`, `user`, `public`, `created`, `lastModif`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Values:

1.PDF
2.PDF Files
3.y
4.default
5.1
6.n
7.0
8.0
9.0
10.0
11.n
12.n
13.n
14.n
15.name_asc
16.24
17.1024
18.
19.o
20.y
21.a
22.o
23.y
24.o
25.y
26.o
27.o
28.o
29.o
30.o
31.o
32.a
33.
34.n
35.y
36.y
37.
38.o
39.
40.list
41.
42.
43.admin
44.n
45.1346091152
46.1346091152
The built query was likely:

INSERT INTO `tiki_file_galleries` (`name`, `description`, `visible`, `type`, `parentId`, `lockable`, `archives`, `quota`, `image_max_size_x`, `image_max_size_y`, `backlinkPerms`, `show_backlinks`, `show_deleteAfter`, `show_lastDownload`, `sort_mode`, `maxRows`, `max_desc`, `subgal_conf`, `show_id`, `show_icon`, `show_name`, `show_description`, `show_size`, `show_created`, `show_modified`, `show_creator`, `show_author`, `show_last_user`, `show_comment`, `show_files`, `show_hits`, `show_lockedby`, `show_checked`, `show_share`, `show_explorer`, `show_path`, `show_slideshow`, `show_source`, `wiki_syntax`, `default_view`, `template`, `icon_fileId`, `user`, `public`, `created`, `lastModif`) VALUES ('PDF', 'PDF Files', 'y', 'default', '1', 'n', '0', '0', '0', '0', 'n', 'n', 'n', 'n', 'name_asc', '24', '1024', NULL, 'o', 'y', 'a', 'o', 'y', 'o', 'y', 'o', 'o', 'o', 'o', 'o', 'o', 'a', NULL, 'n', 'y', 'y', NULL, 'o', , 'list', NULL, , 'admin', 'n', '1346091152', '1346091152')


Update
Alright, noticed that I need to enter an integer under the "Display Properties" Tab on field "Gallery Icon:".
I am now able to create as many galleries as I need.
Sorry for wasting space.