| Author |
 Topic  |
|
|
cybliminal
Starting Member
7 Posts |
 Posted - 18 June 2008 : 14:25:11
|
Greetings fellow code diver (hopefully more experienced than me)
I have installed Links Manager 3 Beta 2, on my 3.4.06 forum, and while accessing "links.asp" and "links.asp?action=submit" works OK, trying to see the New links (links.asp?action=new), Popular links (links.asp?action=popular), Top Rated (links.asp?action=toprated) and even getting to the admin page (admin_Links.asp) gives me the following (slightly varying - line 445 is constand) SQL syntax error for all links.asp calls:
--------------------
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-5.0.37-community-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 'SHOW=1 ORDER BY POST_DATE DESC, NAME DESC LIMIT 15' at line 1
/forum/inc_func_links.asp, line 445
-------------------
admin_Links.asp returns the following:
-------------------
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[MySQL][ODBC 3.51 Driver][mysqld-5.0.37-community-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 'SHOW=0' at line 1
/forum/admin_Links.asp, line 584
-------------------
The MySQL version the site runs on is 4.1.22
Any help and/or hints would be greatly apreciated!
< |
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 18 June 2008 : 14:39:06
|
| If memory serves, I think "SHOW" is a reserved word in MySQL. I do remember that the recipe MOD - which is based on the Links Manager - had some issues with MySQL and reserved words. It would probably be worth while to find the thread that dealt with that issue as it will at least give a clue as to where to go next.< |
 |
|
|
cybliminal
Starting Member
7 Posts |
Posted - 19 June 2008 : 05:18:13
|
Thanx again
You are right, SHOW is a reserved word in MySQL, and this should be the prob.
So I'm changing it now in the db to something unique (and not reserved), and I'll try to locate it in the MOD files and change it there too.
Hope this will set things right.< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
cybliminal
Starting Member
7 Posts |
Posted - 20 June 2008 : 13:43:02
|
ruirib thanks for the tip, I would appreciate it if you could explain a bit further.
The way I've managed to implement the mod with MySQL, for now is as follows:
- I changed "SHOW" in the db setup (dbs_links.asp) to "LM_SHOW" (any unique none Mysql reserved name will work)
- Then I ran the dbs_links.asp so that db setup would create all tables successfuly (otherwise it fails creating the forum_links table)
- Afterwards I found all "SHOW" references (and a couple of "show") in the 4 asp pages of the mod and changed them to LM_SHOW aswell
That's it hope this helps someone struggling with the mod till a final version is released.
Oh, I also if you can not get the links description to be displayed, you can do the following to sort this out:
in inc_func_links.asp (approx. lines 187-189)look for:
Set trs = my_conn.execute(strsql)
TmpStr = ""
TmpStr = TmpStr & "<br/><li>"
and replace it with
Set trs = my_conn.execute(strsql)
strLinkDesc = trs("DESCRIPTION")
TmpStr = ""
TmpStr = TmpStr & "<br/><li>"
AND Then find the following code (approx. lines 239-243):
If strLMShowDesc = 1 Then
If trim(trs("DESCRIPTION")) <> "" Then
TmpStr = TmpStr & " <br />" & formatStr(trs("DESCRIPTION")) & vbNewLine
End If
End if
replace with
If strLMShowDesc = 1 Then
If trim(strLinkDesc) <> "" Then
TmpStr = TmpStr & " <br />" & formatStr(strLinkDesc) & vbNewLine
End If
End if
Only remaining problem is when running a Links search I get the following:
-------------------------------
ADODB.Recordset error '800a0cb3'
Current Recordset does not support bookmarks. This may be a limitation of the provider or of the selected cursortype.
/forum/links.asp, line 326
-------------------------------< |
Edited by - cybliminal on 20 June 2008 13:44:44 |
|
|
|
modifichicci
Average Member
Italy
787 Posts |
|
|
cybliminal
Starting Member
7 Posts |
Posted - 21 June 2008 : 07:38:59
|
modifichicci thank you very, very much!
MOD works perfectly now.< |
|
|
|
janudara
Starting Member
India
4 Posts |
Posted - 24 August 2008 : 12:10:48
|
Hello friend!!!, Can anyone post this mod working with mssql database.Original mod only works with access database & i am not so experianced to do the req. changes myself.
Plase help & thanks in advance.I am sure someone will post it for me.< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
janudara
Starting Member
India
4 Posts |
Posted - 24 August 2008 : 12:40:19
|
Thanks a lot for the quick reply.Can you suggest any directory mod working with snz forum?
Thanka again.< |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
Carefree
Advanced Member
Philippines
4222 Posts |
Posted - 24 August 2008 : 13:21:02
|
quote:
Originally posted by janudara
Thanks a lot for the quick reply.Can you suggest any directory mod working with snz forum?
Thanka again.
What did you need the directory mod to do?< |
|
|
| |
Topic |
|
Topic Locked
