Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Search problem


gegeor

Recommended Posts

Posted

Hi all

 

I gave a problem with the search in oscommerce (ver. 2.2).This is the error i get:

-----------------------

1267 - Illegal mix of collations (greek_general_ci,IMPLICIT) and (latin1_swedish_ci,COERCIBLE) for operation 'like'

 

select count(distinct p.products_id) as total from ((products p) left join manufacturers m using(manufacturers_id), products_description pd) left join specials s on p.products_id = s.products_id, categories c, products_to_categories p2c,products_attributes pa where p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '4' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%δδδδ%' or p.products_model like '%δδδδ%' or m.manufacturers_name like '%δδδδ%') )

 

[TEP STOP]

----------------------

 

site language is Greek and this problem is only when i perform search with Greek word.

I have tried varius "solutions" through searching the error in Google but nothing worked...

 

Any ideas please?

 

Your help is valuable

 

Many thanks

 

George

Posted

go to phpmyadmin (tool probably provided by your hoster) and change the collation on all tables to be the same.

Posted

go to phpmyadmin (tool probably provided by your hoster) and change the collation on all tables to be the same.

Thanks for your reply

 

In which collation should i change? My language file has iso-8859-7 and the language i use is Greek

 

Thanks

  • 2 weeks later...
Posted

go to phpmyadmin (tool probably provided by your hoster) and change the collation on all tables to be the same.

 

Hello

 

This didnt work....I still have error when i try to perform search using Greek words

 

Please any help is valuble

Thanks

Posted

The error message is telling you that parts (or all) of your database are the default Latin-1 (ISO-8859-1) encoding and collation, while other parts may be Greek (ISO-8859-7?). The entire database might still be Latin-1, which MySQL isn't going to like to mix with Greek text coming in. You will need to ensure that your database is ISO-8859-7, but I don't know if you can directly do that (either through osC or phpMyAdmin) without also translating the existing tables. Presumably the database already contains Greek text, so you don't want to "translate" it to Greek -- that would mess up the data. At worst, someone will have to instruct you on how to export (back up) all your data to a dump file, empty out the tables, change their encoding/collation to be consistently Greek, and import the data back in to restore the database. If you're lucky, you might be able to change the encoding/collation without changing the data itself. Someone better versed in MySQL will have to lead you through that. Are your Greek language support files in ISO-8859-7 too, not UTF-8?

 

At any rate, before doing any operations on your database (such as changing encoding/collation), make a database backup. Worst case, you'll have to restore your database to get back to where you are now.

Posted

Hello

 

This didnt work....I still have error when i try to perform search using Greek words

 

Please any help is valuble

Thanks

what version of MySQL ?

 

have you raised it with your host?

Sam

 

Remember, What you think I ment may not be what I thought I ment when I said it.

 

Contributions:

 

Auto Backup your Database, Easy way

 

Multi Images with Fancy Pop-ups, Easy way

 

Products in columns with multi buy etc etc

 

Disable any Category or Product, Easy way

 

Secure & Improve your account pages et al.

Posted

Thanks for your replies

 

MrPhil:I use ISO-8859-7 for Greek language files and the problem appeared with PHP upgradeto ver. 5. My host tried several times to find a solution but with no sucess..

 

The problem is at Mysql because i tried clean oscommerce installation ,import dbase and same thing happens...same error after the import

 

The dbase has lot of items and in any case i cant just forget it.....

 

spooks: MySQL client version: 5.0.87 and as i wrote up my host has tried to solved it ..Do you have any idea of what i ask my host specific to do?perhaps something they dont know?

 

Many thanks both of you:)

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...