Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

[CONTRIBUTION] Ultimate SEO URLs v2.1 - by Chemo


Recommended Posts

Only one person posting in this thread has had any luck running this contribution with Update 060817.

 

-Skittles

 

I guess that's me.

 

Several people were having similar problems and asking what to do.

When this contribution was enabled, osc was using '0' for the id number (order_id, account_id, customer_id, etc.):

 

No problems so far.

 

Everthing gets happily auto-incremented.

 

 

 

The fact that you are running the two without any problems begs the

question does the real issue have more to do with which version of php and/or mysql is running rather than the version/update of osc. It remains to be seen what the real issue is.

 

 

Here is my environment:

 

Apache 2.2.2

MySQL 5.0.21

PHP 5.1.4

 

Pretty actual stuff.

 

 

Greez

 

 

mikeman

Link to comment
Share on other sites

I guess that's me.

No problems so far.

 

Everthing gets happily auto-incremented.

Here is my environment:

 

Apache 2.2.2

MySQL 5.0.21

PHP 5.1.4

 

Pretty actual stuff.

 

 

Greez

 

 

mikeman

Mikeman,

 

You're running with fairly new releases of everything.

 

My local machine (XAMPP) is running the same versions as you:

 

Apache 2.2.2

MySQL 5.0.21

PHP Version 5.1.4

 

(On a Win XP Pro machine. I can't get mod_rewrite to work locally...)

 

However, my dedicated server is running:

 

Apache 1.3.37 (Unix)

MySQL 4.1.21-standard

PHP Version 4.4.4

 

And my shared server is running:

 

Apache 1.3.37 (Unix)

MySQL 4.1.21-standard

PHP Version 4.4.1

 

 

I have two clients running osc, and neither one has the same environment as each other, or as any of my servers...

 

It would be interesting if we could get environment info from the members who were having compatibility problems between this contrib and Update 060817.

 

-Skittles

Link to comment
Share on other sites

Skittles,

 

I want more characters in:

Admin => Configuration => SEO URLs => Enter special character conversions

How to enlarge it?

Paradisebg,

 

I think I now know why you're having problems with this. The data field in the configuration file will only hold 256 characters, but you are trying to add about 320 characters.

 

I think it might be easiest to add a new function to the class, with an array of the cyrillic characters

 

function convert_cyrillic() {

 $convert_chars = array('ь'=>'io', 'я'=>'ia', 'а'=>'a', 'о'=>'o', 'ж'=>'j',
								 'г'=>'g', 'т'=>'t', 'н'=>'n', 'в'=>'v', 'м'=>'m',
								 'ч'=>'ch', 'у'=>'u', 'е'=>'e', 'и'='>i', 'ш'=>'sh', 
								 'щ'=>'sht', 'к'=>'k', 'с'=>'s', 'д'=>'d', 'з'=>'z', 
								 'ц'=>'c', 'б'=>'b', 'л'=>'l', 'р'=>'r', 'п'=>'p', 
								 'х'=>'h', 'ф'=>'f', 'ъ'=>'a', 'й'=>'io', 'ю'=>'iu', 
								 'Ь'=>'IO', 'Я'=>'IA', 'А'=>'A', 'О'=>'O', 'Ж'=>'J', 
								 'Г'=>'G', 'Т'=>'T', 'Н'=>'N', 'В'=>'V', 'М'=>'M', 
								 'Ч'=>'CH', 'У'=>'U', 'Е'=>'E', 'И'=>'I', 'Ш'=>'SH', 
								 'Щ'=>'SHT', 'К'=>'K', 'С'=>'S', 'Д'=>'D', 'З'=>'Z', 
								 'Ц'=>'C', 'Б'=>'B', 'Л'=>'L', 'Р'=>'R', 'П'=>'P', 
								 'Х'=>'H', 'Ф'=>'F', 'Ъ'=>'A', 'Й'=>'IO', 'Ю'=>'IU'
								);
 $string = strtr($string, $convert_chars);
 return $string;
}

 

Then add a function call inside of function strip():

 

function strip($string){
$string = convert_cyrillic($string);
//rest of function here

 

Then remove all of the cyrillic characters from the admin option.

 

You will have to test this. And make sure the all the characters are correct. I don't know it any were changed by my cut and paste operations creating this code for you.

 

Good luck,

-Skittles

Link to comment
Share on other sites

@Skittles

 

Whow, what a coincidence!

 

I also use XAMPP for test purposes on an old Win2000-install.

 

 

The rewrite-mod is commented in the apache conf-file (xampp\apache\conf\)

 

It has to be uncommented and the apache-server restarted.

 

Then it worked for me.

 

 

Thanks

 

 

mikeman

Link to comment
Share on other sites

It has to be uncommented and the apache-server restarted.

Yeah, I know.

 

But for some reason, it doesn't work on my computer.

 

Vger had problems with it too. She got it working, so I asked her for some help. She sent me a copy of her httpd.conf file for reference, but I still couldn't get it to work.

 

Annoying, but not the end of the world...

 

-Skittles

Link to comment
Share on other sites

hi Skittles,

 

thanks again for your answers. I made the changes to product_info.php as you said but it does not seem to have any effect at all (tested at home and on the live site). I have STS 4.2 and HTC 2.6 installed so presume it's something to do with HTC possibly? In fact when i delete a product and go back to it I still have the meta tags that were generated by HTC even though I get the 'product not found' page.

Any ideas?! :)

 

Many Thanks again

Becki

 

Here is my head contect from product_info:

<head>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title><?php echo TITLE; ?></title>
<base href="<?php echo (($request_type == 'SSL') ? HTTPS_SERVER : HTTP_SERVER) . DIR_WS_CATALOG; ?>">
<link rel="stylesheet" type="text/css" href="stylesheet.css">
<script language="javascript"><!--
function popupWindow(url) {
 window.open(url,'popupWindow','toolbar=no,location=no,directories=no,status=no,menubar=no,scrollbars=no,res
izable=yes,copyhistory=no,width=100,height=100,screenX=150,screenY=150,top=150,le
ft=150')
}
//--></script>
<?php 
 if ($product_check['total'] < 1) {
echo '<meta name="robots" content="noindex,nofollow">';
 }
?>
</head>

 

and here is the meta code from the live page:

 

<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
 <title>testing</title>
 <meta name="Description" content="testing"/>
 <meta name="Keywords" content="testing"/>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"/>
<!-- EOF: Generated Meta Tags -->

Becki,

 

I am completely unfamiliar with STS. The info below is for Header Tags Controller:

 

Here's an excerpt from the installation where it instructs you to replace the "Old Lines" in approximately 35 files, with the "New Lines"

 

Old Lines:

<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title><?php echo TITLE; ?></title>

New Lines:

<?php
// BOF: WebMakers.com Changed: Header Tag Controller v2.5.2
// Replaced by header_tags.php
if ( file_exists(DIR_WS_INCLUDES . 'header_tags.php') ) {
 require(DIR_WS_INCLUDES . 'header_tags.php');
} else {
?>
 <title><?php echo TITLE; ?></title>
<?php
}
// EOF: WebMakers.com Changed: Header Tag Controller v2.5.2
?>

 

(A minor snafu here is that if header_tags.php doesn't exist, the meta content-type tag gets omitted completely.)

 

In product_info.php, change the header tag controller stuff to this:

 

<?php
if ($product_check['total'] < 1) {
 echo '<meta name="robots" content="noindex,nofollow">';
 echo '<title>'. TEXT_TITLE_PAGE_NOT_FOUND . ' - ' . TITLE . '</title>';
 echo '<meta http-equiv="Content-Type" content="text/html; charset=' . CHARSET . '">';
} else {
 // BOF: WebMakers.com Changed: Header Tag Controller v2.5.2
 // Replaced by header_tags.php
 if ( file_exists(DIR_WS_INCLUDES . 'header_tags.php') ) {
require(DIR_WS_INCLUDES . 'header_tags.php');
 } else {
 ?>
<title><?php echo TITLE; ?></title>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
 <?php
 }
 // EOF: WebMakers.com Changed: Header Tag Controller v2.5.2
?>

 

And add the definition to the language page for product_info.php

 

define('TEXT_TITLE_PAGE_NOT_FOUND', 'Product Not Found');

 

 

Now, if STS calls Header Tags Controller from another file, like application_top.php, you would need to determine a different way of testing for no product...

 

-Skittles

Link to comment
Share on other sites

Becki,

 

I am completely unfamiliar with STS. The info below is for Header Tags Controller:

 

Here's an excerpt from the installation where it instructs you to replace the "Old Lines" in approximately 35 files, with the "New Lines"

 

Old Lines:

<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
<title><?php echo TITLE; ?></title>

New Lines:

<?php
// BOF: WebMakers.com Changed: Header Tag Controller v2.5.2
// Replaced by header_tags.php
if ( file_exists(DIR_WS_INCLUDES . 'header_tags.php') ) {
 require(DIR_WS_INCLUDES . 'header_tags.php');
} else {
?>
 <title><?php echo TITLE; ?></title>
<?php
}
// EOF: WebMakers.com Changed: Header Tag Controller v2.5.2
?>

 

(A minor snafu here is that if header_tags.php doesn't exist, the meta content-type tag gets omitted completely.)

 

In product_info.php, change the header tag controller stuff to this:

 

<?php
if ($product_check['total'] < 1) {
 echo '<meta name="robots" content="noindex,nofollow">';
 echo '<title>'. TEXT_TITLE_PAGE_NOT_FOUND . ' - ' . TITLE . '</title>';
 echo '<meta http-equiv="Content-Type" content="text/html; charset=' . CHARSET . '">';
} else {
 // BOF: WebMakers.com Changed: Header Tag Controller v2.5.2
 // Replaced by header_tags.php
 if ( file_exists(DIR_WS_INCLUDES . 'header_tags.php') ) {
require(DIR_WS_INCLUDES . 'header_tags.php');
 } else {
 ?>
<title><?php echo TITLE; ?></title>
<meta http-equiv="Content-Type" content="text/html; charset=<?php echo CHARSET; ?>">
 <?php
 }
 // EOF: WebMakers.com Changed: Header Tag Controller v2.5.2
?>

 

And add the definition to the language page for product_info.php

 

define('TEXT_TITLE_PAGE_NOT_FOUND', 'Product Not Found');

Now, if STS calls Header Tags Controller from another file, like application_top.php, you would need to determine a different way of testing for no product...

 

-Skittles

 

Hi,

Thanks for that, although using STS means I don't have to make those changes to each file - I shall look into it and use the information you've given me to hopefully come up with a solution - although it doesn't look as easy as first thought!

 

Becki

Link to comment
Share on other sites

hello.

 

I installed Ultimate SEO and everything work fine.

However, seems Ultimate SEO does not like the word "pro"

e.g.

 

Product Name is Adobe Premiere Pro 2.0

Title is Adobe Premiere Pro 2.0

but the URL only come up

http://www.xyz.com/catalog/adobe-premiere-p-45.html

Samething with other products. e.g.

Adobe After Effects 7 Pro (WINDOWS)

http://www.xyz.com/catalog2/adobe-after-effects-windows-p-34.html

Any ideas?

 

Thanks

 

contribs installed.

Header Tag

Ultimate SEO

CVV2

UPS XML.

and more.

Link to comment
Share on other sites

hello.

 

I installed Ultimate SEO and everything work fine.

However, seems Ultimate SEO does not like the word "pro"

e.g.

 

Product Name is Adobe Premiere Pro 2.0

Title is Adobe Premiere Pro 2.0

but the URL only come up

http://www.xyz.com/catalog/adobe-premiere-p-45.html

Samething with other products. e.g.

Adobe After Effects 7 Pro (WINDOWS)

http://www.xyz.com/catalog2/adobe-after-effects-windows-p-34.html

Any ideas?

 

Thanks

 

contribs installed.

Header Tag

Ultimate SEO

CVV2

UPS XML.

and more.

mileage,

 

There's an option in the Admin to ignore small words. It's set to 3 by default, probably to catch words like "the" and "and". You can change it to 2 and then Pro will show up in your URL.

 

Got to Admin Configuration->SEO URLs to find the option.

 

-Skittles

Link to comment
Share on other sites

mileage,

 

There's an option in the Admin to ignore small words. It's set to 3 by default, probably to catch words like "the" and "and". You can change it to 2 and then Pro will show up in your URL.

 

Got to Admin Configuration->SEO URLs to find the option.

 

-Skittles

 

Thank you Skittles, that fixed the issue.

 

I changed to 2

 

now come up properly

http://www.xyz.com/catalog2/adobe-after-effects-pro-windows-p-34.html

Link to comment
Share on other sites

Hy. I've got a problem with my on-line store http://www.multiservice-canon.ro . This problem appears when an order is made. I can't see the order in my admin page. After i've analized my database structure i've found a problem: my `orders_total` table is empty. It just doesn't populate with any information. I've manually write some insert lines in my sql and then, i was able to see my order. But again if i add a new order, it doesn't appear in my admin. My `orders_total` sql syntax is the next one:

 

CREATE TABLE `orders_total` (

`orders_total_id` int(10) unsigned NOT NULL auto_increment,

`orders_id` int(11) NOT NULL default '0',

`title` varchar(255) NOT NULL default '',

`text` varchar(255) NOT NULL default '',

`value` decimal(15,4) NOT NULL default '0.0000',

`class` varchar(32) NOT NULL default '',

`sort_order` int(11) NOT NULL default '0',

PRIMARY KEY (`orders_total_id`),

KEY `idx_orders_total_orders_id` (`orders_id`)

) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

 

It seems ti be just fine. So i'm guessing that my problem is located in one of my *.php file, but i don't know wich one. I really need an answer to my problem and i will be very thankful.

 

Thanks in advance, Cezar.

Edited by xperyens
Link to comment
Share on other sites

I have a SEO related question. I installed the 2.x version and it works great. Except for one little snafu on my home page: http://www.ecorey.com I have an additional data collector. Per an ordinary site you have one data collector, which by default collects data about manufacturers, I've mirrored that to another set of data called titles, this data is held in titles, and titles_info tables, and has all the same corresponding files as the manufacturers system does, titles.php, title_info.php, and so forth.

 

I've added:

 

RewriteRule ^(.*)-z-(.*).html$ index.php?titles_id=$2&%{QUERY_STRING}

 

to my .htaccess

 

I'm expecting the url output to be something like this dc-comics-z-15.html, because 15 is the titles_id, but instead it shows up as index.php?titles_id=15 and nothing shows up as expected.

 

Any ideas?

Link to comment
Share on other sites

I have a SEO related question. I installed the 2.x version and it works great. Except for one little snafu on my home page: http://www.ecorey.com I have an additional data collector. Per an ordinary site you have one data collector, which by default collects data about manufacturers, I've mirrored that to another set of data called titles, this data is held in titles, and titles_info tables, and has all the same corresponding files as the manufacturers system does, titles.php, title_info.php, and so forth.

 

I've added:

 

RewriteRule ^(.*)-z-(.*).html$ index.php?titles_id=$2&%{QUERY_STRING}

 

to my .htaccess

 

I'm expecting the url output to be something like this dc-comics-z-15.html, because 15 is the titles_id, but instead it shows up as index.php?titles_id=15 and nothing shows up as expected.

 

Any ideas?

con4mity,

 

Have you made changes to the seo.class.php file to support pages with titles_id?

 

-Skittles

Link to comment
Share on other sites

Hello all,

 

I thought I had this installed ok, but I have since found a serious problem, When a customer creates an account the following error shows up

0 - 

insert into customers_info (customers_info_id, customers_info_number_of_logons, customers_info_date_account_created) values ('0', '0', now())

[TEP STOP]

 

Any Ideas? None of the customers info is been stored.

 

Thanks very much for any support.

 

Lee.

Link to comment
Share on other sites

con4mity,

 

Have you made changes to the seo.class.php file to support pages with titles_id?

 

-Skittles

 

Yes, and part of the problem was in seo.class.php

 

But it's still not right somewhere. My seo.class.php changes:

 

changes in catalog/includes/classes/seo.class.php

about line 288 add:

/* Data Collecters 1.0 */									

 );
	$x++;
	$this->default_config['USE_SEO_CACHE_MANUFACTURERS'] = array('DEFAULT' => 'true',


	 'QUERY' => "INSERT INTO `".TABLE_CONFIGURATION."` VALUES ('', 'Enable manufacturers cache?', 

'USE_SEO_CACHE_MANUFACTURERS', 'true', 'This will turn off caching for the manufacturers.', GROUP_INSERT_ID, ".$x.", 

NOW(), NOW(), NULL, 'tep_cfg_select_option(array(''true'', ''false''),')"


	 );
/* EOF Data Collecters 1.0 */

about line 568 add:

/* Data Collector */
'USE_SEO_CACHE_TITLES' => defined('USE_SEO_CACHE_TITLES') ? USE_SEO_CACHE_TITLES : 'false',
/* Data Collecters 1.0 */

about line 590 add:

'titles_id' => '-z-',

about line 615 add:

if ( $this->attributes['USE_SEO_CACHE_TITLES'] == 'true' ) $this->generate_titles_cache();

about 982 add:

function get_titles_name($zID){
switch(true){
	case ($this->attributes['USE_SEO_CACHE_GLOBAL'] == 'true' && defined('TITLES_NAME_' . $zID)):
		$this->performance['CACHE_QUERY_SAVINGS']++;
		$return = constant('TITLES_NAME_' . $zID);
		$this->cache['TITLES'][$zID] = $return;				
		break;
	case ($this->attributes['USE_SEO_CACHE_GLOBAL'] == 'true' && isset($this->cache['TITLES'][$zID])):
		$this->performance['CACHE_QUERY_SAVINGS']++;
		$return = $this->cache['TITLES'][$zID];
		break;
	default:
		$this->performance['NUMBER_QUERIES']++;
		$sql = "SELECT TITLES_name as zName 
				FROM ".TABLE_TITLES." 
				WHERE TITLES_id='".(int)$zID."' 
				LIMIT 1";
		$result = $this->DB->FetchArray( $this->DB->Query( $sql ) );
		$zName = $this->strip( $result['zName'] );
		$this->cache['TITLES'][$mID] = $zName;
		$this->performance['QUERIES']['TITLES'][] = $sql;
		$return = $zName;
		break;								
} # end switch		
return $return;
} # end function

about 1497 add:

	function generate_titles_cache(){
	$this->is_cached($this->cache_file . 'titles', $is_cached, $is_expired);	  
	if ( !$is_cached || $is_expired ) { // it's not cached so create it
	$sql = "SELECT z.titles_id as id, z.titles_name as name 
			FROM ".TABLE_TITLES." z 
			LEFT JOIN ".TABLE_TITLES_INFO." zd 
			ON z.titles_id=zd.titles_id 
			AND zd.languages_id='".(int)$this->languages_id."'";
	$titles_query = $this->DB->Query( $sql );
	$man_cache = '';
	while ($titles = $this->DB->FetchArray($titles_query)) {
		$define = 'define(\'TITLES_NAME_' . $titles['id'] . '\', \'' . $this->strip($titles['name']) . '\');';
		$man_cache .= $define . "\n";
		eval("$define");
	}
	$this->DB->Free($titles_query);
	$this->save_cache($this->cache_file . 'titles', $man_cache, 'EVAL', 1 , 1);
	unset($man_cache);
	} else {
		$this->get_cache($this->cache_file . 'titles');		
	}
} # end function

 

now, I'm getting the expected output for the url, but still the product_list isn't correct. (The items that display are not the product expected. ) Closer, maybe titles_id= isn't being passed because of the modified url?

Edited by con4mity
Link to comment
Share on other sites

I have installed, uninstalled and installed again the Ultimate SEO URLs - 2.1d and still have the same problem where I cannot find the SEO URLs at the Admin/Configuration area. I have followed the installation steps very carefully and have ensure that all modified files and new files goes to the correct sections. My site looks like it is working well with html. Am I right? Pls help!

 

This is my site showing the html

https://www.etrendystore.com/kaftans-handpa...an.c-24_35.html

Link to comment
Share on other sites

I have installed, uninstalled and installed again the Ultimate SEO URLs - 2.1d and still have the same problem where I cannot find the SEO URLs at the Admin/Configuration area. I have followed the installation steps very carefully and have ensure that all modified files and new files goes to the correct sections. My site looks like it is working well with html. Am I right? Pls help!

 

This is my site showing the html

https://www.etrendystore.com/kaftans-handpa...an.c-24_35.html

trixie_lok,

 

The configuration and the options are stored in the database. The seo.class.php is coded to automatically create all of the database changes for you. Check the configuration and configuration_group tables of your database, and see if the records exist. (If you don't have direct access, via a program like phpMyAdmin, you can create and download a database backup.)

 

Chemo provides a class to handle database access, but says it has "minimal error handling". So, if the records don't exist in the database following an install, you probably have an error in your code. But without the error handling, you aren't getting an error message to let you know what needs to be fixed.

 

I hope this helps point you in the right direction.

-Skittles

Link to comment
Share on other sites

trixie_lok,

 

The configuration and the options are stored in the database. The seo.class.php is coded to automatically create all of the database changes for you. Check the configuration and configuration_group tables of your database, and see if the records exist. (If you don't have direct access, via a program like phpMyAdmin, you can create and download a database backup.)

 

Chemo provides a class to handle database access, but says it has "minimal error handling". So, if the records don't exist in the database following an install, you probably have an error in your code. But without the error handling, you aren't getting an error message to let you know what needs to be fixed.

 

I hope this helps point you in the right direction.

-Skittles

 

Hi Skittles,

 

Under my phpmyadmin/configuration tables, I have all this information :

 

configuration_id int(11) No auto_increment

configuration_title varchar(64) latin1_swedish_ci No

configuration_key varchar(64) latin1_swedish_ci No

configuration_value varchar(255) latin1_swedish_ci No

configuration_description varchar(255) latin1_swedish_ci No

configuration_group_id int(11) No 0

sort_order int(5) Yes NULL

last_modified datetime Yes NULL

date_added datetime No 0000-00-00 00:00:00

use_function varchar(255) latin1_swedish_ci Yes NULL

set_function varchar(255) latin1_swedish_ci Yes NULL

 

And under my phpmyadmin/configuration_group tables, I have all this information :

 

configuration_group_id int(11) No auto_increment

configuration_group_title varchar(64) latin1_swedish_ci No

configuration_group_description varchar(255) latin1_swedish_ci No

sort_order int(5) Yes NULL

visible int(1) Yes 1

configuration_group_key varchar(64) latin1_swedish_ci No

 

 

What kind of database or records information should I be seeing that are created by seo.class.php?

 

Regards

Trixie

Link to comment
Share on other sites

Hi Skittles,

 

Under my phpmyadmin/configuration tables, I have all this information :

 

configuration_id int(11) No auto_increment

configuration_title varchar(64) latin1_swedish_ci No

configuration_key varchar(64) latin1_swedish_ci No

configuration_value varchar(255) latin1_swedish_ci No

configuration_description varchar(255) latin1_swedish_ci No

configuration_group_id int(11) No 0

sort_order int(5) Yes NULL

last_modified datetime Yes NULL

date_added datetime No 0000-00-00 00:00:00

use_function varchar(255) latin1_swedish_ci Yes NULL

set_function varchar(255) latin1_swedish_ci Yes NULL

 

And under my phpmyadmin/configuration_group tables, I have all this information :

 

configuration_group_id int(11) No auto_increment

configuration_group_title varchar(64) latin1_swedish_ci No

configuration_group_description varchar(255) latin1_swedish_ci No

sort_order int(5) Yes NULL

visible int(1) Yes 1

configuration_group_key varchar(64) latin1_swedish_ci No

What kind of database or records information should I be seeing that are created by seo.class.php?

 

Regards

Trixie

Trixie,

 

The information you pulled out for this email is the table structure for the two tables. What we need to look at is the data for these tables. From your phpMyAdmin, click on the table `configuration_group`, then click on the tab labeled 'Browse' to view the data. (Check it first. It's much shorter!). Look for an entry with the `configuration_group_title` "SEO URLs".

 

Then click on the table `configuration`, followed by clicking on the tab labeled 'Browse' to view the data. Look for entries that start either "SEO" or "Use Seo"

 

-Skittles

Link to comment
Share on other sites

Trixie,

 

The information you pulled out for this email is the table structure for the two tables. What we need to look at is the data for these tables. From your phpMyAdmin, click on the table `configuration_group`, then click on the tab labeled 'Browse' to view the data. (Check it first. It's much shorter!). Look for an entry with the `configuration_group_title` "SEO URLs".

 

Then click on the table `configuration`, followed by clicking on the tab labeled 'Browse' to view the data. Look for entries that start either "SEO" or "Use Seo"

 

-Skittles

 

 

Skittles!

 

After I did the browser, I cannot find any SEO URL's in both my configuration & configuration_group. :'( That is the cause of not seeing the SEO in my admin/configuration. So now, how do I go about getting this SEO URL in? But I'm so happy that you have help me to find the source of my problem! Thank you so much. I have being struggling to find how to solve my problem for the past 3 days.

 

Trixie

Link to comment
Share on other sites

Skittles!

 

After I did the browser, I cannot find any SEO URL's in both my configuration & configuration_group. :'( That is the cause of not seeing the SEO in my admin/configuration. So now, how do I go about getting this SEO URL in? But I'm so happy that you have help me to find the source of my problem! Thank you so much. I have being struggling to find how to solve my problem for the past 3 days.

 

Trixie

Trixie,

 

Actually, that's what I expected. What I don't understand is why it's not writing to the database.

 

The code in seo.class.php uses the constants defined in the configure.php to access the database. If the information was wrong there, nothing else should be working either.

 

Have you made any modifications to the file seo.class.php?

 

-Skittles

Link to comment
Share on other sites

Trixie,

 

I had the same problem. Download and use chemo's last contribution, not the ones above it. This happened to me and I had to back pedal on the contribs. Once I removed all the code add after chemo's work the system worked great.

 

There is something added in the 21d the messes it up, just install 2.1c.

Link to comment
Share on other sites

Trixie,

 

Actually, that's what I expected. What I don't understand is why it's not writing to the database.

 

The code in seo.class.php uses the constants defined in the configure.php to access the database. If the information was wrong there, nothing else should be working either.

 

Have you made any modifications to the file seo.class.php?

 

-Skittles

 

No! I did not make any changes to seo.class.php! I guess I have to use the 2.1c recommended by Mr Duncan.

And for everybody information, after my installation, my entire Administration catalog does not show anything until I found out there are two errors in admin/catergories.php file. Missing of "(". I'm not good at all with php files and it took me quite a long time to discover this. After I added the "(" before the tep_db_..., all my catalog appear. I hope this information will helps some newbies like me. :lol:

 

Line : 74

'categories_seo_url' => tep_db_prepare_input($categories_seo_url_array[$language_id])),

 

Line : 260

'products_seo_url' => tep_db_prepare_input($HTTP_POST_VARS['products_seo_url'][$language_id]));

 

Thank you so much skittles for your help

Link to comment
Share on other sites

No! I did not make any changes to seo.class.php! I guess I have to use the 2.1c recommended by Mr Duncan.

And for everybody information, after my installation, my entire Administration catalog does not show anything until I found out there are two errors in admin/catergories.php file. Missing of "(". I'm not good at all with php files and it took me quite a long time to discover this. After I added the "(" before the tep_db_..., all my catalog appear. I hope this information will helps some newbies like me. :lol:

 

Line : 74

'categories_seo_url' => tep_db_prepare_input($categories_seo_url_array[$language_id])),

 

Line : 260

'products_seo_url' => tep_db_prepare_input($HTTP_POST_VARS['products_seo_url'][$language_id]));

 

Thank you so much skittles for your help

 

Hi Skittles

 

The strange thing is that everything works fine for me accept the SEO URL not appearing in my admin/configuration and also in my phpmyadmin configuration. I'm able to enter in the Product SEO URL information at the new product and also I can see that my site are showing all the correct url with c-path and p-path. Since this is my case, can I just upload only the seo.class.php from 2.1c version?.

Link to comment
Share on other sites

Hi all:

 

I downloaded and installed Ultimate_SEO_URLsv21da_1_2 uploaded by yesudo Nov 29, 2006

 

I got it working - but when I went to change some languages in existing products files and then updated, the title (product name - $item_name) disappeared and the SEO URL field is all that is now left in admin - so I can't put an item name back in.

 

Is this something you have seen? I looked through 40 pages of the support thread and found nothing.

 

Also (so - as in I believe therefore) when putting an order in the cart I get this error

 

Warning: Missing argument 1 for show_total() in /home/centcom/public_html/onlinestore/includes/classes/shopping_cart.php on line 483

 

Even though the items go into the cart - no prices show - BUT a total does show.

 

Clicking "cart contents" gives then this error

 

Fatal error: Error calling function "CreateItem()": Missing Parameter: "$item_name" must be provided. in /home/centcom/public_html/onlinestore/includes/functions/GlobalAPIFunctions.php on line 419

 

Which appears to be because a item name is missing from Google Checkout's GlobalAPIFunctions.php

 

Of the two items I put int the cart - ignoring the error, the one without a name produces a google checkout API error call above while the one with the name does not. taking the standard checkout path the order can be completed with the "line 483 shopping_cart" errors showing.

 

Has anyone got any ideas of what is causing this - i believe the entire problems surrounds the dropped names - and that is all for right now.

 

Any help anyone can offer is appreciated.

 

Bob

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...