Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online Now
2 registered members (M4TT, mmkk), 65 guests, and 268 spiders.
Key: Admin, Global Mod, Mod
Member Spotlight
isaac
isaac
California
Posts: 1,004
Joined: April 2004
Show All Member Profiles 
Top Posters(30 Days)
Gizmo 15
FREAK 11
M4TT 10
Ruben 5
mmkk 5
isaac 4
Latest Photos
Chinese Buddhist temple.
My buddha beads.
Rendered Walls
Multi-Screen wallpaper
Stockholm Metro
Previous Thread
Next Thread
Print Thread
[FIXED] createtable.php sql error 1064 ? #223103
02/25/09 04:43 PM
02/25/09 04:43 PM
Joined: Aug 2008
Posts: 13
M
Murphdog Offline OP
stranger
Murphdog  Offline OP
stranger
M
Joined: Aug 2008
Posts: 13
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

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: createtable.php sql error 1064 ? [Re: Murphdog] #223107
02/25/09 04:45 PM
02/25/09 04:45 PM
Joined: Apr 2007
Posts: 4,313
SoCal, USA
SD Offline
Carpal Tunnel
SD  Offline
Carpal Tunnel
Joined: Apr 2007
Posts: 4,313
SoCal, USA
yes.. there are other identified errors for a 'fresh install' of 7.5 as well frown

7.5.1 ? laugh

Re: createtable.php sql error 1064 ? [Re: SD] #223111
02/25/09 04:53 PM
02/25/09 04:53 PM
Joined: Dec 2003
Posts: 5,824
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,824
Lutz,FL
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
Re: createtable.php sql error 1064 ? [Re: Ruben] #223112
02/25/09 04:55 PM
02/25/09 04:55 PM
Joined: Aug 2008
Posts: 13
M
Murphdog Offline OP
stranger
Murphdog  Offline OP
stranger
M
Joined: Aug 2008
Posts: 13
I saw that post but wasn't sure it was related. I'll try it out tonight. Thanks

Re: createtable.php sql error 1064 ? [Re: Murphdog] #223114
02/25/09 05:11 PM
02/25/09 05:11 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
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.

Re: createtable.php sql error 1064 ? [Re: Rick] #223233
02/26/09 05:57 PM
02/26/09 05:57 PM
Joined: Dec 2003
Posts: 5,824
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,824
Lutz,FL
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
Re: createtable.php sql error 1064 ? [Re: Ruben] #223234
02/26/09 06:05 PM
02/26/09 06:05 PM
Joined: Mar 2008
Posts: 340
North Carolina
D
DLWebmaestro Offline
enthusiast
DLWebmaestro  Offline
enthusiast
D
Joined: Mar 2008
Posts: 340
North Carolina
No, only the install/createtables.php file has been changed for the update.

Re: createtable.php sql error 1064 ? [Re: DLWebmaestro] #223240
02/26/09 06:12 PM
02/26/09 06:12 PM
Joined: Dec 2003
Posts: 5,824
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,824
Lutz,FL
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
Re: createtable.php sql error 1064 ? [Re: Ruben] #223256
02/26/09 06:45 PM
02/26/09 06:45 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
No, everything else will come via a bugfix release and we'll try to post the fixes here as well when possible.

Re: createtable.php sql error 1064 ? [Re: Rick] #223259
02/26/09 06:53 PM
02/26/09 06:53 PM
Joined: Dec 2003
Posts: 5,824
Lutz,FL
Ruben Offline

Ruben  Offline


Joined: Dec 2003
Posts: 5,824
Lutz,FL
Thank You!
Again Rick.


Blue Man Group


There is no such thing as stupid questions. Just stupid answers

Shout Box
Today's Birthdays
No Birthdays
Recent Topics
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
I want to update forum but can't find license
by dimaninc. 11/23/17 10:51 AM
Forum Statistics
Forums36
Topics35,014
Posts190,533
Members12,045
Most Online978
Jun 24th, 2007
Random Image
Powered by UBB.threads™ PHP Forum Software 7.6.1
(Snapshot build 20171106)