Author |
Topic |
rabufo
Junior Member
Italy
328 Posts |
Posted - 06 April 2002 : 06:24:47
|
no answers to my question about Event working for 3.3.03 let me understand that it's not possible....truly a pity.....Doesn't exist a Link manager working on Snitz 3.3.03 also?
Thank you |
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 06 April 2002 : 07:43:03
|
Link Manager 2 works great with 3.3.03, altough I dont use it as a link manager. I use it it to handle articles instead.
I dont use the pages which goes into default.asp, but they should work also.
Master AO =========== FR Portal |
|
|
rabufo
Junior Member
Italy
328 Posts |
Posted - 06 April 2002 : 08:32:49
|
thank you very much, happy to hear that....anyway, please let me overwork your kindness I've just tried to install the mod like said in the readme file, directly running http://www.awforum.net/prova/links_mod_dbsetup.asp ....but I've received error messages (like the one below) to any attempt of the file to create table and adding columns and records
-2147217900 | [Microsoft][ODBC Microsoft Access Driver] Syntax error in CREATE TABLE statement.
Of course when I've tried to run the file links.asp I've received this : Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'links_categories'. Make sure it exists and that its name is spelled correctly.
/prova/links.asp, line 25
Any suggestions? Did the same happen to you? I'm using the last version of admin_mod_dbsetup.asp file |
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 06 April 2002 : 08:54:18
|
I renamed links_mod_dbsetup.dbs to dbs_linkmod.asp and ran it through the Mod Setup in the admin area.
I added a blank line between the title in the dbs-file and the first [create] statement. I dont think I had to change anything else.
Master AO =========== FR Portal |
|
|
rabufo
Junior Member
Italy
328 Posts |
Posted - 06 April 2002 : 09:25:03
|
>I added a blank line between the title in the dbs-file and the first >[create] statement.
do you mean in the dbs_linkmod.asp file? Where exactly?
I tried to do as you kindly suggested...but it doesn't work...the name of dbs file doesn't appear in the MOD set up field.......maybe I'm asking to much, please apologize me....but can you post to me a .txt version of the dbs_linkmod.asp you used? I'll be very gratefull to you...
|
|
|
rabufo
Junior Member
Italy
328 Posts |
Posted - 06 April 2002 : 10:18:05
|
I realized that it was the file link.dbs to be renamed in dbs_linkmod.asp, right? I've done and run it in MOD set up.....adding the blank line where you suggested..... all went OK......but running the links.asp file I've received this error
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'links_categories'. Make sure it exists and that its name is spelled correctly.
/prova/links.asp, line 25
the line 25 is the last of these four ones:
strSql = "select * from links_categories order by cat_name" dim rsCategories set rsCategories = server.CreateObject("adodb.recordset") rsCategories.Open strSql, my_Conn
Anyway, when installing I've received no error msg regarding cration of table and records...... what can I do???
Thank you very much for any help....
Edited by - rabufo on 06 April 2002 10:29:20 |
|
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 06 April 2002 : 11:03:29
|
You must change all referenses to the tables links, links_categories, links_subcategories, and links_ratings to forum_links, forum_links_categories, forum_links_subcategories, and forum_links_ratings in the select-cases
quote:
Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
[Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'links_categories'. Make sure it exists and that its name is spelled correctly.
/prova/links.asp, line 25
the line 25 is the last of these four ones:
strSql = "select * from links_categories order by cat_name" dim rsCategories set rsCategories = server.CreateObject("adodb.recordset") rsCategories.Open strSql, my_Conn
In the example you provided, it should be as follows (additions in red):
strSql = "select * from forum_links_categories order by cat_name" dim rsCategories set rsCategories = server.CreateObject("adodb.recordset") rsCategories.Open strSql, my_Conn
These should be the only changes you need to make, in order to get it to work.
Master AO =========== FR Portal |
|
|
rabufo
Junior Member
Italy
328 Posts |
Posted - 06 April 2002 : 12:16:08
|
IT WORKS!!!!! thank you so much!!!! by the way....do you know if Event mod can work in 3.3.03 editing it in a similar way??? |
|
|
@tomic
Senior Member
USA
1790 Posts |
|
masterao
Senior Member
Sweden
1678 Posts |
Posted - 06 April 2002 : 16:00:38
|
Im glad you got the links manager working.
I dont use the Event mod, so I dont know. But as @tomic said, it should work fine.
Master AO =========== FR Portal |
|
|
milki
Junior Member
Israel
320 Posts |
Posted - 06 April 2002 : 23:10:57
|
wahr can i find a link to links manager that works to 3.3.03 i have tried to install one but it didnt work ... i need somthing that will work on my forum ... tanks mans
|
|
|
rabufo
Junior Member
Italy
328 Posts |
Posted - 07 April 2002 : 03:52:10
|
milki, I'm working on it..when I'll finish I'll be happy to post all edited files working on 3.3.03...currently I'm having some probs with the add_links_url.asp file, I receive this error
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] The field 'forum_links.RATING' cannot contain a Null value because the Required property for this field is set to True. Enter a value in this field.
/prova/links_add_url.asp, line 77
I've probably made some error in change some LINKS in FORUM_LINKS, searching for it... |
|
|
rabufo
Junior Member
Italy
328 Posts |
Posted - 07 April 2002 : 03:53:36
|
quote:
The Event MOD should work just fine.
oh really??? I was not been able to make it work........can you give any suggestions on how and which files must be edited?
Thank you |
|
|
@tomic
Senior Member
USA
1790 Posts |
Posted - 07 April 2002 : 05:06:21
|
I don't recall it needing any editing. I got it working on a site running 3.3.03 in minutes. What exactly is the error you are getting and where are you trying to put it?
@tomic
http://www.skepticfriends.org |
|
|
rabufo
Junior Member
Italy
328 Posts |
Posted - 07 April 2002 : 06:33:58
|
quote:
I don't recall it needing any editing.
you right, atomic. I re-installed it renaming the mod file in dbs_ and now it works wonderfully
thank you |
|
|
rabufo
Junior Member
Italy
328 Posts |
Posted - 07 April 2002 : 06:56:36
|
quote:
Im glad you got the links manager working.
masterao, sorry to disturb you again....maybe I've talked too much soon I've checked and rechecked all editings, and all seems ok....but when I try to add a new url I receive this error msg:
[Microsoft][ODBC Microsoft Access Driver] The field 'forum_links.RATING' cannot contain a Null value because the Required property for this field is set to True. Enter a value in this field.
/prova/links_add_url.asp, line 77
The line 77 is the last of these ones below:
strSQL = "insert into forum_links (name, url, keyword, category, description, email, banner_url, post_date, parent_ID, show, badlink)" strSQL = strSQL & " values" strSql = strSQL & "('" & chkString(name, "SQLString") & "', '" & url & "', '" & chkString(key, "SQLString") & "', '" & cat & "', '" & chkString(description, "SQLString") & "', '" & chkString(email, "SQLString") & "', '" & banner & "', '" & today & "', '" & parent & "', 0, 0)" my_Conn.Execute (strSQL)
Please help...any idea about the bugs???
THANK YOU |
|
|
Topic |
|