Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
7 registered (smallufo, SteveS, sampsonzurich, Bjab, FordDoctor, Stan, Pilgrim), 27 Guests and 13 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 05/17/12
Posts: 3
Top Posters (30 Days)
Ruben 51
Gizmo 24
DennyP 24
Dunny 15
SteveS 14
AllenAyres 12
SD 10
dbremer 10
drkknght00 9
doug 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Page 1 of 2 1 2 >
Topic Options
#211810 - 05/12/08 04:11 AM Problem with installing 7.3 Test-Board
ADWOFF Offline
member
Registered: 06/06/06
Posts: 179
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
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."
#211811 - 05/12/08 04:18 AM Re: Problem with installing 7.3 Test-Board [Re: ADWOFF]
SD Offline
Registered: 04/19/07
Posts: 4056
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
_________________________

Threads tutorials . Threads & Wordpress experts . UBB resume

If I you, click this link as to why
Top
#211815 - 05/12/08 04:47 AM Re: Problem with installing 7.3 Test-Board [Re: SD]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
Perhaps it would be better to not allow certain characters in the table prefix.
Top
#211819 - 05/12/08 07:34 AM Re: Problem with installing 7.3 Test-Board [Re: Ian]
ADWOFF Offline
member
Registered: 06/06/06
Posts: 179
That did the trick!

Thanks.

~Sue
adwoff.com
Top
#211839 - 05/12/08 09:20 AM Re: Problem with installing 7.3 Test-Board [Re: ADWOFF]
AllenAyres Offline

Registered: 12/29/03
Posts: 1995
Loc: Texas
Hey Sue! :wavey:
_________________________
- Allen
- ThreadsDev | PraiseCafe
Top
#211842 - 05/12/08 09:28 AM Re: Problem with installing 7.3 Test-Board [Re: AllenAyres]
ADWOFF Offline
member
Registered: 06/06/06
Posts: 179
smile Howdy, Allen! I hear I'm late with bday acknowledgments! I hope you had a WONDERFUL day!

~Sue
Top
#211907 - 05/12/08 04:58 PM Re: Problem with installing 7.3 Test-Board [Re: Ian]
SD Offline
Registered: 04/19/07
Posts: 4056
Loc: SoCal, USA
Originally Posted By: Ian
Perhaps it would be better to not allow certain characters in the table prefix.


correct wink
_________________________

Threads tutorials . Threads & Wordpress experts . UBB resume

If I you, click this link as to why
Top
#212005 - 05/13/08 09:53 AM Re: Problem with installing 7.3 Test-Board [Re: SD]
ADWOFF Offline
member
Registered: 06/06/06
Posts: 179
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 10:01 AM Re: Problem with installing 7.3 Test-Board [Re: ADWOFF]
ADWOFF Offline
member
Registered: 06/06/06
Posts: 179
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 10:12 AM Re: Problem with installing 7.3 Test-Board [Re: ADWOFF]
Zarzal Offline
old hand
Registered: 06/05/06
Posts: 1142
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
#212012 - 05/13/08 10:18 AM Re: Problem with installing 7.3 Test-Board [Re: Zarzal]
ADWOFF Offline
member
Registered: 06/06/06
Posts: 179
Originally Posted By: Zarzal
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.


Um, nope, I haven't! Really don't have a clue, so let me do some checkin'!

~Sue
Top
#212015 - 05/13/08 10:27 AM Re: Problem with installing 7.3 Test-Board [Re: ADWOFF]
ADWOFF Offline
member
Registered: 06/06/06
Posts: 179
When I look in PHP Info, this is what I see:

Quote:
gd
GD Support enabled
GD Version bundled (2.0.28 compatible)
FreeType Support enabled
FreeType Linkage with freetype
FreeType Version 2.1.9
GIF Read Support enabled
GIF Create Support enabled
JPG Support enabled
PNG Support enabled
WBMP Support enabled
XBM Support enabled


Am I too assume I need to install something else since it says "GD" and not "GD2"?

~Sue <<-- clueless
Top
#212024 - 05/13/08 11:35 AM Re: Problem with installing 7.3 Test-Board [Re: ADWOFF]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
I think that is GD2 (2.0.28)
Top
#212068 - 05/13/08 07:09 PM Re: Problem with installing 7.3 Test-Board [Re: Ian]
Gizmo Offline

Registered: 06/05/06
Posts: 14995
Loc: Portland, OR; USA
that is gd2; i recommend ImageMagick if you have it installed.

the error just means you havn't set an image processor; go to the gallery page in your cp and submit it (with GD selected)
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#212097 - 05/14/08 02:36 AM Re: Problem with installing 7.3 Test-Board [Re: Gizmo]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
Thanks Gizmo smile .................
Top
#212179 - 05/14/08 10:22 AM Re: Problem with installing 7.3 Test-Board [Re: Gizmo]
ADWOFF Offline
member
Registered: 06/06/06
Posts: 179
Originally Posted By: Gizmo
that is gd2; i recommend ImageMagick if you have it installed.

the error just means you havn't set an image processor; go to the gallery page in your cp and submit it (with GD selected)


OK, color me confused, Gizzy.

According to my CP, in the Gallery Settings, it says this:

Quote:
What Graphics Library do you want to use?


and the only item available in the pulldown menu is "Use GD2"

I don't know anything about ImageMagick and how to go about installing it.

~Sue <<-- the clueless one
Top
#212180 - 05/14/08 10:32 AM Re: Problem with installing 7.3 Test-Board [Re: ADWOFF]
ADWOFF Offline
member
Registered: 06/06/06
Posts: 179
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 10:45 AM)
Edit Reason: see comments
Top
#212186 - 05/14/08 11:19 AM Re: Problem with installing 7.3 Test-Board [Re: ADWOFF]
Ian Offline
Registered: 06/05/06
Posts: 4337
Loc: Essex, UK
Originally Posted By: ADWOFF
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.


Originally Posted By: ADWOFF

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.

Top
#212236 - 05/14/08 07:47 PM Re: Problem with installing 7.3 Test-Board [Re: Ian]
Gizmo Offline

Registered: 06/05/06
Posts: 14995
Loc: Portland, OR; USA
In order for IM to be seen in the list, you have to point to where their binary files are located on the server; hence why I said if it's available wink...
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
Page 1 of 2 1 2 >



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Due Date Calculator-Calculate When Your Baby is Due
by StewartMyduedate
12:54 AM
Temporary Password email not being received
by
05/24/12 10:02 PM
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
Forum Stats
10492 Members
36 Forums
33842 Topics
181709 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image