Re: [Apc-aa-coders] Re: anonymous form filling

[Honza M. <hon...@ec...>]

Table post2shtml is in sql_update.php3 script, so you probably do not
update the database structure.

post2shtml table is used for posting data from anonymous form. We can't
send it directly, because it is not possible to send
enctype="multipart/form-data" to shtml page. So, Jakub writes a script,
which stores data primary to database. That's why you can use
enctype="multipart/form-data" (image/file uploads) also on shtml pages.

Regards,
          Honza

On St, 2003-02-26 at 22:24, Mitra wrote:
> Ram - the main problem seems to me that the table this is being sent 
> to - post2shtml - doesn't exist.
> 
> I don't understand how this works, or where you set the table for it 
> to go to ...... I thought anonymously posted items got added as 
> regular items in some slice or other.
> 
> - Mitra
> 
> 
> At 12:59 AM +0530 27/2/03, Ram Prasad wrote:
> >Mitra
> >
> >I was trying out the anonymous form filling wizard for my Taskss Slice. The
> >form got created fine. I clicked on send, without providing any values (a
> >blank form) and got the following dump on the screen: (should it have not
> >just complained about the values not being there ?)
> >
> >Database error: Invalid SQL: INSERT INTO post2shtml (id, vars, time) VALUES
> >('b24442e11fdfa9dc45c04fca69e844a1',
> >'a:4:{s:4:\"post\";a:25:{s:7:\"err_url\";s:31:\"http://FILL_YOUR_PAGE_URL.sh
> >tml\";s:6:\"ok_url\";s:31:\"http://FILL_YOUR_PAGE_URL.shtml\";s:8:\"slice_id
> >\";s:32:\"cd5409ecfbeba5303da25590203d7d03\";s:14:\"use_post2shtml\";s:1:\"1
> >\";s:10:\"my_item_id\";s:0:\"\";s:45:\"edtv686561646c696e652e2e2e2e2e2e2e2e_
> >FontName\";s:1:\"0\";s:45:\"edtv686561646c696e652e2e2e2e2e2e2e2e_FontSize\";
> >s:1:\"0\";s:33:\"v686561646c696e652e2e2e2e2e2e2e2e\";s:0:\"\";s:37:\"v686561
> >646c696e652e2e2e2e2e2e2e2ehtml\";s:1:\"h\";s:33:\"v61627374726163742e2e2e2e2
> >e2e2e31\";s:4:\"Mark\";s:45:\"edtv66756c6c5f746578742e2e2e2e2e2e2e_FontName\
> >";s:1:\"0\";s:45:\"edtv66756c6c5f746578742e2e2e2e2e2e2e_FontSize\";s:1:\"0\"
> >;s:33:\"v66756c6c5f746578742e2e2e2e2e2e2e\";s:0:\"\";s:37:\"v66756c6c5f74657
> >8742e2e2e2e2e2e2ehtml\";s:1:\"h\";s:33:\"v63617465676f72792e2e2e2e2e2e2e2e\"
> >;s:11:\"In_Progress\";s:33:\"v746578742e2e2e2e2e2e2e2e2e2e2e32\";s:0:\"\";s:
> >33:\"v746578742e2e2e2e2e2e2e2e2e2e2e31\";s:0:\"\";s:33:\"v656e645f646174652e
> >2e2e2e2e2e2e31\";s:0:\"\";s:45:\"edtv61627374726163742e2e2e2e2e2e2e32_FontNa
> >me\";s:1:\"0\";s:45:\"edtv61627374726163742e2e2e2e2e2e2e32_FontSize\";s:1:\"
> >0\";s:33:\"v61627374726163742e2e2e2e2e2e2e32\";s:0:\"\";s:37:\"v616273747261
> >63742e2e2e2e2e2e2e32html\";s:1:\"h\";s:4:\"send\";s:4:\"Send\";s:6:\"result\
> >";a:1:{s:8:\"validate\";a:2:{s:33:\"v686561646c696e652e2e2e2e2e2e2e2e\";s:54
> >:\"
> >Error in Task (it must be filled)
> >\";s:33:\"v746578742e2e2e2e2e2e2e2e2e2e2e32\";s:63:\"
> >Error in Received Date (it must be filled)
> >\";}}s:13:\"oldcontent4id\";a:34:{s:16:\"headline........\";a:1:{i:0;a:2:{s:
> >5:\"value\";s:0:\"\";s:4:\"flag\";i:1;}}s:16:\"abstract.......1\";a:1:{i:0;a
> >:2:{s:5:\"value\";s:4:\"Mark\";s:4:\"flag\";i:0;}}s:16:\"full_text.......\";
> >a:1:{i:0;a:2:{s:5:\"value\";s:0:\"\";s:4:\"flag\";i:1;}}s:16:\"category.....
> >...\";a:1:{i:0;a:2:{s:5:\"value\";s:11:\"In_Progress\";s:4:\"flag\";i:0;}}s:
> >16:\"text...........2\";a:1:{i:0;a:2:{s:5:\"value\";s:0:\"\";s:4:\"flag\";i:
> >0;}}s:16:\"text...........1\";a:1:{i:0;a:2:{s:5:\"value\";s:0:\"\";s:4:\"fla
> >g\";i:0;}}s:16:\"end_date.......1\";a:1:{i:0;a:2:{s:5:\"value\";s:0:\"\";s:4
> >:\"flag\";i:0;}}s:16:\"abstract.......2\";a:1:{i:0;a:2:{s:5:\"value\";s:0:\"
> >\";s:4:\"flag\";i:1;}}s:16:\"highlight.......\";a:1:{i:0;a:2:{s:5:\"value\";
> >i:0;s:4:\"flag\";i:0;}}s:16:\"link_only.......\";a:1:{i:0;a:2:{s:5:\"value\"
> >;s:0:\"\";s:4:\"flag\";i:0;}}s:16:\"hl_href.........\";a:1:{i:0;a:2:{s:5:\"v
> >alue\";s:0:\"\";s:4:\"flag\";i:0;}}s:16:\"created_by......\";a:1:{i:0;a:2:{s
> >:5:\"value\";s:0:\"\";s:4:\"flag\";i:0;}}s:16:\"e_posted_by.....\";a:1:{i:0;
> >a:2:{s:5:\"value\";s:0:\"\";s:4:\"flag\";i:0;}}s:16:\"source..........\";a:1
> >:{i:0;a:2:{s:5:\"value\";s:0:\"\";s:4:\"flag\";i:0;}}s:16:\"source_href.....
> >\";a:1:{i:0;a:2:{s:5:\"value\";s:0:\"\";s:4:\"flag\";i:0;}}s:16:\"place.....
> >......\";a:1:{i:0;a:2:{s:5:\"value\";s:0:\"\";s:4:\"flag\";i:0;}}s:16:\"expi
> >ry_date.....\";a:1:{i:0;a:2:{s:5:\"value\";i:1219042800;s:4:\"flag\";i:0;}}s
> >:16:\"publish_date....\";a:1:{i:0;a:2:{s:5:\"value\";i:1046287486;s:4:\"flag
> >\";i:0;}}s:16:\"lang_code.......\";a:1:{i:0;a:2:{s:5:\"value\";s:2:\"EN\";s:
> >4:\"flag\";i:0;}}s:16:\"cp_code.........\";a:1:{i:0;a:2:{s:5:\"value\";s:9:\
> >"iso8859-1\";s:4:\"flag\";i:0;}}s:16:\"img_src.........\";a:1:{i:0;a:2:{s:5:
> >\"value\";s:0:\"\";s:4:\"flag\";i:0;}}s:16:\"img_width.......\";a:1:{i:0;a:2
> >:{s:5:\"value\";s:0:\"\";s:4:\"flag\";i:0;}}s:16:\"img_height......\";a:1:{i
> >:0;a:2:{s:5:\"value\";s:0:\"\";s:4:\"flag\";i:0;}}s:16:\"edit_note.......\";
> >a:1:{i:0;a:2:{s:5:\"value\";s:0:\"\";s:4:\"flag\";i:0;}}s:16:\"slice_id.....
> >...\";a:1:{i:0;a:2:{s:5:\"value\";s:1:\"1\";s:4:\"flag\";i:0;}}s:16:\"post_d
> >ate.......\";a:1:{i:0;a:2:{s:5:\"value\";i:1046287486;s:4:\"flag\";i:0;}}s:1
> >6:\"status_code.....\";a:1:{i:0;a:2:{s:5:\"value\";s:1:\"1\";s:4:\"flag\";i:
> >0;}}s:16:\"edited_by.......\";a:1:{i:0;a:2:{s:5:\"value\";s:0:\"\";s:4:\"fla
> >g\";i:0;}}s:16:\"posted_by.......\";a:1:{i:0;a:2:{s:5:\"value\";s:0:\"\";s:4
> >:\"flag\";i:0;}}s:16:\"last_edit.......\";a:1:{i:0;a:2:{s:5:\"value\";i:1046
> >287486;s:4:\"flag\";i:0;}}s:16:\"display_count...\";a:1:{i:0;a:2:{s:5:\"valu
> >e\";s:1:\"0\";s:4:\"flag\";i:0;}}s:16:\"disc_count......\";a:1:{i:0;a:2:{s:5
> >:\"value\";s:1:\"0\";s:4:\"flag\";i:0;}}s:16:\"disc_app........\";a:1:{i:0;a
> >:2:{s:5:\"value\";s:1:\"0\";s:4:\"flag\";i:0;}}s:16:\"flags...........\";a:1
> >:{i:0;a:1:{s:5:\"value\";i:32;}}}}s:3:\"get\";a:0:{}s:5:\"files\";a:0:{}s:6:
> >\"cookie\";a:0:{}}', 1046287486)
> >MySQL Error: 1146 (Table 'aadb.post2shtml' doesn't exist)
> >Please contact mi...@ea... and report the exact error message.
> >Session halted.
> 
> 
> -- 
> Mitra Technology Consulting -  www.mitra.biz - mi...@mi...
> 02-6684-8096  or 0414-648-0722 
> 
> Life is a Mystery to be Lived, not a Problem to be Solved
> 
> 
> 
> -------------------------------------------------------
> This SF.net email is sponsored by: Scholarships for Techies!
> Can't afford IT training? All 2003 ictp students receive scholarships.
> Get hands-on training in Microsoft, Cisco, Sun, Linux/UNIX, and more.
> www.ictp.com/training/sourceforge.asp
> _______________________________________________
> Apc-aa-coders mailing list
> Apc...@li...
> https://lists.sourceforge.net/lists/listinfo/apc-aa-coders
>