| T O P I C R E V I E W |
| weeweeslap |
Posted - 21 November 2010 : 20:34:17
Hi,
This is in relation to one of the mods for snitz. Snitz Personalization. We moved to windows 2008 and are presented with a lot of problems. Most are taken care of fortunately or being taken care of. However, this one I can't figure it out.
Basically the database table is not being updated after the code is ran. The site is reading the tables just fine and is writing to all other tables just fine, just this one is giving me grief. Here is a text version of the asp page that is not updating the database:
http://www.coastercrazy.com/forum/my_edit_config.txt
If I manually add to the table, the site will read the table and display things correctly. However, if you log into the website and click any of the theme switching icons on the home page right below the menu on the right, it will tell you that it was updated successfully, however, it does not because you are still left with the default theme. Below is info to login and test it out for yourself:
Demo Account: SnitzTest
password: testtest
This code was working just fine on windows 2003 and sql server 2000. We moved to windows 2008 and sql server 2008 and this problem presented itself. I have deleted that specific table and recreated it manually and it did not fix the problem. I also deleted that table again and ran the dbs file for it and stil did not solve the problem. I am thinking maybe there is some code incompatability? Can someone please view the code linked above and see if there is anything that should be changed so it is windows 2008 and sql server 2008 compatible?
We thought maybe a trigger of the db was missing so I reexported the stored procs from the original db and imported them back into this db we have live now and still no fix. I appreciate any help you can provide on this situation.
Thank you,
Oscar |
| 15 L A T E S T R E P L I E S (Newest First) |
| ruirib |
Posted - 26 November 2010 : 18:15:10
You're welcome. We do not celebrate Thanksgiving here, but I hope you have a Happy one yourself. |
| weeweeslap |
Posted - 26 November 2010 : 14:17:18
Happy Thanksgiving, thank you for resolving this error  |
| ruirib |
Posted - 26 November 2010 : 04:38:25
Yeppers, that was it.
I guess this means that you can't even use the argument that a given set of code was working well before, when problems arise. You just need to question it all!! Not a reassuring thought!! |
| Davio |
Posted - 25 November 2010 : 13:09:11
Ahh yes. I see what you're saying now. Just went and look back at the file weeweeslap posted:
quote:
Set objDB = Server.CreateObject("ADODB.Connection")
objDB.Open my_Conn
It was using it's own connection instead. I see I see. |
| HuwR |
Posted - 25 November 2010 : 10:28:02
well, that is a strange one for sure |
| ruirib |
Posted - 25 November 2010 : 10:10:57
Well there were two coding errors. First, for some unknown reason, the Snitz connection object was not being used, a new connection was created. To open this connection, instead of passing the connection string, the code was passing the snitz connection object! For some reason, this worked on Windows 2003! The weird thing is that not only the method call to open the connection was not generating any errors, but any subsequent uses of the connection to execute SQL weren't generating errors either! So the code was executing SQL over even non existing database tables without so much as a "complaint"!
Once that was fixed, the desired SQL started to execute. There was another logical error (trying to update a record without being sure it existed, which didn't update at all when the record did not exist), but the major issue was the one with the connection opening method call. |
| Davio |
Posted - 24 November 2010 : 22:55:59
What was the problem Rui? |
| weeweeslap |
Posted - 24 November 2010 : 20:46:13
ruirib is awesome! He came in and fixed it all up. Thank you much Rui! |
| ruirib |
Posted - 24 November 2010 : 13:19:03
Got it. I'll see if I can check it later today. Will reply to you by email. |
| weeweeslap |
Posted - 23 November 2010 : 23:22:14
hi ruirib,
I have sent you a detailed email. I provided contact info as well and if there is any missing info, please reply to it. 
Thank you,
Oscar |
| ruirib |
Posted - 23 November 2010 : 12:05:58
Well if you want to email me the details I can try and have a look. Please provide me all the relevant data - remote desktop access and login data, SQL Server data, script name for the code that it is failing. |
| weeweeslap |
Posted - 23 November 2010 : 11:51:29
I am certain. You are welcomed to RDC into my server and check it out if you'd like? |
| ruirib |
Posted - 23 November 2010 : 07:05:01
Well that simply can't be. If your code accesses the table, it would generate errors, unless your code is explicitly ignoring them. You are sure you don't have other versions of the table, under different schemas? |
| weeweeslap |
Posted - 22 November 2010 : 19:25:38
I actually didn't get any error message doing the above. Even if I delete the table (FORUM_MY_CONFIG) it doesn't give an error. It just assumes a value of 0 and shows the default theme. |
| ruirib |
Posted - 22 November 2010 : 18:20:36
What error message are you getting? |
