| Author |
 Topic  |
|
Faizan
Average Member
United Kingdom
592 Posts |
 Posted - 10 February 2003 : 15:05:23
|
Thanks DJBBIZ
How do u get this country shown in
<--- This bar? I can't find it.
|
»Snitz Graphics
|
 |
|
|
DJBBIZ
Junior Member
214 Posts |
Posted - 10 February 2003 : 15:21:03
|
If you look closely on the ServerHacker version this information is in the bottom left hand corner of the post/reply rather than where it is located here. In version 9 it will have:
Alert Moderator | Country | Posts
in the bottom left hand corner. You can see this at www.shnforum.com or click the link on the right in my signature - Fiancial Principles & Strategies and go to any topic. |
"The difference between good ideas and good results is performance"
the management institute | tmiFinance | tmiCreative | ProfileOnDemand |
|
|
|
Faizan
Average Member
United Kingdom
592 Posts |
Posted - 10 February 2003 : 17:23:41
|
Oh yeah....I didn't notice...
Thanks |
»Snitz Graphics
|
|
|
|
steffan
Starting Member
11 Posts |
Posted - 07 March 2003 : 13:04:36
|
Hi i´ve problem with the Member Spotlight. I get this message:
ADODB.Recordset error '800a0bcd'
Entweder BOF oder EOF ist True, oder der aktuelle Datensatz wurde gelöscht. Der angeforderte Vorgang benötigt einen aktuellen Datensatz.
/forum7/forum/include/member_spotlight.asp, line 38
Thanks
Steffan
P.S.: Absolutely Cool Forum, Thanks to ALL.
|
|
|
|
steffan
Starting Member
11 Posts |
Posted - 07 March 2003 : 13:10:17
|
How do i set the Forum to be German or multiple languages? Can someone help me?
Thanks
Steffan |
|
|
|
steffan
Starting Member
11 Posts |
Posted - 07 March 2003 : 13:14:55
|
Sorry, one more time.
Here i got a failure in the Statistics:
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-3.23.54-nt]You have an error in your SQL syntax near '25 member_id, m_name, m_lastheredate FROM FORUM_MEMBERS ORDER BY M_LASTHEREDATE ' at line 1
/forum7/forum/member_stats.asp, line 262
Can somebody help me?
Thanks
Steffan
|
|
|
|
alex2k
Starting Member
1 Posts |
Posted - 12 March 2003 : 04:38:23
|
| Can I use it on Linux server with ChiliSoft ASP and MySQL? |
Regards,
Alex K. |
|
|
|
OneWayMule
Dev. Team Member & Support Moderator
Austria
4969 Posts |
|
|
wasim
Junior Member
USA
121 Posts |
Posted - 12 March 2003 : 23:34:26
|
a question...if i wanted to connect this new forum to my existing SQL server 2000 DB , what would the safest way to update my sql database? i know there are many new columns in 3.4 and in this mod such as active users.. i am currenty running 3.3.something. any advice would be appreciated.
|
|
|
|
DJBBIZ
Junior Member
214 Posts |
Posted - 12 March 2003 : 23:50:21
|
quote:
Originally posted by wasim
a question...if i wanted to connect this new forum to my existing SQL server 2000 DB , what would the safest way to update my sql database? i know there are many new columns in 3.4 and in this mod such as active users.. i am currenty running 3.3.something. any advice would be appreciated.
if you just hook the SH version to an old Snitz version, it will throw many errors. In addition there are many more tables to be created for all the additional mods which would also cause errors.
Go to the site www.shnforum.com and read through the SQL forum and the topics on upgrading in the help forums. Unfortunately their never seems to be an easy upgrade for something like this and because the SH forum is so knew, it was built on the latest platform, so there is not a lot of upgrade history to look back on.
I am using SQL 2000 on my forum but, I created a new install from the Access db by using the upsize feature. In addition you could try and use Enterprise Manager to export from the Access db to SQL Sever.
DJBBIZ
ServerHacker Moderator |
"The difference between good ideas and good results is performance"
the management institute | tmiFinance | tmiCreative | ProfileOnDemand |
|
|
|
wasim
Junior Member
USA
121 Posts |
Posted - 13 March 2003 : 01:19:03
|
hi hope someone can help me out...
i have no problems getting from access to sql server 2000...flawless upsize.
however..need to get lots of data from my 3.3.X forum to the new forum. i have set up a new database (upsized with serverhacker access database and the forum works fine)
what i need to do is know the options to follow in enterprise manager to bring data from my existing sql server 2000 database into the new database with all the new columns that are in this upgrade. what i do now it adds new tables such as active users, events etc..but for tables like FORUM_MEMBERS..it overwrites the ENTIRE table therefore leaving off new columns such as M_AVATAR etc.
can someone help with the steps in sql... for example
Copy Objects and data between SQL server databses>
then which combination of options in "select objects to copy" and so on.
thanks! |
Edited by - wasim on 13 March 2003 02:11:02 |
|
|
|
Bendro
Starting Member
Sweden
7 Posts |
Posted - 15 March 2003 : 10:02:50
|
I tried to upgrade to serverhacks moded version från a clean Snitz 3.4.
Running on a Linux server with ChiliASP and MySQL. What am I doing wrong?
Once I have copied the upgrade files into the directory I get this error when trying to enter Admin options:
----------------------------------------
ADODB.Recordset.1 error '80004005'
SQLState: S1000
Native Error Code: 1146
[TCX][MyODBC]Table 'bendro_net.FORUM_PM' doesn't exist
privatemess.asp, line 54
----------------------------------------
What do I do now? Can´t access Admin options and I am too much of a newbi to understand what I have done wrong. Appriciate any help I can get. |
|
|
|
PeeWee.Inc
Senior Member
United Kingdom
1893 Posts |
Posted - 15 March 2003 : 10:07:37
|
| Look in your DB and make sure the FORUM_PM table is there. |
De Priofundus Calmo Ad Te Damine |
|
|
|
PeeWee.Inc
Senior Member
United Kingdom
1893 Posts |
Posted - 15 March 2003 : 10:22:04
|
| also, did you run the DBS scripts? |
De Priofundus Calmo Ad Te Damine |
|
|
|
Bendro
Starting Member
Sweden
7 Posts |
Posted - 15 March 2003 : 13:21:19
|
The ones I have tried are dbsetup.asp and audbsetup.asp.
Have I missed any?
When trying dbsetup I get to database setup, but there are no mods in the dropdown list to choose from.
When trying audbsetup.asp I get to the forums starting page, but the error from above doesn´t give me any access to the Admin options, or any part of the site for that matter.
No the FORUM_PM table is not in the database, probably cuz I´ve missed something.
(sorry about the newbi level on the questions)
|
|
|
|
Topic |
|
Topic Locked
