Em Andamento

Website MySQL Database Error fix

I recently got my website rebuilt by an external developer that did a bad job with the queries in the database.

When I click on any subcategory on the [url removed, login to view] page I get the following error message:

Problem in Product Selection: The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay.

I have reviewed individual .php files and cannot find anything that could link me to this error message, I also looked through the MYSQL and could not find anything. I have been adding new products to the site but can see it except if it is though the main index page.

I was told by my hosting company to do the following, I have minimal knowledge of the MYSQL. The Developer that worked on my site, did a crappy job and I am just fixing so far all his bad work.

*****************************************************

Regarding the large MySQL query you are creating, please use an ON or USING clause to each table join so that you limit or decrease the amount of permutations the MySQL database needs to examine (thus decreasing the SELECT size).

Please be advised that the code you are using should have this in front of the main query.

mysql_query("set sql_big_selects=1");

********************************************************

I am in need of an experienced and outstanding MySQL/PHP database developer that can assist me in looking into my current database and be able to fix the errors received on the Subcategory pages on my website.

[url removed, login to view] (this is okay)

[url removed, login to view] (this and the rest of the links under it are erroring out.

Thanks.

Habilidades: PHP

Ver mais: fix mysql database error, database error fix, website fix anything, website page size, website errors fix, this error, selection problem, problem website, mysql developer job, my fix, job find website, get fix, fix page, fix anything website, find job php developer, find job developer, find developer job, error page jsp, developer job website, database website developer, creating website company, creating php table, amount received, website database error, mysql permutations select

Acerca do Empregador:
( 5 comentários ) Brampton, Canada

ID do Projeto: #169713