Strange Warning message

[Kevin205]

A zen site running 1.5.1 is using a link checker to verify his site's link and on the following urls,

http: //Domain.com/index.php?main_page=products_all&disp_order=1&fltCategory[]=19
http: //Domain.com/index.php?main_page=products_all&disp_order=1&fltCategory[]=20
http: //Domain.com/index.php?main_page=products_new&disp_order=6&fltCategory[]=19
http: //Domain.com/index.php?main_page=products_new&disp_order=6&fltCategory[]=20
http: //Domain.com/index.php?main_page=products_new&disp_order=6&fltPrice[]=128.01--178&fltCategory[]=19
http: //Domain.com/index.php?main_page=products_new&disp_order=6&fltPrice[]=128.01--178&fltCategory[]=20
http: //Domain.com/index.php?main_page=products_new&disp_order=6&fltPrice[]=128.01--178&fltCategory[]=21
http: //Domain.com/index.php?main_page=products_new&disp_order=6&fltPrice[]=128.01--178&fltCategory[]=22
http: //Domain.com/index.php?main_page=products_new&disp_order=6&fltPrice[]=128.01--178&fltCategory[]=23

mostly happening on Category[]=19, 20, 21, 22, & 24

he is getting the following warning on lower left hand corner of the page. And the page shows the header info, left category box and the rest is white.

WARNING: An Error occurred, please refresh the page and try again.
Page displays the same when page is refreshed.


It seems to me the links checker is going through the Dynamic filter (as the [] are seen).

Any one with any ideas?

[Kevin205]

OK I duplicated the case while using the dynamic filter and selecting New Products or All Products and clicking on any of categories 19, 20, 21, 22, 23 & 24.


I don't know how to move or close this from General Question, as it has to be discussed on Dynamic Filter thread.

[DrByte]

WARNING: An Error occurred, please refresh the page and try again.

http://www.zen-cart.com/content.php?...-and-try-again

[Kevin205]

http://www.zen-cart.com/content.php?...-and-try-again

As I checked the error log, I guess the question stays here, as it is NOT a Dynamic filter issue!

The error message is as follow:

[17-Apr-2013 20:20:50] PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '), 'Y', 'N') as flag FROM zen_manufacturers WHERE manufacturers_id IN (24,4,8,13' at line 1 :: SELECT manufacturers_id, manufacturers_name, IF(manufacturers_id IN(), 'Y', 'N') as flag FROM zen_manufacturers WHERE manufacturers_id IN (24,4,8,13,10,23,18,15,16,21,17,20,19,22,12,14) ORDER BY manufacturers_name in /MyPath/includes/classes/db/mysql/query_factory.php on line 120

DrByte, I am lost with this error. Can the tables be fixed?

[DivaVocals]

As I checked the error log, I guess the question stays here, as it is NOT a Dynamic filter issue!

The error message is as follow:




DrByte, I am lost with this error. Can the tables be fixed?

And you have provided virtually no information that would give anyone a clue as to what's going on.. (starting with basic information like what were you doing before this error occurred)

So let me suggest that you take a look at the posting tips (that show above the reply box when you add a post to this site).. Provide the information suggested.. This will help the community to help you..

[Kevin205]

DrByte understood.

The error log explain something that I don't understand!

[Kevin205]

And you have provided virtually no information that would give anyone a clue as to what's going on.. (starting with basic information like what were you doing before this error occurred)

So let me suggest that you take a look at the posting tips (that show above the reply box when you add a post to this site).. Provide the information suggested.. This will help the community to help you..

Did you read the entire post? If you didn't, then you should.

[RodG]

As I checked the error log, I guess the question stays here, as it is NOT a Dynamic filter issue!

I don't know how you came to this conclusion based on the error message provided.
Yes, it may appear the the problem has something more to do with "query_factory.php", but this is only the messenger. The real problem is within the code that calls the query_factory.

DrByte, I am lost with this error. Can the tables be fixed?

THere is nothing in the error message that suggests the the tables are broken. However, if in doubt, phpMyAdmin (and pretty much any other MySQL administration tool) has options to check and/or repair the DB tables. There is no harm in using these tools, and depending on the cause of the problem, it can indeed solve some issues. Alas, I don't think you'll be as lucky.

I think you were closer to the mark with your dynamic filter diagnosis.

Cheers
Rod

[Kevin205]

I don't know how you came to this conclusion based on the error message provided.
Yes, it may appear the the problem has something more to do with "query_factory.php", but this is only the messenger. The real problem is within the code that calls the query_factory.



THere is nothing in the error message that suggests the the tables are broken. However, if in doubt, phpMyAdmin (and pretty much any other MySQL administration tool) has options to check and/or repair the DB tables. There is no harm in using these tools, and depending on the cause of the problem, it can indeed solve some issues. Alas, I don't think you'll be as lucky.

I think you were closer to the mark with your dynamic filter diagnosis.

Cheers
Rod

Thanks for the info. I will look at my PHPMyadmin to see what tools are available to me. And will let you know if it works.
But as you said I don't think I would be that lucky!

Following is what I have done after a site without any errors:

1. Installed sitemapXML
2. Updated/revised the manufacturer's name for some products, and uploaded them using EP4 (through Full-EP_04_10_2013.csv)

After looking at it in detail:
The error only occurs when New Products, /index.php?main_page=products_new and All Products, /index.php?main_page=products_all are selected; and not all categories results in the error, only selecting certain categories causes the error. I am now trying narrow down the category ID numbers. I am guessing the might be numbered (24,4,7,8,13,10,23,18,15,16,21,17,20,19,22,12,14).

Following are a serires of error I am getting as testing:

[18-Apr-2013 07:40:48] PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '), 'Y', 'N') as flag FROM zen_manufacturers WHERE manufacturers_id IN (24,4,7,8,' at line 1 :: SELECT manufacturers_id, manufacturers_name, IF(manufacturers_id IN(), 'Y', 'N') as flag FROM zen_manufacturers WHERE manufacturers_id IN (24,4,7,8,13,10,23,18,15,16,21,17,20,19,22,12,14) ORDER BY manufacturers_name in /MyPath/includes/classes/db/mysql/query_factory.php on line 120

[18-Apr-2013 07:40:25] PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '), 'Y', 'N') as flag FROM zen_manufacturers WHERE manufacturers_id IN (24,4,8,13' at line 1 :: SELECT manufacturers_id, manufacturers_name, IF(manufacturers_id IN(), 'Y', 'N') as flag FROM zen_manufacturers WHERE manufacturers_id IN (24,4,8,13,10,23,18,15,16,21,17,20,19,22,12,14) ORDER BY manufacturers_name in /MyPath/includes/classes/db/mysql/query_factory.php on line 120

[18-Apr-2013 07:40:19] PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '), 'Y', 'N') as flag FROM zen_manufacturers WHERE manufacturers_id IN (24,4,8,13' at line 1 :: SELECT manufacturers_id, manufacturers_name, IF(manufacturers_id IN(), 'Y', 'N') as flag FROM zen_manufacturers WHERE manufacturers_id IN (24,4,8,13,10,23,18,15,16,21,17,20,19,22,12,14) ORDER BY manufacturers_name in /MyPath/includes/classes/db/mysql/query_factory.php on line 120

[18-Apr-2013 07:37:23] PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '), 'Y', 'N') as flag FROM zen_manufacturers WHERE manufacturers_id IN (24,4,8,13' at line 1 :: SELECT manufacturers_id, manufacturers_name, IF(manufacturers_id IN(), 'Y', 'N') as flag FROM zen_manufacturers WHERE manufacturers_id IN (24,4,8,13,10,23,18,15,16,21,17,20,19,22,12,14) ORDER BY manufacturers_name in /MyPath/includes/classes/db/mysql/query_factory.php on line 120

[lhungil]

[17-Apr-2013 20:20:50] PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '), 'Y', 'N') as flag FROM zen_manufacturers WHERE manufacturers_id IN (24,4,8,13' at line 1 :: SELECT manufacturers_id, manufacturers_name, IF(manufacturers_id IN(), 'Y', 'N') as flag FROM zen_manufacturers WHERE manufacturers_id IN (24,4,8,13,10,23,18,15,16,21,17,20,19,22,12,14) ORDER BY manufacturers_name in /MyPath/includes/classes/db/mysql/query_factory.php on line 120

I am not 100% sure what the part in red is trying to do, but is is the cause of the error. I also did not (with a quick search) find this query in the stock Zen Cart code. You will have to find the code creating that SQL Query, determine what the extra "flag" is for, and adjust the SQL (or code generating the SQL) as appropriate.

Note: If it is supposed to add a flag to the SQL result and uses the same condition as the WHERE clause condition... The "flag" can probably be removed from the query and code...