Change from MyISAM to InnoDB
After I make changes in sql file from MyISAM to InnoDB i receive that error.
This is what i change : https://github.com/Shadowss/TravianZ...22ef82fa0b15fc
Like @InCube says
PHP Code:
[24-Feb-2016 09:47:26 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 32 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 09:47:29 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 72 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 09:47:31 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 72 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 09:47:32 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 72 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 09:47:39 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 80 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 09:48:06 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 128 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 09:48:07 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 128 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 09:49:02 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 4 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 09:49:03 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 128 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 09:49:53 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 128 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 09:51:25 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 4 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 09:51:26 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 128 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 09:53:17 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 4 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 09:58:40 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 77 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 09:58:41 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 128 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 10:00:59 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 4 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 10:05:19 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 4 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 10:10:31 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 4 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 10:10:32 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 128 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 10:11:35 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 4 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 10:11:37 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 128 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 10:11:38 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 128 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
Memory limit is to 128M
On that line is : while($row = mysql_fetch_assoc($result)) {
PHP Code:
/***************************
Function to process MYSQLi->fetch_all (Only exist in MYSQL)
References: Result
***************************/
function mysql_fetch_all($result) {
$all = array();
if($result) {
while($row = mysql_fetch_assoc($result)) {
$all[] = $row;
}
return $all;
}
}
function query_return($q) {
$result = mysql_query($q, $this->connection);
return $this->mysql_fetch_all($result);
}
Anyone any idea ? @ronix ?
Re: Change from MyISAM to InnoDB
Quote:
Originally Posted by
cata7007
After I make changes in sql file from MyISAM to InnoDB i receive that error.
This is what i change :
https://github.com/Shadowss/TravianZ...22ef82fa0b15fc
Like @
InCube says
PHP Code:
[24-Feb-2016 09:47:26 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 32 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 09:47:29 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 72 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 09:47:31 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 72 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 09:47:32 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 72 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 09:47:39 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 80 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 09:48:06 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 128 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 09:48:07 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 128 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 09:49:02 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 4 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 09:49:03 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 128 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 09:49:53 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 128 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 09:51:25 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 4 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 09:51:26 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 128 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 09:53:17 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 4 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 09:58:40 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 77 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 09:58:41 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 128 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 10:00:59 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 4 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 10:05:19 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 4 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 10:10:31 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 4 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 10:10:32 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 128 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 10:11:35 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 4 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 10:11:37 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 128 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
[24-Feb-2016 10:11:38 Europe/Bucharest] PHP Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 128 bytes) in /home/outlet/public_html/shadowss.ro/travian2/GameEngine/Database/db_MYSQL.php on line 3023
Memory limit is to 128M
On that line is : while($row = mysql_fetch_assoc($result)) {
PHP Code:
/***************************
Function to process MYSQLi->fetch_all (Only exist in MYSQL)
References: Result
***************************/
function mysql_fetch_all($result) {
$all = array();
if($result) {
while($row = mysql_fetch_assoc($result)) {
$all[] = $row;
}
return $all;
}
}
function query_return($q) {
$result = mysql_query($q, $this->connection);
return $this->mysql_fetch_all($result);
}
Anyone any idea ? @
ronix ?
Stop getting so many data at once.
And use this:
https://github.com/laravel/framework...ilder.php#L337
Documentation:
https://laravel.com/docs/5.1/queries "Chunking Results From A Table"
Re: Change from MyISAM to InnoDB
If you don`t want to help just say :)
I receive blank page. Anyone ?
Re: Change from MyISAM to InnoDB
Just use xDebug and trace back the error dude. What you post is completely useless to understand.
