PDA

View Full Version : You have an error in your SQL syntax


adhmwagde
02-22-2009, 04:25 PM
hi

i have problem that someone have deleted my database . so i asked my web server to give me the lasts backup's they don't have from the last 2 day's or 1 week too ..

i have old database but i meet problem when i upload i can see the tabuls are 50 ..!

and see this error .

Error
There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unknown Punctuation String @ 6
STR: />
SQL:
<br />
<b>Fatal error</b>: Allowed memory size of 33554432 bytes exhausted (tried to allocate 28313601 bytes) in <b>/home/alain/public_html/vb/includes/adminfunctions_backup.php</b> on line <b>81</b><br />



SQL query:


Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 28313601 bytes) in /home/alain/public_html/vb/includes/adminfunctions_backup.php on line 81


MySQL said:

#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 '<br />
<b>Fatal error</b>: Allowed memory size of 33554432 bytes exhausted (tri' at line 1

can someone help me :)

thanks

Lynne
02-22-2009, 05:02 PM
That error indicates that your php doesn't have enough memory allocated to complete the operation. You can either increase your memory_limit setting in php.ini to xxM or to temporarily up your limits edit your includes/config.php file and add this line right under the <?php line:

ini_set('memory_limit', xx * 1024 * 1024);

xx being the next step up in size... if you are currently set to 8MB, up it to 16. If you are set at 16, up it to 32, etc.