|
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: 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
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
|
|
|
|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
Carpal Tunnel
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 |
|
|
|
|
Joined: Jun 2006
Posts: 171 Likes: 1
member
|
member
Joined: Jun 2006
Posts: 171 Likes: 1 |
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
Former Developer
|
Former Developer
Joined: Apr 2007
Posts: 3,940 Likes: 1 |
Perhaps it would be better to not allow certain characters in the table prefix. correct
|
|
|
|
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: 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.
|
|
|
|
Joined: Jun 2006
Posts: 171 Likes: 1
member
|
member
Joined: Jun 2006
Posts: 171 Likes: 1 |
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: 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
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837 |
I think that is GD2 (2.0.28)
|
|
|
|
Joined: Jun 2006
Posts: 16,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 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)
|
|
|
|
Joined: Jun 2006
Posts: 3,837
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837 |
Thanks Gizmo .................
|
|
|
|
Joined: Jun 2006
Posts: 171 Likes: 1
member
|
member
Joined: Jun 2006
Posts: 171 Likes: 1 |
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: 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
Carpal Tunnel
|
Carpal Tunnel
Joined: Jun 2006
Posts: 3,837 |
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. 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,301 Likes: 116
|
Joined: Jun 2006
Posts: 16,301 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 ...
|
|
|
1 members (Ruben),
1,101
guests, and
206
robots. |
Key:
Admin,
Global Mod,
Mod
|
|
|
|