From: i18n <i1...@ya...> - 2002-08-21 19:26:12
|
I have written a script that is supposed to write stories directly into the db, but they are not showing up as expected. This is a Bender system. The script has dumped the info as I expected into the stories table. I also made copies into the newstories table. Below is a dump of part of the stories table with stories form today: - stories with ID 0151220, 1543256 , 1545251 , 161247 were created via the admin interface in the usual fashion and are currently displayed on the site (www.i18n.com if you want to see) - story with ID 1741253 (title is "test") was created from the admin interface but set the display option to never display. this does not display on the site, but does display in the admin interface under stories. I was hoping to duplicate this behavior with my script - stories with IDs 1129236 and 1138252 were inserted by the script. As far as I can tell, all the relevant fields match the record I was trying to copy. The problem is, those two script inserted records are not showing in the admin screen as expected. Is there something else I need to set in the db? Anyone have an example of a similar script to share (direct insertion of stories, I already have one that works that writes to the submissions table). Thanks! Barry -------------------------------------------------------------------------------------- mysql> select sid,tid,section,title,time,writestatus,displaystatus,commentstatus,uid -> from stories where sid like "%02/08/22%"; +------------------+-----------------+----------+--------------------------------------------------------------------------------------------------+---------------------+-------------+---------------+---------------+-----+ | sid | tid | section | title | time | writestatus | displaystatus | commentstatus | uid | +------------------+-----------------+----------+--------------------------------------------------------------------------------------------------+---------------------+-------------+---------------+---------------+-----+ | 02/08/22/0151220 | Press_Releases | BizDev | Software Research Associates Acquires Turbolinux Linux Software Business | 2002-08-21 18:47:33 | 0 | 0 | 0 | 7 | | 02/08/22/1543256 | 1 | articles | Study Reveals Greater Need for Translation Services by Global Fortune 500 | 2002-08-22 08:42:34 | 1 | 0 | 0 | 7 | | 02/08/22/1545251 | 1 | articles | RoboHelp Extends Reach to Key Asian Markets With Localized Versions | 2002-08-22 08:45:30 | 0 | 0 | 0 | 7 | | 02/08/22/161247 | Events-Calendar | Events | Multicultural Holidays Bulletin - August and September 2002 | 2002-08-22 08:59:30 | 0 | 0 | 0 | 7 | | 02/08/22/1741253 | 1 | articles | test | 2002-08-22 10:41:38 | 1 | -1 | 0 | 7 | | 02/08/22/1129236 | 1 | articles | CipherTrust Raises The Bar In Providing Comprehensive Protection For Enterprise Web-Enabled Mail | 2002-08-22 11:29:36 | 1 | -1 | 0 | 7 | | 02/08/22/1138252 | 1 | articles | CipherTrust Raises The Bar In Providing Comprehensive Protection For Enterprise Web-Enabled Mail | 2002-08-22 11:38:52 | 1 | -1 | 0 | 7 | +------------------+-----------------+----------+--------------------------------------------------------------------------------------------------+---------------------+-------------+---------------+---------------+-----+ |
From: i18n <i1...@ya...> - 2002-08-22 03:53:00
|
I found in my own personal archives a message from last novermber 11 from Allessio where he presented some code: my $data = {uid => $uid, tid => $tid, time => time2str('%Y-%m-%d %T', str2time($myheader{'Date'})), title => $myheader{'Subject'}, section => $section, bodytext => undef, introtext => $html_body, writestatus => 1, displaystatus => $display, commentstatus => -1, }; $sid = $slashdb->createStory($data); $slashdb->createDiscussion ($sid, $data->{title}, $data->{'time'}, "$constants->{rootdir}/article.pl?sid=$sid" ); The main diff between this and what I was doing is he called createStory (+ createDiscusion) where I was calling sqlInsert directly on the stories table. The $data hashes were essentially the same. Funny thing is, his worked! And now mine does too! This is going to let me do lots of cool things and reduce the admin burden on me with repetitive stories. Barry ------------------------------------------------ At 12:23 PM 8/21/2002 -0700, you wrote: >I have written a script that is supposed to write stories directly into the db, but they are not showing up as expected. > >This is a Bender system. > >The script has dumped the info as I expected into the stories table. I also made copies into the newstories table. Below is a dump of part of the stories table with stories form today: > >- stories with ID 0151220, 1543256 , 1545251 , 161247 were created via the admin interface in the usual fashion and are currently displayed on the site (www.i18n.com if you want to see) >- story with ID 1741253 (title is "test") was created from the admin interface but set the display option to never display. this does not display on the site, but does display in the admin interface under stories. I was hoping to duplicate this behavior with my script >- stories with IDs 1129236 and 1138252 were inserted by the script. As far as I can tell, all the relevant fields match the record I was trying to copy. > >The problem is, those two script inserted records are not showing in the admin screen as expected. > >Is there something else I need to set in the db? Anyone have an example of a similar script to share (direct insertion of stories, I already have one that works that writes to the submissions table). > >Thanks! > >Barry >-------------------------------------------------------------------------------------- > > >mysql> select sid,tid,section,title,time,writestatus,displaystatus,commentstatus,uid > -> from stories where sid like "%02/08/22%"; >+------------------+-----------------+----------+--------------------------------------------------------------------------------------------------+---------------------+-------------+---------------+---------------+-----+ >| sid | tid | section | title | time | writestatus | displaystatus | commentstatus | uid | >+------------------+-----------------+----------+--------------------------------------------------------------------------------------------------+---------------------+-------------+---------------+---------------+-----+ >| 02/08/22/0151220 | Press_Releases | BizDev | Software Research Associates Acquires Turbolinux Linux Software Business | 2002-08-21 18:47:33 | 0 | 0 | 0 | 7 | >| 02/08/22/1543256 | 1 | articles | Study Reveals Greater Need for Translation Services by Global Fortune 500 | 2002-08-22 08:42:34 | 1 | 0 | 0 | 7 | >| 02/08/22/1545251 | 1 | articles | RoboHelp Extends Reach to Key Asian Markets With Localized Versions | 2002-08-22 08:45:30 | 0 | 0 | 0 | 7 | >| 02/08/22/161247 | Events-Calendar | Events | Multicultural Holidays Bulletin - August and September 2002 | 2002-08-22 08:59:30 | 0 | 0 | 0 | 7 | >| 02/08/22/1741253 | 1 | articles | test | 2002-08-22 10:41:38 | 1 | -1 | 0 | 7 | >| 02/08/22/1129236 | 1 | articles | CipherTrust Raises The Bar In Providing Comprehensive Protection For Enterprise Web-Enabled Mail | 2002-08-22 11:29:36 | 1 | -1 | 0 | 7 | >| 02/08/22/1138252 | 1 | articles | CipherTrust Raises The Bar In Providing Comprehensive Protection For Enterprise Web-Enabled Mail | 2002-08-22 11:38:52 | 1 | -1 | 0 | 7 | >+------------------+-----------------+----------+--------------------------------------------------------------------------------------------------+---------------------+-------------+---------------+---------------+-----+ > > > >------------------------------------------------------- >This sf.net email is sponsored by: OSDN - Tired of that same old >cell phone? Get a new here for FREE! >https://www.inphonic.com/r.asp?r=sourceforge1&refcode1=vs3390 >_______________________________________________ >Slashcode-general mailing list >Sla...@li... >https://lists.sourceforge.net/lists/listinfo/slashcode-general |