Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
4 registered (blaaskaak, Gizmo, Jim, Outdoorking), 31 Guests and 20 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member

Ian
Registered: 06/05/06
Posts: 4160
Top Posters (30 Days)
Ruben Rocha 187
Gizmo 107
Rick 100
Thelockman 83
driv 41
AllenAyres 35
Sirdude 29
ntdoc 28
Ian 24
ScriptKeeper 18
Latest Photos
My Home System
test photo gallery
Bernese Mountain Dogs
My Daimler
Dorado and shark
Page 1 of 2 1 2 >
Topic Options
Rate This Topic
#211810 - 05/12/08 01:11 AM Problem with installing 7.3 Test-Board
ADWOFF Offline
member

Registered: 06/06/06
Posts: 165
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:

Quote:
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
#211811 - 05/12/08 01:18 AM Re: Problem with installing 7.3 Test-Board [Re: ADWOFF]
Sirdude Offline

*****

Registered: 04/19/07
Posts: 2083
Loc: SoCal, USA
i think using a - in a table name is not wise..

since mysql does math, + and - are used..

change the name of your test board DB wink
_________________________


Top
#211815 - 05/12/08 01:47 AM Re: Problem with installing 7.3 Test-Board [Re: Sirdude]
Ian Moderator Offline

***

Registered: 06/05/06
Posts: 4160
Loc: Essex, UK
Perhaps it would be better to not allow certain characters in the table prefix.
_________________________
Fans Focus - Focusing on Fans of Sport

(Okay - mainly football (the British variety wink at the moment - but expanding all the time....))

Top
#211819 - 05/12/08 04:34 AM Re: Problem with installing 7.3 Test-Board [Re: Ian]
ADWOFF Offline
member

Registered: 06/06/06
Posts: 165
That did the trick!

Thanks.

~Sue
adwoff.com

Top
#211839 - 05/12/08 06:20 AM Re: Problem with installing 7.3 Test-Board [Re: ADWOFF]
AllenAyres Moderator Offline

****

Registered: 12/29/03
Posts: 1639
Loc: Texas
Hey Sue! :wavey:
_________________________
- Allen
- ThreadsDev | PraiseCafe

Top
#211842 - 05/12/08 06:28 AM Re: Problem with installing 7.3 Test-Board [Re: AllenAyres]
ADWOFF Offline
member

Registered: 06/06/06
Posts: 165
smile Howdy, Allen! I hear I'm late with bday acknowledgments! I hope you had a WONDERFUL day!

~Sue

Top
#211907 - 05/12/08 01:58 PM Re: Problem with installing 7.3 Test-Board [Re: Ian]
Sirdude Offline

*****

Registered: 04/19/07
Posts: 2083
Loc: SoCal, USA
Originally Posted By: Ian
Perhaps it would be better to not allow certain characters in the table prefix.


correct wink
_________________________


Top
#212005 - 05/13/08 06:53 AM Re: Problem with installing 7.3 Test-Board [Re: Sirdude]
ADWOFF Offline
member

Registered: 06/06/06
Posts: 165
Since I've started this thread, I thought I'd continue with another question: I'm exploring the possibility of adding a gallery to my forum. How big can the pictures be (should they be?!)?

Thanks.

~Sue
adwoff.com

Top
#212007 - 05/13/08 07:01 AM Re: Problem with installing 7.3 Test-Board [Re: ADWOFF]
ADWOFF Offline
member

Registered: 06/06/06
Posts: 165
Along with the question of the recommended size for photos for the gallery, I'm getting this message when I try to upload a file:

Quote:
Fatal error: Call to undefined function resize_image_() in /var/www/vhosts/adwoff.com/httpdocs/testboard/libs/image.inc.php on line 66


Any ideas?

~Sue

Top
#212009 - 05/13/08 07:12 AM Re: Problem with installing 7.3 Test-Board [Re: ADWOFF]
Zarzal Offline
old hand

Registered: 06/05/06
Posts: 1091
Loc: Berlin, Germany
do you setup GD2 or ImageMagick for your board an d galery? Work this with captcha? If you unsure take a look to phpinfo to see the versions of it.
_________________________
my board: http://www.dragon-clan.de
my hobby: http://www.biker-reise.de
Ich kann bei Fragen zu UBBthreads in Deutsch weiterhelfen oder es zumindest versuchen

Top
Page 1 of 2 1 2 >


Shout Box

Today's Birthdays
kimteague_5@msn.com, Trekkie, Trixie
Recent Topics
Issue mass-emailing
by Mitch P.
Today at 12:55 PM
Inclusion of Locked/Closed thread capabilities
by QSS Tim
Today at 11:17 AM
Contact Page Problem
by David DelMonte
Today at 09:05 AM
FAQ bug,
by BreeOge
Today at 08:36 AM
I'm the Admin but.....
by David DelMonte
Yesterday at 11:12 AM
Forum Stats
4261 Members
33 Forums
30539 Topics
155016 Posts

Max Online: 978 @ 06/24/07 08:19 PM