You are not logged in. [Log In] UBB.threads PHP Forum Software Community » Forums » UBB.threads 7 Discussion » Version 7 Installation Assistance » Beta 7.3 SQL Instal Issue
Register User    Portal Page     Forum List        Calendar     Active Topics     Search     FAQ
Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
2 registered (driv, Outdoorking), 40 Guests and 14 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 11/22/06
Posts: 163
Top Posters (30 Days)
Ruben 51
DennyP 24
Gizmo 24
Dunny 15
SteveS 14
AllenAyres 12
dbremer 10
SD 10
drkknght00 9
doug 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Page 1 of 4 1 2 3 4 >
Topic Options
#206410 - 02/15/08 12:16 AM Beta 7.3 SQL Instal Issue
AshtarRose Offline
journeyman 		Registered: 09/01/07
Posts: 64
Loc: Concord, NC
Code:
Duplicate entry '1' for key 1Duplicate entry '2' for key 1Duplicate entry '3' for key 1You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',0,,0,0,0,1,1,0,1,,0,0)' at line 4You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0,,0,0,0,0,0,0,0,1,0,0,0,0,0,0)' at line 4Duplicate entry '6' for key 1Duplicate entry '7' for key 1Duplicate entry '8' for key 1Duplicate entry '9' for key 1Duplicate entry '10' for key 1Duplicate entry '11' for key 1Duplicate entry '12' for key 1Duplicate entry '13' for key 1Duplicate entry '14' for key 1Duplicate entry '15' for key 1Duplicate entry '16' for key 1Duplicate entry '17' for key 1Duplicate entry '18' for key 1Duplicate entry '19' for key 1Duplicate entry '20' for key 1Duplicate entry '21' for key 1Duplicate entry '22' for key 1Duplicate entry '23' for key 1Duplicate entry '24' for key 1Duplicate entry '25' for key 1Duplicate entry '26' for key 1Duplicate entry '27' for key 1Duplicate entry '28' for key 1Duplicate entry '29' for key 1Duplicate entry '30' for key 1Duplicate entry '31' for key 1Duplicate entry '32' for key 1Duplicate entry '33' for key 1Duplicate entry '34' for key 1Duplicate entry '35' for key 1Duplicate entry '36' for key 1Duplicate entry '37' for key 1Duplicate entry '38' for key 1Duplicate entry '39' for key 1Duplicate entry '40' for key 1Duplicate entry '41' for key 1Duplicate entry '42' for key 1Duplicate entry '43' for key 1Duplicate entry '44' for key 1Duplicate entry '45' for key 1Duplicate entry '46' for key 1Duplicate entry '47' for key 1Duplicate entry '48' for key 1Duplicate entry '49' for key 1Duplicate entry '50' for key 1Duplicate entry '51' for key 1Duplicate entry '52' for key 1

Updating step to 15 ....	OK
Inserting default Site Permissions	OK
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (1,1,1,1,1,1,10000,100,1,500,1,1,0,1,1,1,1,0,1,1)
 	Reason for failure:	Duplicate entry '1' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (2,1,1,1,1,1,10000,100,1,500,1,1,0,1,1,0,1,0,0,0)
 	Reason for failure:	Duplicate entry '2' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (3,1,1,1,1,1,10000,100,1,500,1,1,0,1,1,0,1,0,1,0)
 	Reason for failure:	Duplicate entry '3' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (4,0,0,1,0,1,,,0,,0,0,0,1,1,0,1,,0,0)
 	Reason for failure:	You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ',0,,0,0,0,1,1,0,1,,0,0)' at line 4
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (5,0,0,,0,,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '0,,0,0,0,0,0,0,0,1,0,0,0,0,0,0)' at line 4
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (6,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '6' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (7,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '7' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (8,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '8' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (9,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '9' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (10,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '10' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (11,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '11' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (12,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '12' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (13,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '13' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (14,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '14' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (15,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '15' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (16,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '16' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (17,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '17' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (18,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '18' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (19,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '19' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (20,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '20' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (21,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '21' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (22,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '22' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (23,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '23' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (24,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '24' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (25,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '25' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (26,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '26' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (27,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '27' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (28,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '28' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (29,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '29' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (30,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '30' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (31,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '31' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (32,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '32' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (33,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '33' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (34,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '34' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (35,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '35' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (36,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '36' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (37,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '37' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (38,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '38' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (39,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '39' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (40,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '40' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (41,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '41' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (42,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '42' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (43,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '43' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (44,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '44' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (45,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '45' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (46,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '46' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (47,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '47' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (48,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '48' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (49,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '49' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (50,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '50' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (51,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '51' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
 	SQL Query:	 insert into ubbt_SITE_PERMISSIONS (GROUP_ID,SIGNATURE_IMAGES,MEMBER_LIST,MEMBER_PROFILES,MAIL_POST,POLL_VOTE,PM_TOTAL,PM_INVITES,CALENDAR_EVENTS,SIGNATURE_LENGTH,REMOTE_AVATARS,STOCK_AVATARS,UPLOAD_AVATARS,CAN_SEE_SHOUTS,CAN_SHOUT,ANNOUNCEMENTS,CAN_SEARCH,SEARCH_THROTTLE,CUSTOM_TITLE,EXT_INFO) values (52,0,0,0,0,0,0,0,0,0,0,0,0,1,0,0,0,0,0,0)
 	Reason for failure:	Duplicate entry '52' for key 1
 	Upgrade Step:	/install/upgrade.php?step=altertable
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#206422 - 02/15/08 04:41 AM Re: Beta 7.3 SQL Instal Issue [Re: AshtarRose]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
What version are you upgrading from?
Top
#206429 - 02/15/08 06:43 AM Re: Beta 7.3 SQL Instal Issue [Re: Ian]
Gizmo Offline

Registered: 06/05/06
Posts: 14995
Loc: Portland, OR; USA
She's upgrading from 7.2.2 (she's one of my clients, I referred her to post it here), the upgrade goes perfectly until it gets to the altertable step.
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#206434 - 02/15/08 08:09 AM Re: Beta 7.3 SQL Instal Issue [Re: Gizmo]
gliderdad Offline
Registered: 06/08/06
Posts: 1466
Loc: NY
Same for me. If you go to the forums this is what you get

Code:
We encountered a problem. The reason reported was

Script: /home/glidercentral/public_html/test/libs/user.inc.php
Line#: 434
SQL Error: Unknown column 't2.USER_SHOW_LEFT_MYSTUFF' in 'field list'
SQL Error #: 1054
Query: SELECT t2.USER_TIME_OFFSET,t2.USER_TOPIC_VIEW_TYPE,t2.USER_TIME_FORMAT, t1.USER_ID, t1.USER_DISPLAY_NAME, t1.USER_PASSWORD, t1.USER_SESSION_ID, t1.USER_MEMBERSHIP_LEVEL, t1.USER_IS_BANNED,t1.USER_RULES_ACCEPTED, t1.USER_IS_UNDERAGE, t2.USER_TOTAL_PM, t2.USER_STYLE, t2.USER_HIDE_LEFT_COLUMN,t2.USER_HIDE_RIGHT_COLUMN, t2.USER_LANGUAGE, t2.USER_MOOD, t2.USER_RELATIVE_TIME, t2.USER_TIME_OFFSET,t2.USER_SHOW_ALL_GRAEMLINS, t2.USER_AVATAR, t2.USER_TITLE, t2.USER_CUSTOM_TITLE, t2.USER_NAME_COLOR, t2.USER_SHOW_LEFT_MYSTUFF FROM ubbt_USERS as t1, ubbt_USER_PROFILE as t2 WHERE t1.USER_ID = 797 AND t1.USER_ID = t2.USER_ID
Top
#206435 - 02/15/08 08:26 AM Re: Beta 7.3 SQL Instal Issue [Re: gliderdad]
Gizmo Offline

Registered: 06/05/06
Posts: 14995
Loc: Portland, OR; USA
Yeh, the error is simply telling you that the altertable hasn't been run.
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#206436 - 02/15/08 08:26 AM Re: Beta 7.3 SQL Instal Issue [Re: Gizmo]
Gizmo Offline

Registered: 06/05/06
Posts: 14995
Loc: Portland, OR; USA
(Go figure that my two clients that test it get the same error? lol...)
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#206437 - 02/15/08 08:28 AM Re: Beta 7.3 SQL Instal Issue [Re: Gizmo]
gliderdad Offline
Registered: 06/08/06
Posts: 1466
Loc: NY
Yea, just figured I'd throw it in. Extra info never hurts much wink Everything was going pretty good for me too until this.
Top
#206447 - 02/15/08 11:06 AM Re: Beta 7.3 SQL Instal Issue [Re: gliderdad]
Rick Offline
Post-a-holic 		Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Hopefully, both of you have done this on a test site smile If so, then if you can setup a fresh test site again and I can get ftp and forum login info I can take a look.

glider, did you get the same duplicate key issues? Basically, if it's stopping there, there are a bunch of altertable steps left to be run. It almost looks like this step is being run twice for some reason.
Top
#206450 - 02/15/08 12:15 PM Re: Beta 7.3 SQL Instal Issue [Re: Rick]
gliderdad Offline
Registered: 06/08/06
Posts: 1466
Loc: NY
Yes this is done on a test site. I actually just installed the test site and started off by installing a fresh 7.2 first so I could go through and see how the upgrade would be. And yes I did get the same duplicate error on step 15 as posted above. Will send you info shortly wink
Top
#206452 - 02/15/08 12:24 PM Re: Beta 7.3 SQL Instal Issue [Re: gliderdad]
Rick Offline
Post-a-holic 		Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Ok, great. If you can setup a 7.2 install like you did before prior to the 7.3 upgrade, then I'll walk through the upgrade and see what I can find.
Top
Page 1 of 4 1 2 3 4 >



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Due Date Calculator-Calculate When Your Baby is Due
by StewartMyduedate
Today at 12:54 AM
Temporary Password email not being received
by
05/24/12 10:02 PM
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
Forum Stats
10491 Members
36 Forums
33842 Topics
181709 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image
Board Rules · Mark all read
Contact Us · UBBCentral · Top