| Author |
 Topic  |
|
weeweeslap
Senior Member
USA
1077 Posts |
 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 |
coaster crazy |
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 21 November 2010 : 20:46:51
|
| 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? |
Support Snitz Forums
|
 |
|
|
weeweeslap
Senior Member
USA
1077 Posts |
Posted - 21 November 2010 : 20:51:15
|
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 |
coaster crazy |
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 21 November 2010 : 22:14:39
|
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. |
Support Snitz Forums
|
|
|
|
weeweeslap
Senior Member
USA
1077 Posts |
|
|
HuwR
Forum Admin
United Kingdom
20611 Posts |
|
|
weeweeslap
Senior Member
USA
1077 Posts |
Posted - 22 November 2010 : 11:25:08
|
It is indeed different, it is username.TABLENAME with username being the username I use to connect to the db. However, I did create the table manually and that turned out to be dbo.TABLENAME and then it would not even read the table. It only reads username.TABLENAME
What I mean is after the table was created, I manually added a row to the table to see if it was even reading it right. In the dbo.TABLENAME, it was not reading the table after adding a row. In the username.TABLENAME, which was created by the dbs file, it read the table fine, but it would not write to it. |
coaster crazy |
|
|
|
HuwR
Forum Admin
United Kingdom
20611 Posts |
|
|
weeweeslap
Senior Member
USA
1077 Posts |
Posted - 22 November 2010 : 15:58:27
|
| When running the exact same sql in EM being logged in as the same user as the forum, no errors are being returned. |
coaster crazy |
Edited by - weeweeslap on 22 November 2010 15:58:49 |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
Posted - 22 November 2010 : 16:21:49
|
| It does look like a schema / permissions issue The table should have the same schema as the existing forum tables and you should make sure the table is created with the same permissions as the other forum tables, in the exact same schema as the forum ones. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
weeweeslap
Senior Member
USA
1077 Posts |
Posted - 22 November 2010 : 17:02:31
|
I recreated it using the same schema and permissions as the other tables and the code will not read from that table nor write to it as well  |
coaster crazy |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
weeweeslap
Senior Member
USA
1077 Posts |
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. |
coaster crazy |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
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? |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
weeweeslap
Senior Member
USA
1077 Posts |
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?  |
coaster crazy |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
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. |
Snitz 3.4 Readme | Like the support? Support Snitz too |
|
|
|
Topic |
|
Code Works In Windows 2003 Not In Windows 2008
