Previous Thread
Next Thread
Print Thread
Hop To
Joined: Jun 2006
Posts: 171
Likes: 1
member
member
Joined: Jun 2006
Posts: 171
Likes: 1
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


Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
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

Joined: Jun 2006
Posts: 3,837
I
Ian Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,837
Perhaps it would be better to not allow certain characters in the table prefix.

Joined: Jun 2006
Posts: 171
Likes: 1
member
member
Joined: Jun 2006
Posts: 171
Likes: 1
That did the trick!

Thanks.

~Sue
adwoff.com

Joined: Dec 2003
Posts: 1,796
Pooh-Bah
Pooh-Bah
Joined: Dec 2003
Posts: 1,796
Hey Sue! :wavey:


- Allen
- ThreadsDev | PraiseCafe
Joined: Jun 2006
Posts: 171
Likes: 1
member
member
Joined: Jun 2006
Posts: 171
Likes: 1
smile Howdy, Allen! I hear I'm late with bday acknowledgments! I hope you had a WONDERFUL day!

~Sue

Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
Originally Posted by Ian
Perhaps it would be better to not allow certain characters in the table prefix.


correct wink

Joined: Jun 2006
Posts: 171
Likes: 1
member
member
Joined: Jun 2006
Posts: 171
Likes: 1
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

Joined: Jun 2006
Posts: 171
Likes: 1
member
member
Joined: Jun 2006
Posts: 171
Likes: 1
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

Joined: Jun 2006
Posts: 956
Old Hand
Old Hand
Joined: Jun 2006
Posts: 956
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.dragonclan-forum.de
my hobby: http://www.biker-reise.de
Ich kann bei Fragen zu UBBthreads in Deutsch weiterhelfen oder es zumindest versuchen
Joined: Jun 2006
Posts: 171
Likes: 1
member
member
Joined: Jun 2006
Posts: 171
Likes: 1
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

Joined: Jun 2006
Posts: 171
Likes: 1
member
member
Joined: Jun 2006
Posts: 171
Likes: 1
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

Joined: Jun 2006
Posts: 3,837
I
Ian Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,837
I think that is GD2 (2.0.28)

Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
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)


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Jun 2006
Posts: 3,837
I
Ian Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,837
Thanks Gizmo smile .................

Joined: Jun 2006
Posts: 171
Likes: 1
member
member
Joined: Jun 2006
Posts: 171
Likes: 1
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

Joined: Jun 2006
Posts: 171
Likes: 1
member
member
Joined: Jun 2006
Posts: 171
Likes: 1
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!

Last edited by ADWOFF; 05/14/2008 10:45 AM. Reason: see comments
Joined: Jun 2006
Posts: 3,837
I
Ian Offline
Carpal Tunnel
Carpal Tunnel
I Offline
Joined: Jun 2006
Posts: 3,837
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.


Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
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...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
1 members (Ruben), 476 guests, and 111 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)