Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MySql
 Microsoft OLE DB Provider for ODBC Drivers error '
 New Topic  Topic Locked
 Printer Friendly
Next Page
Author Previous Topic Topic Next Topic
Page: of 2

tomasalsbro
Average Member

Sweden
818 Posts

Posted - 19 December 2009 :  11:49:03  Show Profile  Visit tomasalsbro's Homepage
Hi,
I'm a little bit lost.
After importing my discussion folder back to my web site, I reciewed following error:
----------------------
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'

[MySQL][ODBC 3.51 Driver][mysqld-5.0.24a-standard-log]Table 'user_snitz.forum_config_new' doesn't exist

/diskussion/inc_func_admin.asp, line 48
----------------------

What did I wrong?

Thanks / Tomas

!-Keep distance in traffic-!
www.whiplashinfo.se

Edited by - tomasalsbro on 19 December 2009 11:51:00

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 19 December 2009 :  13:35:39  Show Profile  Send ruirib a Yahoo! Message
Probably you haven't configured your connection string properly.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

tomasalsbro
Average Member

Sweden
818 Posts

Posted - 20 December 2009 :  12:16:10  Show Profile  Visit tomasalsbro's Homepage
OK, I imported a backup version of my config.asp and default.asp, with the result that the board asked me to create all tables..?
------------------------
Installation of forum-tables in the database.

Database Type: MySQL

To install the tables in the database you need to create the empty database on the server first. Then you have to provide a username and password of a user that has table creation/modification rights at the database you use. This might not be the same user as you use in your connectionstring !

Name:
Password:

Forum Admin UserName/Password:

Here you will choose the Forum Admin UserName & Password that will be entered into the database for the Forum Admin. The password should be something that you can remember, but not something easily guessed by anyone else. Size limit is 25 characters.

Username:
Password:
Password Again:
------------------------

I don't understqand this as the data base still exists. The only thing I have done is to drop some tables made by a mod (captcha) whitch didn't work with my version of forum.

Thanks / Tomas


!-Keep distance in traffic-!
www.whiplashinfo.se
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 20 December 2009 :  13:01:58  Show Profile  Send ruirib a Yahoo! Message
Hmmm... did you drop the forum_config_new table?


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

tomasalsbro
Average Member

Sweden
818 Posts

Posted - 21 December 2009 :  12:52:02  Show Profile  Visit tomasalsbro's Homepage
quote:
Originally posted by ruirib

Hmmm... did you drop the forum_config_new table?


Not what I'm aware of..


!-Keep distance in traffic-!
www.whiplashinfo.se
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 21 December 2009 :  13:21:36  Show Profile  Send ruirib a Yahoo! Message
Better check it, as the forum code is missing it.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts

Posted - 21 December 2009 :  13:23:20  Show Profile  Visit HuwR's Homepage
does the forum use the same user sql user to create the tables as it does to run the forum
Go to Top of Page

tomasalsbro
Average Member

Sweden
818 Posts

Posted - 21 December 2009 :  14:05:40  Show Profile  Visit tomasalsbro's Homepage
quote:
Originally posted by HuwR

does the forum use the same user sql user to create the tables as it does to run the forum



??? - Sorry Huw, I haven't got the skill to quite understand your question.

As far as I'm aware, I just have one data base, if that's what you ment.

Thanks / Tomas

!-Keep distance in traffic-!
www.whiplashinfo.se
Go to Top of Page

tomasalsbro
Average Member

Sweden
818 Posts

Posted - 22 December 2009 :  05:48:14  Show Profile  Visit tomasalsbro's Homepage
I looked at the data base and found this:

forum_a_reply
forum_a_topics
forum_allowed_members
forum_badwords
forum_category
forum_forum
forum_group_names
forum_groups
forum_members
forum_members_pending
forum_moderator
forum_namefilter
forum_reply
forum_spam_mail
forum_subscriptions
forum_topics
forum_totals

I guess there should be a "forum_config" as well or...?

Tomas

!-Keep distance in traffic-!
www.whiplashinfo.se
Go to Top of Page

AnonJr
Moderator

United States
5768 Posts

Posted - 22 December 2009 :  07:40:17  Show Profile  Visit AnonJr's Homepage
There should also be a forum_config_new
Go to Top of Page

tomasalsbro
Average Member

Sweden
818 Posts

Posted - 22 December 2009 :  11:57:25  Show Profile  Visit tomasalsbro's Homepage
quote:
Originally posted by AnonJr

There should also be a forum_config_new



Japp - I figured this out reading a little more about the database.

I have asked my host to install a baclup of the database.

Tomas

!-Keep distance in traffic-!
www.whiplashinfo.se
Go to Top of Page

tomasalsbro
Average Member

Sweden
818 Posts

Posted - 30 December 2009 :  04:10:20  Show Profile  Visit tomasalsbro's Homepage
Due to a miss at my web host provider they cdon't have any accurat backup of the data base.

The oldest is to new and contain the missing tables.

What can and should I do?

Happy New Year!

Tomas

!-Keep distance in traffic-!
www.whiplashinfo.se
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 30 December 2009 :  10:58:04  Show Profile  Send ruirib a Yahoo! Message
You will have to get a table to replace the lost one, no other way around it. Probably get one from a clean 3.4.07 forum and use it.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

tomasalsbro
Average Member

Sweden
818 Posts

Posted - 30 December 2009 :  18:57:34  Show Profile  Visit tomasalsbro's Homepage
quote:
Originally posted by ruirib

You will have to get a table to replace the lost one, no other way around it. Probably get one from a clean 3.4.07 forum and use it.



OK, I got one. I tryed to import it as a plain txt-file, but got a error message. I'm not sure if I should import the first row - the one with the table name or..?

Tomas

!-Keep distance in traffic-!
www.whiplashinfo.se
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 30 December 2009 :  21:53:59  Show Profile  Send ruirib a Yahoo! Message
You mean an SQL file?


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

tomasalsbro
Average Member

Sweden
818 Posts

Posted - 31 December 2009 :  05:29:39  Show Profile  Visit tomasalsbro's Homepage
Yes, I entered the phpMyAdmin and tryed to import FORUM_CONFIG_NEW.txt

This was what I thought was the right thing to do, but I have no experieces at all working with data bases.

Under the subject Import I fetched the .txt file, used utf8 asa caracter statement, under the subject Partiel Import I entered 0 posts (lines) to jump over (ignore(?)). Under Format At The Imported File SQL was marked and SQL-compability = NONE

The eeror message was:
-------------
Error
SQL-question:

"ID";



MySQL sa:

#1064 - 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 '"ID"' at line 1
-------------


Tomas



!-Keep distance in traffic-!
www.whiplashinfo.se
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Next Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.18 seconds. Powered By: Snitz Forums 2000 Version 3.4.07