{"id":63,"date":"2006-06-09T01:17:02","date_gmt":"2006-06-09T07:17:02","guid":{"rendered":"http:\/\/thepizzy.net\/blog\/?p=63"},"modified":"2011-02-24T10:05:30","modified_gmt":"2011-02-24T16:05:30","slug":"update-tsnx-database-movement","status":"publish","type":"post","link":"https:\/\/thepizzy.net\/blog\/2006\/06\/update-tsnx-database-movement\/","title":{"rendered":"Update: tsnX Database Movement"},"content":{"rendered":"

\"\"I’m backing up the tsnX.3 Beta’s Database (with the posts, forums, and accounts) and going to start moving the tsnV database into the tsnX site. The site is going to be down for a bit, while I do this, and iron out the kinks of auth-access, and conversions. If things don’t go properly after a bit, I’ll restore the tsnX.3 database, and continue working on converting tsnV to tsnX again. There are some things that I can’t test just by looking at the SQL Code, and that I have to implement for it to be tested.<\/p>\n

So check the pizzy for updates if the forums aren’t working. If, in the meantime, the server goes down for some reason, and you can’t get to thepizzy or tsn, then go to http:\/\/tsnblog.blogspot.com to fing out why.<\/p>\n","protected":false},"excerpt":{"rendered":"

I’m backing up the tsnX.3 Beta’s Database (with the posts, forums, and accounts) and going to start moving the tsnV database into the tsnX site. The site is going to be down for a bit, while I do this, and iron out the kinks of auth-access, and conversions. If things don’t go properly after a […]<\/p>\n","protected":false},"author":1,"featured_media":1181,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[11,3,9,347,2],"tags":[449,214,454,207,350,453,121,209,292,452,359,361,355,441],"class_list":["post-63","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-projects","category-tech","category-the-spot-net","category-the-spot-network","category-updates","tag-beta","tag-code","tag-conversions","tag-database","tag-forums","tag-pizzy","tag-server","tag-site","tag-sql","tag-sql-code","tag-tsn","tag-tsnv","tag-tsnx","tag-update"],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/thepizzy.net\/blog\/wp-content\/uploads\/2008\/04\/Untitled-2.png?fit=400%2C400&ssl=1","jetpack_likes_enabled":false,"jetpack_shortlink":"https:\/\/wp.me\/prOO4-11","jetpack-related-posts":[{"id":61,"url":"https:\/\/thepizzy.net\/blog\/2006\/06\/update-tsnx-coding-100\/","url_meta":{"origin":63,"position":0},"title":"Update: tsnX Coding @ 100%","author":"[[Neo]]","date":"June 3, 2006","format":false,"excerpt":"Well, I finished updating the basic forums to work with what I want and what people expect in the-spot.net. It's taken about a month and a half, with some restarts in coding, and lots of frustration and a couple feature scale-backs. What's next on the list, is debugging some of\u2026","rel":"","context":"In "Projects"","block_context":{"text":"Projects","link":"https:\/\/thepizzy.net\/blog\/category\/projects\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/thepizzy.net\/blog\/wp-content\/uploads\/2008\/04\/Untitled-2.png?fit=400%2C400&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":62,"url":"https:\/\/thepizzy.net\/blog\/2006\/06\/update-tsnx-database-conversion-50\/","url_meta":{"origin":63,"position":1},"title":"Update: tsnX Database Conversion @ 50%","author":"[[Neo]]","date":"June 6, 2006","format":false,"excerpt":"Ok, so I'm converting the tsnV database into one that will work with the tsnX database structure. What this will do is bring our posts, user accounts, and forums over from the old site and make it work with the mods and settings of the new site. It's something I\u2026","rel":"","context":"In "Projects"","block_context":{"text":"Projects","link":"https:\/\/thepizzy.net\/blog\/category\/projects\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/thepizzy.net\/blog\/wp-content\/uploads\/2008\/04\/Untitled-2.png?fit=400%2C400&ssl=1&resize=350%2C200","width":350,"height":200},"classes":[]},{"id":52,"url":"https:\/\/thepizzy.net\/blog\/2006\/05\/update-tsnx-good-newsbad-news\/","url_meta":{"origin":63,"position":2},"title":"Update: tsnX – Good News\/Bad News","author":"[[Neo]]","date":"May 14, 2006","format":false,"excerpt":"Good News: I'm going to be making progress starting tomorrow with the site coding and design. Bad News: I'm going to be making progress by starting over with the whole thing. The reason: I cannot figure out where the code errors are, and the updates that I did to the\u2026","rel":"","context":"In "Technology"","block_context":{"text":"Technology","link":"https:\/\/thepizzy.net\/blog\/category\/tech\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":23,"url":"https:\/\/thepizzy.net\/blog\/2006\/04\/tsnxhere-we-go\/","url_meta":{"origin":63,"position":3},"title":"tsnX…here we go…","author":"[[Neo]]","date":"April 4, 2006","format":false,"excerpt":"So the start of tsnX has become necessary sooner than expected. I wouldn't be so distraught if it was during a time when there WAS time to be creating a new site, and that this new site was not time-critical in its creation. Because not only do I now have\u2026","rel":"","context":"In "Technology"","block_context":{"text":"Technology","link":"https:\/\/thepizzy.net\/blog\/category\/tech\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":30,"url":"https:\/\/thepizzy.net\/blog\/2006\/04\/update-tsnx-sub-forums-100-complete\/","url_meta":{"origin":63,"position":4},"title":"Update: tsnX – Sub-forums @ 100% complete","author":"[[Neo]]","date":"April 7, 2006","format":false,"excerpt":"Ok, I thought I Was going to have a bit of a problem there for most of the night. I couldn't get the actual forums to show up properly on the page when I thought I had finished everything up. I actually did things right, but I uploaded some files\u2026","rel":"","context":"In "Technology"","block_context":{"text":"Technology","link":"https:\/\/thepizzy.net\/blog\/category\/tech\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":35,"url":"https:\/\/thepizzy.net\/blog\/2006\/04\/update-tsnx-beta-release-information-upgrade-to-2020-100\/","url_meta":{"origin":63,"position":5},"title":"Update: tsnX – Beta Release information, Upgrade to 2.0.20 @ 100%","author":"[[Neo]]","date":"April 11, 2006","format":false,"excerpt":"Well, I updated the files necessary for the .19 to .20 switch, but for some reason, the page still says that I am running .19. So I will have to go edit the database to get it to show the proper version, and then all will be well - and\u2026","rel":"","context":"In "Technology"","block_context":{"text":"Technology","link":"https:\/\/thepizzy.net\/blog\/category\/tech\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/posts\/63","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/comments?post=63"}],"version-history":[{"count":5,"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/posts\/63\/revisions"}],"predecessor-version":[{"id":1218,"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/posts\/63\/revisions\/1218"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/media\/1181"}],"wp:attachment":[{"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/media?parent=63"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/categories?post=63"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/thepizzy.net\/blog\/wp-json\/wp\/v2\/tags?post=63"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}