kbwill
Posts: 20
|
| Posted: 06/10/2008, 12:51 PM |
|
I tested my query (below) on my MySQL 5.0 database and it worked great.
Then I tried to copy and paste the sql into CodeCharge Studio 3.204 and I could not paste it (i dunno why). I contnued to reconstruct the query in the CCS3 Query Builder and created my report.
SELECT
mat.item
, mat.descr
, mat.catnbr
, mat.per
, mat.vuid
, mat.grpnr
, mat.unit
, matgrp.grpname
, vendor.vendorname
FROM
mydatabase1.matgrp
INNER JOIN mydatabase1.mat
ON (matgrp.grpnr = mat.grpnr)
INNER JOIN mydatabase1.vendor
ON (vendor.vuid = mat.vuid)
GROUP BY mat.vuid, mat.item, mat.descr, mat.catnbr
Order BY mat.vuid, mat.grpnr, mat.grps1, mat.grps2, mat.grps3, mat.grps4;
My goal is to print a stock list of items to order by vendor with a new page beginning for each vendor. All seems to go very well until I view the Live Page and I get this response...
Quote :Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 9120 bytes) in C:\wamp\web\mypracticewebsite\stock_by_vendor.php on line 760
How do I fix a memory problem like this? Is it a Code Charge bug?
I know this is a long one but I wanted to give you enough info to help me.
Thanks, in advance.
Kim
_________________
Learning CentOS, CCS3.2,
some assembly may be required. |
 |
 |
wkempees
Posts: 1679
|
| Posted: 06/10/2008, 2:05 PM |
|
Not a CCS bug.
Memory exhausting on XAMPP.
Are you doing a LivePage or Shift+F7?
Try Shift+F7, running your app on XAMPP in the Browser.
Come back.
You can increase the memory allowed per process by editing this line in your php.ini file and restarting Apache:
memory_limit = 16M
add the line if it is missing or edit the memory_limit=8M
OR (better solution on a per use base)
your Page, AfterInitialize event
ini_set("memory_limit","16M");
Vary 8,16,24,32.....
This is only needed for intensive processes which your repor(?) probably is, building a large dataset and doing processing on that.
Walter
(Advice not suited for children, may contain small parts,lol)
(liked your signature)
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
datadoit
|
| Posted: 06/10/2008, 3:03 PM |
|
Check your memory_limit value in your php.ini. Give it something high,
like 128M.
|
|
|
|
kbwill
Posts: 20
|
| Posted: 06/11/2008, 1:23 PM |
|
Quote datadoit:
Check your memory_limit value in your php.ini. Give it something high,
like 128M.
It worked - Thanks!
That was a big help.
_________________
Learning CentOS, CCS3.2,
some assembly may be required. |
|
|
|
wkempees
Posts: 1679
|
| Posted: 06/11/2008, 4:23 PM |
|
@K
Allthough Datadoit and I almost always agree, I would like to warn you of the following:
You have now set processing memory to 128MB for your total PhP setup.
First do a btree search for the needed memory.
Meaning standard = 8, yours is now 128.
Set it to 64, test. if it runs set it to 32 if not set it to 96.
Do this until you reach an acceptable value.
THEN:
adapt it to my ini_set("memory_limit","xxM");
method (replace xxM with found value).
Test.
If this works you have succesfully set processing memory for this process only.
This way if you have many processes running, each will be at default 8M setting, the altered process will use more memory untill it ends its processing.
From your post I gather 16M will be sufficient so 32 will be safely cater for growth.
Walter
.
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
datadoit
|
| Posted: 06/11/2008, 5:23 PM |
|
I agree. ;)
|
|
|
|
wkempees
Posts: 1679
|
| Posted: 06/11/2008, 6:32 PM |
|
Pfeeeew.
We agree again, Ya*oo
Walter  (3:34AM yawn)
@K
If satisfactory, change title to [SOLVED] or [HOW TO].
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
kbwill
Posts: 20
|
| Posted: 06/12/2008, 5:13 AM |
|
It worked at 64M.
Thanks to both of you.
You are a good team.
According to Google-Earth you guys are about 4,400 miles apart. (Walter in NL, DataDoIt in FL).
Technology brought together for my issue.
Thanks again to both of you for your help.
"The sum of all of us is smarter than any one of us"
You can declare this problem "Solved" (fixed).
_________________
Learning CentOS, CCS3.2,
some assembly may be required. |
|
|
|
wkempees
Posts: 1679
|
| Posted: 06/12/2008, 6:36 AM |
|
@kbwill
change title to [SOLVED] or [HOW TO] by editing your first post.
Happy you are happy!
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
|
