Jump to content


Corporate Sponsors


Latest News: (loading..)

* * * * - 8 votes

Article Manager v1.0


2060 replies to this topic

#601 The Final Touch

  • Community Member
  • 8 posts
  • Real Name:Leslie Aubrey

Posted 20 September 2006, 15:06

Hi I am just working on my site and i'm very keen to instal this contribution however when i try and import the sql file i get the following error:

Quote

Database the-final-touch_net_1
Error

SQL-query : [Edit]

DELETE FROM configuration WHERE configuration_group_id = '456'

MySQL said:

Table 'the-final-touch_net_1.configuration' doesn't exist

Is there any way to solve this please..

Thanks in advance.

#602 The Final Touch

  • Community Member
  • 8 posts
  • Real Name:Leslie Aubrey

Posted 20 September 2006, 16:50

I have managed to find out how to solve the problem, it was because i was using a lycos instal package and the tables were named differently in the sql file however i now have the following problem:

1054 - Unknown column 'a.authors_id' in 'on clause'

select count(*) as total from articles a, articles_to_topics a2t left join topics_description td on a2t.topics_id = td.topics_id left join authors au on a.authors_id = au.authors_id, articles_description ad where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a.articles_id = ad.articles_id and ad.language_id = '1' and td.language_id = '1'

This appears when i click "new articles" or "All articles"

any help is much appreciated

#603 Madman00

  • Community Member
  • 150 posts
  • Real Name:AL

Posted 21 September 2006, 02:45

Hi,

I Installed Article manager 1.4. I have STS 1.9 installed. I can't get the article title and header tags to show up. The titles and headers tags for all articles are being grabbed from article_header_tags.php, and it's the same for all the articles. I've looked so many places for a solution and i tried the one posted in this forum by jaxx. It Did not do it for me. Check link here. http://creatingbeauty.com/article_info.php?articles_id=2

This article is titled as asdfadsfadsf. This should show up in the title of teh broswer so we can have a search engine freindly page.

Thanks for you help.

#604 jakobsen

  • Community Member
  • 8 posts
  • Real Name:Bo Jakobsen

Posted 21 September 2006, 17:50

I have just installed Article Manager 1.4.

Everything seems to work allright except when I enter an article. All the menus looks messy both left and right. The counters in () are missing after I enter an article.

I have worked with this problem in 2 days now....help!


/Bo

#605 xix17

  • Community Member
  • 25 posts
  • Real Name:ryan

Posted 21 September 2006, 19:34

I having please display the articles after post.

very funny, I did manage to post it online and list in all articles. but once I click into the article I cant see any article content I upload.. what is the problem>
please help and urgently

thanks

#606 joelm

  • Community Member
  • 42 posts
  • Real Name:Joel M

Posted 02 October 2006, 17:26

Any help how to install tinymce HTML editor into this contribution?

#607 claybaker

  • Community Member
  • 7 posts
  • Real Name:Clay Baker

Posted 05 October 2006, 03:23

Rob,
I just finished adding the latest Article Manager to my site. Please visit www.claybaker.com click Articles to see the installation.

I have been looking at ways to increase the content on my site by having other authors write and contribute. I have been demoing a CMS product called vivvo (www.vivvo.com). This article manager has a great feature that allows for an Administrator, Editor, Trusted Author or Writer status. A trusted Author can write an article and post it to my site on his own. A writer can author an article and submit it for review. Would you consider developing this functionality into Article Manager? If so I would be happy to discuss a contribution for your effort and a reciprocal link on my site. I'm sure that many people would benefit for this improvement.

Thanks
Clay

#608 Micke

  • Community Member
  • 191 posts
  • Real Name:Micke

Posted 05 October 2006, 07:39

Hi All!

I'd like to have a box on the Contact us page (in the middle, not in column left or right) with all the authors listed.
Name and description, clicking the name would take you to the Authors detail page with lists of articles and so on. Maybe it would be possible to modify the Authors box in some way?

// Micke

#609 toiletcake

  • Community Member
  • 21 posts
  • Real Name:Jason Lundeen
  • Location:Dallas, TX 75240

Posted 07 October 2006, 03:15

i need help fixing my site can some one help me i need to make some corrections. please let me know if there is anyone that can help me out. thanks.

http://www.pureintelligence.net

its the ccc9.3 build i need help with it thanks.

#610 monikart

  • Community Member
  • 73 posts
  • Real Name:monika
  • Gender:Female
  • Location:Chicago

Posted 08 October 2006, 01:34

The problem below is exactly what i am experiencing. except, i have STS Plus 4.2 with Header Tags installed and i loaded Article Manager 1.4

a lot of what you placed as a solution does not appear in my files. for instance the application_top does not have require(DIR_WS_FUNCTIONS . 'clean_html_comments.php');
and my sts_dispaly_output has non eof what you wrote and is located under modulte/sts_inc/sts_diplay_output. would you have any recommendations?

View Postzareen, on Nov 15 2005, 06:33 AM, said:

This Article contribution is so great! I've been having problems with it since installing STS (Simple Template Solution), and also have Header Tags installed.

My articles were not showing up wrapped in my STS pages. After many late nights, with blurry eyes, I finally tackled the problem early in the morning and found I wasn't reading the solutions correctly! So to help others having that same late night problem, I've edited the (PERFECT!) fix from Jaxx. Hope you don't mind! And that it helps others find the cure;

-----------------------------------
FIX FOR ARTICLES NOT SHOWING IN STS WITH HEADER TAGS
------------------------------------

Fix from Jaxx

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

Article Manager was not working with Simple Template System 1.9 and higher with the Header Tags Controller installed. To get the HTC and STS to work I stated in a previous post that all that was needed was to disable the HTC code in /catalog/includes/application_top.php, since STS has HTC support built already. Here's what I actually did to make everything play well together:

-----------------------------
/includes/application_top.php
-----------------------------
Article Manager specifies to comment out the following line if HTC installed:CODE

require(DIR_WS_FUNCTIONS . 'clean_html_comments.php');

Instead, Change that line to:
require_once(DIR_WS_FUNCTIONS . 'clean_html_comments.php');

Make sure that // require_once(DIR_WS_FUNCTIONS . 'header_tags.php'); is commented out

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

HTC adds the following code:
CODE

// BOF: WebMakers.com Added: Header Tags Controller v1.0
require(DIR_WS_FUNCTIONS . 'header_tags.php');
// Clean out HTML comments from ALT tags etc.
require(DIR_WS_FUNCTIONS . 'clean_html_comments.php');
// Also used by: WebMakers.com Added: FREE-CALL FOR PRICE
// EOF: WebMakers.com Added: Header Tags Controller v1.0
Comment out or delete this section. STS has support for HTC in sts_display_output.php.
------------------------------------------
/catalog/includes/article_header_tags.php
------------------------------------------
Added the following line to the end of the file, before the closing ?> tag:
CODE

// flag to determine whether to use custom tags or article header tags with STS
$use_ah_tags = 'true';
-------------------------------------------------------------
/catalog/article*.php -- that means ALL the article files...
-------------------------------------------------------------
Comment out or delete the HTC <?php ?> code blocks immediately above and below the
CODE

<title><?php echo TITLE ?></title>
line, so that it looks like this:

<?php /*
// Mofification of Header Tags Contribution
// BOF: WebMakers.com Changed: Header Tag Controller v1.0
// Replaced by header_tags.php
if ( file_exists(DIR_WS_INCLUDES . 'article_header_tags.php') ) {
require(DIR_WS_INCLUDES . 'article_header_tags.php');
} else {*/
?>
<title><?php echo TITLE ?></title>
<?php /*
}
// EOF: WebMakers.com Changed: Header Tag Controller v1.0
*/ ?>

---------------------------------------------------
Still in ALL /catalog/Article files (article*.php)
---------------------------------------------------

Changed the code between <!-- header //--> and <!-- header_eof //--> to the following:
CODE

<!-- header //-->
<?php require(DIR_WS_INCLUDES . 'header.php');

// Moved header tag call to here to facilitate STS blocks
if ( file_exists(DIR_WS_INCLUDES . 'article_header_tags.php') ) {
require(DIR_WS_INCLUDES . 'article_header_tags.php');
}
?>
<!-- header_eof //-->
--------------------------------------------------
/includes/sts_display_output.php
--------------------------------------------------
Comment out (approx line 159)
require_once(DIR_WS_FUNCTIONS . 'clean_html_comments.php');
--------------------------------------------------------------

Change Lines 149-167 (stock file) (HTC support code)

// STS: ADD: Support for WebMakers.com's Header Tag Controller contribution
// Capture the output
require(STS_START_CAPTURE);

// BOF: WebMakers.com Changed: Header Tag Controller v1.0
// Replaced by header_tags.php
if ( file_exists(DIR_WS_INCLUDES . 'header_tags.php') ) {
require(DIR_WS_FUNCTIONS . 'clean_html_comments.php');
require(DIR_WS_FUNCTIONS . 'header_tags.php');
require(DIR_WS_INCLUDES . 'header_tags.php');
} else {
echo "<title>" . TITLE . "</title>";
}
// EOF: WebMakers.com Changed: Header Tag Controller v1.0

$sts_block_name = 'headertags';
require(STS_STOP_CAPTURE);

// STS: EOADD: Support for WebMakers.com's Header Tag Controller contribution

--------------------------------
to the following:
------------------------------------

// STS: ADD: Support for WebMakers.com's Header Tag Controller contribution
// BOF: WebMakers.com Changed: Header Tag Controller v1.0
// Replaced by header_tags.php
// Modified to work with Article Manager (which uses custom headers)
if ($use_ah_tags == 'true') {
// require(DIR_WS_INCLUDES . 'article_header_tags.php');
// don't process HTC - use headertags from article_header_tags
} else {
// Capture the output
require(STS_START_CAPTURE);
if ( file_exists(DIR_WS_INCLUDES . 'header_tags.php') ) {
require_once(DIR_WS_FUNCTIONS . 'clean_html_comments.php');
require_once(DIR_WS_FUNCTIONS . 'header_tags.php');
require(DIR_WS_INCLUDES . 'header_tags.php');
} else {
echo "<title>" . TITLE . "</title>";
}
$sts_block_name = 'headertags';
require(STS_STOP_CAPTURE);
}

// EOF: WebMakers.com Changed: Header Tag Controller v1.0
// STS: EOADD: Support for WebMakers.com's Header Tag Controller contribution


--------------------------------------
AND FINALLY
--------------------------------------

still in catalog/includes/sts_display_output.php
comment out:

require(DIR_WS_FUNCTIONS . 'clean_html_comments.php');

What would you do if you knew you could not fail?

#611 Tsuri Japan

  • Community Member
  • 415 posts
  • Real Name:Nigel

Posted 19 October 2006, 04:43

I've just installed this contrib and my admin side is ok but when I do the includes/application_top.php add the following:

Look for:

// add the products model to the breadcrumb trail
  if (isset($HTTP_GET_VARS['products_id'])) {
	$model_query = tep_db_query("select products_model from " . TABLE_PRODUCTS . " where products_id = '" . (int)$HTTP_GET_VARS['products_id'] . "'");
	if (tep_db_num_rows($model_query)) {
	  $model = tep_db_fetch_array($model_query);
	  $breadcrumb->add($model['products_model'], tep_href_link(FILENAME_PRODUCT_INFO, 'cPath=' . $cPath . '&products_id=' . $HTTP_GET_VARS['products_id']));
	}
  }

and after add:

// include the articles functions
  require(DIR_WS_FUNCTIONS . 'articles.php');
  require(DIR_WS_FUNCTIONS . 'article_header_tags.php');
 

// calculate topic path
  if (isset($HTTP_GET_VARS['tPath'])) {
	$tPath = $HTTP_GET_VARS['tPath'];
  } elseif (isset($HTTP_GET_VARS['articles_id']) && !isset($HTTP_GET_VARS['authors_id'])) {
	$tPath = tep_get_article_path($HTTP_GET_VARS['articles_id']);
  } else {
	$tPath = '';
  }

  if (tep_not_null($tPath)) {
	$tPath_array = tep_parse_topic_path($tPath);
	$tPath = implode('_', $tPath_array);
	$current_topic_id = $tPath_array[(sizeof($tPath_array)-1)];
  } else {
	$current_topic_id = 0;
  }

// add topic names or the author name to the breadcrumb trail
  if (isset($tPath_array)) {
	for ($i=0, $n=sizeof($tPath_array); $i<$n; $i++) {
	  $topics_query = tep_db_query("select topics_name from " . TABLE_TOPICS_DESCRIPTION . " where topics_id = '" . (int)$tPath_array[$i] . "' and language_id = '" . (int)$languages_id . "'");
	  if (tep_db_num_rows($topics_query) > 0) {
		$topics = tep_db_fetch_array($topics_query);
		$breadcrumb->add($topics['topics_name'], tep_href_link(FILENAME_ARTICLES, 'tPath=' . implode('_', array_slice($tPath_array, 0, ($i+1)))));
	  } else {
		break;
	  }
	}
  } elseif (isset($HTTP_GET_VARS['authors_id'])) {
	$authors_query = tep_db_query("select authors_name from " . TABLE_AUTHORS . " where authors_id = '" . (int)$HTTP_GET_VARS['authors_id'] . "'");
	if (tep_db_num_rows($authors_query)) {
	  $authors = tep_db_fetch_array($authors_query);
	  $breadcrumb->add('Articles by ' . $authors['authors_name'], tep_href_link(FILENAME_ARTICLES, 'authors_id=' . $HTTP_GET_VARS['authors_id']));
	}
  }

// add the articles name to the breadcrumb trail
  if (isset($HTTP_GET_VARS['articles_id'])) {
	$article_query = tep_db_query("select articles_name from " . TABLE_ARTICLES_DESCRIPTION . " where articles_id = '" . (int)$HTTP_GET_VARS['articles_id'] . "'");
	if (tep_db_num_rows($article_query)) {
	  $article = tep_db_fetch_array($article_query);
	  if (isset($HTTP_GET_VARS['authors_id'])) {
		$breadcrumb->add($article['articles_name'], tep_href_link(FILENAME_ARTICLE_INFO, 'authors_id=' . $HTTP_GET_VARS['authors_id'] . '&articles_id=' . $HTTP_GET_VARS['articles_id']));
	  } else {
		$breadcrumb->add($article['articles_name'], tep_href_link(FILENAME_ARTICLE_INFO, 'tPath=' . $tPath . '&articles_id=' . $HTTP_GET_VARS['articles_id']));
	  }
	}
  }

I get this error:
Parse error: syntax error, unexpected T_DNUMBER in /home/fukuokaf/public_html/tsurishopjapan/includes/application_top.php on line 257

right after this line is where I added the code:
$cPath . '&products_id=' . $HTTP_GET_VARS['products_id']));
}
}

I'm adding the new HTML code but it's not working.... also if I add the code to the colum left or right I'm getting errors again. I'm almost there guys and I would appreciate any help on this. FYI I do have header tags contrib installed on my site if that means anything. If need be I can post my whole aplication top file.

Nigel

Edited by Tsuri Japan, 19 October 2006, 04:45.


#612 Tsuri Japan

  • Community Member
  • 415 posts
  • Real Name:Nigel

Posted 19 October 2006, 10:51

UDATE ERROR MESSAGE:

If I add the code to the includes/colum left or right this is the error I'm getting:
Fatal error: Call to undefined function: tep_has_topic_subtopics() in /home/fukuokaf/public_html/tsurishopjapan/includes/boxes/articles.php on line 41

Just trying to give more info so I can get this figured out!

Thanks in advance,

Nigel

#613 Tsuri Japan

  • Community Member
  • 415 posts
  • Real Name:Nigel

Posted 19 October 2006, 17:19

got it.......I just removed this section in the includes/aplication top and it worked for me!

// verify the IP address if the feature is enabled
  if (SESSION_CHECK_IP_ADDRESS == 'True') {
	67.138.240.18_address = tep_get_ip_address();
	if (!tep_session_is_registered('SESSION_IP_ADDRESS')) {
	  $SESSION_IP_ADDRESS = $ip_address;
	  tep_session_register('SESSION_IP_ADDRESS');
	}

	if ($SESSION_IP_ADDRESS != $ip_address) {
	  tep_session_destroy();
	  tep_redirect(tep_href_link(FILENAME_LOGIN));
	}
  }

Hope this helps for others!

Nigelman

#614 genxer

  • Community Member
  • 3 posts
  • Real Name:Beth

Posted 28 October 2006, 04:19

I am having an issue with Article manager on only one of our oscommerce sites. We have it running on about 50 sites and this is the only site with the problem. There are no errors but if you go to the articles, it doesn't display the page 1 2 3 4 on the articles and all articles page.

There are no errors and i just can't figure out where its generating from

http://www.naturalsupplementwarehouse.com

Edited by genxer, 28 October 2006, 04:23.


#615 zaxxon

  • Community Member
  • 159 posts
  • Real Name:Ron
  • Location:Northern Ireland

Posted 06 November 2006, 12:50

View Postclaybaker, on Oct 5 2006, 03:23 AM, said:

This vivvo article manager has a great feature that allows for an Administrator, Editor, Trusted Author or Writer status. A trusted Author can write an article and post it to my site on his own. A writer can author an article and submit it for review. Would you consider developing this functionality into Article Manager? If so I would be happy to discuss a contribution for your effort and a reciprocal link on my site. I'm sure that many people would benefit for this improvement.

i totaly agree, it wouldbe great if other users can add articles, it makes collecting theirmaterial and publishing it a fully outsource proccess - i wouldnt need to ask them for it to publish any thing and i wouldnt need to give them access to my admin area.

i cant help with any coding , but would definetly consider donating to the effort in other ways.
currently using OSC2.2MS2 051113 with the following contributions:

AJAX Attributemanager 2.1 - All_products 4.4 - Banner manager 1.5b - banner hack picture in manager * description in product listing hack ms2 v2.4 * drop shadow boxes v.1.1 * Easy populater 2.76d-ms2 by surfalot * FCKEditor * header tag controller v2.5.9 * jcssmenu * LoginBox 5.6 * option type feature v1.71 * OSC-Cach-v1.1 * popup_imagecleaned_stilized_2 * Remove from cart button hack * scrolling bestsellers * Article manager1.4 * Links Manager v1.14. * proffessional invoice&packingslip 6.1 * Ultimate SEO URLs

Personaly i think all these features NEED to be in the main core as they are quite basic features that are missing. but then again what do i know?

#616 zaxxon

  • Community Member
  • 159 posts
  • Real Name:Ron
  • Location:Northern Ireland

Posted 08 November 2006, 10:57

could any one help in posting some code orpointing to the right direction about how to just show the article topics ?
i just installed it and i have about 5 articles on it and already it looks very cluttered. if i could just display the topics and then the user can drill down to his article it would present it better for me.
thanks in advance
currently using OSC2.2MS2 051113 with the following contributions:

AJAX Attributemanager 2.1 - All_products 4.4 - Banner manager 1.5b - banner hack picture in manager * description in product listing hack ms2 v2.4 * drop shadow boxes v.1.1 * Easy populater 2.76d-ms2 by surfalot * FCKEditor * header tag controller v2.5.9 * jcssmenu * LoginBox 5.6 * option type feature v1.71 * OSC-Cach-v1.1 * popup_imagecleaned_stilized_2 * Remove from cart button hack * scrolling bestsellers * Article manager1.4 * Links Manager v1.14. * proffessional invoice&packingslip 6.1 * Ultimate SEO URLs

Personaly i think all these features NEED to be in the main core as they are quite basic features that are missing. but then again what do i know?

#617 jchasick

  • Community Member
  • 1,511 posts
  • Real Name:jeff
  • Location:California

Posted 09 November 2006, 03:48

I used the patches in this thread and it fixed my problem with I click on NEW ARTICLES

but... when I click on ALL ARTICLES, I am still getting the following error:

1054 - Unknown column 'a.authors_id' in 'on clause'

select count(*) as total from articles a, articles_to_topics a2t left join topics_description td on a2t.topics_id = td.topics_id left join authors au on a.authors_id = au.authors_id, articles_description ad where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a.articles_id = ad.articles_id and ad.language_id = '1' and td.language_id = '1'

[TEP STOP]


all I know is that the problem is in articles.php

anyone know the patch for this?

TIA

#618 zaxxon

  • Community Member
  • 159 posts
  • Real Name:Ron
  • Location:Northern Ireland

Posted 09 November 2006, 14:24

View Postzaxxon, on Nov 8 2006, 10:57 AM, said:

could any one help in posting some code orpointing to the right direction about how to just show the article topics ?
i just installed it and i have about 5 articles on it and already it looks very cluttered. if i could just display the topics and then the user can drill down to his article it would present it better for me.
thanks in advance
started typing with out investigatin it my self. i removed the article box cuz i didnt want any more boxes in my column.one i brought back the article box all the menus and submenues work perfectly . i use JCSSMENU and was hoping to integrate the article manager with it(look at my menu here - my webpage - at the moment i just have one link there for the articles.php file. but i would like that link to 'fly out' like the rest of the categories sub menus. this way it would look neater and i wouldnt have to have yet another BOX. in jcssmenu code there is this section that agregates all the categories and sub categories but i cant figure it out as i have no php skills at all
view the code in here

has any one ever integrated this with jcssmenu ?
many thanks in advance for any help
currently using OSC2.2MS2 051113 with the following contributions:

AJAX Attributemanager 2.1 - All_products 4.4 - Banner manager 1.5b - banner hack picture in manager * description in product listing hack ms2 v2.4 * drop shadow boxes v.1.1 * Easy populater 2.76d-ms2 by surfalot * FCKEditor * header tag controller v2.5.9 * jcssmenu * LoginBox 5.6 * option type feature v1.71 * OSC-Cach-v1.1 * popup_imagecleaned_stilized_2 * Remove from cart button hack * scrolling bestsellers * Article manager1.4 * Links Manager v1.14. * proffessional invoice&packingslip 6.1 * Ultimate SEO URLs

Personaly i think all these features NEED to be in the main core as they are quite basic features that are missing. but then again what do i know?

#619 jchasick

  • Community Member
  • 1,511 posts
  • Real Name:jeff
  • Location:California

Posted 09 November 2006, 15:11

to help narrow down where the error is occuring I added some echo statements and the error is being generated from the following code:

catalog/articles.php


<?php
$articles_all_array = array();

$articles_all_query_raw = "select a.articles_id, a.articles_date_added, ad.articles_name, ad.articles_head_desc_tag, au.authors_id, au.authors_name, td.topics_id, td.topics_name from " . TABLE_ARTICLES . " a, " . TABLE_ARTICLES_TO_TOPICS . " a2t left join " . TABLE_TOPICS_DESCRIPTION . " td on a2t.topics_id = td.topics_id left join " . TABLE_AUTHORS . " au on a.authors_id = au.authors_id, " . TABLE_ARTICLES_DESCRIPTION . " ad where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a.articles_id = ad.articles_id and ad.language_id = '" . (int)$languages_id . "' and td.language_id = '" . (int)$languages_id . "' order by a.articles_date_added desc, ad.articles_name";




1054 - Unknown column 'a.authors_id' in 'on clause'

select count(*) as total from articles a, articles_to_topics a2t left join topics_description td on a2t.topics_id = td.topics_id left join authors au on a.authors_id = au.authors_id, articles_description ad where (a.articles_date_available IS NULL or to_days(a.articles_date_available) <= to_days(now())) and a.articles_id = a2t.articles_id and a.articles_status = '1' and a.articles_id = ad.articles_id and ad.language_id = '1' and td.language_id = '1'

Edited by jchasick, 09 November 2006, 15:12.

Reading is beneficial - Searching is enlightening
find answers at wiki.oscommerce.com/top

#620 mkwinters

  • Community Member
  • 1 posts
  • Real Name:Kyle Winters

Posted 13 November 2006, 03:35

Hi All,

The Article Manager appeared to work at first. Loaded 2 articles. Now when I try to add articles, and I hit preview, before insert, it states:

"Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, webmaster@addictiveperformance.com and inform them of the time the error occurred, and anything you might have done that may have caused the error.

More information about this error may be available in the server error log.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request. "


Now I know this appears to be a server error; however, if my article is only 1-3 sentences in length.. it will submit w/o the error. In addition my error log reads:

[Sun Nov 12 22:27:50 2006] [error] [client REMOVED] mod_security: Access denied with code 500. Pattern match "((select|grant|delete|insert|drop|alter|replace|truncate|update|create|rena
me|describe)[[:space:]]+[A-Z|a-z|0-9|\\\\*| |\\\\,]+[[:space:]]+(from|into|table|database|index|view)[[:space:]]+[A-Z|a-z|0-9|\\\\*| |\\\\,]|UNION SELECT.*\\\\'.*\\\\'.*,[0-9].*INTO.*FROM)" at POST_PAYLOAD [id "300013"][rev "1"] [msg "Generic SQL injection protection"] [severity "2"] [hostname "www.REMOVED.com"] [uri "/catalog/admin/articles.php?tPath=2&action=article_preview"]
[Sun Nov 12 22:27:50 2006] [error] [client 71.71.243.124] File does not exist: /home/REMOVED/domains/REMOVED.com/public_html/500.shtml


so, any recommendations/ ideas?