We had deployed a Zen Cart website and we came up with the following error in the Zen Cart admin panel when clicking on the Tools -> Send Email link. Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation ‘locate’ After checking the table collation in PHPmyAdmin I found that the subscribers table (created when … Read more How to resolve the Zen Cart Illegal mix of collations error
mySQL has full text indexing and searching support from version 5.0 onwards however there are some limitations. If you need to implement full text indexing then please review points given below: 1. mySQL allows full text indexing on MyISAM tables and not any other table type. If you try to create a full text index … Read more Steps to implement mySQL FULLTEXT
After Oracle announced in mid 2009 to acquire Sun there has been much apprehension in the open source community over the future of mySQL. Sun had acquired MySQL AB (the company) and kept it open source however once Oracle acquires it things may not remain the same as mySQL is a competitor to Oracle. Save … Read more Sign the petition to save mySQL
A client of mine developed his website in Zencart and after careful scrutiny approved the website for deployment to his production machine. He provided the FTP and mySQL information for us to deploy the website. As is the practice, I check for any version conflicts that may conflict with our system before I give the … Read more What is the minimum mySQL version requirement for Zencart?
A client was running a membership driven website for some time now. He had been offering free membership and no membership expiry up till now. However, some where along the way he was bit by the commercial bug 🙂 and he decided on ending free membership for all members. He wanted his members to pay … Read more How to add number of days in a date in mySQL?
I had logged into PhPMyAdmin and was trying to add some fields into a table when I got the error “Got error 28 from storage engine”. I tried to refresh the page but it kept coming. I closed the browser and then tried to run my website and found that the same error message was … Read more What to do if you got the “Got error 28 from storage engine” in mySQL?
mySQL is one of the most widely used open source databases around the world. Today this is the database engine driving up to 90% of PHP driven websites on the web. PHP has been the first love of mySQL and it will always have a special place. However, with other technologies coming to the fore … Read more How to connect .NET with mySQL?
If you have a database with millions of records on which you provide search facility to customers then you will need to maintain indexes so that the visitor experience is enhanced. SQL Server 2005 allows you to create indexes. Its up to you to decide which columns should be indexed. Most probably those columns should … Read more Rebuild indexes in SQL Server 2005
If you want to modify the auto increment column to start inserting records from a specific value then you will need to run the following statement. ALTER TABLE <table_name> AUTO_INCREMENT = 12345; After running the above statement the insertion will start from that value. However if there are any records which have a value greater … Read more Modify the auto increment value in mySQL
If you have a large number of stored procedures in your SQL Server 2005 and you have to give EXEC permission to a database user on all of them then the best way to do it is by running the following SQL SELECT ‘ GRANT EXEC ON ‘+ name +’ TO <database_user> ‘ from sys.procedures … Read more Grant EXEC permission on all stored procedures in SQL Server 2005