Go Back   vb.org Archive > vBulletin 4 Discussion > vB4 Programming Discussions
  #1  
Old 10-01-2010, 04:01 AM
dznmods dznmods is offline
 
Join Date: Sep 2010
Posts: 17
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default error im trying to upgrade from vb3.8.0 to vb4.0.7 and this is what error say i need

Step 4) Import latest style

Importing vbulletin-style.xml

Database error
The DZN Mods Forums database has encountered a problem.
Please try the following:
Load the page again by clicking the Refresh button in your web browser.
Open the http://www.dznmods.net home page, then try to open another page.
Click the Back button to try another link.
The http://www.dznmods.net forum technical staff have been notified of the error, though you may contact them if the problem persists.

We apologise for any inconvenience.
danny
Sep 30th '10 02:35am
Database error in vBulletin 3.8.0:

Invalid SQL:

REPLACE INTO stylevardfn
(stylevarid, styleid, stylevargroup, product, datatype, validation, failsafe)
VALUES
('albumedit_blockrow_border', -1, 'Album', 'vbulletin', 'border', '', ''),('albumedit_maineditor_background', -1, 'Album', 'vbulletin', 'background', '', ''),('albumedit_maineditor_border', -1, 'Album', 'vbulletin', 'border', '', ''),('albumedit_maineditor_width', -1, 'Album', 'vbulletin', 'size', '', ''),('albumedit_thumbnailedit_width', -1, 'Album', 'vbulletin', 'size', '', ''),('albumlist_blockbody_background', -1, 'Album', 'vbulletin', 'background', '', ''),('albumlist_entry_background', -1, 'Album', 'vbulletin', 'background', '', ''),('albumlist_entry_border', -1, 'Album', 'vbulletin', 'border', '', ''),('albumlist_entry_width', -1, 'Album', 'vbulletin', 'size', '', ''),('albumlist_image_shadow_color', -1, 'Album', 'vbulletin', 'color', '', ''),('albumtop_background', -1, 'Album', 'vbulletin', 'background', '', ''),('albumtop_border', -1, 'Album', 'vbulletin', 'border', '', ''),('albumtop_font_size', -1, 'Album', 'vbulletin', 'size', '', ''),('albumtop_list_a_color', -1, 'Album', 'vbulletin', 'color', '', ''),('albumtop_list_a_hover_color', -1, 'Album', 'vbulletin', 'color', '', ''),('albumtop_margin', -1, 'Album', 'vbulletin', 'size', '', ''),('album_content_width', -1, 'Album', 'vbulletin', 'size', '', ''),('picturelink_img_shadow_color', -1, 'Album', 'vbulletin', 'color', '', ''),('picturelink_margin', -1, 'Album', 'vbulletin', 'size', '', '');

MySQL Error : Table 'forumdznmods.stylevardfn' doesn't exist
Error Number : 1146
Request Date : Wednesday, September 29th 2010 @ 11:21:29 PM
Error Date : Wednesday, September 29th 2010 @ 11:21:29 PM
Script : http://www.dznmods.net/install/final...p=4&startat=60
Referrer : http://www.dznmods.net/install/final...p=4&startat=50
IP Address : 75.108.189.42
Username :
Classname : vB_Database
MySQL Version : 5.0.91-log
Reply With Quote
  #2  
Old 10-01-2010, 02:06 PM
Lynne's Avatar
Lynne Lynne is offline
 
Join Date: Sep 2004
Location: California/Idaho
Posts: 41,180
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Did you have any previous errors during the upgrade? That table should have been created. You can get the information for creating it in the install/mysql-schema.php file.
Reply With Quote
  #3  
Old 10-03-2010, 02:11 AM
Videx's Avatar
Videx Videx is offline
 
Join Date: Feb 2007
Posts: 3,085
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Personally, I just very carefully uninstalled all my old mods (including uploaded files) and styles before updating. Nothing but trouble.
Reply With Quote
Reply

Thread Tools
Display Modes

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 02:12 PM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.03702 seconds
  • Memory Usage 2,171KB
  • Queries Executed 11 (?)
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
  • (3)post_thanks_box
  • (3)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (3)post_thanks_postbit_info
  • (3)postbit
  • (3)postbit_onlinestatus
  • (3)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