Loading...
 
Skip to main content

Features / Usability


You are viewing a reply to Secound File Gallery Creation - Error

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')