Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
5 registered (David DelMonte, David Dreezer, DougMM, Harold, 1 invisible), 25 Guests and 18 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 08/30/06
Posts: 1299
Top Posters (30 Days)
Ruben Rocha 179
Gizmo 112
Rick 106
Thelockman 79
driv 43
AllenAyres 35
ntdoc 28
Ian 24
Sirdude 23
ScriptKeeper 20
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: 2077
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: 2077
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
No Birthdays
Recent Topics
I'm the Admin but.....
by David DelMonte
Today at 11:12 AM
Fatal error: Smarty::require_once
()

by ThreadsUser
Today at 08:17 AM
PayPal batch file for ID'ing expired and failed payment subscriptions?
by Mitch P.
Today at 06:02 AM
Shrinking graemlins
by Djuma
Yesterday at 05:48 PM
2 problems I'm seeing now.
by DougMM
Yesterday at 04:39 PM
Forum Stats
4261 Members
33 Forums
30535 Topics
154978 Posts

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