|
|
 |
 |
 |
 |
#211810 - 05/12/08 01:11 AM
Problem with installing 7.3 Test-Board
|
member
Registered: 06/06/06
Posts: 162
|
I set everything up correctly (*I think*); did the file permissions; did the admin set-up; then when to create the tables, and I received this error message: UBB 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 '-boardFORUMS ( FORUM_TITLE text, FORUM_DESCRIPTION text, FORUM_ID int(9) unsi' at line 1 SQL Error #: 1064 Query: create table ubbt_test-boardFORUMS ( FORUM_TITLE text, FORUM_DESCRIPTION text, FORUM_ID int(9) unsigned auto_increment primary key, FORUM_PARENT int(9) unsigned, FORUM_POSTS int(9) unsigned default '0', FORUM_LAST_POST_TIME int(11) unsigned, FORUM_CREATED_ON int(11) unsigned, FORUM_IS_MODERATED tinyint(1) unsigned default '0', CATEGORY_ID int(4) unsigned default '1' not null, FORUM_TOPICS int(9) unsigned default '0', FORUM_SORT_ORDER int(4) unsigned, FORUM_DEFAULT_TOPIC_AGE int(4) unsigned, FORUM_CUSTOM_HEADER int(1) unsigned, FORUM_STYLE mediumint(4) not null default '0', FORUM_LAST_POST_ID int(9) unsigned default '0', FORUM_LAST_TOPIC_ID int(9) unsigned, FORUM_LAST_POSTER_ID int(9) default '1', FORUM_LAST_POSTER_NAME varchar(64), FORUM_LAST_POST_SUBJECT text, FORUM_LAST_POST_ICON varchar(30), FORUM_IMAGE varchar(255), FORUM_IS_ACTIVE tinyint(1) default '1' not null, FORUM_ISLAND_INSERT mediumint(5) not null default '0', FORUM_IS_RSS tinyint(1) not null default '0', FORUM_RSS_TITLE varchar(255), FORUM_SHOW_INTRO tinyint(1) not null default '0', FORUM_INTRO_TITLE varchar(255), FORUM_IS_TEASER tinyint(1) not null default '0', FORUM_IS_GALLERY tinyint(1) not null default '0', FORUM_ACTIVE_POSTS tinyint(1) default '1', FORUM_POSTS_COUNT tinyint(1) default '1', INDEX CAT_NDX (CATEGORY_ID), INDEX ACTIVE_NDX (FORUM_IS_ACTIVE) ) TYPE=MyISAM
Please click back to return to the previous page. Any ideas? ~Sue adwoff.com
|
|
Top
|
|
|
|
|
 |
 |
 |
 |
 |
 |
 |
 |
#211839 - 05/12/08 06:20 AM
Re: Problem with installing 7.3 Test-Board
[Re: ADWOFF]
|
 
Registered: 12/29/03
Posts: 1523
Loc: Texas
|
|
|
Top
|
|
|
|
|
 |
 |
 |
 |
 |
 |
 |
 |
#212180 - 05/14/08 07:32 AM
Re: Problem with installing 7.3 Test-Board
[Re: ADWOFF]
|
member
Registered: 06/06/06
Posts: 162
|
Yikes, I'm going to have to read some of the fine print of this upgrade a little closer.
I'm seeing two things that I'm not sure I like--either I have missed it in setting things up, or they've gone away.
First, I like being "invisible" when I'm online--especially on my board; it's just the way I am. In addition, the main attraction to my slice of cyberspace, Nora Roberts, needs to have that anonymity, too.
So, am I missing something there?
---
Second, I also liked the ability to set up how the forums appeared for me. Example, here @ UBB Central, I have the left side of the portal page turned off when I'm looking at the threads/messages.
At my site, I turn off both sides when I'm viewing the actual board.
At my test site--with the upgrade, I don't even see the portal page as an option.
I know I need to play a bit more, but what am I missing?!
~Sue <<-- confused
ETA: I found the deal about the portal page ETA II: I think I found the Who's Online deal, too!
Edited by ADWOFF (05/14/08 07:45 AM) Edit Reason: see comments
|
|
Top
|
|
|
|
|
 |
 |
 |
 |
 |
 |
 |
 |
#212186 - 05/14/08 08:19 AM
Re: Problem with installing 7.3 Test-Board
[Re: ADWOFF]
|
Registered: 06/05/06
Posts: 4102
Loc: Essex, UK
|
Yikes, I'm going to have to read some of the fine print of this upgrade a little closer.
I'm seeing two things that I'm not sure I like--either I have missed it in setting things up, or they've gone away.
First, I like being "invisible" when I'm online--especially on my board; it's just the way I am. In addition, the main attraction to my slice of cyberspace, Nora Roberts, needs to have that anonymity, too.
So, am I missing something there? As long as you have not selected to prevent invisible members under general in the CP, all members can select if they wish to be invisible. Second, I also liked the ability to set up how the forums appeared for me. Example, here @ UBB Central, I have the left side of the portal page turned off when I'm looking at the threads/messages.
At my site, I turn off both sides when I'm viewing the actual board.
Again this is a user selectable option as long as you have not blocked it within the settings.
_________________________
Fans Focus - Focusing on Fans of Sport (Okay - mainly football (the British variety at the moment - but expanding all the time....))
|
|
Top
|
|
|
|
|
 |
 |
 |
 |
|
|