Memory exhausted, upping memory_limit not working

I am moving my site locally to a development server and having some issues just loading the page.  When I go to the root, I am getting the following memory size exhausted error.  I have read all over the forums to change the php.ini memory_limit to a higher number and have done so, but the same error comes up and the bytes numbers in the error message just seem to go up as I increase the memory_limit. I tried lowering and increasing in smaller increments as well. Any ideas?  Thanks!

-- php.ini memory_limit is 512M

[Fri May 03 09:24:34 2013] [error] [client 24.27.181.225] PHP Fatal error:  Allowed memory size of 536870912 bytes exhausted (tried to allocate 78907668 bytes) in /var/www/inc/classes/BxDolDb.php on line 482

-- changed php.ini memory_limit to 2048M

[Fri May 03 09:31:06 2013] [error] [client 24.27.181.225] PHP Fatal error:  Allowed memory size of 2147483648 bytes exhausted (tried to allocate 330337428 bytes) in /var/www/inc/classes/BxDolDb.php on line 482

There is some db error and possible some infinite loop, so it causes to exhaust any memory limit.

Check configuration, db - maybe something went wrong during site moving.

If you are moving a Dolphin site from a local windows machine like a wamp setup to a development linux machine sometimes this can happen because a local windows setup tends to creates database tables with all lowercase names when installed, but there are some tables that Dolphin usually needs capital letters on some linux systems, which can cause an exahaust memory limit error. Windows thinks rayboardboards and RayBoardBoards are the same, but linux thinks they are different.

Check the following tables in your database and make sure they have capitals:
Profiles
RayBoardBoards
RayBoardCurrentUsers
RayBoardUsers
RayChatCurrentUsers
RayChatMemberships
RayChatMembershipsSettings
RayChatMessages
RayChatProfiles
RayChatRooms
RayChatRoomsUsers
RayImContacts
RayImMessages
RayImPendings
RayImProfiles
RayMp3Files
RayMp3Tokens
RayShoutboxMessages
RayVideoFiles
RayVideoTokens
RayVideo_commentsFiles
RayVideo_commentsTokens

If not rename the tables so they have capital letters. Make sure you get them all right like RayBoardBoards and not just Rayboardboards.

Not sure that this is your problem, but I have seen the same or similar issue when moving from a local windows machine to linux web server on several occasions. Worth a quick peek anyway.

 WOW...

[edit] you actually have experienced this?

It happens when you work locally on a Windows system.  Never happened on my QNX box!

 Nathan, we can never keep up with you.

I could google it, but your description would be much better. What the F is QNX?

I have also never setup up a Windows server for D...

The same software that keeps a nuclear power plant from making a tunnel to BoonEx HQ.

 No wonder you have 7k post, half are like mine. BS

I ran into this when I moved from my windoze box to my quad core ubuntu server.

It was time consuming, but, I installed another dolphin site (in a subdomain)  then compared database table names and changed all the names to match the site I moved over on the linux box.

Thank you soooo much.  I renamed all these and it didnt work, but then I realized I did rename the Profiles table and it worked.  Thanks again!  Are there any other big windows > linux gotchas I should look out for?  Found out I had to use restorecon on all files after transferring from windows.

I have a test site this happened to.  The site was working fine and then started having the memory issues.  I contacted the host and they would increase memory without luck.  Now the site is set at a very high memory limit and will load but very slowly.  I think the site may have been compromised or a bad mod installation caused it.  Since it is a test site, I am just going to pull it down and clean up the server.

Another thing you might need to do if you are going from Dolphin on windows to linux is swap out ffmpeg.exe if you haven't already. The one in the standard Boonex Download is for most linux systems. If you replaced it with the windows ffmpeg.exe for your local setup you would need to make sure you swap it with the linux version in the regular Dolphin download. You will also most likely need to set ffmpeg.exe to either 755 or 777 depending on your setup.

You may need to adjust some file/folder permissions depending on the server/setup configuration you moved it to.

You are probably going to want to setup a cron job as well if you haven't done so yet.

Look around in the Dolphin Administration under tools-> Host Tools. Check the Audit, Permissions, and PHP info settings.

This happens to me too. The "Profiles" was "profiles". I remember wasting lots of hours figuring that out when i was a dolphin noob.

@Nathan Must be fun using a real time operating system lol

 if you set lower_case_table_names=2 in my.ini  then it will adhere to uppercase when creating new tables.

figured out this one years ago the hard way....  

are you using IIS or XAMPP (Or WAMP, DAMP etc)?

I almost mentioned editing mysql config file, but wasn't sure if timmyg13 had access to do so or not. I figured he probably did since he mentioned raising php.ini up to a 2gb memory limit, but decided to omit it in case others that don't have that kind of access happen to check this one.

I have chagned it locally in a test environment myself on a few occasions, but not in a live or development setting. From what I understand you should set that one once and leave it. Changing it back and forth can cause issues. Never tried multiple changes myself to see what would become of it though.

The thing I am wondering about is:

Do these tables really need to be capitalized to begin with?

I mean it seems to me it would due away with a few problems and issues if they were all the more popular lowercase entries to begin with.

Obviously there would need to be some changes to pages and such too.

I know moving from a windows wamp type of setting to a development linux setup is not the most popular thing with Dolphin, but it does happen. Seems to me if the tables were all lowercase it would help reduce a few odd ball situations like this one.

I requested all lower case tables about 4 years ago and got no where with it.  They have removed a lot of uppercase tables a long the way but as you know a few still remain.... 

 Thats a very good point, why do something that will cause issue on some situations.

This is not a fix for your problem and I haven't used wamp for a couple of years but I seem to recall that to avoid this problem you just change the c in the wamp manager.ini file to C all instances before you install dolphin on your local machine this seemed to stop this problem from the start .

Action: run; FileName: "c:/wamp/bin/php/php5.3.5/php-win.exe";Parameters: "-c .

changeLanguage.php dutch";WorkingDir: "c:/wamp/scripts"; Flags: waituntilterminated
Action: run; FileName: "c:/wamp/bin/php/php5.3.5/php-win.exe";Parameters: "-c .

refresh.php";WorkingDir: "c:/wamp/scripts"; Flags: waituntilterminated
Action: resetservices
Action: readconfig;

[lang_english]
Action: run; FileName: "C:/wamp/bin/php/php5.3.5/php-win.exe";Parameters: "-C .

changeLanguage.php english";WorkingDir: "C:/wamp/scripts"; Flags: waituntilterminated
Action: run; FileName: "C:/wamp/bin/php/php5.3.5/php-win.exe";Parameters: "-C .

refresh.php";WorkingDir: "C:/wamp/scripts"; Flags: waituntilterminated

Happy thoughts