Jack_mcs

You're telling Ultimate SEO to use an alternate setting so you have to make sure that setting is filled in. To do that, go to the product edit page and scroll down to the section with the title of "Header Tags SEO Meta Tag Data" and you will see the "Title Tag - URL" box.

Are you saying you have the use Header Tags setting enabled in Ultimate SEO and that you have an entry in the Header Tags URl box for the product and the url title doesn't change to that text?

I'm not sure I understand the problem but it sounds like you are not setting up Header Tags SEO correctly. This post may help.

When that option is set, the url uses the text set in the Title Tag - URL setting for the category, manufacturer or product. You have to fill that in or you will get a url like you show. In the future, please post questions about a specific addon in the support thread for that addon.

That will work but there's isn't any code in place to capture the IP unless something was added.

See the Honey Pot addon. There are only a few changes needed. It stops 100% of spam by bots on the contact us page and is completely transparent to the customer.

It's failing because the on clause is for manufacturers and specials but the code is referencing a product field. That can be changed but I think the more important question is if your code can handle the newer php version, which will be used with the new MySQL version. If your shop is using that old of a MySQL version then I suspect the code has not been updated to run with newer versions of php. It should run on, at least, 5.4 and even that is no longer supported. You would be better off switching to the latest oscommerce version.

Assuming you mean my addon, it uses javascript for the create account page and javascript can be bypassed by spammers. It can't be bypassed on the contact us page because that also uses php code. What could be done is to add code to store the IP and the date of account creation and then refuse new accounts if it is from the same IP and within XX amount of time. That won't stop it but it should cut it down quite a bit. I already have the code for that in the Pro version of View Counter. I'll see about adding it to the next Honey Pot version.

That is a good idea but won't help in this case since it the creation of accounts causing a problem. And if that is put on hold for approval, the shop would probably lose sales.

You may want to look at my Database Optimizer.

There are several threads regarding this on this subject. There's no simple way to remove them in a stock shop. You can do one of the following: If there are not too many, you can manually delete them in admin->Customers. If there are too many to delete manually, you can delete them by editing the database. How easy this is depends on when the accounts were created and if there is something in common with them, like the same in each. To prevent it from happening again, If you can determine the country that the accounts are being added from and if you won't sell to that country, then remove the country from the countries list in admin or install an addon or package that blocks countries if your host doesn't provide that option. If you can determine the IP of those that created the account, you could block those IP's. There are addons meant to store the IP if you don't have one installed.

The above only works if you have Header Tags SEO installed. Other than that one setting, Ultimate SEO doesn't have anything to do with meta tags. Try turning Ultimate SEO off in admin and see if your meta tags appear. If not, you have some other problem. If they do, turn it back on and turn off that setting to see if that helps.

Then you have the "official" version. In that case, the css file used to change some of the styling is the stylesheet.css file in the root. It won't contain all of classes used in the shop but you can add them there. But some styling is hard-code into the files so it will depend on what you want to change to determine where to change the css.

There is the "Free Shipping per Product" addon but I don't know if it is up-to-date or not. The Daily Specials addon will do that and should work with 2.3.4, as I recall. I recently released Gift Vouchers Secure which allows you to limit coupons to certain products but that requires you to provide the code to the customers.

It depends on the version of the shop and whether or not it uses a template.