3906 replies to this topic

[donny84]

Surely there is a missing file in

\catalog\includes\modules\ultimate_seo_urls5\page_modules\

Shouldn't there be a products_new.php file?

[donny84]

This is my /includes/modules/new_products.php file...

<?php
/*
  $Id$
  osCommerce, Open Source E-Commerce Solutions
  http://www.oscommerce.com
  Copyright (c) 2010 osCommerce
  Released under the GNU General Public License
*/
  if ( (!isset($new_products_category_id)) || ($new_products_category_id == '0') ) {
	$new_products_query = tep_db_query("select p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);
  } else {
	$new_products_query = tep_db_query("select distinct p.products_id, p.products_image, p.products_tax_class_id, pd.products_name, if(s.status, s.specials_new_products_price, p.products_price) as products_price from " . TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on p.products_id = s.products_id, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c where p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and c.parent_id = '" . (int)$new_products_category_id . "' and p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '" . (int)$languages_id . "' order by p.products_date_added desc limit " . MAX_DISPLAY_NEW_PRODUCTS);
  }
  $num_new_products = tep_db_num_rows($new_products_query);
  if ($num_new_products > 0) {
	$counter = 0;
	$col = 0;
	$new_prods_content = '<table border="0" width="100%" cellspacing="0" cellpadding="2">';
	while ($new_products = tep_db_fetch_array($new_products_query)) {
	  $counter++;
	  if ($col === 0) {
		$new_prods_content .= '<tr>';
	  }
	  $new_prods_content .= '<td width="33%" align="center" valign="top"><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $new_products['products_image'], $new_products['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br /><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $new_products['products_id']) . '">' . $new_products['products_name'] . '</a><br />' . $currencies->display_price($new_products['products_price'], tep_get_tax_rate($new_products['products_tax_class_id'])) . '</td>';
	  $col ++;
	  if (($col > 2) || ($counter == $num_new_products)) {
		$new_prods_content .= '</tr>';
		$col = 0;
	  }
	}
	$new_prods_content .= '</table>';
?>
  <h2><?php echo sprintf(TABLE_HEADING_NEW_PRODUCTS, strftime('%B')); ?></h2>
  <div class="contentText">
	<?php echo $new_prods_content; ?>
  </div>
<?php
  }
?>

[vampirehunter]

is this plugin fully working and is it the best SEO search friendly url plugin available?

Edited by vampirehunter, 31 May 2013 - 08:49 AM.

[sepatufutsal]

DaddyChan, on 12 March 2013 - 10:11 AM, said:

Sorry all

it was the rerite rule within htaccess that was causing the issue.

Am off to bed for some much needed sleep..

*Note to anyone that this may nelp..  if you have installed your oscommerce on a subdomain for testing i.e  http://www.mysite.com/test  then you need to change the rewrite rule to /test

hello dady chan
may I know what is the modified of your htacces, because I have the some problem like you,
hopely can get the solution from you ...

thx

[redrum]

I have switched from Chemos SEO URLs to this one by FWR Media

I first received this error in my logs

PHP Warning: SQLiteDatabase::query() [<a href='sqlitedatabase.query'>sqlitedatabase.query</a>]: column cache_name is not unique in /xxx/includes/modules/ultimate_seo_urls5/cache_system/sqlite.php on line 130

I then updated sqlite.php from
http://forums.oscommerce.com/topic/336702-ultimate-seo-urls-5-by-fwr-media/page__st__2920#entry1573002
and reset USU5 Cache from admin

Then after a couple of minutes these error messages appeared in the logs

PHP Warning: SQLiteDatabase::query() [<a href='sqlitedatabase.query'>sqlitedatabase.query</a>]: column cache_name is not unique in /xxx/includes/modules/ultimate_seo_urls5/cache_system/sqlite.php on line 136
PHP Warning: SQLiteDatabase::query() [<a href='sqlitedatabase.query'>sqlitedatabase.query</a>]: unable to open database file in /xxx/includes/modules/ultimate_seo_urls5/cache_system/sqlite.php on line 136

These error messages have occured 5 times during 4 hours.

The folder includes/modules/ultimate_seo_urls5/cache_system/sqlite have the rights 777
I use Ultimate Seo Urls 5 PRO ( r205 ) at http://addons.oscommerce.com/info/6768
PHP Version: 5.2.17
OSC Version: 2.2 rc2a

Any idea how to fix there errors?

[redrum]

redrum, on 17 June 2013 - 05:22 PM, said:

I have switched from Chemos SEO URLs to this one by FWR Media

I first received this error in my logs

PHP Warning: SQLiteDatabase::query() [<a href='sqlitedatabase.query'>sqlitedatabase.query</a>]: column cache_name is not unique in /xxx/includes/modules/ultimate_seo_urls5/cache_system/sqlite.php on line 130

I then updated sqlite.php from
http://forums.oscommerce.com/topic/336702-ultimate-seo-urls-5-by-fwr-media/page__st__2920#entry1573002
and reset USU5 Cache from admin

Then after a couple of minutes these error messages appeared in the logs

PHP Warning: SQLiteDatabase::query() [<a href='sqlitedatabase.query'>sqlitedatabase.query</a>]: column cache_name is not unique in /xxx/includes/modules/ultimate_seo_urls5/cache_system/sqlite.php on line 136
PHP Warning: SQLiteDatabase::query() [<a href='sqlitedatabase.query'>sqlitedatabase.query</a>]: unable to open database file in /xxx/includes/modules/ultimate_seo_urls5/cache_system/sqlite.php on line 136

These error messages have occured 5 times during 4 hours.

The folder includes/modules/ultimate_seo_urls5/cache_system/sqlite have the rights 777
I use Ultimate Seo Urls 5 PRO ( r205 ) at http://addons.oscommerce.com/info/6768
PHP Version: 5.2.17
OSC Version: 2.2 rc2a

Any idea how to fix there errors?

I have some more errors in my log since the last post and one of them is new.
Here it is:

PHP Warning: SQLiteDatabase::query() [<a href='sqlitedatabase.query'>sqlitedatabase.query</a>]: database disk image is malformed in /xxx/includes/modules/ultimate_seo_urls5/cache_system/sqlite.php on line 136

I have switched "cache system" in admin from "sqlite" to "file". So lets see how that turns out.

Another question. As for the different cache systems, which is the best, next best, and so on?

Thanks,
Fredrik

Edited by redrum, Yesterday, 12:01 AM.

[redrum]

FWR Media, on 17 January 2011 - 03:27 PM, said:

Odd, how many of these do you have?

The below is not a fix but may provide me the info I need.

includes/modules/ultimate_seo_urls5/main/usu5.php

Lines 76 - 78

Find ..

	public function __destruct() {
	if ( defined( 'USU5_ENABLED' ) && ( USU5_ENABLED == 'true' ) ) {
	$this->getVar( 'cache' )->store( $this->getVar( 'registry' )->store() );

Change to ..

	public function __destruct() {
	if ( defined( 'USU5_ENABLED' ) && ( USU5_ENABLED == 'true' ) ) {
	$cache = $this->getVar( 'cache' );
	$registry = $this->getVar( 'registry' );
	$store = true;
	if ( false === ( ( $cache instanceof iCache_System ) && ( $registry instanceof Data_Registry ) ) ) {
	$store = false;
	$error = 'Cache or registry cannot be retrieved: ' . PHP_EOL . PHP_EOL . print_r( $this, true );
	trigger_error( $error, E_USER_WARNING );
	}
	( false !== $store ) ? $cache->store( $registry->store() ) : null;

Did you find a solution for this?

I hope I dont speak to mylelf here.
After changing from "sqlite" to "file", the only error message in the log that I have received during 40 hrs is

PHP Fatal error: Call to a member function store() on a non-object in /xxx/includes/modules/ultimate_seo_urls5/main/usu5.php on line 78

it occured 42 times during a period of 1,5 minute.

I searched this thread and found that some other have had the same problem, but I couldnt find any soultion for it. The closest thing I found was the qoute above.

I find it confusing that this contribution generate so many error massage for me, as faar as I know Robert is a skilled programmer.