| Author |
 Topic  |
|
|
Nepherim
Starting Member
12 Posts |
 Posted - 05 April 2002 : 23:20:47
|
Trying to install the Guestbook mod. I uploaded the files to my forum directory, and went selected Install from the MOD manager. All went well until:
Adding Column G_MESSAGE...
ALTER TABLE FORUM_GB_OPTIONS ADD COLUMN G_MESSAGE text NOT NULL DEFAULT 'Welcome to my Guestbook'
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in ALTER TABLE statement.
All statements after this failed. Full list of errors is: http://www.solidgone.com/guestbook-errors.html
Help is appreciated.
~ ~ David
|
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 06 April 2002 : 05:02:36
|
there's something no entirely right with this dbs file... could you post the code here?
Crash's Site | Crash is from 
|
 |
|
|
Nepherim
Starting Member
12 Posts |
Posted - 06 April 2002 : 13:21:27
|
I'm pretty new to this, so I'm not sure exactly which file you need to see -- I found no dbs files.
I've put all the guestbook script files that I uploaded to my server in http://www.solidgone.com/guestbook337.zip.
Let me know if this is not what you needed...
~ ~ David |
|
|
|
crash
Advanced Member
Netherlands
2064 Posts |
|
|
Nepherim
Starting Member
12 Posts |
Posted - 06 April 2002 : 19:57:55
|
Okay, I took a look at your new dbs file, and I see why the original was causing problems. I loaded up the new one and ran it, and still have problems: http://www.solidgone.com/guestbook-errors.html
It looks like the gb_options table gets dropped okay, but then a warning is displayed when trying to re-create gb_options indicating that for some reason it stills exists.
Question: what causes "forum_" to be prefixed to the commands in the dbs? Could it be that it's not correctly prefixing for either the drop or the create?
Thanks for helping...
~ ~ David
|
|
|
|
Nepherim
Starting Member
12 Posts |
Posted - 06 April 2002 : 20:00:45
|
Hmmm, well having re-read the error message it seems that the "forum" prefix is added correctly -- I'm still interested in knowing what it is that is processing the dbs file.
And now I have no idea what the problem is again...
~ ~ David |
|
|
|
crash
Advanced Member
Netherlands
2064 Posts |
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 06 April 2002 : 20:16:54
|
the thing that causes FORUM to be prefixed is hardcoded in the MOD manager. the variable strTablePrefix is set to FORUM_ in config.asp
Crash's Site | Crash is from
|
|
|
|
Nepherim
Starting Member
12 Posts |
Posted - 06 April 2002 : 22:32:09
|
Still getting a similar error: http://www.solidgone.com/ guestbook-error.html
To ensure that I was using your new version I changed the text of the G_T_Message field to 'NO THANKS!...'.
~ ~ David |
|
|
|
Nepherim
Starting Member
12 Posts |
Posted - 06 April 2002 : 22:43:21
|
I'm on AIM, as Nepherim if you have time/interest in helping that way. Either way, your help is appreciated -- nice site too btw!
~ ~ David |
|
|
|
crash
Advanced Member
Netherlands
2064 Posts |
Posted - 07 April 2002 : 02:55:31
|
unfortunately i don't have AIM here in Holland. can i have a look around on your site? the url's solidgone.com?
Crash's Site | Crash is from
|
|
|
|
Nepherim
Starting Member
12 Posts |
Posted - 07 April 2002 : 11:30:18
|
| I sent a response via e-mail Crash. |
|
|
|
Nepherim
Starting Member
12 Posts |
Posted - 07 April 2002 : 16:10:22
|
Well, I tried switching to a DSN connection in case that was the problem, but I get the same results.
What I tried doing was breaking the dbs file down:
- removed everything except the drops
- removed everything except the creates. Creates GUESTBOOK okay, complains that GB_OPTIONS already 'exists'! At this point I downloaded the DB and checked it out. What I see is that only GUESTBOOK exists. Changed the dbs to just create GB_OPTIONS -- continued to get table exists error. Double checked the DB, GB_OPTIONS is *not* there.
It just seems to be really confussed, thinking that GB_OPTIONS exists when trying to create it, and thinking it doesn't when dropping it, or trying to insert into it. Is some kind of caching involved here? Could the DB be corrupt (if so how do I go about correcting it)?
Since I'm a newbie here, I just want to verify that I check that a table exists by loading the MDB in Access and seeing an entry for the table under the Table tab. Sounds obviuos, but at this point I'm done with obvious...
~ ~ David
|
|
|
|
Nepherim
Starting Member
12 Posts |
Posted - 07 April 2002 : 16:26:09
|
Okay, it looks like the error is being mis-reported. The problem seems to be the syntax of the INT columns, rather than the table existing or not existing.
The format is G_V1_SWITCH#INT#NULL#. When I remove all INT columns from the GB_OPTIONS table, I get NO errors. I'm not sure what the correct syntax for INT columns is, and I couldn't find any docs on tis forum describing what it should be.
Nearly there...
~ ~ David |
|
|
|
Nepherim
Starting Member
12 Posts |
Posted - 07 April 2002 : 20:40:58
|
Okay, after hours of screwing around, I eventually ended up changing my connect string to use the Jet4.0 driver, rather than the Microsoft Access Driver.
So the question is since it seems not to work, why include it as an option in the config.asp...?
~ ~ David
|
|
|
| |
Topic |
|
Topic Locked
