Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
2 registered members (M4TT, isaac), 47 guests, and 279 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
M4TT
M4TT
Canada, SK
Posts: 49
Joined: March 2015
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 15
M4TT 11
FREAK 11
mmkk 5
Ruben 5
isaac 4
Latest Photos
Chinese Buddhist temple.
My buddha beads.
Rendered Walls
Multi-Screen wallpaper
Stockholm Metro
Previous Thread
Next Thread
Print Thread
Beta 7.3 SQL Instal Issue #206410
02/15/08 12:16 AM
02/15/08 12:16 AM
Joined: Sep 2007
Posts: 67
Hackelton U.K.
TGCsanderson Offline OP
journeyman
TGCsanderson  Offline OP
journeyman
Joined: Sep 2007
Posts: 67
Hackelton U.K.
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

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."
Re: Beta 7.3 SQL Instal Issue [Re: TGCsanderson] #206422
02/15/08 04:41 AM
02/15/08 04:41 AM
Joined: Jun 2006
Posts: 4,372
Essex, UK
I
Ian Offline
Carpal Tunnel
Ian  Offline
Carpal Tunnel
I
Joined: Jun 2006
Posts: 4,372
Essex, UK
What version are you upgrading from?

Re: Beta 7.3 SQL Instal Issue [Re: Ian] #206429
02/15/08 06:43 AM
02/15/08 06:43 AM
Joined: Jun 2006
Posts: 16,785
Portland, OR; USA
Gizmo Offline
UBB.threads Developer
Gizmo  Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,785
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.


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.
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!
Re: Beta 7.3 SQL Instal Issue [Re: Gizmo] #206434
02/15/08 08:09 AM
02/15/08 08:09 AM
Joined: Jun 2006
Posts: 1,475
NY
G
gliderdad Offline
veteran
gliderdad  Offline
veteran
G
Joined: Jun 2006
Posts: 1,475
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 

Re: Beta 7.3 SQL Instal Issue [Re: gliderdad] #206435
02/15/08 08:26 AM
02/15/08 08:26 AM
Joined: Jun 2006
Posts: 16,785
Portland, OR; USA
Gizmo Offline
UBB.threads Developer
Gizmo  Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,785
Portland, OR; USA
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.
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!
Re: Beta 7.3 SQL Instal Issue [Re: Gizmo] #206436
02/15/08 08:26 AM
02/15/08 08:26 AM
Joined: Jun 2006
Posts: 16,785
Portland, OR; USA
Gizmo Offline
UBB.threads Developer
Gizmo  Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,785
Portland, OR; USA
(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.
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!
Re: Beta 7.3 SQL Instal Issue [Re: Gizmo] #206437
02/15/08 08:28 AM
02/15/08 08:28 AM
Joined: Jun 2006
Posts: 1,475
NY
G
gliderdad Offline
veteran
gliderdad  Offline
veteran
G
Joined: Jun 2006
Posts: 1,475
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.

Re: Beta 7.3 SQL Instal Issue [Re: gliderdad] #206447
02/15/08 11:06 AM
02/15/08 11:06 AM
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
R
Rick Offline
Former Developer
Rick  Offline
Former Developer
R
Joined: Jun 2006
Posts: 10,177
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.

Re: Beta 7.3 SQL Instal Issue [Re: Rick] #206450
02/15/08 12:15 PM
02/15/08 12:15 PM
Joined: Jun 2006
Posts: 1,475
NY
G
gliderdad Offline
veteran
gliderdad  Offline
veteran
G
Joined: Jun 2006
Posts: 1,475
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

Re: Beta 7.3 SQL Instal Issue [Re: gliderdad] #206452
02/15/08 12:24 PM
02/15/08 12:24 PM
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
R
Rick Offline
Former Developer
Rick  Offline
Former Developer
R
Joined: Jun 2006
Posts: 10,177
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.

Re: Beta 7.3 SQL Instal Issue [Re: Rick] #206453
02/15/08 12:26 PM
02/15/08 12:26 PM
Joined: Sep 2007
Posts: 67
Hackelton U.K.
TGCsanderson Offline OP
journeyman
TGCsanderson  Offline OP
journeyman
Joined: Sep 2007
Posts: 67
Hackelton U.K.
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.

Re: Beta 7.3 SQL Instal Issue [Re: Rick] #206455
02/15/08 12:36 PM
02/15/08 12:36 PM
Joined: Jun 2006
Posts: 1,475
NY
G
gliderdad Offline
veteran
gliderdad  Offline
veteran
G
Joined: Jun 2006
Posts: 1,475
NY
Sure, give me a few

Re: Beta 7.3 SQL Instal Issue [Re: TGCsanderson] #206456
02/15/08 01:07 PM
02/15/08 01:07 PM
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
R
Rick Offline
Former Developer
Rick  Offline
Former Developer
R
Joined: Jun 2006
Posts: 10,177
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.

Re: Beta 7.3 SQL Instal Issue [Re: Rick] #206464
02/15/08 02:45 PM
02/15/08 02:45 PM
Joined: Sep 2007
Posts: 67
Hackelton U.K.
TGCsanderson Offline OP
journeyman
TGCsanderson  Offline OP
journeyman
Joined: Sep 2007
Posts: 67
Hackelton U.K.
In your PM Rick

Re: Beta 7.3 SQL Instal Issue [Re: TGCsanderson] #206471
02/15/08 03:29 PM
02/15/08 03:29 PM
Joined: Sep 2007
Posts: 67
Hackelton U.K.
TGCsanderson Offline OP
journeyman
TGCsanderson  Offline OP
journeyman
Joined: Sep 2007
Posts: 67
Hackelton U.K.
Rick Fixed it, yey Rick smile

Re: Beta 7.3 SQL Instal Issue [Re: TGCsanderson] #206475
02/15/08 04:11 PM
02/15/08 04:11 PM
Joined: Jan 2008
Posts: 242
Netherlands - Valkenswaard
Robje01 Offline
enthusiast
Robje01  Offline
enthusiast
Joined: Jan 2008
Posts: 242
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
Re: Beta 7.3 SQL Instal Issue [Re: Robje01] #206480
02/15/08 04:39 PM
02/15/08 04:39 PM
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
R
Rick Offline
Former Developer
Rick  Offline
Former Developer
R
Joined: Jun 2006
Posts: 10,177
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.

Re: Beta 7.3 SQL Instal Issue [Re: Rick] #206483
02/15/08 04:43 PM
02/15/08 04:43 PM
Joined: Jan 2008
Posts: 242
Netherlands - Valkenswaard
Robje01 Offline
enthusiast
Robje01  Offline
enthusiast
Joined: Jan 2008
Posts: 242
Netherlands - Valkenswaard
Thanks Rick. :thumbs:


My place to be: http://www.freesat.nl
Re: Beta 7.3 SQL Instal Issue [Re: Robje01] #206485
02/15/08 06:51 PM
02/15/08 06:51 PM
Joined: Jan 2008
Posts: 242
Netherlands - Valkenswaard
Robje01 Offline
enthusiast
Robje01  Offline
enthusiast
Joined: Jan 2008
Posts: 242
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?

Last edited by Robje01; 02/15/08 06:55 PM.

My place to be: http://www.freesat.nl
Re: Beta 7.3 SQL Instal Issue [Re: Rick] #206487
02/15/08 07:31 PM
02/15/08 07:31 PM
Joined: Jun 2006
Posts: 16,785
Portland, OR; USA
Gizmo Offline
UBB.threads Developer
Gizmo  Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,785
Portland, OR; USA
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.
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!
Re: Beta 7.3 SQL Instal Issue [Re: Gizmo] #206511
02/15/08 11:25 PM
02/15/08 11:25 PM
Joined: Jun 2006
Posts: 1,475
NY
G
gliderdad Offline
veteran
gliderdad  Offline
veteran
G
Joined: Jun 2006
Posts: 1,475
NY
yummy yummy yummy I got cookie in my tummy

Re: Beta 7.3 SQL Instal Issue [Re: Gizmo] #206512
02/16/08 01:19 AM
02/16/08 01:19 AM
Joined: Sep 2007
Posts: 67
Hackelton U.K.
TGCsanderson Offline OP
journeyman
TGCsanderson  Offline OP
journeyman
Joined: Sep 2007
Posts: 67
Hackelton U.K.
pfttt.. I live on the edge.

Re: Beta 7.3 SQL Instal Issue [Re: TGCsanderson] #206515
02/16/08 05:02 AM
02/16/08 05:02 AM
Joined: Jan 2008
Posts: 242
Netherlands - Valkenswaard
Robje01 Offline
enthusiast
Robje01  Offline
enthusiast
Joined: Jan 2008
Posts: 242
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
Re: Beta 7.3 SQL Instal Issue [Re: Robje01] #206524
02/16/08 11:25 AM
02/16/08 11:25 AM
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
R
Rick Offline
Former Developer
Rick  Offline
Former Developer
R
Joined: Jun 2006
Posts: 10,177
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?

Re: Beta 7.3 SQL Instal Issue [Re: Rick] #206527
02/16/08 12:30 PM
02/16/08 12:30 PM
Joined: Jan 2008
Posts: 242
Netherlands - Valkenswaard
Robje01 Offline
enthusiast
Robje01  Offline
enthusiast
Joined: Jan 2008
Posts: 242
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
Re: Beta 7.3 SQL Instal Issue [Re: Robje01] #206528
02/16/08 12:38 PM
02/16/08 12:38 PM
Joined: Jan 2008
Posts: 242
Netherlands - Valkenswaard
Robje01 Offline
enthusiast
Robje01  Offline
enthusiast
Joined: Jan 2008
Posts: 242
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
Re: Beta 7.3 SQL Instal Issue [Re: Gizmo] #206548
02/16/08 04:50 PM
02/16/08 04:50 PM
Joined: Sep 2007
Posts: 67
Hackelton U.K.
TGCsanderson Offline OP
journeyman
TGCsanderson  Offline OP
journeyman
Joined: Sep 2007
Posts: 67
Hackelton U.K.
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.

Re: Beta 7.3 SQL Instal Issue [Re: TGCsanderson] #206549
02/16/08 05:03 PM
02/16/08 05:03 PM
Joined: Sep 2007
Posts: 67
Hackelton U.K.
TGCsanderson Offline OP
journeyman
TGCsanderson  Offline OP
journeyman
Joined: Sep 2007
Posts: 67
Hackelton U.K.
Smilies are not working in my shout box

Re: Beta 7.3 SQL Instal Issue [Re: TGCsanderson] #206550
02/16/08 05:12 PM
02/16/08 05:12 PM
Joined: Sep 2007
Posts: 67
Hackelton U.K.
TGCsanderson Offline OP
journeyman
TGCsanderson  Offline OP
journeyman
Joined: Sep 2007
Posts: 67
Hackelton U.K.
Fixed Smilies, but still can not mass email through the CP

Re: Beta 7.3 SQL Instal Issue [Re: TGCsanderson] #206553
02/16/08 05:36 PM
02/16/08 05:36 PM
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
R
Rick Offline
Former Developer
Rick  Offline
Former Developer
R
Joined: Jun 2006
Posts: 10,177
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.

Re: Beta 7.3 SQL Instal Issue [Re: Rick] #206562
02/16/08 08:36 PM
02/16/08 08:36 PM
Joined: Jan 2008
Posts: 242
Netherlands - Valkenswaard
Robje01 Offline
enthusiast
Robje01  Offline
enthusiast
Joined: Jan 2008
Posts: 242
Netherlands - Valkenswaard
Will a SSH session do?

Not running FTP there...

Rob


My place to be: http://www.freesat.nl
Re: Beta 7.3 SQL Instal Issue [Re: Robje01] #206564
02/16/08 08:48 PM
02/16/08 08:48 PM
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
R
Rick Offline
Former Developer
Rick  Offline
Former Developer
R
Joined: Jun 2006
Posts: 10,177
Aberdeen, WA
Yep, SSH is even better wink

Re: Beta 7.3 SQL Instal Issue [Re: Rick] #206568
02/16/08 10:52 PM
02/16/08 10:52 PM
Joined: Jun 2006
Posts: 16,785
Portland, OR; USA
Gizmo Offline
UBB.threads Developer
Gizmo  Offline
UBB.threads Developer
Joined: Jun 2006
Posts: 16,785
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:


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.
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!
Re: Beta 7.3 SQL Instal Issue [Re: Gizmo] #206577
02/17/08 08:42 AM
02/17/08 08:42 AM
Joined: Jan 2008
Posts: 242
Netherlands - Valkenswaard
Robje01 Offline
enthusiast
Robje01  Offline
enthusiast
Joined: Jan 2008
Posts: 242
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

Shout Box
Today's Birthdays
No Birthdays
Recent Topics
Users Unable to Upload Avatar
by M4TT. 12/13/17 08:51 AM
Shout Box Sound Effect
by M4TT. 11/29/17 08:28 PM
Ad island
by TGCsanderson. 11/25/17 06:41 PM
Taking to long to connect to DB
by AstroCat. 11/24/17 12:34 PM
Forum Statistics
Forums36
Topics35,015
Posts190,534
Members12,045
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.1
(Snapshot build 20171106)