| Author |
 Topic  |
|
cripto9t
Average Member
USA
881 Posts |
 Posted - 27 February 2008 : 17:18:33
|
quote:
Originally posted by weeweeslap
if by db set file you mean the dbs file
No, in "admin options > User Space Configuration" there's a link "Feature Set Up" to set up the feature tables.
I wrote it because Mod Setup doesn't allow for index fields other
than identity. (That would be a good mod for someone  ).
Anyway glad you got it working. I'll give the dbs file a look, maybe I didn't try is with mssql.
< |
_-/Cripto9t\-_ |
 |
|
|
weeweeslap
Senior Member
USA
1077 Posts |
Posted - 27 February 2008 : 17:26:57
|
| Oh that, yes I used that but for some reason something wasn't going right for the bookmarks add on. Friends one went on just fine.< |
coaster crazy |
|
|
|
leatherlips
Senior Member
USA
1838 Posts |
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 02 March 2008 : 09:22:33
|
No idea, I haven't had any feedback on access. The basic feature "User Posts" only adds 4 fields to the "config_new" table.
You could hardcode them on the user_space page to test that feature without changes to the database.
Something like this
Const strUSSwitch = 1
Const strUSPostSwitch = 1
Const strUSPostMaxSwitch = 1
Const strUSPostMax = 50 < |
_-/Cripto9t\-_ |
|
|
|
leatherlips
Senior Member
USA
1838 Posts |
Posted - 15 April 2008 : 11:21:20
|
I tried installing this using Access Database. I made the changes to my files
but when it came time for the database here is what I see:
User Space
Adding new records..
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES
('STRUSSWITCH',1)
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES
('STRUSPOSTSWITCH',1)
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES
('STRUSPOSTMAXSWITCH',1)
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES
('STRUSPOSTMAX',30)
Value(s) updated successfully
------------------------------
Database setup finished
Then when I go back to User Space Configuration it says this:
Database Needs Updated!
Run User Space Setup in Mod Setup.
It's as if I didn't do anything.
Any ideas how to get this to work with Access?
I would really like to try to use this mod as it looks pretty good.< |
Mangione Magic Forum - The Music of Chuck Mangione
My Mods: Googiespell MOD | Link To Reply MOD | Petition MOD | Contact Page MOD | Share This Topic MOD | MP3 MOD | PageEar MOD | Google Viewer MOD |
Edited by - leatherlips on 15 April 2008 11:25:21 |
|
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 15 April 2008 : 13:54:39
|
That means it can't find STRUSSWITCH, but your setup says it was added.
I've had problems like this before. I think it has something to do with the session.
Try logging off and and closing your session.
Then start another session and log back in.
After that look at "forum variables" in "admin options" and see if STRUSSWITCH listed.
< |
_-/Cripto9t\-_ |
Edited by - cripto9t on 15 April 2008 13:55:46 |
|
|
|
leatherlips
Senior Member
USA
1838 Posts |
|
|
leatherlips
Senior Member
USA
1838 Posts |
|
|
leatherlips
Senior Member
USA
1838 Posts |
|
|
leatherlips
Senior Member
USA
1838 Posts |
Posted - 15 April 2008 : 16:05:03
|
When I run the database setup file here is the message:
Bookmarks
Creating table(s)...
CREATE TABLE FORUM_BOOKMARKS( BOOKMARK_ID int IDENTITY (1, 1) PRIMARY KEY NOT NULL , B_MEMBER int (11) NOT NULL DEFAULT 0, B_URL text (255) NULL DEFAULT '', B_TITLE text (100) NULL DEFAULT '', B_CAT text (100) NULL DEFAULT '', B_DATE text (14) NULL DEFAULT '')
Table already exists
--------------------------------------------------------------------------------
Adding new records..
INSERT INTO FORUM_CONFIG_NEW (C_VARIABLE,C_VALUE) VALUES ('STRUSBOOKMARKSWITCH',1)
Value(s) updated successfully
--------------------------------------------------------------------------------
Database setup finished< |
Mangione Magic Forum - The Music of Chuck Mangione
My Mods: Googiespell MOD | Link To Reply MOD | Petition MOD | Contact Page MOD | Share This Topic MOD | MP3 MOD | PageEar MOD | Google Viewer MOD |
Edited by - leatherlips on 15 April 2008 16:05:32 |
|
|
|
leatherlips
Senior Member
USA
1838 Posts |
|
|
Carefree
Advanced Member
Philippines
4207 Posts |
Posted - 16 April 2008 : 02:04:18
|
Everyone is having to manually create the table using Access, the table's title is "FORUM_BOOKMARKS". Within that table,
Column 1 "BOOKMARK_ID", set to autonumber.
Column 2 "B_MEMBER", set to integer (not long integer), the format should be 11, the number of decimal points should be 0.
Column 3 "B_URL", set to text, length 255.
Column 4 "B_TITLE", set to text, length 100.
Column 5 "B_CAT", set to text, length 100.
Column 6 "B_DATE", set to text, length 14.
Save.
If you tried to run the dbs file more than once, you'll need to remove the additional lines from the "FORUM_CONFIG_NEW" table. Open it up and look at the very end. If you have more than one entry "STRUSBOOKMARKSWITCH", delete all but one.
Save.
Exit Access. Do not rerun the dbs file but go ahead and use bookmarks.< |
|
|
|
leatherlips
Senior Member
USA
1838 Posts |
|
|
cripto9t
Average Member
USA
881 Posts |
Posted - 16 April 2008 : 09:50:07
|
I once had a similar issue (not with this mod), using mod setup to create a table, with mysql.
I even tryed renaming the table and was still told "table already exists"?!?!
I couldn't even create it manually until I dropped it.
I don't know why the dbs files arn't working with access.
I tested them with mysql and ms sql with no problems.
< |
_-/Cripto9t\-_ |
|
|
|
leatherlips
Senior Member
USA
1838 Posts |
|
|
Topic |
|
User Space 1.1.02 (last update 02/14/08)
<