Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

ULTIMATE Seo Urls 5 - by FWR Media


Recommended Posts

I have no clue what could have happened to the database then :( I am the only person with access. Since the store went live couple of months back, I haven't messed either with the php files nor database and everything worked correctly till now. As all I know about php and mysql comes from this forum and from the add-on install instructions, my knowledge is limited.

 

 

I made a backup of the sql file, opened it, and these are the only entries concerning USU5 in the database that I found (I corelated them with the installer.php script):

 

INSERT INTO `configuration_group` (`configuration_group_id`, `configuration_group_title`, `configuration_group_description`, `sort_order`, `visible`) VALUES (...),(..),(41,'Seo Urls 5','Options for ULTIMATE Seo Urls 5 by FWR Media',99,1),(..)

 

and

 

DROP TABLE IF EXISTS `usu_cache`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `usu_cache` (
 `cache_name` varchar(32) NOT NULL,
 `cache_data` mediumtext NOT NULL,
 `cache_date` datetime NOT NULL,
 PRIMARY KEY  (`cache_name`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `usu_cache`
--

LOCK TABLES `usu_cache` WRITE;
/*!40000 ALTER TABLE `usu_cache` DISABLE KEYS */;
/*!40000 ALTER TABLE `usu_cache` ENABLE KEYS */;
UNLOCK TABLES;

 

 

Would it be possible to edit the installer.php script in order to load up the missing database entries?

 

Save the following as usu5_db_removal.php

 

<?php
 require_once 'includes/application_top.php';

 $query = "DROP TABLE `usu_cache`";

 tep_db_query( $query );

 $query = "DELETE FROM `configuration_group` WHERE configuration_group_title = 'Seo Urls 5'";

 tep_db_query( $query );

 $keys = array( 'SEO_URLS_ENABLED', 'SEO_ADD_CPATH_TO_PRODUCT_URLS', 'SEO_ADD_CAT_PARENT',
                'SEO_URLS_FILTER_SHORT_WORDS', 'SEO_URLS_USE_W3C_VALID', 'SEO_URLS_TYPE',
                'SEO_CHAR_CONVERT_SET', 'SEO_REMOVE_ALL_SPEC_CHARS', 'SEO_URLS_CACHE_DAYS',
                'SEO_URLS_CACHE_RESET', 'SEO_URLS_OUPUT_PERFORMANCE', 'SEO_URLS_CACHE_SYSTEM');

 $remove = new ArrayIterator( $keys );

 while ( $remove->valid() ) {
   $query = "DELETE FROM `configuration` WHERE configuration_key = '" . $remove->current() . "'";
   tep_db_query( $query ); 
   $remove->next();
 }

 require_once 'includes/application_bottom.php';
?>

 

Save it in the root of your site and run it like www.mysite.com/catalog/usu5_db_removal.php

 

Once run DELETE THE FILE then run the USU5 installer again.

Link to comment
Share on other sites

Thank you soo much! Worked like a charm!

 

And.. unbelievably.. by running the removal script and then the USU5 install.php... the issue I had with Header Tags SEO got fixed too! :) :) :)

 

The only thing that still needs research is Who's Online, but I can live without that.

 

Thank you soo much again :) :)

Link to comment
Share on other sites

And.. unbelievably.. by running the removal script and then the USU5 install.php... the issue I had with Header Tags SEO got fixed too

 

The reason header tags was fixed is that without the db settings USU5 reverts to the file based settings which are the standard uri type (path based) .. the current code in header tags doesn't return a valid file when the uri is path based therefore you got problems.

Edited by FWR Media
Link to comment
Share on other sites

New Version Uploaded:

 

Ultimate Seo Urls 5

version 1.0 STABLE

Revision: 117

 

Stable release meaning after much testing and user feedback we currently have no known issues. This is recommended for use on a live site.

 

Changelog:


  •  
  • Fixed Windows server REQUEST_URI.
  • Improved logic for base filename.
  • Patch for osC files using PHP_SELF.
  • Removed one hardcoded table name.
  • General tidying.
  • Preparation for version 1.1 (Ultimate Seo Urls 5 Pro).
  • Installers now attempt to self delete.

Edited by FWR Media
Link to comment
Share on other sites

For anyone who's interested I just put up a new post in the contribution development forum about the new Ultimate Seo Urls 5 Pro (version 1.1)

 

http://www.oscommerce.com/forums/topic/349814-ultimate-seo-urls-5-pro/

Link to comment
Share on other sites

A great contribution that I had working perfectly, unfortunately i messed up on something else and have spent an age 'mending' my site. Anyway I am now getting an error when I try to add a new product:

 

Fatal error: Call to undefined function tep_reset_cache_data_seo_urls() in /public_html/shop/admin/categories.php on line 24

 

the site still works so it seems to be just admin side

 

I have dbl checked all install steps and all files appear to be as the documentation, any ideas?

Link to comment
Share on other sites

A great contribution that I had working perfectly, unfortunately i messed up on something else and have spent an age 'mending' my site. Anyway I am now getting an error when I try to add a new product:

 

Fatal error: Call to undefined function tep_reset_cache_data_seo_urls() in /public_html/shop/admin/categories.php on line 24

 

the site still works so it seems to be just admin side

 

I have dbl checked all install steps and all files appear to be as the documentation, any ideas?

 

catalog/ADMIN/includes/functions/general.php

 

you are missing the function tep_reset_cache_data_seo_urls()

 

Go back through the instructions and add this.

Link to comment
Share on other sites

I already checked this and its already there, word for word as per instructions...

 

if I turn off seo urls I still get the same error message...

 

catalog/ADMIN/includes/functions/general.php

 

you are missing the function tep_reset_cache_data_seo_urls()

 

Go back through the instructions and add this.

Edited by Dzines
Link to comment
Share on other sites

I already checked this and its already there, word for word as per instructions...

 

if I turn off seo urls I still get the same error message...

 

I'm not saying it is possibly the issue I am stating that it IS the issue.

 

Are you checking ..

 

catalog/ADMIN/includes/functions/general.php

 

or ..

 

catalog/includes/functions/general.php

Link to comment
Share on other sites

Please don't post whole files it makes the support topic unreadable for everyone else.

 

If the function is present in catalog/ADMIN/includes/functions/general.php, and it seems that it is then you must have errors in your code elsewhere.

 

Your error states that the function is undefined.

 

catalog/ADMIN/includes/functions/general.php is called in application_top.php and here tep_reset_cache_data_seo_urls() is therefore defined.

 

application_top.php should be called at the very top of admin/categories.php therefore on line 24 of admin/categories.php tep_reset_cache_data_seo_urls() must be defined.

Link to comment
Share on other sites

ok it was this file, problem with ftp & dreamweaver. thanks

 

Glad you got it sorted and thanks for removing the long file :thumbsup:

Link to comment
Share on other sites

Version 1.0 [sTABLE] r117

 

I would like to say thank you Robert for this great contribution with very good support.

 

I decided to upgrade to your newest release when I saw it yesterday. I had one issue. I use information pages and when I linked directly to one of these pages like this:

<?php echo '<a href="' . tep_href_link('about-i-3.html') . '"><img border="0" src="images/my-image.jpg" width="200" height="150" class="fader"></a>'; ?>

 

I get three warnings (created by ULTIMATE Seo Urls) that the page is not found. When I hover over the link it does not show the correct link (about-i-3.html) but rather apon hover I see information.php

Also, this is a valid link created by the newest Version 1.0. and I cleared the cache.

 

All works fine on the prior version of ULTIMATE Seo Urls.

 

And one other small issue... Filter short words is hardcoded 1, 2, or 3. Many of my products are like P-XX, B-XX (old aircraft designations). So filter short words I need to enter:0, or be able to add an ignore list, or turn it off. Perhaps I could just locate (Filter short words) in the sql file and change it or add 0 as an option. The bigger issue is not being able to link directly to my information pages.

 

Everything else worked fine though. I actually found the older version quite stable. Do you highly recommend the upgrade or is it mostly for non standard servers?

 

Regards,

 

Rick

Link to comment
Share on other sites

fopr anyone following my comments...i eventually realised i was using a different ultimate seo contribution.

 

i have (i am pretty sure) uninstalled the previous version and installed version 5 build 117

 

after uploading all the relevant files a ran the installed.php file and this is the error i get

 

"At least one of the configuration values already exists!

 

There was at least one error, we therefore cannot install.

 

Database db_name has not been touched.

 

Please check database db_name against the contribution for conflicts."

 

I have gone through the upgrade steps and the start from scratch steps and i can't seem to find what i have done wrong.

 

This is the type of URLs i am getting at the moment

http://shireen.com.au/index.php/handbags-c-58

 

so i know its not completely broken...

 

can someone advise what i need to check to find my problem

 

Ilan

Link to comment
Share on other sites

hello friends..

another problem i have encounterd..

i am using another contrib of product listing. it give me grid view of my product

but now after installing "URL seo" "add to cart" button on products no more working..what is this?

Can anybody tell me in which file error may b?

Thanks

Link to comment
Share on other sites

fopr anyone following my comments...i eventually realised i was using a different ultimate seo contribution.

 

i have (i am pretty sure) uninstalled the previous version and installed version 5 build 117

 

after uploading all the relevant files a ran the installed.php file and this is the error i get

 

"At least one of the configuration values already exists!

 

There was at least one error, we therefore cannot install.

 

Database db_name has not been touched.

 

Please check database db_name against the contribution for conflicts."

 

I have gone through the upgrade steps and the start from scratch steps and i can't seem to find what i have done wrong.

 

This is the type of URLs i am getting at the moment

http://shireen.com.au/index.php/handbags-c-58

 

so i know its not completely broken...

 

can someone advise what i need to check to find my problem

 

Ilan

 

You didn't run usu5_db_removal.php which is in the update instructions.

Link to comment
Share on other sites

Version 1.0 [sTABLE] r117

 

I would like to say thank you Robert for this great contribution with very good support.

 

I decided to upgrade to your newest release when I saw it yesterday. I had one issue. I use information pages and when I linked directly to one of these pages like this:

<?php echo '<a href="' . tep_href_link('about-i-3.html') . '"><img border="0" src="images/my-image.jpg" width="200" height="150" class="fader"></a>'; ?>

 

I get three warnings (created by ULTIMATE Seo Urls) that the page is not found. When I hover over the link it does not show the correct link (about-i-3.html) but rather apon hover I see information.php

Also, this is a valid link created by the newest Version 1.0. and I cleared the cache.

 

All works fine on the prior version of ULTIMATE Seo Urls.

 

Yes tep_href_link('about-i-3.html') is an incorrect way to write a link (even if it did work by chance before) .. it should be ..

 

tep_href_link( FILENAME_INFORMATION, 'info_id=3' );

 

And one other small issue... Filter short words is hardcoded 1, 2, or 3. Many of my products are like P-XX, B-XX (old aircraft designations). So filter short words I need to enter:0, or be able to add an ignore list, or turn it off. Perhaps I could just locate (Filter short words) in the sql file and change it or add 0 as an option. The bigger issue is not being able to link directly to my information pages.

 

Everything else worked fine though. I actually found the older version quite stable. Do you highly recommend the upgrade or is it mostly for non standard servers?

 

Regards,

 

Rick

 

This was set as 3 options on purpose, 0 should not be allowed as the seo url markers use -p-, -a-, -c-, -m- etc etc 3 should be the max as it is highly unlikely that a user would want to filter out words with 4 letters.

 

Otherwise a product using -p-XX in the name would create a problem.

 

If you really MUST have the setting 0 then in phpMyAdmin

 

1) select the configuration table

 

2) Search for configuration key SEO_URLS_FILTER_SHORT_WORDS

 

3) edit the set_function field replacing ..

tep_cfg_select_option(array('1', '2', '3'),

 

with ..

 

tep_cfg_select_option(array('0', '1', '2', '3'),

 

I don't recommend this as at some stage you will have a product name conflict with an seo url marker.

Link to comment
Share on other sites

hello friends..

another problem i have encounterd..

i am using another contrib of product listing. it give me grid view of my product

but now after installing "URL seo" "add to cart" button on products no more working..what is this?

Can anybody tell me in which file error may b?

Thanks

 

I don't know the contribution you are using but I'll make a guess as to the problem.

 

osCommerce has a bug in the standard product_listing.php which is why a part of the installation instructions for USU5 replaces a line in this file.

 

Open up your problem file and search for ..

 

tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $listing['products_id'])

 

If you find it replace it with ..

 

tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action', 'products_id')) . 'action=buy_now&products_id=' . $listing['products_id'])

 

If that doesn't help I would need to see the site or at least the link in question.

Edited by FWR Media
Link to comment
Share on other sites

I don't know the contribution you are using but I'll make a guess as to the problem.

 

osCommerce has a bug in the standard product_listing.php which is why a part of the installation instructions for USU5 replaces a line in this file.

 

Open up your problem file and search for ..

 

tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action')) . 'action=buy_now&products_id=' . $listing['products_id'])

 

If you find it replace it with ..

 

tep_href_link(basename($PHP_SELF), tep_get_all_get_params(array('action', 'products_id')) . 'action=buy_now&products_id=' . $listing['products_id'])

 

If that doesn't help I would need to see the site or at least the link in question.

 

 

Hello,

I am replace My cotrib Product_listing.php with with Default Product_listing.php,and make changes as u refer above..But nothing happen..Problem is still there,"Add to cart" button of product _listing page not working.. and i have test my site locally

Thanks!

Link to comment
Share on other sites

Hello,

hello, im use seo v0.84 but i had problem, when i active seo enable,

button buy now cant function? but if i disable seo5, its work fine.

can anyone help me?

 

like in thi slink

http://warung.exalumni.com/index.php/fooddrinks-makanan-c-39_37

 

but its normal for index.php

 

i think my scrit like this

$lc_text['button_buy_now'] = '<a href="' . tep_href_link(basename($_SERVER['PHP_SELF']), tep_get_all_get_params(array('action','sort','products_id')) . 'action=buy_now&products_id=' . $listing[$x]['products_id']) . '">' . tep_image_button('more_info.gif', IMAGE_BUTTON_MORE_INFO, 'style="padding-bottom: 5px;"') . '</a>';		

Link to comment
Share on other sites

Hello,

hello, im use seo v0.84 but i had problem, when i active seo enable,

button buy now cant function? but if i disable seo5, its work fine.

can anyone help me?

 

like in thi slink

http://warung.exalumni.com/index.php/fooddrinks-makanan-c-39_37

 

but its normal for index.php

 

i think my scrit like this

$lc_text['button_buy_now'] = '<a href="' . tep_href_link(basename($_SERVER['PHP_SELF']), tep_get_all_get_params(array('action','sort','products_id')) . 'action=buy_now&products_id=' . $listing[$x]['products_id']) . '">' . tep_image_button('more_info.gif', IMAGE_BUTTON_MORE_INFO, 'style="padding-bottom: 5px;"') . '</a>';		

 

Hi the buy now link is incorrect ..

 

http://warung.exalumni.com/fooddrinks-makanan-c-39_37?cPath=39_37&action=buy_now&products_id=111

 

Should be ..

 

http://warung.exalumni.com/index.php/fooddrinks-makanan-c-39_37?action=buy_now&products_id=111

 

There have been many changes since r84 could you upgrade to version r96 then r117.

Link to comment
Share on other sites

Hello,

I am replace My cotrib Product_listing.php with with Default Product_listing.php,and make changes as u refer above..But nothing happen..Problem is still there,"Add to cart" button of product _listing page not working.. and i have test my site locally

Thanks!

 

Which version are you using and on which server type *nix/Windows?

 

You would need to post a site link or at least post the code that is showing when you hover a buy now button as this doesn't happen on a fresh install.

Link to comment
Share on other sites

Hi the buy now link is incorrect ..

 

http://warung.exalumni.com/fooddrinks-makanan-c-39_37?cPath=39_37&action=buy_now&products_id=111

 

Should be ..

 

http://warung.exalumni.com/index.php/fooddrinks-makanan-c-39_37?action=buy_now&products_id=111

 

There have been many changes since r84 could you upgrade to version r96 then r117.

 

yes, i wanna to replace v.84 to v 1.17, i had download it, but i dontknow how to uninstall v0.84, because when i runs intall, still 1 warning "....At least one of the configuration values already exists! ..."

and i cant find where i must change :(

Link to comment
Share on other sites

yes, i wanna to replace v.84 to v 1.17, i had download it, but i dontknow how to uninstall v0.84, because when i runs intall, still 1 warning "....At least one of the configuration values already exists! ..."

and i cant find where i must change :(

 

You need to upgrade r84 to r96 then r96 to r117, it is very simple follow the upgrade instructions in extras.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...