Help with database_setup.php header tags controller

[avus11]

Hi. I just started installing the 'Header Tags Controller V2.6.3 Complete' contribution. While I received the 'Database update successful' message after running the database_setup.php file, within the store in the right column, I lost several of my infoboxes (including product notifications, reviews, scrolling new products) and received the following text instead:

 

1104 - 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

 

select p.products_id, p.products_image, p.products_tax_class_id, p.products_price, pd.products_name from products p left join products_description pd on p.products_id = pd.products_id where products_status = '1' and p.products_id not in (select products_id from specials where status = 1) order by p.products_date_added desc limit 9

 

[TEP STOP]

 

This can be seen (the right hand column needs to be selected as my backgroun is black, as is the error text) here:

 

http://www.10500rpm.com/catalog

 

Without seeing this at first (due to the text color), I proceeded as per the install_catalog.txt read me (and did receive the desired 'home page" title for the index page), but have not proceeded with the admin part. I know the error occurred after running the database_setup.php though.

 

What went wrong and how can I fix this? Please don't hesitate to oversimplify in responding as I am new to this :'( .

 

Thank you!

[avus11]

Nevermind - it seems that my web host was doing something database-wise on their end which caused this as it spontaneously fixed itself!

 

Hi. I just started installing the 'Header Tags Controller V2.6.3 Complete' contribution. While I received the 'Database update successful' message after running the database_setup.php file, within the store in the right column, I lost several of my infoboxes (including product notifications, reviews, scrolling new products) and received the following text instead:

 

1104 - 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

 

select p.products_id, p.products_image, p.products_tax_class_id, p.products_price, pd.products_name from products p left join products_description pd on p.products_id = pd.products_id where products_status = '1' and p.products_id not in (select products_id from specials where status = 1) order by p.products_date_added desc limit 9

 

[TEP STOP]

 

This can be seen (the right hand column needs to be selected as my backgroun is black, as is the error text) here:

 

http://www.10500rpm.com/catalog

 

Without seeing this at first (due to the text color), I proceeded as per the install_catalog.txt read me (and did receive the desired 'home page" title for the index page), but have not proceeded with the admin part. I know the error occurred after running the database_setup.php though.

 

What went wrong and how can I fix this? Please don't hesitate to oversimplify in responding as I am new to this :'( .

 

Thank you!