Previous Thread
Next Thread
Print Thread
Hop To
#206410 02/15/2008 1:16 AM
Joined: Sep 2007
Posts: 73
Likes: 1
Journeyman
Journeyman
Joined: Sep 2007
Posts: 73
Likes: 1
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

Joined: Jun 2006
Posts: 3,837
I
Ian Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,837
What version are you upgrading from?

Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
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.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Jun 2006
Posts: 1,344
G
veteran
veteran
G Offline
Joined: Jun 2006
Posts: 1,344
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 

Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Yeh, the error is simply telling you that the altertable hasn't been run.


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
(Go figure that my two clients that test it get the same error? lol...)


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Jun 2006
Posts: 1,344
G
veteran
veteran
G Offline
Joined: Jun 2006
Posts: 1,344
Yea, just figured I'd throw it in. Extra info never hurts much wink Everything was going pretty good for me too until this.

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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.

Joined: Jun 2006
Posts: 1,344
G
veteran
veteran
G Offline
Joined: Jun 2006
Posts: 1,344
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

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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.

Joined: Sep 2007
Posts: 73
Likes: 1
Journeyman
Journeyman
Joined: Sep 2007
Posts: 73
Likes: 1
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.

Joined: Jun 2006
Posts: 1,344
G
veteran
veteran
G Offline
Joined: Jun 2006
Posts: 1,344
Sure, give me a few

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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.

Joined: Sep 2007
Posts: 73
Likes: 1
Journeyman
Journeyman
Joined: Sep 2007
Posts: 73
Likes: 1
In your PM Rick

Joined: Sep 2007
Posts: 73
Likes: 1
Journeyman
Journeyman
Joined: Sep 2007
Posts: 73
Likes: 1
Rick Fixed it, yey Rick smile

Joined: Jan 2008
Posts: 222
enthusiast
enthusiast
Joined: Jan 2008
Posts: 222
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
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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.

Joined: Jan 2008
Posts: 222
enthusiast
enthusiast
Joined: Jan 2008
Posts: 222
Thanks Rick. :thumbs:


My place to be: http://www.freesat.nl
Joined: Jan 2008
Posts: 222
enthusiast
enthusiast
Joined: Jan 2008
Posts: 222
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?

Last edited by Robje01; 02/15/2008 7:55 PM.

My place to be: http://www.freesat.nl
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Ash's was on her live site; Glider always uses a test site (good boy, you get a cookie)


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Jun 2006
Posts: 1,344
G
veteran
veteran
G Offline
Joined: Jun 2006
Posts: 1,344
yummy yummy yummy I got cookie in my tummy

Joined: Sep 2007
Posts: 73
Likes: 1
Journeyman
Journeyman
Joined: Sep 2007
Posts: 73
Likes: 1
pfttt.. I live on the edge.

Joined: Jan 2008
Posts: 222
enthusiast
enthusiast
Joined: Jan 2008
Posts: 222
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
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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?

Joined: Jan 2008
Posts: 222
enthusiast
enthusiast
Joined: Jan 2008
Posts: 222
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
Joined: Jan 2008
Posts: 222
enthusiast
enthusiast
Joined: Jan 2008
Posts: 222
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
Joined: Sep 2007
Posts: 73
Likes: 1
Journeyman
Journeyman
Joined: Sep 2007
Posts: 73
Likes: 1
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.

Joined: Sep 2007
Posts: 73
Likes: 1
Journeyman
Journeyman
Joined: Sep 2007
Posts: 73
Likes: 1
Smilies are not working in my shout box

Joined: Sep 2007
Posts: 73
Likes: 1
Journeyman
Journeyman
Joined: Sep 2007
Posts: 73
Likes: 1
Fixed Smilies, but still can not mass email through the CP

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
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.

Joined: Jan 2008
Posts: 222
enthusiast
enthusiast
Joined: Jan 2008
Posts: 222
Will a SSH session do?

Not running FTP there...

Rob


My place to be: http://www.freesat.nl
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
Yep, SSH is even better wink

Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
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:


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Jan 2008
Posts: 222
enthusiast
enthusiast
Joined: Jan 2008
Posts: 222
Hey Rick,

Sended you a PM. Made (specialy for you) a FTP login account smile


My place to be: http://www.freesat.nl

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
0 members (), 396 guests, and 110 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)