vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Error in the upgrade procedure vb2.3.0 to vb3 RC3 (https://vborg.vbsupport.ru/showthread.php?t=61067)

TheLab 02-02-2004 10:56 AM
Error in the upgrade procedure vb2.3.0 to vb3 RC3
 
I get this at the 9 step:

Quote:
Step 9) Alter User Table (part 2)

Altering User Table (1 of 5)
Altering User Table (2 of 5)
Altering User Table (3 of 5)
Altering User Table (4 of 5)
Altering User Table (5 of 5)
Converting Birthdays to New Format
Inserting administrator permissions into Administrator table


There seems to have been a slight problem with the database.
Please try again by pressing the refresh button in your browser.

An E-Mail has been dispatched to our Technical Staff, who you can also contact if the problem persists.

We apologise for any inconvenience.
and the source says:
Quote:
Database error in vBulletin :

Invalid SQL:
INSERT INTO administrator (userid, adminpermissions)
SELECT user.userid, 65532
FROM user INNER JOIN usergroup USING(usergroupid)
WHERE usergroup.cancontrolpanel = 1

mysql error: Duplicate entry '1' for key 1

mysql error number: 1062

Date: Monday 02nd of February 2004 11:38:42 AM
Script: http://localhost/install/upgrade1.php?step=9
Referer: http://localhost/install/upgrade1.php?step=8
IP Address: 127.0.0.1
-->
What should i do?

allan grossman 02-02-2004 12:17 PM
I'd head over to

http://www.vbulletin.com/forum/forumdisplay.php?f=59

and ask the question there. That's the vB3 troubleshooting forum ;)

I've upgraded vB 2.3.0 boards to RC3 several times. The first time I had an error at step 16, but after repairing the database and running most all the maintenance options in the admin cp the next attempt worked without an error.

Also, vBulletin released a tool to see if your database was compatible with vB3 - it might be worth running ;)

YMMV, but I'd repair the database, and run all the appropriate maintenance options through vB's admin cp. A clean database is liable to convert a little easier ;)

TheLab 02-02-2004 12:31 PM
Before i upgrade, had already run the maintenance scripts so it must be something else.

Thanx anyway :)


All times are GMT. The time now is 07:07 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.01006 seconds
  • Memory Usage 1,717KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (3)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.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/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.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
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete