Categories
Database Development

ERROR 1071 (42000): Specified key was too long; max key length is 1000 bytes

An online optimization tool offered to add indexes. One of the index is successfully created but i cant create the second one. Do you think that indexes going to reduce query run time? Any ideas how can i pass through the error code? SQL Query takes 10.1 secs and got over 380 times execution in […]

Categories
Development MySQL Plugins Wordpress

Table ‘wp_users’ already exists

Was working on a site offline and suddenly mysql port clash error came then I had to work on it solution for many hours but no luck. So I took the theme files and database manually from xampp and pasted them into a different computer system with a fresh xampp installed on it. This error […]