OK I edited the file and replaced the previously edited file, but aside from the green notification on top, the R button does not look any different. Is that what I should expect?
OK I edited the file and replaced the previously edited file, but aside from the green notification on top, the R button does not look any different. Is that what I should expect?
Hi, the R button does not work on my v1.5.5e even I have copied query_factory.php of v1.5.5f to the folder.
When I clicked on the R button, it shows the following message: WARNING: An Error occurred, please refresh the page and try again.
Did I miss anything?
Thanks.
To help identify the issue and whenever being presented that response, see the following FAQ: https://www.zen-cart.com/content.php...-and-try-again
There should be a myDebug-xxx log to identify what the error was.
ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...
Hi mc12345678, this is the error being logged.
trigger_error() called at [/home6/bolderso/public_html/includes/classes/db/mysql/query_factory.php:171]
#2 queryFactory->show_error() called at [/home6/bolderso/public_html/includes/classes/db/mysql/query_factory.php:143]
#3 queryFactory->set_error() called at [/home6/bolderso/public_html/includes/classes/db/mysql/query_factory.php:270]
#4 queryFactory->Execute() called at [/home6/bolderso/public_html/peNny-QLM-skUnk/downloads_manager.php:66]
[07-Aug-2018 00:24:33 America/Denver] PHP Fatal error: 1104:The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET MAX_JOIN_SIZE=# if the SELECT is okay :: update zen_orders_products_download opd,
zen_orders o,
zen_orders_products op,
zen_orders_products_attributes opa,
zen_products_attributes pa,
zen_products_attributes_download pad
set opd.download_count = pad.products_attributes_maxcount,
opd.download_maxdays = DATEDIFF(CURDATE(), o.date_purchased) + pad.products_attributes_maxdays
WHERE op.orders_id = o.orders_id
and op.orders_id = opd.orders_id
and pa.products_attributes_id = pad.products_attributes_id
and pa.options_id = opa.products_options_id
and pa.options_values_id = opa.products_options_values_id
and pad.products_attributes_filename = opd.orders_products_filename
and pad.products_attributes_id = 271 ==> (as called by) /home6/bolderso/public_html/peNny-QLM-skUnk/downloads_manager.php on line 66 <== in /home6/bolderso/public_html/includes/classes/db/mysql/query_factory.php on line 171
Sorry for late response as I was working on other projects earlier. Now, I am back to this project again.
Last edited by chbong; 7 Aug 2018 at 07:30 AM.
Earlier asked if anything had been missed. One thing missed in the post is information related to the posting tips. So far it can be seen that at least in part ZC 1.5.5e has been installed with some aspects of ZC 1.5.5f. The issue appears to be related to the sql server. Could you please at least identify the server environment information from the top of the screen selecting the version link from the admin? There may also be some environment related variables related to the mysql server below that which may be helpful.
ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...
You've got some customizations to your admin's /downloads_manager.php that are causing this issue. Line 66 of the as-shipped version for the Zen Cart 1.5.5e/f version of that file is
Code:<body marginwidth="0" marginheight="0" topmargin="0" bottommargin="0" leftmargin="0" rightmargin="0" bgcolor="#FFFFFF" onload="init()">
Actually I didn't modify anything in the downloads_manager.php.
My line 66 is identical to yours. Any other possible cause?
The error message:is in disagreement with that statement.Code:#4 queryFactory->Execute() called at [/home6/bolderso/public_html/peNny-QLM-skUnk/downloads_manager.php:66]
I don't recall the line numbers but I seem to recall that there were only two places in the file with an Execute command. I thought one was around line 30 and one around line 90. So the question becomes why is line 66 being reported?
ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...
I downloaded the file and opened it with a code editor. line 66 in download_manager.php is referred to
queryFactory->Execute().
The file is from the previous thread from DrByte.
I suspect the SQL statement causes the fatal error.
Bookmarks