quote:

---

Originally posted by modifichicci

Read this:
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=60194

---

quote:

---

Originally posted by modifichicci

I don't know that code, but check if you have a
rs.CursorLocation = adUseClient
before the rs.open command

---

quote:

---

Originally posted by jeeper

quote:

---

Originally posted by modifichicci

I don't know that code, but check if you have a
rs.CursorLocation = adUseClient
before the rs.open command

---

here's the full code.

<% '## Forum_SQL - Get Games from DB
Dim my_Conn
strSql = "SELECT " & strTablePrefix & "games.id"
strSql = strSql & ", " & strTablePrefix & "games.imageurl"
strSql = strSql & ", " & strTablePrefix & "games.name"
strSql = strSql & ", " & strTablePrefix & "games.display"
strSql = strSql & ", " & strTablePrefix & "games.gameurl"
strSql = strSql & " FROM " & strTablePrefix & "games "
strSql = strSql & " WHERE " & strTablePrefix & "games.display = '1' "
strSql = strSql & " ORDER BY " & strTablePrefix & "games.name ASC;"
set rs = Server.CreateObject("ADODB.Recordset")
rs.cachesize = 20
rs.open strSql, my_Conn, 3
if rs.EOF or rs.BOF then '## No replies found in DB
%>

If I remove the ,3 - then I get this error
Error: Microsoft OLE DB Provider for ODBC Drivers error '80040e37'
Table 'airzona.FORUM_games' doesn't exist

---

quote:

---

Originally posted by modifichicci

Put this line:

rs.CursorLocation = adUseClient

just before:

rs.open strSql, my_Conn, 3

Try and say something

---

quote:

---

-2147217865 | Table 'airzona.FORUM_GAMES' doesn't exist

---

quote:

---

Originally posted by Classicmotorcycling

Have a look at the error that jeeper is getting:

quote:

---

-2147217865 | Table 'airzona.FORUM_GAMES' doesn't exist

---

The dbs file is not creating the table. Can point me as to where you got the mod from and I will have a look at it and advise as to why the table is not being created from the dbs...

---

[DROP]
games
[END]

[DROP]
GAMES
[END]
[CREATE]
GAMES
ID
imageurl#varchar (100)#NULL#
name#varchar (50)#NULL#
gameurl#varchar (100)#NULL#
display#varchar (1)#NULL#
[END]

[INSERT]
GAMES
(imageurl,name,gameurl,display)#('./flash/spankmonkey_logo.gif','Spank Monkey','./flash/spankmonkey.swf','1')
(imageurl,name,gameurl,display)#('./flash/solitaire_logo.gif','Solitaire','./flash/solitaire.swf','1')
(imageurl,name,gameurl,display)#('./flash/shangai_dynasty_logo.gif','Shangai Dynasty','./flash/shangai_dynasty.swf','1')
(imageurl,name,gameurl,display)#('./flash/pingpong_logo.gif','Ping Pong','./flash/pingpong.swf','1')
(imageurl,name,gameurl,display)#('./flash/flash_sprint_logo.gif','Flash Sprint','./flash/flash_sprint.swf','1')
(imageurl,name,gameurl,display)#('./flash/black_jack_logo.gif','Blackjack','./flash/ace_blackjack.swf','1')
(imageurl,name,gameurl,display)#('./flash/ace_poker_logo.gif','Ace Poker','./flash/flash_poker.swf','1')
[END]

quote:

---

Originally posted by Classicmotorcycling

OK, I have installed this from the file you suggested and found only a small thing if you have loaded them from the 2 versions. I take it that you run Snitz 3.4.X. I have seen that the dbs file had the following:

[DROP]
games
[END]

In MySQL or any type of DB, it generally likes the table name that you are dropping in the same case. Since it creates a uppercase table name and it is trying to drop a lower case it feels it is not there to drop so it continues and errors out.

I am saying this as I feel that you attempted to install the old 3.3 version and it did not work, so you tried to install the correct version and of course it can not find the right fields in the table so it bombs out. Try running this in the Alternative Mod Setup:

[DROP]
GAMES
[END]
[CREATE]
GAMES
ID
imageurl#varchar (100)#NULL#
name#varchar (50)#NULL#
gameurl#varchar (100)#NULL#
display#varchar (1)#NULL#
[END]

[INSERT]
GAMES
(imageurl,name,gameurl,display)#('./flash/spankmonkey_logo.gif','Spank Monkey','./flash/spankmonkey.swf','1')
(imageurl,name,gameurl,display)#('./flash/solitaire_logo.gif','Solitaire','./flash/solitaire.swf','1')
(imageurl,name,gameurl,display)#('./flash/shangai_dynasty_logo.gif','Shangai Dynasty','./flash/shangai_dynasty.swf','1')
(imageurl,name,gameurl,display)#('./flash/pingpong_logo.gif','Ping Pong','./flash/pingpong.swf','1')
(imageurl,name,gameurl,display)#('./flash/flash_sprint_logo.gif','Flash Sprint','./flash/flash_sprint.swf','1')
(imageurl,name,gameurl,display)#('./flash/black_jack_logo.gif','Blackjack','./flash/ace_blackjack.swf','1')
(imageurl,name,gameurl,display)#('./flash/ace_poker_logo.gif','Ace Poker','./flash/flash_poker.swf','1')
[END]

I found it worked for me on a test site. Let me know how you go and if it doesn't work, then let me know your forum and I will logon and help you there, followed by coming back here and letting eveyone know how it was resolved.

I hope that the new DB setup will do the job that is needed.

---