Previous Thread
Next Thread
Print Thread
Hop To
Joined: Aug 2008
Posts: 12
M
stranger
stranger
M Offline
Joined: Aug 2008
Posts: 12
Doing a fresh install to try to bypass a couple gallery errors I was getting..... so when creating the db tables, it starts, then I get a message saying....
Quote
BB Message We encountered a problem. The reason reported was

Script:
Line#:
SQL Error: 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 'INDEX birthday_ndx (USER_BIRTHDAY, USER_PUBLIC_BIRTHDAY), INDEX email_ndx(USER_' at line 66
SQL Error #: 1064
Query: create table ubbt_USER_PROFILE ( USER_ID int(9) not null primary key, USER_REAL_EMAIL varchar(50) not null default '', USER_DISPLAY_EMAIL varchar(50), USER_UNVERIFIED_EMAIL varchar(50) not null default '', USER_LANGUAGE varchar(50), USER_SIGNATURE text, USER_DEFAULT_SIGNATURE text, USER_HOMEPAGE varchar(150), USER_OCCUPATION varchar(150), USER_HOBBIES varchar(200), USER_LOCATION varchar(200), USER_START_VIEW varchar(20) not null default 'cfrm', USER_FAVORITES_TAB varchar(10) not null default 'forums', USER_FAVORITES_SORT varchar (10) not null default 'reply', USER_TOPIC_VIEW_TYPE varchar(10) not null default 'flat', USER_TOPICS_PER_PAGE int(1), USER_NOTIFY_ON_PM varchar(3) not null default 'no', USER_ICQ varchar(200), USER_YAHOO varchar(200), USER_MSN varchar(200), USER_AIM varchar(200), USER_EXTRA_FIELD_1 varchar(200), USER_EXTRA_FIELD_2 varchar(200), USER_EXTRA_FIELD_3 varchar(200), USER_EXTRA_FIELD_4 varchar(200), USER_EXTRA_FIELD_5 varchar(200), USER_AVATAR varchar(150), USER_SHOW_AVATARS tinyint(1) not null default '1', USER_VISIBLE_ONLINE_STATUS varchar(3) default 'yes', USER_ACCEPT_PM varchar(3) default 'yes', USER_EMAIL_WATCHLISTS tinyint(1) not null default '0', USER_TITLE varchar(100), USER_CUSTOM_TITLE varchar(255), USER_POSTS_PER_TOPIC varchar(2), USER_TEMPORARY_PASSWORD varchar(32), USER_NAME_COLOR varchar(15), USER_TIME_OFFSET varchar(10), USER_RELATIVE_TIME tinyint(1), USER_TOTAL_PM int(4) default '0', USER_TOTAL_POSTS int(9) default '0', USER_SHOW_SIGNATURES varchar(3), USER_RATING int(1), USER_TOTAL_RATES mediumint(6) not null default '0', USER_AVATAR_WIDTH int(4) default '0', USER_AVATAR_HEIGHT int(4) default '0', USER_ACCEPT_ADMIN_EMAILS varchar(3), USER_BIRTHDAY varchar(10) not null default '0', USER_PUBLIC_BIRTHDAY int(1) not null default '0', USER_TIME_FORMAT varchar(30), USER_IGNORE_LIST text, USER_FLOOD_CONTROL_OVERRIDE mediumint(8) default '-1', USER_STYLE mediumint(4) not null default '0', USER_UNAPPROVED_POST_NOTIFY tinyint(1) not null default '0', USER_REPORT_POST_NOTIFY tinyint(1) not null default '0', USER_TEXT_EDITOR varchar(10) default 'standard', USER_HIDE_LEFT_COLUMN tinyint(1) not null default '0', USER_HIDE_RIGHT_COLUMN tinyint(1) not null default '0', USER_MOOD varchar(50), USER_NOTIFY_NEW_USER tinyint(1) not null default '0', USER_POST_LAYOUT varchar(4), USER_SHOW_ALL_GRAEMLINS tinyint(1) default '0', USER_SHOW_LEFT_MYSTUFF tinyint(1) not null default '0', USER_GROUP_IMAGES varchar(255), USER_NOTIFY_MULTI tinyint(1) unsigned not null default '0' INDEX birthday_ndx (USER_BIRTHDAY, USER_PUBLIC_BIRTHDAY), INDEX email_ndx(USER_REAL_EMAIL) ) TYPE=MyISAM

Please click back to return to the previous page.

It is able to create
ubbt_CATEGORIES
ubbt_FILES
ubbt_FORUMS
ubbt_FORUM_LAST_VISIT
ubbt_POLL_DATA
ubbt_POLL_OPTIONS
ubbt_POLL_VOTES
ubbt_POSTS
ubbt_TOPICS
ubbt_USERS

Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
yes.. there are other identified errors for a 'fresh install' of 7.5 as well frown

7.5.1 ? laugh

Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
Looks like DLWebmaestro beat you to it finding this bug. He has a suggested fix if you can't wait HERE


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Aug 2008
Posts: 12
M
stranger
stranger
M Offline
Joined: Aug 2008
Posts: 12
I saw that post but wasn't sure it was related. I'll try it out tonight. Thanks

Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
We refreshed 7.5 this morning which has the updated createtable.php script in place, so that should fix the issue if you want to grab it again.

Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
Originally Posted by Rick
We refreshed 7.5 this morning which has the updated createtable.php script in place, so that should fix the issue if you want to grab it again.
Other than a net new install. Should any of us concern ourselves with re-downloading the zip and re-install some files?


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Mar 2008
Posts: 326
D
Enthusiast
Enthusiast
D Offline
Joined: Mar 2008
Posts: 326
No, only the install/createtables.php file has been changed for the update.

Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
Well I'm just curious if there are any other cleanup issues addressed other than the one file?


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2006
Posts: 9,242
Likes: 1
R
Former Developer
Former Developer
R Offline
Joined: Jun 2006
Posts: 9,242
Likes: 1
No, everything else will come via a bugfix release and we'll try to post the fixes here as well when possible.

Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
Thank You!
Again Rick.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers

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
2 members (Gizmo, Nightcrawler), 553 guests, and 186 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)