Author |
Topic |
|
NiteOwl
Junior Member
Canada
403 Posts |
Posted - 28 January 2005 : 22:27:26
|
Snits 3.4.05 MySQL 3.51
I had the following error when updating the database, any suggestions what or if I need to take action?:
Adding Column M_AUHIDE... ALTER TABLE FORUM_MEMBERS ADD M_AUHIDE varchar(1) NULL Column added successfully Adding Column M_AUHIDE... ALTER TABLE FORUM_MEMBERS ALTER COLUMN M_AUHIDE varchar(1) NULL ALTER TABLE FORUM_MEMBERS ALTER COLUMN M_AUHIDE varchar(1) NULL -2147217900 | [MySQL][ODBC 3.51 Driver][mysqld-4.0.15-nt]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 'varchar(1) NULL' at line 1
|
-=NiteOwl=-
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 29 January 2005 : 07:26:15
|
Even though you got an error, it might have been added correctly. Can you take a look in the FORUM_MEMBERS table and check if the M_AUHIDE was added and altered? |
Jan =========== FR Portal Forums | Active Users 4.0.20 Mod |
|
|
UnderRated
Starting Member
Portugal
39 Posts |
Posted - 15 February 2005 : 15:01:20
|
I am having a problem with my active users MOD.
Snits 3.4.05 SQL server
www.underratedteam.com/talk/default.asp user name: test password: test
Can someone help me with this.
Also, if you look at the background color it is diferent from the rest of the page. how can i fix this. |
Edited by - UnderRated on 15 February 2005 17:02:31 |
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 16 February 2005 : 14:18:14
|
UnderRated, you seem to have missed adding which language file you want to use in LangMODS_Ls3kAU4.asp.
The color problem comes from a mod that you have added to your forum (the skin-mod, I think). You have to apply similar changes to inc_activeusers.asp that you did to default.asp. That should fix the color problem. |
Jan =========== FR Portal Forums | Active Users 4.0.20 Mod |
|
|
UnderRated
Starting Member
Portugal
39 Posts |
Posted - 16 February 2005 : 16:37:02
|
that's the thing, i got this forum with some mod already installed and i just added the active users mod and the Private message mod. i followed the instructions for both mods but the skin mod came with the forum so what do I do? |
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 16 February 2005 : 17:26:16
|
Ok. Do you have any documention with the forum, or did you get forum "as is"? CSS isn't my area, so Im not able to help you there.
As for the AU-mod, it seems as if you missed a few instructions. Did you check LangMODS_Ls3kAU4.asp as I asked you to? If you only want to use english, you only need the following line after %> in that file:
<!--#INCLUDE FILE="LangMODS_Ls3kAU4_1033.asp" -->
Also make sure that you have uploaded that file. |
Jan =========== FR Portal Forums | Active Users 4.0.20 Mod |
|
|
UnderRated
Starting Member
Portugal
39 Posts |
Posted - 16 February 2005 : 18:37:30
|
just did that still not working i had it working before i installed the new version of the site, and now it doesn't work. I'm lost |
|
|
NiteOwl
Junior Member
Canada
403 Posts |
Posted - 16 February 2005 : 23:14:04
|
Sorry for the delay masterao, I have checked and the M_AUHIDE is there!
However it dod not populate VARCHAR(1) but rather only CHAR(1) is that ok? or should I change it?
|
-=NiteOwl=-
|
Edited by - NiteOwl on 16 February 2005 23:16:40 |
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 17 February 2005 : 14:01:42
|
quote: Originally posted by NiteOwl
Sorry for the delay masterao, I have checked and the M_AUHIDE is there!
However it dod not populate VARCHAR(1) but rather only CHAR(1) is that ok? or should I change it?
No, CHAR(1) should work ok as that is what I have too. It will only contain one character, so it will not be an issue.
quote: Originally posted by UnderRated
just did that still not working i had it working before i installed the new version of the site, and now it doesn't work. I'm lost
I noticed that I mentioned the wrong file earlier. It should be in LangMODS_Ls3kAU4.asp, and not LangMODS_Ls3kAU4_1033.asp. In any case, I checked your site again and I noticed that it looks ok now. I guess that you found out what was missing. |
Jan =========== FR Portal Forums | Active Users 4.0.20 Mod |
|
|
UnderRated
Starting Member
Portugal
39 Posts |
Posted - 17 February 2005 : 16:58:04
|
Yes masterao, i totaly changed it and solve all the problems it had apart form one. The upload MOD. it keeps giving me this message
file create, write, and read failed! Please check the permissions on your folder e:\InetPub\Clients\underratedteam.com\talk\uploaded!
what to do? |
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 17 February 2005 : 18:24:53
|
Im glad to hear that you solved the AU-problems. As for the upoad-mod problems, you should post a new topic about that in this forum. |
Jan =========== FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
Topic |
|