♥FWR Media Posted November 28, 2009 Author Share Posted November 28, 2009 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. Quote Ultimate SEO Urls 5 PRO - Multi Language Modern, Powerful SEO Urls KissMT Dynamic SEO Meta & Canonical Header Tags KissER Error Handling and Debugging KissIT Image Thumbnailer Security Pro - Querystring protection against hackers ( a KISS contribution ) If you found my post useful please click the "Like This" button to the right. Please only PM me for paid work. Link to comment Share on other sites More sharing options...
solarplexus Posted November 28, 2009 Share Posted November 28, 2009 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 :) :) Quote Link to comment Share on other sites More sharing options...
♥FWR Media Posted November 28, 2009 Author Share Posted November 28, 2009 (edited) 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 November 28, 2009 by FWR Media Quote Ultimate SEO Urls 5 PRO - Multi Language Modern, Powerful SEO Urls KissMT Dynamic SEO Meta & Canonical Header Tags KissER Error Handling and Debugging KissIT Image Thumbnailer Security Pro - Querystring protection against hackers ( a KISS contribution ) If you found my post useful please click the "Like This" button to the right. Please only PM me for paid work. Link to comment Share on other sites More sharing options...
♥FWR Media Posted November 29, 2009 Author Share Posted November 29, 2009 (edited) 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 November 29, 2009 by FWR Media Quote Ultimate SEO Urls 5 PRO - Multi Language Modern, Powerful SEO Urls KissMT Dynamic SEO Meta & Canonical Header Tags KissER Error Handling and Debugging KissIT Image Thumbnailer Security Pro - Querystring protection against hackers ( a KISS contribution ) If you found my post useful please click the "Like This" button to the right. Please only PM me for paid work. Link to comment Share on other sites More sharing options...
♥FWR Media Posted November 29, 2009 Author Share Posted November 29, 2009 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/ Quote Ultimate SEO Urls 5 PRO - Multi Language Modern, Powerful SEO Urls KissMT Dynamic SEO Meta & Canonical Header Tags KissER Error Handling and Debugging KissIT Image Thumbnailer Security Pro - Querystring protection against hackers ( a KISS contribution ) If you found my post useful please click the "Like This" button to the right. Please only PM me for paid work. Link to comment Share on other sites More sharing options...
Dzines Posted November 30, 2009 Share Posted November 30, 2009 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? Quote Link to comment Share on other sites More sharing options...
♥FWR Media Posted November 30, 2009 Author Share Posted November 30, 2009 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. Quote Ultimate SEO Urls 5 PRO - Multi Language Modern, Powerful SEO Urls KissMT Dynamic SEO Meta & Canonical Header Tags KissER Error Handling and Debugging KissIT Image Thumbnailer Security Pro - Querystring protection against hackers ( a KISS contribution ) If you found my post useful please click the "Like This" button to the right. Please only PM me for paid work. Link to comment Share on other sites More sharing options...
Dzines Posted November 30, 2009 Share Posted November 30, 2009 (edited) 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 November 30, 2009 by Dzines Quote Link to comment Share on other sites More sharing options...
♥FWR Media Posted November 30, 2009 Author Share Posted November 30, 2009 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 Dzines 1 Quote Ultimate SEO Urls 5 PRO - Multi Language Modern, Powerful SEO Urls KissMT Dynamic SEO Meta & Canonical Header Tags KissER Error Handling and Debugging KissIT Image Thumbnailer Security Pro - Querystring protection against hackers ( a KISS contribution ) If you found my post useful please click the "Like This" button to the right. Please only PM me for paid work. Link to comment Share on other sites More sharing options...
Dzines Posted November 30, 2009 Share Posted November 30, 2009 (edited) ok it was this file, problem with ftp & dreamweaver. thanks Edited November 30, 2009 by Dzines Quote Link to comment Share on other sites More sharing options...
♥FWR Media Posted November 30, 2009 Author Share Posted November 30, 2009 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. Quote Ultimate SEO Urls 5 PRO - Multi Language Modern, Powerful SEO Urls KissMT Dynamic SEO Meta & Canonical Header Tags KissER Error Handling and Debugging KissIT Image Thumbnailer Security Pro - Querystring protection against hackers ( a KISS contribution ) If you found my post useful please click the "Like This" button to the right. Please only PM me for paid work. Link to comment Share on other sites More sharing options...
♥FWR Media Posted November 30, 2009 Author Share Posted November 30, 2009 ok it was this file, problem with ftp & dreamweaver. thanks Glad you got it sorted and thanks for removing the long file :thumbsup: Quote Ultimate SEO Urls 5 PRO - Multi Language Modern, Powerful SEO Urls KissMT Dynamic SEO Meta & Canonical Header Tags KissER Error Handling and Debugging KissIT Image Thumbnailer Security Pro - Querystring protection against hackers ( a KISS contribution ) If you found my post useful please click the "Like This" button to the right. Please only PM me for paid work. Link to comment Share on other sites More sharing options...
Debs Posted December 1, 2009 Share Posted December 1, 2009 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 Quote Link to comment Share on other sites More sharing options...
iperez_genius Posted December 1, 2009 Share Posted December 1, 2009 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 Quote Link to comment Share on other sites More sharing options...
Jaskaran Posted December 1, 2009 Share Posted December 1, 2009 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 Quote Link to comment Share on other sites More sharing options...
♥FWR Media Posted December 1, 2009 Author Share Posted December 1, 2009 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. Quote Ultimate SEO Urls 5 PRO - Multi Language Modern, Powerful SEO Urls KissMT Dynamic SEO Meta & Canonical Header Tags KissER Error Handling and Debugging KissIT Image Thumbnailer Security Pro - Querystring protection against hackers ( a KISS contribution ) If you found my post useful please click the "Like This" button to the right. Please only PM me for paid work. Link to comment Share on other sites More sharing options...
♥FWR Media Posted December 1, 2009 Author Share Posted December 1, 2009 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. Quote Ultimate SEO Urls 5 PRO - Multi Language Modern, Powerful SEO Urls KissMT Dynamic SEO Meta & Canonical Header Tags KissER Error Handling and Debugging KissIT Image Thumbnailer Security Pro - Querystring protection against hackers ( a KISS contribution ) If you found my post useful please click the "Like This" button to the right. Please only PM me for paid work. Link to comment Share on other sites More sharing options...
♥FWR Media Posted December 1, 2009 Author Share Posted December 1, 2009 (edited) 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 December 1, 2009 by FWR Media Quote Ultimate SEO Urls 5 PRO - Multi Language Modern, Powerful SEO Urls KissMT Dynamic SEO Meta & Canonical Header Tags KissER Error Handling and Debugging KissIT Image Thumbnailer Security Pro - Querystring protection against hackers ( a KISS contribution ) If you found my post useful please click the "Like This" button to the right. Please only PM me for paid work. Link to comment Share on other sites More sharing options...
iperez_genius Posted December 1, 2009 Share Posted December 1, 2009 thanks FWR for the help... addon is working beautifully.. thanks again Ilan Quote Link to comment Share on other sites More sharing options...
Jaskaran Posted December 2, 2009 Share Posted December 2, 2009 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! Quote Link to comment Share on other sites More sharing options...
exca Posted December 2, 2009 Share Posted December 2, 2009 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>'; Quote Link to comment Share on other sites More sharing options...
♥FWR Media Posted December 2, 2009 Author Share Posted December 2, 2009 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. Quote Ultimate SEO Urls 5 PRO - Multi Language Modern, Powerful SEO Urls KissMT Dynamic SEO Meta & Canonical Header Tags KissER Error Handling and Debugging KissIT Image Thumbnailer Security Pro - Querystring protection against hackers ( a KISS contribution ) If you found my post useful please click the "Like This" button to the right. Please only PM me for paid work. Link to comment Share on other sites More sharing options...
♥FWR Media Posted December 2, 2009 Author Share Posted December 2, 2009 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. Quote Ultimate SEO Urls 5 PRO - Multi Language Modern, Powerful SEO Urls KissMT Dynamic SEO Meta & Canonical Header Tags KissER Error Handling and Debugging KissIT Image Thumbnailer Security Pro - Querystring protection against hackers ( a KISS contribution ) If you found my post useful please click the "Like This" button to the right. Please only PM me for paid work. Link to comment Share on other sites More sharing options...
exca Posted December 2, 2009 Share Posted December 2, 2009 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 :( Quote Link to comment Share on other sites More sharing options...
♥FWR Media Posted December 2, 2009 Author Share Posted December 2, 2009 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. Quote Ultimate SEO Urls 5 PRO - Multi Language Modern, Powerful SEO Urls KissMT Dynamic SEO Meta & Canonical Header Tags KissER Error Handling and Debugging KissIT Image Thumbnailer Security Pro - Querystring protection against hackers ( a KISS contribution ) If you found my post useful please click the "Like This" button to the right. Please only PM me for paid work. Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.