Jump to content
Latest News: (loading..)
FWR Media

ULTIMATE Seo Urls 5 - by FWR Media

Recommended Posts

Surely there is a missing file in

 

\catalog\includes\modules\ultimate_seo_urls5\page_modules\

 

Shouldn't there be a products_new.php file?

Share this post


Link to post
Share on other sites

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
 }
?>

Share this post


Link to post
Share on other sites

Sorry all :blush:

 

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

 

Am off to bed for some much needed sleep.. :blush: :blush: :blush:

 

*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

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Well, this contribution keeps confusing me.

 

I noticed that the settings in admin was changed;

Cache system was chaned from "file" to "sqlite"

uri format was changed from "rewrite" to "standard"

So the settings was reverted to default.

 

I thougth it was very odd, but just changed it back. A few hours later it was back to default again.

I then checked the database tables for usu5 and noticed that the time for date_added was just recently.

 

So for some reason usu5 reinstalls for me.

 

help, anyone?

Share this post


Link to post
Share on other sites

Installed this about a year or so ago (maybe more) and it works great. Question though: Is there a way to get rid of (examples)

 

-c-24_66.html for categories

 

and

 

-p-5743.html for products

 

in order just to end clenaly with the keyworded category/product name?

 

Thanks!

Share this post


Link to post
Share on other sites

HI All,

 

Thank you for this great addon.

 

I have a problem, in rewrite mode, with .htaccess.

All the time then I click to category link or product link, it trying to access this page and then redirect all the time to index.php. On the server mod_rewrite is ON and configured.

 

I don't know why this happens, have you see this before?

 

htaccess

 

# If you are getting errors you may need to comment this out like ..

# Options +FollowSymLinks

Options +SymLinksIfOwnerMatch

 

<IfModule mod_rewrite.c>

RewriteEngine On

 

# RewriteBase instructions

# Change RewriteBase dependent on how your shop is accessed as below.

# http://www.mysite.com = RewriteBase /

# http://www.mysite.com/catalog/ = RewriteBase /catalog/

# http://www.mysite.com/catalog/shop/ = RewriteBase /catalog/shop/

 

# Change RewriteBase using the instructions above

RewriteBase /

RewriteRule ^([a-z0-9/-]+)-p-([0-9]+).html$ product_info.php [NC,L,QSA]

RewriteRule ^([a-z0-9/-]+)-c-([0-9_]+).html$ index.php [NC,L,QSA]

RewriteRule ^([a-z0-9/-]+)-m-([0-9]+).html$ index.php [NC,L,QSA]

RewriteRule ^([a-z0-9/-]+)-pi-([0-9]+).html$ popup_image.php [NC,L,QSA]

RewriteRule ^([a-z0-9/-]+)-pr-([0-9]+).html$ product_reviews.php [NC,L,QSA]

RewriteRule ^([a-z0-9/-]+)-pri-([0-9]+).html$ product_reviews_info.php [NC,L,QSA]

# Articles contribution

RewriteRule ^([a-z0-9/-]+)-t-([0-9_]+).html$ articles.php [NC,L,QSA]

RewriteRule ^([a-z0-9/-]+)-au-([0-9]+).html$ articles.php [NC,L,QSA]

RewriteRule ^([a-z0-9/-]+)-a-([0-9]+).html$ article_info.php [NC,L,QSA]

# Information pages

RewriteRule ^([a-z0-9/-]+)-i-([0-9]+).html$ information.php [NC,L,QSA]

# Links contribution

RewriteRule ^([a-z0-9/-]+)-links-([0-9_]+).html$ links.php [NC,L,QSA]

# Newsdesk contribution

RewriteRule ^([a-z0-9/-]+)-n-([0-9]+).html$ newsdesk_info.php [NC,L,QSA]

RewriteRule ^([a-z0-9/-]+)-nc-([0-9]+).html$ newsdesk_index.php [NC,L,QSA]

RewriteRule ^([a-z0-9/-]+)-nri-([0-9]+).html$ newsdesk_reviews_info.php [NC,L,QSA]

RewriteRule ^([a-z0-9/-]+)-nra-([0-9]+).html$ newsdesk_reviews_article.php [NC,L,QSA]

</IfModule>

Share this post


Link to post
Share on other sites

Hello, i have the seo url 5 installed and working fine, but few months ago the website stopped working, throwing this error message:

 

Fatal error: Class 'SQLiteDatabase' not found in /home/xxxxxx/public_html/includes/modules/ultimate_seo_urls5/cache_system/sqlite.php on line 103

 

so i turned the Cache System to MySQL in stead of sqlite.

 

the website worked again without errors, but this is what happened:

  • Dramatic decrease in website ranking
  • I got the error_log file size to 5GB+

i opened the error_log file, i found the following message repeated infinitely (each second):

 

PHP compiled with module API=20090626

These options need to match

in Unknown on line 0

[27-Jun-2013 08:01:52 America/Chicago] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_sqlite.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_sqlite.so: undefined symbol: php_pdo_register_driver in Unknown on line 0

[27-Jun-2013 08:01:52 America/Chicago] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/sqlite.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/sqlite.so: undefined symbol: php_pdo_register_driver in Unknown on line 0

[27-Jun-2013 08:01:52 America/Chicago] PHP Warning: PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_mysql.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_mysql.so: undefined symbol: php_pdo_get_dbh_ce in Unknown on line 0

[27-Jun-2013 08:01:52 America/Chicago] PHP Deprecated: Directive 'magic_quotes_gpc' is deprecated in PHP 5.3 and greater in Unknown on line 0

[27-Jun-2013 08:02:12 America/Chicago] PHP Warning: PHP Startup: PDO: Unable to initialize module

Module compiled with module API=20060613

 

PLEASE HELP

Share this post


Link to post
Share on other sites

I installed this twice. I removed it the first time because there was something wrong on my end. When I removed the installation I also removed "seo url" in configuration in my admin. I deleted that in MyphpAdmin. I just installed this again but I can no longer see seo in my configuration in admin so basically nothing has changed and I cannot turn the setting to "true." I have read through all the pages in this support thread but I cannot find anyone else with this problem. Please help.

Share this post


Link to post
Share on other sites

hello

 

i am programming my modified site with among seo url and header tags 3.0 to work with multiple sites contrib 1730.

 

everything work ok but if seo url is turned on i get "The page isn't redirecting properly" a problem with cookies

 

if i turn off seo everything works correct

 

the contrib add stores_id to products, categories, manufacturer etc which is saved in the configuration table

 

can anyone help ?

 

greet

eric

Share this post


Link to post
Share on other sites

I have just installed this in 2.3.3 with the only other add-ons being a paypal payment module, KISSer and KISSit. It seems to be working fine but is throwing one error as below. None of our products have a model which is not the trivial string. But models are working - I tried adding one and they show beneath the product on the product page. There is some discussion about this earlier concerning corrupt databases: I don't think that is our problem since the SQL query that FWR Media gave previously works fine and returns products_model as the empty string (or something that lokos like that). Has anybody actually fixed this?

 

Toby

Error: Undefined index: products_model

File: includes/modules/ultimate_seo_urls5/page_modules/product_info.php

Line: 189

Share this post


Link to post
Share on other sites

hello, I have a problem with the issue of special characters, I only recognized the strange characters in the Spanish language is the admin, but in German, Swedish. French Norwegian etc., appear square on the links and texts etc, put the files for special characters in different languages​​, I put either the name of the file and fill in the missing letters for conversion, but nothing happens, could give me some help please?, thanks, the address is www.arthandpainted.com

Share this post


Link to post
Share on other sites

Hi Ashley

 

Please try the attached file and post back here how it handles your issue.

 

This replacement file intends to handle an issue where an old/changed cPath would not 301 redirect to the new version.

 

catalog/includes/modules/ultimate_seo_urls5/main/validator.php

 

validator.php

 

You should add this to the addon page, just this single file telling people it would solve the problem with DC.

 

/action-c-3_10 - Valid

 

/action-c-0_10 - Invalid, but instead of showing category 10, it redirect to the URL above.

Share this post


Link to post
Share on other sites

Hiya!

 

I've recently moved my Oscommerce site to a VPS Host instead of a Shared Host, I've followed the tutorial and updated the configure files x2 with the new updated database details.

But I keep getting this error whenever I access any part of the site:

 

Fatal error: Class 'SQLiteDatabase' not found in /home/gimme/public_html/includes/modules/ultimate_seo_urls5/cache_system/sqlite.php on line 103

 

Do you have any idea what this is about?

 

I have checked the Database and it has been imported correctly from the old host and all the tables are there and the new database info added to configure files in Includes and Admin.

 

Is there anyway to Disable SEO Urls via the database or anything just so I can at least get the site back on for now?

 

Many thanks for any responses!

 

Andy.

Share this post


Link to post
Share on other sites

Hi there, hi Robert.

 

I get this error when i switch cache to true :

 

Catchable fatal error: Argument 1 passed to Data_Registry::load() must be an array, boolean given, called in /web/htdocs/www.***.*/home/***/includes/modules/ultimate_seo_urls5/main/usu5.php on line 276 and defined in /web/htdocs/www.***.*/home/***/includes/modules/ultimate_seo_urls5/main/registry.php on line 133

 

It seems that that error appear only when i try a search like :

 

.../advanced_search_result.php?keywords=dolce e gabbana OR time&search_in_description=1&language=it

 

And i want to ask you if is possible to use cache default OsCommerce system instead of USU5 cache. Or USU5 cache replace it ?

 

Can you help me ?

 

Thanks

Edited by Predator123

Share this post


Link to post
Share on other sites

I can add this info :

 

It happened after some days of cache enabled. I have about 9000 products in store and "file" system cache enabled. It seems like "saturated" error.

 

Hope this helps

Share this post


Link to post
Share on other sites

Hiya!

 

I've recently moved my Oscommerce site to a VPS Host instead of a Shared Host, I've followed the tutorial and updated the configure files x2 with the new updated database details.

But I keep getting this error whenever I access any part of the site:

 

Fatal error: Class 'SQLiteDatabase' not found in /home/gimme/public_html/includes/modules/ultimate_seo_urls5/cache_system/sqlite.php on line 103

 

Do you have any idea what this is about?

 

I have checked the Database and it has been imported correctly from the old host and all the tables are there and the new database info added to configure files in Includes and Admin.

 

Is there anyway to Disable SEO Urls via the database or anything just so I can at least get the site back on for now?

 

Many thanks for any responses!

 

Andy.

 

 

Hi again!

 

I Updated my SEO Urls to the latest version to try and get rid of this Error.

 

I did that but now I'm getting this:

 

Fatal error Call to a member function retrieveDependencies() on a non-object in /home/gimme/public_html/includes/modules/ultimate_seo_urls5/uri_modules/path_standard.php on line83

 

Any help is appreciated!

 

Many thanks.

Edited by AngelLoving

Share this post


Link to post
Share on other sites

Hi, I'm a novice, I'm not a programmer or anything, the server tells me this is a problem of "ultimate seo", the server tells me that:

"The SQLite Library version on our servers is 3.3.7"

I would appreciate help, was finished, after much work, now nothing works, I'm desperate

Fatal error: Uncaught exception 'SQLiteException' with message 'SQLiteDatabase::__construct() [<a href='sqlitedatabase.--construct'>sqlitedatabase.--construct</a>]: database disk image is malformed' in /home/www/dominio.com/includes/modules/ultimate_seo_urls5/cache_system/sqlite.php:103 Stack trace: #0 /home/www/dominio.com/includes/modules/ultimate_seo_urls5/cache_system/sqlite.php(103): SQLiteDatabase->__construct('/home/www/dominio...', 438, 'database disk i...') #1 /home/www/dominio.com/includes/modules/ultimate_seo_urls5/cache_system/sqlite.php(66): Sqlite_Cache_Module::createDatabase() #2 [internal function]: Sqlite_Cache_Module::i() #3 /home/www/dominio.com/includes/modules/ultimate_seo_urls5/main/bootstrap.php(515): call_user_func(Array) #4 /home/www/dominio.com/includes/modules/ultimate_seo_urls5/main/bootstrap.php(86): Usu5_Bootstrap->cacheSystem() #5 /home/www/dominio.com/includes/modules/ultimate_seo_urls5/main/usu5.php(119): Usu5_Bootstrap->bootStrapper(Object(language) in /home/www/dominio.com/includes/modules/ultimate_seo_urls5/cache_system/sqlite.php on line 103

Share this post


Link to post
Share on other sites

Hi

just a question :

 

is normal to have Data loaded from cache: false( Cache System: File_Cache_Module )

my cache is : files.

 

What is the best memecached or files ?

 

tandard URI produced: 28

SEO URI produced: 54

Query Count: 34

Queries Saved: 20

Cache load time: 0.0001 seconds ( includes gzinflate/base64_decode/unserialize )

Data loaded from cache: false ( Cache System: File_Cache_Module )

Total query time: 0.0089 seconds

Cache system is On

Thanks ?

Edited by Gyakutsuki


Regards
-----------------------------------------
Loïc

Contact me by skype for business
Contact me @gyakutsuki for an answer on the forum

Tuto for 2.4 :
- How to Display a new page with app
- How to make Header Tags under app APP
- How to make a
boostrap modal with external element
 

 

Share this post


Link to post
Share on other sites

I just had problems clearing the cache for this add-on under 2.3.3. The culprit seems to be the odd coding (probably there's a reason) of tep_reset_cache_data_usu5 which uses lots of ../ and so on to locate the catalog/includes/modules directory. This breaks if the admin is located outside of and at the same level as the catalog.

 

Replacing the second line of the function with the more usual

 

$usu5_path = DIR_FS_DOCUMENT_ROOT . DIR_WS_MODULES . 'ultimate_seo_urls5/';

 

seems to cure the problem.

Share this post


Link to post
Share on other sites

Hi there

I'd like to get rd of the -c-9999 and other markets...

When I remove them the page is not displayed, although the address is good

ie the link/url is domain/catalog/productname and when I click on the link, page not found...

Any clue ?

thanks

Fred

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×