Memory problem after updating promotional member to standard member

[killerhaai]

Also into beta 6 I got the same problem after trying to update a promotical user to standard user. The problem is that there is always a error to got more memory for php scripts. I had by installation already upgraded to 18 MB for scripts. look to the code please. For my is not a problem but for others maby.

Database query error Query: SELECT sys_acl_levels_members.IDLevel as ID, sys_acl_levels.Name as Name, UNIX_TIMESTAMP(sys_acl_levels_members.DateStarts?) as DateStarts?, UNIX_TIMESTAMP(sys_acl_levels_members.DateExpires?) as DateExpires?, sys_acl_levels_members.TransactionID AS TransactionID FROM sys_acl_levels_members RIGHT JOIN Profiles ON sys_acl_levels_members.IDMember = Profiles.ID AND (sys_acl_levels_members.DateStarts? IS NULL OR sys_acl_levels_members.DateStarts? <= FROM_UNIXTIME(-1)) AND (sys_acl_levels_members.DateExpires? IS NULL OR sys_acl_levels_members.DateExpires? > FROM_UNIXTIME(-1)) LEFT JOIN sys_acl_levels ON sys_acl_levels_members.IDLevel = sys_acl_levels.ID WHERE Profiles.ID = 2 ORDER BY sys_acl_levels_members.DateStarts? DESC LIMIT 0, 1 Mysql error: Column 'DateStarts?' cannot be null Found error in the file '/home/vdstudio/domains/vdstudio.nl/public_html/inc/membership_levels.inc.php' at line 163. Called 'fromMemory' function with erroneous argument #2.

Fatal error: Allowed memory size of 18874368 bytes exhausted (tried to allocate 3709877 bytes) in /home/vdstudio/domains/vdstudio.nl/public_html/inc/classes/BxDolTemplate.php on line 1177

[AntonL]

1. We cannot reproduce the issue on any of our servers. What MySQL version do you use?
   

2. Did you still receive the error after you've increased the memory size? If so, could you please provide us with access to your server, that we can investigate the issue and find the solution.

[killerhaai]

Yes after increase the memort size to 19 mb I got the same error with the following error under the red box:

Fatal error: Allowed memory size of 19922944 bytes exhausted (tried to allocate 3709457 bytes) in /home/vdstudio/domains/vdstudio.nl/public_html/inc/classes/BxDolTemplate.php on line 1177

I will give you the data to my server by PM.

[AntonL]

New version of Dolphin uses a lot of cache(in files, in memory). If you take a look at the error's description you may see that script tries to get data calling 'fromMemory' function instead of getting it directly from DB. But the memory is full, it cannot get requested data and error appears.
We updated the requirements for Dolphin script. Memory limit should be 128M or more.