[phpws-comm-auto] [ phpwebsite-comm-Support Requests-771989 ] Converted articles can't be deleted

[SourceForge.net <no...@so...>]

Support Requests item #771989, was opened at 2003-07-15 20:11
Message generated for change (Comment added) made by adarkling
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=563509&aid=771989&group_id=81360

Category: Module: article
Group: None
Status: Open
Resolution: None
Priority: 5
Submitted By: David M Walker (datamgmt)
Assigned to: Nobody/Anonymous (nobody)
Summary: Converted articles can't be deleted

Initial Comment:
After converting my pagemaster pages to articles I 
could not delete any of the ones I did not require and 
got the message

DB Error: no such field
SELECT * FROM mod_article_sections WHERE id IN (a) 
[nativecode=1054 ** Unknown column 'a' in 'where 
clause']

----------------------------------------------------------------------

Comment By: Eloi George (adarkling)
Date: 2003-07-16 16:25

Message:
Logged In: YES 
user_id=619893

I ran a few test conversions & they all came out OK.  Here's
a few things to try:

1) The error you described sounds like the section never got
saved to the table, possibly because the database server was
overworked.  Try doing the conversion when database usage is
low.

2) Make sure that you've made the change to your
/core/Database.php file that I recommended in INSTALL.txt so
you can see any error messages that the database creates. 
If it spits out some SQL errors & you don't see what went
wrong, send it to my e-mail so I can analyze it.

3) It's not needed & I'm not sure if the slashes will get
doubled up, but you can try changing
article/inc/importPM.php line 55 from:

$current_section->title = $old_page->sections[$x]->title;
to:
$current_section->title =
addslashes($old_page->sections[$x]->title);

and line 57 from:
$current_section->text = $old_page->sections[$x]->text;
to:
$current_section->text =
addslashes($old_page->sections[$x]->text);



----------------------------------------------------------------------

Comment By: Eloi George (adarkling)
Date: 2003-07-15 22:49

Message:
Logged In: YES 
user_id=619893

That sounds like a conversion error.  I'll run some test
conversions tonight & see if I can replicate it.  


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=563509&aid=771989&group_id=81360