Fatal Error[solved]

[theinvisible]

When i created backup of sql file on server, i got an error stating " Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 72 bytes) in /home/******/public_html/oc-includes/osclass/model/Dump.php on line 147 "

What does this means? there is no problem on backing up of files on my server.

[Ashok Bhamla]

This is problem with hosting company.

please ask them to increase your memory limit in php.ini file 128M to 256M.

128M is the default value in php.ini make it 256M.

[theinvisible]

This is problem with hosting company.

please ask them to increase your memory limit in php.ini file 128M to 256M.

128M is the default value in php.ini make it 256M.

I asked about that. And they said their default value is 64M and they already increased it to 128M and their max limit is 128M 

[frosticek]

@theinvisible
Well, 128MB should be enough. There might be specific cases or bugs where 256MB is required. Usually good hosting providers provide maximum 256MB, not 128MB.
I do not think you can do anything with this, it seems that sql file you want to create is bigger or require more memory to create, so you can only try to create backup directly on database.

[teseo]

Hi,

As frosticek has already pointed, 128MB should be enough for a simple backup, unless you have a big amount of data on your database (lots of ads and/or languages and/or locations...). If that's not the case maybe you have some kind of memory leak provoked by a plugin. Try disabling them before making the backup and see what happens.

Regards

[Ashok Bhamla]

@theinvisible
In that case backup all files from FTP and also get backup your database with the help of online backup software

using these software's
simply use BD user name and password to connect,

http://mysqlbackupftp.com/

http://www.heidisql.com/

[Aficionado]

@theinvisible
In that case backup all files from FTP and also get backup your database with the help of online backup software

using these software's
simply use BD user name and password to connect,

http://mysqlbackupftp.com/

http://www.heidisql.com/

Are you for real ? Or a posting bot ? What non-sense are you posting ?

[theinvisible]

thanks @frosticek, @teseo, @ashokbhamla for info..

I am going to try disabling plugins first.

[theinvisible]

@theinvisible
In that case backup all files from FTP and also get backup your database with the help of online backup software

using these software's
simply use BD user name and password to connect,

http://mysqlbackupftp.com/

http://www.heidisql.com/

Are you for real ? Or a posting bot ? What non-sense are you posting ?

@Aficionado what happened?

[theinvisible]

I disabled all my plugins, and tried to backup my sql file on my server. But the error is still there. I don't know what to do now.

[fog]

Hi,

Don't use online websites for sql backups or other methods online with your passwords. Use only phpmyadmin.

You can export sql on phpmyadmin or happens the same?

Make sure you have all plugins disabled.

If you can export your DB on phpmyadmin, save your db tables on your computer.

After that, create a subdomain and install osclass from scratch.

Upload your theme.

Open phpmyadmin again and delete/drop all tables.

All tables was deleted? Good, now import your sql tables backup for your new db name empty.

If no errors during the import, all run well on your subdomain with a fresh install and new db name, now try make a sql backup from osclass admin for see what happens.

This test is for see if with a fresh install osclass with same sql tables, can solve the problem.

Regards

[Aficionado]

Just remove or disable all those plugins. What have you added, the whole Market ?

Some plugin is eating your memory.

[frosticek]

Guys I am not sure if disable has any effect. If you think about it, disabled plugin is still ready to use and all tables are kept in database.

[theinvisible]

Ok. I was just testing what changes each plugins make to my site. Because the description of some plugins is too less.

So what are u suggesting? I already disabled them all and checked. Now what? Uninstall them?

[Aficionado]

Just back up with Cpanel phpadmin.

Also installing all kind of plugins in your live system is crazy. Make a local dev system and do all your tests.

Also Enable Osclas debug and check the logs.

And do a plan.