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 02-15-2008, 06:37 PM
laserterd laserterd is offline
 
Join Date: Oct 2007
Posts: 30
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Upgrading to 3.7

Hey so i thought i would give upgrading to 3.7 a try, and i uploaded all the files, renamed config.php.new to config.php, and then opened it up in a text editor. I think i filled out the correct variables, then when i went to www.myforumsurl.com/install/upgrade.php i got this warning:

PHP Code:
Database error in vBulletin :

Invalid SQL:

            
SELECT *
            
FROM mydatathing.secureserver.com
            WHERE title IN 
('','options','bitfields','attachmentcache','forumcache','usergroupcache','stylecache','languagecache','products','pluginlist','cron','profilefield','loadcache');

MySQL Error  You have an error in your SQL syntaxcheck the manual that corresponds to your MySQL server version for the right syntax to use near '.netdatastore
            WHERE title IN ('','
options','bitfields','attachmentcache','for' at line 2
Error Number : 1064
Date         : Friday, February 15th 2008 @ 01:25:55 PM
Script       : http://myforumsurl.com/install/upgrade.php
Referrer     : 
IP Address   : my.IP.adress
Username     : 
Classname    : vb_database 
If anyone could help me with this thatd be great! Im kind of worried because right now im in the between world, i dont know how to get back to 3.6.8 and i cannot get to 3.7

So what should i do? I wouldnt mind downgrading to 3.6.8 for the time being until i figure it out, but right now any forum is better then none, my users are probably worried! :erm:

Thanks
Reply With Quote
  #2  
Old 02-15-2008, 06:38 PM
SCRIPT3R SCRIPT3R is offline
 
Join Date: Jan 2005
Posts: 1,303
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Nm...
Reply With Quote
  #3  
Old 02-15-2008, 06:49 PM
laserterd laserterd is offline
 
Join Date: Oct 2007
Posts: 30
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

what
Reply With Quote
  #4  
Old 02-15-2008, 06:54 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

I don't even see a "netdatastore" in the statement.

I would check your config file and make sure you have everything related to your database correct - like the table prefix.
Reply With Quote
  #5  
Old 02-15-2008, 06:56 PM
laserterd laserterd is offline
 
Join Date: Oct 2007
Posts: 30
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

yes ok thank you, the table prefix was one of the things that i was a bit unsure about. how can i find this out?

--------------- Added [DATE]1203110867[/DATE] at [TIME]1203110867[/TIME] ---------------

ahh ok i seemed to have figured that part out. Now, however, it asks me to enter in my vBulletin member number, so i did, and it said "it was successful". Now, according to the directions, i am supposed to have a bunch of instructions on the screen related to upgrading the system.

But instead, i have this error:
Quote:
Your vBulletin (3.6.8) does not appear to be running the version that was downloaded (3.7.0 Beta 2).

This generally means your upgrade was not successful. Please ensure that you have uploaded the latest files and click here to try again.

If you are sure you wish to continue with this part of the upgrade, click here.
Reply With Quote
  #6  
Old 02-15-2008, 09:05 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Did you download all the files from the member area at vb.com and then upload ALL of them to your website?
Reply With Quote
  #7  
Old 02-15-2008, 09:17 PM
laserterd laserterd is offline
 
Join Date: Oct 2007
Posts: 30
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

That post prompted me to go and double check, and sure enough! I read the readme wrong, the part where it said "upload everything with the exception of install/install.php, i didnt install anything from the install folder!

So thats uploading now, and after that ill let you know if i have any more problems.

--------------- Added [DATE]1203122344[/DATE] at [TIME]1203122344[/TIME] ---------------

ok so i came up with a new problem

The first time it asked me to enter my customer number it worked, but i hadnt uploaded the install folder all the way. The second time it asked me to enter my customer number, after i uploaded the install folder, it didnt work! I type my customer number, then press "Enter upgrade system". The page reloads, but its just back at the same screen... it doesnt even say "error in logging in" or anything!

So whats the deal this time?

Thanks!
Reply With Quote
  #8  
Old 02-16-2008, 07:15 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Ensure that you are using the files belonging to that customernumber.
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: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.03859 seconds
  • Memory Usage 2,233KB
  • 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)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (8)post_thanks_box
  • (8)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (8)post_thanks_postbit_info
  • (8)postbit
  • (8)postbit_onlinestatus
  • (8)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_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