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
#206453 - 02/15/08 12:26 PM Re: Beta 7.3 SQL Instal Issue [Re: Rick]
AshtarRose Offline
journeyman 		Registered: 09/01/07
Posts: 64
Loc: Concord, NC
Mine however is not on a test site, but I have patience to wait to see if it can be fixed before having to reinstall the old board again.
Top
#206455 - 02/15/08 12:36 PM Re: Beta 7.3 SQL Instal Issue [Re: Rick]
gliderdad Offline
Registered: 06/08/06
Posts: 1466
Loc: NY
Sure, give me a few
Top
#206456 - 02/15/08 01:07 PM Re: Beta 7.3 SQL Instal Issue [Re: AshtarRose]
Rick Offline
Post-a-holic 		Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Originally Posted By: AshtarRose
Mine however is not on a test site, but I have patience to wait to see if it can be fixed before having to reinstall the old board again.


Since yours is live it might be a bit harder to fix. I'd need access to 2 things in order to debug. First one would be something like phpmyadmin where I can take a look at the database itself. The second, would be the admin login info to the forum.
Top
#206464 - 02/15/08 02:45 PM Re: Beta 7.3 SQL Instal Issue [Re: Rick]
AshtarRose Offline
journeyman 		Registered: 09/01/07
Posts: 64
Loc: Concord, NC
In your PM Rick
Top
#206471 - 02/15/08 03:29 PM Re: Beta 7.3 SQL Instal Issue [Re: AshtarRose]
AshtarRose Offline
journeyman 		Registered: 09/01/07
Posts: 64
Loc: Concord, NC
Rick Fixed it, yey Rick smile
Top
#206475 - 02/15/08 04:11 PM Re: Beta 7.3 SQL Instal Issue [Re: AshtarRose]
Robje01 Offline
enthusiast 		Registered: 01/19/08
Posts: 239
Loc: Netherlands - Valkenswaard
Can there be any feed-back because i have the same problem, also on a live board. But reinstalled the 7.2.2 version again and it's up and running again but i want to replace the board software tonight again with a proper fix if possible...

Rob
_________________________
My place to be: http://www.freesat.nl
Top
#206480 - 02/15/08 04:39 PM Re: Beta 7.3 SQL Instal Issue [Re: Robje01]
Rick Offline
Post-a-holic 		Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
I'm actually still trying to figure out why this is happening on some installs but not all. I'll email you a script that has a test fix in it for you to try.
Top
#206483 - 02/15/08 04:43 PM Re: Beta 7.3 SQL Instal Issue [Re: Rick]
Robje01 Offline
enthusiast 		Registered: 01/19/08
Posts: 239
Loc: Netherlands - Valkenswaard
Thanks Rick. :thumbs:
_________________________
My place to be: http://www.freesat.nl
Top
#206485 - 02/15/08 06:51 PM Re: Beta 7.3 SQL Instal Issue [Re: Robje01]
Robje01 Offline
enthusiast 		Registered: 01/19/08
Posts: 239
Loc: Netherlands - Valkenswaard
The error here is:

Script: /data/vhosts/testserver/ubbtest/libs/ubbthreads.inc.php
Line#: 628
SQL Error: Table 'dreambox.ubbt_CATEGORIES' doesn't exist
SQL Error #: 1146
Query: select CATEGORY_ID,CATEGORY_TITLE from ubbt_CATEGORIES order by CATEGORY_SORT_ORDER

This table doesn't exist, the prefix is ubbt_ and not dreambox.ubbt_
Im my config files there's nothing to find like dreambox...

I must say, there's a database existing on my server named dreambox, but no config points to that one...


Any suggestions?


Edited by Robje01 (02/15/08 06:55 PM)
_________________________
My place to be: http://www.freesat.nl
Top
#206487 - 02/15/08 07:31 PM Re: Beta 7.3 SQL Instal Issue [Re: Rick]
Gizmo Offline

Registered: 06/05/06
Posts: 14995
Loc: Portland, OR; USA
Ash's was on her live site; Glider always uses a test site (good boy, you get a cookie)
_________________________
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
#206511 - 02/15/08 11:25 PM Re: Beta 7.3 SQL Instal Issue [Re: Gizmo]
gliderdad Offline
Registered: 06/08/06
Posts: 1466
Loc: NY
yummy yummy yummy I got cookie in my tummy
Top
#206512 - 02/16/08 01:19 AM Re: Beta 7.3 SQL Instal Issue [Re: Gizmo]
AshtarRose Offline
journeyman 		Registered: 09/01/07
Posts: 64
Loc: Concord, NC
pfttt.. I live on the edge.
Top
#206515 - 02/16/08 05:02 AM Re: Beta 7.3 SQL Instal Issue [Re: AshtarRose]
Robje01 Offline
enthusiast 		Registered: 01/19/08
Posts: 239
Loc: Netherlands - Valkenswaard
Got a testforum now to get it working, but for now, with Ricks new script, it still doesn't work frown
_________________________
My place to be: http://www.freesat.nl
Top
#206524 - 02/16/08 11:25 AM Re: Beta 7.3 SQL Instal Issue [Re: Robje01]
Rick Offline
Post-a-holic 		Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Originally Posted By: Robje01
The error here is:

Script: /data/vhosts/testserver/ubbtest/libs/ubbthreads.inc.php
Line#: 628
SQL Error: Table 'dreambox.ubbt_CATEGORIES' doesn't exist
SQL Error #: 1146
Query: select CATEGORY_ID,CATEGORY_TITLE from ubbt_CATEGORIES order by CATEGORY_SORT_ORDER

This table doesn't exist, the prefix is ubbt_ and not dreambox.ubbt_
Im my config files there's nothing to find like dreambox...

I must say, there's a database existing on my server named dreambox, but no config points to that one...


Any suggestions?


dreambox.ubbt_CATEGORIES is the databasename.tablename. It's just the way PHP is generating the error. It's basically saying that the ubbt_CATEGORIES table doesn't exist in the dreambox database.

For some reason it's looking in the dreambox database. At what point does this error come up? Can you check your includes/config.inc.php to see what it has for the database information?
Top
#206527 - 02/16/08 12:30 PM Re: Beta 7.3 SQL Instal Issue [Re: Rick]
Robje01 Offline
enthusiast 		Registered: 01/19/08
Posts: 239
Loc: Netherlands - Valkenswaard
Thanks for your answer.
This shows when we just finished the upgrade to 7.3b4
There's a link to the ubbthreads.php file and this shows.
Strange enough there's nothing in the config files which includes the word dreambox.
The only database related thing i can find is that there's a database called dreambox.
It's also the first database ever made on that MySQL server and alphabetic it's the first one.
No database with A, B, C but D is dreambox.

The config.inc.php file is the same as the one in 7.2.2


Rob
_________________________
My place to be: http://www.freesat.nl
Top
#206528 - 02/16/08 12:38 PM Re: Beta 7.3 SQL Instal Issue [Re: Robje01]
Robje01 Offline
enthusiast 		Registered: 01/19/08
Posts: 239
Loc: Netherlands - Valkenswaard
If you want to, i can get you a login to MySQL and the Admin area...

Rob
_________________________
My place to be: http://www.freesat.nl
Top
#206548 - 02/16/08 04:50 PM Re: Beta 7.3 SQL Instal Issue [Re: Gizmo]
AshtarRose Offline
journeyman 		Registered: 09/01/07
Posts: 64
Loc: Concord, NC
Parse error: syntax error, unexpected T_ARRAY in /home/riddle6/public_html/hprpg/admin/dosendemail.php on line 77

When trying to email all of my members via control panel.
Top
#206549 - 02/16/08 05:03 PM Re: Beta 7.3 SQL Instal Issue [Re: AshtarRose]
AshtarRose Offline
journeyman 		Registered: 09/01/07
Posts: 64
Loc: Concord, NC
Smilies are not working in my shout box
Top
#206550 - 02/16/08 05:12 PM Re: Beta 7.3 SQL Instal Issue [Re: AshtarRose]
AshtarRose Offline
journeyman 		Registered: 09/01/07
Posts: 64
Loc: Concord, NC
Fixed Smilies, but still can not mass email through the CP
Top
#206553 - 02/16/08 05:36 PM Re: Beta 7.3 SQL Instal Issue [Re: AshtarRose]
Rick Offline
Post-a-holic 		Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
This topic is starting to get a bit confusing with the variety of posts and problems in it. AshtarRose, since you were able to get upgraded, can you make bug report posts for any issues you encounter?

Rob, if I can get FTP access to your site, I can take a looksee.
Top
#206562 - 02/16/08 08:36 PM Re: Beta 7.3 SQL Instal Issue [Re: Rick]
Robje01 Offline
enthusiast 		Registered: 01/19/08
Posts: 239
Loc: Netherlands - Valkenswaard
Will a SSH session do?

Not running FTP there...

Rob
_________________________
My place to be: http://www.freesat.nl
Top
#206564 - 02/16/08 08:48 PM Re: Beta 7.3 SQL Instal Issue [Re: Robje01]
Rick Offline
Post-a-holic 		Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Yep, SSH is even better wink
Top
#206568 - 02/16/08 10:52 PM Re: Beta 7.3 SQL Instal Issue [Re: Rick]
Gizmo Offline

Registered: 06/05/06
Posts: 14995
Loc: Portland, OR; USA
SSH/SCP > FTP as it's far more secure :nods:

Then you have my anal retentiveness kick in with SSH Certificates and pub keys... :looks at Rick:
_________________________
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
#206577 - 02/17/08 08:42 AM Re: Beta 7.3 SQL Instal Issue [Re: Gizmo]
Robje01 Offline
enthusiast 		Registered: 01/19/08
Posts: 239
Loc: Netherlands - Valkenswaard
Hey Rick,

Sended you a PM. Made (specialy for you) a FTP login account smile
_________________________
My place to be: http://www.freesat.nl
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