Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 10-15-2011, 10:29 PM
Booyakan Booyakan is offline
 
Join Date: Jan 2007
Posts: 100
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default error in your SQL syntax

I am trying to import a database.sql file into another new database. (switching hosts)
I am receiving the error below. Can someone please help me out with what I need to change?

Error
SQL query:

INSERT INTO `filedata` (`filedataid`, `userid`, `dateline`, `thumbnail_dateline`, `filedata`, `filesize`, `filehash`, `thumbnail`, `thumbnail_filesize`, `extension`, `width`, `height`, `thumbnail_width`, `thumbnail_height`, `refcount`) VALUES (16, 21, 1302331460, 1302331460, 0x504b03041400020008007aab833ebd7c0b7d9e8b0000c4af 00000900000028313130292e6a7067 ec3a095453d7b6e7669e18420282205cc60818324120612680 c48268c401da6a4372814806cc2048 ad73f5b5b55a017d55eb8476b00eadbeaab5d55aadd6f6d5aa 38cf555bea545bad459fb69a7fee4d 0801b1ed7febf5fdf5d7e264dd9b7df6bcf739f79c9ddce33c e5bc08fc8714aa0b0142424011fc00 e725da8d82064315002525200100c000742400902184c00f40 fa032a01035089847ae0f1c840370f 09de24f81df0e16545a41e78f61c03a0b8f9df80d717f02a72 f789ef5cbda5124387d558ec165b8d a50e4d4d1203a9589caa94489452292a5128539295c962c80a c82b912e9f56923af522392bc91ef8 2270351a4276f3d2bcfd4782bafc47c2bdfd87b9e8d41147f2 e8a6ee74ebebe6b3b3b71cde041c22 9671aa12c8f123f0257a403f8d90380b66010e83c16032384c 2687cb66b1b9817e1c8e5f60308f17 c8e[...]

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>: Out of memory (allocated 63963136) (tried to allocat' at line 2
Reply With Quote
  #2  
Old 10-16-2011, 03:41 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

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 (something larger than what you currently have) 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", "xxM");

(You can view your current memory_limit in Maintenance > View PHP Info . If it's 16M, try 32M. If it's 32M, try 64M. If it's 64M, try 92M or 128M, etc.)
Reply With Quote
Reply


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 03:04 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03593 seconds
  • Memory Usage 2,164KB
  • Queries Executed 13 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (2)post_thanks_box
  • (2)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (2)post_thanks_postbit_info
  • (2)postbit
  • (2)postbit_onlinestatus
  • (2)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete