| Author |
 Topic  |
|
|
505_medic
New Member
USA
54 Posts |
 Posted - 17 December 2005 : 16:30:08
|
Error Message:
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[MySQL][ODBC 3.51 Driver][mysqld-5.0.15-nt]Table 'seehawk98.forum_active_users' doesn't exist
/forums/inc_func_common.asp, line 57
I have attempted to repost the Inc Func Common thread...
code removed by ruirib - Please do not post large amounts of code, they are pretty useless like this. If you need to post them, please post them as a link to a text file.
-Edit: Sorry about that.
Jon
And it still doesn't work. Does anyone have an idea on what I could have done wrong on this? Thanks...
Jon |
http://www.silent-knights.com/forums
Mods Utilized: Active Users 4.0, Customized Icons, Customized Ranks, Private Messaging, Split Topics, IP Search, Custom Policy, Custom FAQ |
Edited by - 505_medic on 17 December 2005 17:34:07 |
|
|
laser
Advanced Member
Australia
3859 Posts |
Posted - 17 December 2005 : 16:38:42
|
| Did you run MOD Setup first ? |
 |
|
|
505_medic
New Member
USA
54 Posts |
Posted - 17 December 2005 : 17:25:43
|
I feel really stupid. I accidentally uploaded a couple of the edited files in with the others.
When I ran it the correct method (after replacing one..).
Running it the proper way, I did get an error message:
quote:
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-5.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
I have no idea what is causing this.
Jon
|
http://www.silent-knights.com/forums
Mods Utilized: Active Users 4.0, Customized Icons, Customized Ranks, Private Messaging, Split Topics, IP Search, Custom Policy, Custom FAQ |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 18 December 2005 : 12:59:59
|
| It is possible that the change was successfully made even though you received an error msg. Do you have a tool to view your mysql-db? If so, check the table forum_members and see if M_AUHIDE isn't there already. The error msg comes from trying to change the column M_AUHIDE. If you didn't have the column before, it should have been added correctly when you ran the dbs. |
Jan
===========
FR Portal Forums | Active Users 4.0.20 Mod |
|
|
|
505_medic
New Member
USA
54 Posts |
Posted - 19 December 2005 : 22:39:08
|
Its working fine now. Ruirib helped out, so whether it was him or just a goof...I'm not sure.
Jon |
http://www.silent-knights.com/forums
Mods Utilized: Active Users 4.0, Customized Icons, Customized Ranks, Private Messaging, Split Topics, IP Search, Custom Policy, Custom FAQ |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
|
|
sikandar
Junior Member
Pakistan
135 Posts |
Posted - 17 March 2006 : 01:52:25
|
Forum setup has been completed.
Congratulations!!
The forum setup has been completed successfully.
You can now start using Snitz Forums 2000.
If you have questions or remarks you can visit us at: http://forum.snitz.com
You can also post the address of your forum there
so others can come and visit you.
Click here to go to the forum.
Upgrade the database.
(shouldn't be needed for this database!)
Create the database tables.
(shouldn't be needed for this database!)
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E37)
[MySQL][ODBC 3.51 Driver][mysqld-4.1.7]Table 'mysql.FORUM_ACTIVE_USERS' doesn't exist
/forum/inc_func_common.asp, line 424
Please let me know what should I do here to overcome this error. How I can proceed? |
|
|
|
masterao
Senior Member
Sweden
1678 Posts |
|
| |
Topic |
|
Topic Locked
