Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
4 registered (Gizmo, Jim, Outdoorking, 1 invisible), 28 Guests and 24 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 07/21/06
Posts: 1792
Top Posters (30 Days)
Ruben Rocha 187
Gizmo 107
Rick 100
Thelockman 83
driv 41
AllenAyres 35
Sirdude 29
ntdoc 28
Ian 24
ScriptKeeper 18
Latest Photos
My Home System
test photo gallery
Bernese Mountain Dogs
My Daimler
Dorado and shark
Topic Options
Rate This Topic
#211753 - 05/11/08 08:09 AM createtables missing fields
budh Offline
stranger

Registered: 03/23/04
Posts: 17
The fields FORUM_ALLOW_HTML and FORUM_ALLOW_MARKUP for the FORUMS table are missing for the createtable.php script released with 7.3.

Top
#211760 - 05/11/08 09:01 AM Re: createtables missing fields [Re: budh]
Rick Administrator Offline

*****

Registered: 06/04/06
Posts: 7904
Loc: Aberdeen, WA
That's normal. These fields are no longer stored in the ubbt_FORUMS table and are now a FORUM_PERMISSION setting so they can be applied on a per group basis.
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top
#211794 - 05/11/08 06:55 PM Re: createtables missing fields [Re: Rick]
budh Offline
stranger

Registered: 03/23/04
Posts: 17
Normal...

But in threads_import you have

$query = "insert into {$config['TABLE_PREFIX']}FORUMS
(FORUM_TITLE,FORUM_DESCRIPTION,FORUM_ALLOW_HTML,
FORUM_ALLOW_MARKUP,FORUM_CREATED_ON,FORUM_IS_MODERATED,
CATEGORY_ID,FORUM_TOPICS,FORUM_POSTS,FORUM_SORT_ORDER,
FORUM_DEFAULT_TOPIC_AGE,FORUM_IS_ACTIVE)
values
( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
";

Perhaps I'm using the wrong threads_import.

Top
#211795 - 05/11/08 07:25 PM Re: createtables missing fields [Re: budh]
Gizmo Moderator Online   sleepy

***

Registered: 06/04/06
Posts: 12008
Loc: Portland, OR; USA
I don't think the importers have been updated for 7.3 yet.
_________________________
UGN Security, Elite Web Gamers & VNC Web Design Owner
Longtime UBB Supporter, UBB7 Beta Tester & Resident Post-A-Holic

Top
#211838 - 05/12/08 06:19 AM Re: createtables missing fields [Re: Gizmo]
budh Offline
stranger

Registered: 03/23/04
Posts: 17
Obviously you must be correct.

It might be helpful if there was a version number for the threads_import script somewhere (on the members page, in the source file, etc.) Perhaps I missed it somewhere.

Top
#211893 - 05/12/08 01:09 PM Re: createtables missing fields [Re: budh]
Rick Administrator Offline

*****

Registered: 06/04/06
Posts: 7904
Loc: Aberdeen, WA
The importers should have been updated at the same time 7.3 was put into the Members Area. Will need to double check.
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top
#212170 - 05/14/08 06:06 AM Re: createtables missing fields [Re: Rick]
budh Offline
stranger

Registered: 03/23/04
Posts: 17
The changes required appear non-trivial. I'll have to postpone my upgrade.

Top
#212939 - 05/19/08 05:55 PM Re: createtables missing fields [Re: budh]
budh Offline
stranger

Registered: 03/23/04
Posts: 17
Thank you for today's update to the threads_import script. The forums and posts now import.

I've now made it down to the Moderator Permissions. The createtable script doesn't seen to build this table.

Top
#212940 - 05/19/08 06:06 PM Re: createtables missing fields [Re: budh]
Rick Administrator Offline

*****

Registered: 06/04/06
Posts: 7904
Loc: Aberdeen, WA
Need to make one more change to that. It's not that it isn't building the table, it's that the table insert is no longer needed.

Once you get to the moderator's part and it stops or errors, you can just change ubb=mods to ubb=buddies and it will continue fine.
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top


Shout Box

Today's Birthdays
kimteague_5@msn.com, Trekkie, Trixie
Recent Topics
Issue mass-emailing
by Mitch P.
Today at 12:55 PM
Inclusion of Locked/Closed thread capabilities
by QSS Tim
Today at 11:17 AM
Contact Page Problem
by David DelMonte
Today at 09:05 AM
FAQ bug,
by BreeOge
Today at 08:36 AM
I'm the Admin but.....
by David DelMonte
Yesterday at 11:12 AM
Forum Stats
4261 Members
33 Forums
30539 Topics
155016 Posts

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