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: MOD Implementation
 problems with avatar mod after conversion to mysql
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

sheridan
Starting Member

22 Posts

Posted - 09 May 2003 :  10:36:56  Show Profile
after the conversion from access to mysql a message error appears when users try to enter in My Avatar List ou Avatar Legends

when try to access Avatar Legends
ADODB.Recordset error '800a0cb3'
Current Recordset does not support bookmarks. This may be a limitation of the provider or of the selected cursortype.

/forum/pop_avatar_legend.asp, line 244

this line in pop_avatar_legend.asp
rs.absolutePage = myPage




when try to access My Avatar List
ADODB.Recordset error '800a0cb3'
Current Recordset does not support bookmarks. This may be a limitation of the provider or of the selected cursortype.

/forum/my_avatar.asp, line 489

this line in my_avatar.asp
rs.absolutePage = myPage




this recordset error appears in this topic, but not related with this mod. can i aplly this solution?

http://forum.snitz.com/forum/topic.asp?TOPIC_ID=41978

thanks

Sheridan

Edited by - ruirib on 09 May 2003 11:13:24

puzo
Junior Member

Israel
417 Posts

Posted - 09 May 2003 :  11:07:16  Show Profile  Visit puzo's Homepage
are you sure youve installed it correctly? if you did, perhaps your host has a problem with certain MS Access commands.


Go to Top of Page

sheridan
Starting Member

22 Posts

Posted - 09 May 2003 :  11:22:42  Show Profile
before the conversion the mod was fine. and i was dumb to put the forum on -line before complete the tests. my luck is this mod is the only one with errors.
i read in the post i commented this error appears because a counting records problems. and the guy resolved creating a RS solely for this purpose. but i don´t know how to do this...

my host is a linux, what i have do ask to my provider???

thanks

Edited by - sheridan on 09 May 2003 11:24:28
Go to Top of Page

DoraMoon
Average Member

Taiwan
661 Posts

Posted - 09 May 2003 :  17:00:58  Show Profile
hi~ sheridan,

obviously, it's a problem cause from my mod code did'nt compatible with MySQL..
sorry for this.. i really know nothing about MySQL..

and i try the ruirib's solution by above link.. i also take a reference to snitz code..
i think it may just the different way to get the maxPages page count, also found there are many place have '# MySql specific code in snitz's code.....

so here is an attempt to fix for MySQL... my_avatar_addon-MySQL_fix.zip

and of course, i can't test these fixed "MySql specific code"...
also not very understand what those code meaning... just borrow the similar one from another snitz file ~~

so please try it.. and if still not work, you may need to post a new thread in "MySQL forum" to ask someone other can help you.
Go to Top of Page
  Previous Topic Topic Next Topic  
 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.27 seconds. Powered By: Snitz Forums 2000 Version 3.4.07