Re: Secound File Gallery Creation - Error
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')