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?
Results 21 to 30 of 30
-
5 Jan 2018, 12:17 AM #21
Totally Zenned
- Join Date
- Feb 2009
- Posts
- 861
- Plugin Contributions
- 0
Re: Reactivating download links in bulk?
-
15 Apr 2018, 02:08 PM #22
New Zenner
- Join Date
- Jan 2018
- Location
- Kuching
- Posts
- 6
- Plugin Contributions
- 0
Re: Reactivating download links in bulk?
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.
-
15 Apr 2018, 03:12 PM #23
Totally Zenned
- Join Date
- Jul 2012
- Posts
- 16,732
- Plugin Contributions
- 17
Re: Reactivating download links in bulk?
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
Originally Posted by chbong
There should be a myDebug-xxx log to identify what the error was.ZC Installation/Maintenance Support <- Site
Contribution for contributions welcome...
-
7 Aug 2018, 07:27 AM #24
New Zenner
- Join Date
- Jan 2018
- Location
- Kuching
- Posts
- 6
- Plugin Contributions
- 0
Re: Reactivating download links in bulk?
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.
-
7 Aug 2018, 12:00 PM #25
Totally Zenned
- Join Date
- Jul 2012
- Posts
- 16,732
- Plugin Contributions
- 17
Re: Reactivating download links in bulk?
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...
-
7 Aug 2018, 03:03 PM #26
New Zenner
- Join Date
- Jan 2018
- Location
- Kuching
- Posts
- 6
- Plugin Contributions
- 0
Re: Reactivating download links in bulk?
This is the server info.
-
7 Aug 2018, 03:12 PM #27
Administrator
- Join Date
- Sep 2009
- Location
- Stuart, FL
- Posts
- 12,478
- Plugin Contributions
- 88
Re: Reactivating download links in bulk?
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()">
-
8 Aug 2018, 08:14 AM #28
New Zenner
- Join Date
- Jan 2018
- Location
- Kuching
- Posts
- 6
- Plugin Contributions
- 0
Re: Reactivating download links in bulk?
Actually I didn't modify anything in the downloads_manager.php.
My line 66 is identical to yours. Any other possible cause?
-
8 Aug 2018, 09:01 AM #29
Totally Zenned
- Join Date
- Jul 2012
- Posts
- 16,732
- Plugin Contributions
- 17
Re: Reactivating download links in bulk?
The error message: Originally Posted by chbong
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...
-
8 Aug 2018, 02:17 PM #30
New Zenner
- Join Date
- Jan 2018
- Location
- Kuching
- Posts
- 6
- Plugin Contributions
- 0
Re: Reactivating download links in bulk?
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.
Reply With Quote
Similar Threads
-
Reactivating Downloads on ALL Orders
By jmsnyder23 in forum Setting Up Categories, Products, AttributesReplies: 3Last Post: 5 Apr 2011, 01:44 AM -
reactivating coupon codes
By booghaboobaby in forum General QuestionsReplies: 1Last Post: 5 Dec 2009, 05:31 AM -
RE: Download to Bulk Uploader
By waynevincent in forum General QuestionsReplies: 0Last Post: 9 Nov 2008, 12:53 AM -
No Download Links
By EdelineM in forum Basic ConfigurationReplies: 0Last Post: 14 May 2008, 09:27 PM
Bookmarks