The Forum has been Updated
The code has been upgraded to the latest .NET core version. Please check instructions in the Community Announcements about migrating your account.
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
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
Posted
Off the bat, it sounds like there is a problem writing to the new table you created. Have you checked the permissions on the table to see if the account you using in config.asp has UPDATE permissions set for the table?
Posted
Yes it has UPDATE selected under permissions. There's 3 columns to select for UPDATE: Grant, With Grant and Deny
The Grant tick box is ticked, the remaining two are not. Should I tick box any of the other two?
Thank you,
Oscar
The Grant tick box is ticked, the remaining two are not. Should I tick box any of the other two?
Thank you,
Oscar
Posted
No the Grant should be enough. Does the SQL logs show any errors when you try to switch themes?
If not, it may just be the code that is the problem. Would need to step through each UPDATE in the code and see which is failing.
Posted
There's no errors in the SQL logs when I try to switch themes.
This you can help me out with the code perhaps? This is the file in charge of updating the database when switching themes: http://www.coastercrazy.com/forum/my_edit_config.txt
:)
thank you
:)
thank you
Posted
it could be to do with the schema in which the table was created, does your new table have the same schema as all the other tables?
i.e
are they all called [dbo].TABLENAME, or is your new table something different like [username].TABLENAME
i.e
are they all called [dbo].TABLENAME, or is your new table something different like [username].TABLENAME
