Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
3 Registered (Anrui, driv, 1 invisible), 26 Guests and 28 Spiders online.
Key: Admin, Global Mod, Mod
Top Posters
Gizmo 11678
Rick 7551
Ian 4102
Mark S 3969
ntdoc 3102
Sirdude 2041
jgeoff 1876
David Dreezer 1750
driv 1557
AllenAyres 1523
Latest Photos
Carrie - So Very
Testing
Test Photo
4TH of July at the river!
Test shots from D300 part 3
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: 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:

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: 2041
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
_________________________

A taxpayer voting for Obama is like a chicken voting for Colonel Sanders.

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: 4102
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: 162
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: 1523
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: 162
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: 2041
Loc: SoCal, USA
Originally Posted By: Ian
Perhaps it would be better to not allow certain characters in the table prefix.


correct wink
_________________________

A taxpayer voting for Obama is like a chicken voting for Colonel Sanders.

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: 162
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: 162
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: 1055
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 07:18 AM Re: Problem with installing 7.3 Test-Board [Re: Zarzal]
ADWOFF Offline
member

Registered: 06/06/06
Posts: 162
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 07:27 AM Re: Problem with installing 7.3 Test-Board [Re: ADWOFF]
ADWOFF Offline
member

Registered: 06/06/06
Posts: 162
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 08:35 AM Re: Problem with installing 7.3 Test-Board [Re: ADWOFF]
Ian Moderator Offline


Registered: 06/05/06
Posts: 4102
Loc: Essex, UK
I think that is GD2 (2.0.28)
_________________________
Fans Focus - Focusing on Fans of Sport

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

Top
#212068 - 05/13/08 04:09 PM Re: Problem with installing 7.3 Test-Board [Re: Ian]
Gizmo Moderator Offline


Registered: 06/04/06
Posts: 11678
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)
_________________________
UGN Security, Elite Web Gamers & VNC Web Design Owner
Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic

Top
#212097 - 05/13/08 11:36 PM Re: Problem with installing 7.3 Test-Board [Re: Gizmo]
Ian Moderator Offline


Registered: 06/05/06
Posts: 4102
Loc: Essex, UK
Thanks Gizmo smile .................
_________________________
Fans Focus - Focusing on Fans of Sport

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

Top
#212179 - 05/14/08 07:22 AM Re: Problem with installing 7.3 Test-Board [Re: Gizmo]
ADWOFF Offline
member

Registered: 06/06/06
Posts: 162
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 07:32 AM Re: Problem with installing 7.3 Test-Board [Re: ADWOFF]
ADWOFF Offline
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]
Ian Moderator Offline


Registered: 06/05/06
Posts: 4102
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.

_________________________
Fans Focus - Focusing on Fans of Sport

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

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


Registered: 06/04/06
Posts: 11678
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...
_________________________
UGN Security, Elite Web Gamers & VNC Web Design Owner
Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic

Top
Page 1 of 2 1 2 >


Shout Box

August
Su M Tu W Th F Sa
1 2
3 4 5 6 7