https://www.icyphoenix.com/viewtopic.php?f=35&t=5419
-----------------------------------
chowhan1234
Fri 06 Feb, 2009 21:34

Fatal Error: Allowed Memory Size Of 12582912 Bytes Exhausted
-----------------------------------
hi i have this error with my website plz can someone help me to find out what is happening. i need  yoour help to fix it.

thanks



Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'chowhan'@'boscgi1604.eigbox.net' (using password: YES) in /hermes/bosweb/web194/b1944/d5.chowhan/public_html/torrent-informatica.com/descargas-gratis/includes/db/mysql4.php on line 53

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /hermes/bosweb/web194/b1944/d5.chowhan/public_html/torrent-informatica.com/descargas-gratis/includes/db/mysql4.php on line 683

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /hermes/bosweb/web194/b1944/d5.chowhan/public_html/torrent-informatica.com/descargas-gratis/includes/db/mysql4.php on line 684
Critical Error

Could not connect to the database

tiny link to my web forum



http://tinyurl.com/bed3et


-----------------------------------
DWho
Fri 06 Feb, 2009 21:58

Re: Error  Plz Help
-----------------------------------
your config file does not have the right database name or password or both...


-----------------------------------
chowhan1234
Sat 07 Feb, 2009 20:58

Re: Error  'read Int(1) DEFAULT '0' NOT NULL,
-----------------------------------
[quote user="DWho" post="36402"]your config file does not have the right database name or password or both...[/quote]

i have correct info in that file.


i have tried to recreate the database but now i get this error when i restore the database from my last backup.




Error

SQL query:

CREATE TABLE ip_force_read_users(
user varchar( 255 ) DEFAULT '' NOT NULL ,
READ int( 1 ) DEFAULT '0' NOT NULL ,
time int( 10 ) DEFAULT '0' NOT NULL
);

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'read int(1) DEFAULT '0' NOT NULL,
   time int(10) DEFAULT '0' NOT NULL
)' at line 3


-----------------------------------
Chaotic
Sat 07 Feb, 2009 21:02

Re: Error  Plz Help
-----------------------------------
Would you mind please editing your topic title to be more specific of your problem?  "Error Plz Help" isn't helping anyone notice your problem on viewforum.

Thanks


-----------------------------------
spydie
Sat 07 Feb, 2009 21:03

Re: Error  Plz Help
-----------------------------------
what version do you use ??

ip 1.2.0.27c or the new beta

your site is throughing this error right
[spoiler]Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'chowhan'@'boscgi1602.eigbox.net' (using password: YES) in /hermes/bosweb/web194/b1944/d5.chowhan/public_html/torrent-informatica.com/descargas-gratis/includes/db/mysql4.php on line 53

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /hermes/bosweb/web194/b1944/d5.chowhan/public_html/torrent-informatica.com/descargas-gratis/includes/db/mysql4.php on line 683

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /hermes/bosweb/web194/b1944/d5.chowhan/public_html/torrent-informatica.com/descargas-gratis/includes/db/mysql4.php on line 684
Critical Error

Could not connect to the database[/spoiler]


-----------------------------------
chowhan1234
Mon 09 Feb, 2009 18:39

Re: Error  Plz Help
-----------------------------------
i have reInstall IP and wheni want to restore my database i have this error from ACP .


Fatal error: Allowed memory size of 12582912 bytes exhausted (tried to allocate 1045937 bytes) in /hermes/bosweb/web194/b1944/d5.chowhan/public_html/torrent-informatica.com/descargas-gratis/includes/sql_parse.php on line 71



and restoring From PHPmyadmin i have this error.

Error

SQL query:

/*!40000 ALTER TABLE `ip_kb_categories` ENABLE KEYS */;

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ';
CREATE TABLE `ip_kb_config` (
  `config_name` varchar(255) NOT NULL default ''' at line 4


-----------------------------------
spydie
Mon 09 Feb, 2009 21:53

Re: Fatal Error: Allowed Memory Size Of 12582912 Bytes Exhausted
-----------------------------------
looks like your data base is overloaded.

do you know what max size does your hosting allow ?


-----------------------------------
Limun
Mon 09 Feb, 2009 22:00

Re: Fatal Error: Allowed Memory Size Of 12582912 Bytes Exhausted
-----------------------------------
wait a second....

forghet for now error you get (exept the error Allowed memory size of 12582912) 
when you restore from acp is it sucesfuly restored ?


-----------------------------------
spydie
Mon 09 Feb, 2009 22:10

Re: Fatal Error: Allowed Memory Size Of 12582912 Bytes Exhausted
-----------------------------------
thats correct Limun.

first thing is does IP restore DB correctly.

but on the other site it looks like he made a few posts and uploads on his site and DB went in the shitter.

since most hostings dont allow more then 2 MB uploads in DB. if he used parfield. if he uses adv downloads he can upload with ftp.

and that goes only by name through DB. that means the file isnt stored in the DB. Its stored in a folder of IP.


-----------------------------------
novice programmer
Mon 09 Feb, 2009 22:27

Re: Fatal Error: Allowed Memory Size Of 12582912 Bytes Exhausted
-----------------------------------
Use a memory_init(32M); fuction on config.php file

Look at:

http://www.icyphoenix.com/viewtopic.php?f=4&t=4713

and:

http://www.icyphoenix.com/viewtopic.php?f=4&t=2682


