[phpGroupWare-users] Problem installing forum application

[Achim Schmidt]

Hi,

just installed the phpgroupware 0.9.16.011 and most is working fine.

Just by installing the forum application and the fudforum I get some errors and 
cant setup.

Both will genreate some sql errors, that let my think there is something wrong 
into the createscrips. dateils attached below.

does anybody could help me ??

thx & rgds

achim

by installing the forum (through the setup page) I get:

pp install/remove/upgrade:
Database error: Invalid SQL: CREATE TABLE phpgw_forum_body (id int(11) 
auto_increment not null NULL, cat_id int NOT NULL, for_id int NOT NULL, message 
blob NOT NULL, PRIMARY KEY(id))
MySQL Error: 1171 (All parts of a PRIMARY KEY must be NOT NULL; If you need 
NULL in a key, use UNIQUE instead)
Database error: Invalid SQL: INSERT INTO phpgw_forum_categories (name,descr) 
VALUES ('Just a sample', 'This is a sample category')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_forum_categories' doesn't 
exist)
Database error: Invalid SQL: INSERT INTO phpgw_forum_categories (name,descr) 
VALUES ('Another sample category', 'Just another sample')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_forum_categories' doesn't 
exist)
Database error: Invalid SQL: INSERT INTO phpgw_forum_forums 
(name,perm,groups,descr, cat_id) VALUES ('Sample', '0', '0', 'This is a 
sample', '1')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_forum_forums' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_forum_forums 
(name,perm,groups,descr, cat_id) VALUES ('This is another sample', '0', '0', 
'sub-category', '1')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_forum_forums' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_forum_forums 
(name,perm,groups,descr, cat_id) VALUES ('Sample', '0', '0', 'Wow, what a 
suprise, another sample :)', '2')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_forum_forums' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_forum_body (cat_id, for_id, 
message) VALUES ('1', '1','Here is an example message.')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_forum_body' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_forum_body (cat_id, for_id, 
message) VALUES ('1', '1', 'Here is an example of a reply.')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_forum_body' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_forum_body (cat_id, for_id, 
message) VALUES ('1', '2', 'Yup, another example')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_forum_body' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_forum_body (cat_id, for_id, 
message) VALUES ('2', '3', 'I ran out of ideas ... so, heres another sample.')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_forum_body' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_forum_threads  
(postdate,main,parent,cat_id,for_id,thread_owner,subject,stat,thread,d 
epth,pos,n_replies) VALUES ('2000-12-27 04:19:54', '1', '-1', '1', '1',0, 
'Example','0', '1', '0', '0', '1')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_forum_threads' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_forum_threads  
(postdate,main,parent,cat_id,for_id,thread_owner,subject,stat,thread,d 
epth,pos,n_replies) VALUES ('2000-12-27 04:20:12', '2', '1', '1', '1',0, 'Re: 
Example','0', '1', '1', '1', '1')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_forum_threads' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_forum_threads  
(postdate,main,parent,cat_id,for_id,thread_owner,subject,stat,thread,d 
epth,pos,n_replies) VALUES ('2000-12-27 04:21:15', '3', '-1', '1', '2',0, 
'Example message','0', '3', '0', '0', '0')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_forum_threads' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_forum_threads  
(postdate,main,parent,cat_id,for_id,thread_owner,subject,stat,thread,d 
epth,pos,n_replies) VALUES ('2000-12-27 04:21:58', '4', '-1', '2', '3',0, 
'','0', '4', '0', '0', '0')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_forum_threads' doesn't exist)

by installing ths fudforum I get:

App install/remove/upgrade:
Database error: Invalid SQL: CREATE TABLE phpgw_fud_action_log (id int(11) 
auto_increment not null NULL, logtime bigint NOT NULL DEFAULT 0, logaction 
varchar(100) NULL, user_id int NOT NULL DEFAULT 0, a_res varchar(100) NULL, 
a_res_id int NOT NULL DEFAULT 0, PRIMARY KEY(id), INDEX (user_id,logtime))
MySQL Error: 1171 (All parts of a PRIMARY KEY must be NOT NULL; If you need 
NULL in a key, use UNIQUE instead)
Database error: Invalid SQL: INSERT INTO phpgw_fud_cat 
(name,description,cat_opt,view_order) VALUES ('Test Category', ' - Just a test 
category',3, 1)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_cat' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_forum (cat_id, name, 
date_created, max_attach_size, view_order) VALUES(1, 'TestForum', 1173098725, 
1024, 1)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_forum' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_fc_view (c, f) VALUES(1, 1)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_fc_view' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_groups (name, forum_id, 
groups_opt) VALUES('Global Anonymous Access', 0,262147)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_groups' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_groups (name, forum_id, 
groups_opt) VALUES('Global Registered Access', 0,313231)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_groups' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_groups (name, forum_id, 
groups_opt) VALUES ('TestForum', 1,327679)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_groups' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_group_resources (group_id, 
resource_id) VALUES(3, 1)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_group_resources' doesn't 
exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_group_members (user_id, 
group_id, group_members_opt) VALUES (0, 3,327683)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_group_members' doesn't 
exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_group_members (user_id, 
group_id, group_members_opt) VALUES (2147483647, 3,378767)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_group_members' doesn't 
exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_group_cache (user_id, 
resource_id, group_id, group_cache_opt) VALUES (0, 1, 3,262147)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_group_cache' doesn't 
exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_group_cache (user_id, 
resource_id, group_id, group_cache_opt) VALUES (2147483647, 1, 3,313231)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_group_cache' doesn't 
exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_level (name,post_count) 
VALUES ('Senior Member',100)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_level' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_level (name,post_count) 
VALUES ('Member',30)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_level' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_level (name,post_count) 
VALUES ('Junior Member',0)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_level' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('aiff','audio/x-aiff','AIFF 
File','sound.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('wav','audio/x-wav','Wave File','sound.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('midi','audio/midi','MIDI File','midi.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('au','audio/basic','Sun ulaw-Compressed 
Audio File','sound.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('mp3','audio/mpeg','MP3 File','sound.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('rm','audio/x-realaudio','Real 
Audio','real.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('gif','image/gif','GIF Image','image.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('ico','image/ico','Icon File','image.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('jpeg','image/jpeg','JPEG 
Image','image.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('jpg','image/jpeg','JPEG Image','image.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('tiff','image/tiff','TIFF 
Image','image.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('tif','image/tiff','TIFF Image','image.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('pict','image/x-pict','Macintosh PICT 
format','image.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('bmp','image/x-win-bmp','BMP 
Image','image.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('png','image/png','PNG Image','image.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('mpeg','video/mpeg','MPEG 
Movie','video.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('mpg','video/mpeg','MPEG Movie','video.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('qt','video/quicktime','QuickTime 
Movie','video.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('mov','video/quicktime','QuickTime 
Movie','video.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('vivo','video/vnd.vivo','VIVO 
Movie','video.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('avi','video/x-msvideo','Microsoft 
Video','video.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('gz','application/x-gzip','GZIP 
Archive','tgz.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('tar','application/x-tar','TAR 
Archive','tar.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('zip','application/zip','ZIP 
Archive','tgz.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('doc','application/msword','MS Word 
Document','word.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('dot','application/msword','MS Word 
Document','word.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('xls','application/vnd.ms-excel','MS 
Excel','excel.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('ppt','application/vnd.ms-powerpoint','MS 
PowerPoint','ppt.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('pdf','application/pdf','PDF 
Document','pdf.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('rtf','application/rtf','Rich Text 
Format','txt.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('htm','text/html','HTML Page','html.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('html','text/html','HTML Page','html.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('txt','text/plain','Plain Text','txt.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) 
VALUES('ps','application/postscript','Postscript','postscript.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) 
VALUES('swf','application/x-shockwave-flash','ShockWave Flash','flash.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('exe','application/application','Binary 
File','binary.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('bin','application/application','Binary 
File','binary.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('sh','application/sh','UNIX Shell 
Script','sh.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('hqx','application/mac-binhex40','Mac 
Binary','binary.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) 
VALUES('','application/octet-stream','Unknown','unknown.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('pl','application/x-perl','Perl 
Script','source.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('pm','application/x-perl','Perl 
Module','source.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_mime 
(fl_ext,mime_hdr,descr,icon) VALUES('php','application/x-httpd-php','PHP 
Script','source.gif')
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_mime' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_smiley (img, descr, code, 
vieworder) VALUES ('icon_redface.gif','Embarassed',':blush:',1)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_smiley' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_smiley (img, descr, code, 
vieworder) VALUES ('icon_razz.gif','Razz',':P~:-P~:razz:',2)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_smiley' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_smiley (img, descr, code, 
vieworder) VALUES ('icon_mad.gif','Mad',':x~:-x~:mad:',3)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_smiley' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_smiley (img, descr, code, 
vieworder) VALUES ('icon_lol.gif','Laughing',':lol:',4)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_smiley' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_smiley (img, descr, code, 
vieworder) VALUES ('icon_cool.gif','Cool','8)~8-)~:cool:',5)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_smiley' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_smiley (img, descr, code, 
vieworder) VALUES ('icon_confused.gif','Confused',':?~:-?~:???:',6)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_smiley' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_smiley (img, descr, code, 
vieworder) VALUES ('icon_eek.gif','Shocked','8O~8-O~:shock:',7)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_smiley' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_smiley (img, descr, code, 
vieworder) VALUES ('icon_surprised.gif','Surprised',':o~:-o~:eek:',8)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_smiley' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_smiley (img, descr, code, 
vieworder) VALUES ('icon_sad.gif','Sad',':(~:-(~:sad:',9)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_smiley' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_smiley (img, descr, code, 
vieworder) VALUES ('icon_smile.gif','Smile',':)~:-)~:smile:',10)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_smiley' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_smiley (img, descr, code, 
vieworder) VALUES ('icon_biggrin.gif','Very Happy',':D~:-D~:grin:',11)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_smiley' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_smiley (img, descr, code, 
vieworder) VALUES ('icon_cry.gif','Crying or Very Sad',':cry:~:((~:-((',12)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_smiley' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_smiley (img, descr, code, 
vieworder) VALUES ('icon_evil.gif','Evil or Very Mad',':evil:',13)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_smiley' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_smiley (img, descr, code, 
vieworder) VALUES ('icon_twisted.gif','Twisted Evil',':twisted:',14)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_smiley' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_smiley (img, descr, code, 
vieworder) VALUES ('icon_rolleyes.gif','Rolling Eyes',':roll:',15)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_smiley' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_smiley (img, descr, code, 
vieworder) VALUES ('icon_wink.gif','Wink',';)~;-)~:wink:',16)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_smiley' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_smiley (img, descr, code, 
vieworder) VALUES ('icon_exclaim.gif','Exclamation',':!:',17)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_smiley' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_smiley (img, descr, code, 
vieworder) VALUES ('icon_question.gif','Question',':?:',18)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_smiley' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_smiley (img, descr, code, 
vieworder) VALUES ('icon_idea.gif','Idea',':idea:',19)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_smiley' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_smiley (img, descr, code, 
vieworder) VALUES ('icon_arrow.gif','Arrow',':arrow:',20)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_smiley' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_smiley (img, descr, code, 
vieworder) VALUES ('icon_neutral.gif','Neutral',':|~:-|~:neutral:',21)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_smiley' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_smiley (img, descr, code, 
vieworder) VALUES ('icon_mrgreen.gif','Grin',':]~:-]~:brgin:',22)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_smiley' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_smiley (img, descr, code, 
vieworder) VALUES ('icon_dead.gif','Dead','x(~:dead:',23)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_smiley' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_smiley (img, descr, code, 
vieworder) VALUES ('icon_frown.gif','Frown',':frown:',24)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_smiley' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_smiley (img, descr, code, 
vieworder) VALUES ('icon_nod.gif','Nod',':nod:',25)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_smiley' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_smiley (img, descr, code, 
vieworder) VALUES ('icon_proud.gif','Proud',':proud:',26)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_smiley' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_smiley (img, descr, code, 
vieworder) VALUES ('icon_smug.gif','Smug',':smug:',27)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_smiley' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_smiley (img, descr, code, 
vieworder) VALUES ('icon_thumbsup.gif','Thumbs Up',':thumbup:',28)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_smiley' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_smiley (img, descr, code, 
vieworder) VALUES ('icon_thumbdown.gif','Thumbs Down',':thumbdown:',29)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_smiley' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_smiley (img, descr, code, 
vieworder) VALUES ('icon_uhoh.gif','Uh Oh',':uhoh:',30)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_smiley' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_smiley (img, descr, code, 
vieworder) VALUES ('icon_yawn.gif','Bored',':yawn:',31)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_smiley' doesn't exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_stats_cache 
VALUES(0,0,0,0,0,'',0)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_stats_cache' doesn't 
exist)
Database error: Invalid SQL: INSERT INTO phpgw_fud_users (phpgw_id, login, 
alias, time_zone, theme, email, passwd, name, users_opt) VALUES(-1, 'Anonymous 
Coward', 'Anonymous Coward', 'America/Montreal', 1, mailto:'address@hidden', 
'1', 'Anonymous Coward',6585269)
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_users' doesn't exist)
Database error: Invalid SQL: ALTER TABLE phpgw_fud_thread_view CHANGE pos pos 
INT NOT NULL AUTO_INCREMENT
MySQL Error: 1146 (Table 'fhlen_phpgroupware.phpgw_fud_thread_view' doesn't 
exist)

Sent from the phpGroupWare forums @ http://forums.phpGroupWare.org