Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 01-16-2005, 02:01 PM
Borgs8472 Borgs8472 is offline
 
Join Date: Apr 2004
Posts: 924
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Grrr... what's gone wrong? Post server move loads of posts missing!

Hey all, I just moved my board, www.wordforge.net to it's new home at http://okinawa.globat.com/~wordforge.net/forum/ which I will soon update the DNS for.

However many of my threads have gone missing! Arghh!

An example:
http://okinawa.globat.com/~wordforge...ad.php?t=14717

Attempting to reply to this 'empty' thread returns:

PHP Code:
Database error in vBulletin 3.0.1:

Invalid SQL
            
INSERT INTO post
                
(threadidparentidtitleusernameuseriddatelinepagetextallowsmilie,
                 
showsignatureipaddressiconidvisibleattach)
            
VALUES
                
(14717, , 'Re: Had a dream with garamet in it.',
                 
'Borgs'81105891173,
                 
'd'11,
                 
'edit - blerr'010)
        
mysql errorYou have an error in your SQL syntaxcheck the manual that corresponds to your MySQL server version for the right syntax to use near ' 'ReHad a dream with garamet in it.',
                 '
Borgs', 8, 1105891173,
                 '
d', 1' at line 5

mysql error number
1064

Date
Sunday 16th of January 2005 07:59:33 AM
Script
http://okinawa.globat.com/~wordforge.net/forum/newreply.php
Refererhttp://okinawa.globat.com/~wordforge.net/forum/showthread.php?t=14717
UsernameBorgs
IP Address
editblerr 
Did I not move over the post content or is the post indexing messed up? I don't know!

Please could someone help, there's ?10 for someone who can help me* within 24 hours.

( * Help me is defined as either tweaking my database to get it to work, or transferring from the old database better for things to work )
Reply With Quote
  #2  
Old 01-16-2005, 02:19 PM
Borgs8472 Borgs8472 is offline
 
Join Date: Apr 2004
Posts: 924
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

To clarify, though I DID turn the board off before downloading the data and uploading it, it seems that all posts from about 12 hours were lost, through empty threads remain.

Does this mean I don't have the end of the 'post' table installed maybe?
Reply With Quote
  #3  
Old 01-16-2005, 02:24 PM
Borgs8472 Borgs8472 is offline
 
Join Date: Apr 2004
Posts: 924
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

My webhost people missed one of my SQL files! I fixed it! Sorry guys!
Reply With Quote
  #4  
Old 01-16-2005, 02:51 PM
Deaths Deaths is offline
 
Join Date: Oct 2004
Location: Europe, Belgium
Posts: 679
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Edit your post and remove your IP adress ...
Reply With Quote
  #5  
Old 01-16-2005, 04:13 PM
Zachery's Avatar
Zachery Zachery is offline
 
Join Date: Jul 2002
Location: Ontario, Canada
Posts: 11,440
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Just for refernce, global is a horrid host at best.
Reply With Quote
  #6  
Old 01-16-2005, 04:22 PM
Borgs8472 Borgs8472 is offline
 
Join Date: Apr 2004
Posts: 924
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

*sob*
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 05:52 PM.


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.03945 seconds
  • Memory Usage 2,217KB
  • 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)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (6)post_thanks_box
  • (6)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (6)post_thanks_postbit_info
  • (6)postbit
  • (6)postbit_onlinestatus
  • (6)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