vb.org Archive - db problem ? help ?

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)

- - db problem ? help ? (https://vborg.vbsupport.ru/showthread.php?t=72621)

miz	12-07-2004 10:21 PM

db problem ? help ?

hey there, i have downloaded my old vb2 db backup inorder to to upgrade to main site to vb3

now when im tring to load my db backup on new server i get this error

Code:

ERROR 1064 at line 12292: You have an error in your SQL syntax.  Check the manua

l that corresponds to your MySQL server version for the right syntax to use near

 '<br />

<b>Fatal error</b>:  Allowed memory size of 8388608 byte

any idea how to slove it ?

Steve Machol

12-07-2004 10:23 PM

You need to increase the allowed memory size in php.ini. Here is a post that explains this:

http://www.vbulletin.com/forum/showp...77&postcount=4

miz	12-07-2004 11:41 PM

Quote:

Originally Posted by Steve Machol

You need to increase the allowed memory size in php.ini. Here is a post that explains this:

http://www.vbulletin.com/forum/showp...77&postcount=4

thanx for reply but still got the problem
this is what i got on php.ini (on windows dir)

Code:

;;;;;;;;;;;;;;;;;;;

; Resource Limits ;

;;;;;;;;;;;;;;;;;;;

max_execution_time = 30     ; Maximum execution time of each script, in seconds

max_input_time = 60        ; Maximum amount of time each script may spend parsing request data

memory_limit = 16M      ; Maximum amount of memory a script may consume (8MB)

and this is the error

Code:

ERROR 1064 at line 52631: You have an error in your SQL syntax.  Check the manua

l that corresponds to your MySQL server version for the right syntax to use near

 '<br />

<b>Fatal error</b>:  Allowed memory size of 8388608 byte

anymore ideas ?

Steve Machol

12-08-2004 02:58 AM

You need to restart Apache after making the change to php.ini. The new settings won't take affect until you do.

miz	12-08-2004 10:07 AM

Quote:

Originally Posted by Steve Machol

You need to restart Apache after making the change to php.ini. The new settings won't take affect until you do.

i know i read about it on the post so i did

net stop apache2
net start apache2

but still problem stays...

miz	12-08-2004 10:46 AM

ok i have found the problem :P

problem is on my crapy host its didnt allowed me to download all in 1 time :P

so im downloading all in few times

i opened the sql file (all apps were stuck even zend - used ultraedit - so if you need to edit big files use only this app)

and found at the end the error !!

any way, thanx for helping mate :P

All times are GMT. The time now is 11:08 AM.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01647 seconds Memory Usage 1,723KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_code_printable (2)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (6)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: