| Author |
Topic |
|
flukebuzzsaw
Starting Member
13 Posts |
 Posted - 2005-05-06 : 13:41:55
|
| Hello,I recently built a dev server -Windows2003Server box running IIS6 and SQL2000 with SP3 for a production website. I then imported the data from the production database to the dev database. I then created a SQLuser with permissions to select, update, insert, yada, yada. When I fire up the dev website and login to the admin section, I can modify or delete any of the existing data, but I cannot add any new data. The database is not full, and it is set to grow. My user account has Select, update, insert, delete and DRI on all tables. I am able through Query analyser to insert data into the tables, but not through the web gui.A side note, the production environment is a Windows2000Server running IIS5 and SQLServer2000. So I'm not sure if my problem is OS, IIS or SQLAny help would be appreciated. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-05-06 : 13:43:20
|
| What is the error that you are getting? If no error, then have you run SQL Profiler to determine what is going on? Make sure to add the exception event to the trace.Tara |
 |
|
|
flukebuzzsaw
Starting Member
13 Posts |
Posted - 2005-05-06 : 14:10:31
|
| Tara,Thanks for the post. I, however, have never used the profiler before. |
|
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2005-05-06 : 14:19:54
|
| When things like this happen, I usually suspect the app not the user permissions. Do you have a way to debug the app and pull the sql that is being executed against the db? That usually provides a better idea of what's happening. Not getting an error might just mean that your app is handling the error and letting you continue, not that an error message is absent. stepping through would give you a better idea.Mike"oh, that monkey is going to pay" |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-05-06 : 14:20:40
|
| Look in the error log..It's amazing, I just got handed the same problem...It's a third party product called Gufts.I don't think it's sql, we get an errorError: 15457, Severity: 0, State: 1Configuration option 'allow updates' changed from 0 to 1. Run the RECONFIGURE statement to install..What the hell is this?The application can connect, read data, but when they try to do an update it won't. I haven't even seen the app yet...I'm gonna do that Monday...Never seen this beforeBrett8-)EDIT: This is a dev box...production is fine..I wonder if it's an upgrade... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-05-06 : 15:10:45
|
| That "error" is just telling you that someone has changed the server option to allow modifications to the system table data. I'd say it's more of a warning.Tara |
|
|
|
flukebuzzsaw
Starting Member
13 Posts |
Posted - 2005-05-06 : 15:55:45
|
| My app works fine in the production environment. Those same pages do not work in the dev. I do not get an error, and nothing is added to the database. |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-05-06 : 15:56:41
|
quote:
Originally posted by tduggan
That "error" is just telling you that someone has changed the server option to allow modifications to the system table data. I'd say it's more of a warning.Tara
Who? I gotta find out who's got access...or change the sa password...Brett8-) |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-05-06 : 16:02:50
|
| Who, I don't know. But someone is running sp_configure and to make this type of change you'd need to be sysadmin or serveradmin roles.Tara |
|
|
|
flukebuzzsaw
Starting Member
13 Posts |
Posted - 2005-05-06 : 17:42:50
|
| It appears as if the data is trying to be submitted to the database, but nothing gets loaded. Example below from the PROFILERRPC:Completed exec sp_cursor 180150000, 4, 1, N'', @tourneyName = 'test', @firstDay = 'May 6 2005 12:00:00:000AM', @lastDay = 'May 7 2005 12:00:00:000AM', @entryDeadline = 'May 6 2005 12:00:00:000AM', @entryFeeInfo = '', @openEntryFeeMember = '300', @openEntryFeeNon = '325', @indexedEntryFeeFirst = '125', @indexedEntryFeeLast = '125', @amateurEntryFeeFirst = '75', @amateurEntryFeeLast = '75', @payOutInfo = '600', @startTimeInfo = '8am', @courseId = 99, @indexedPayOutInfo = '500', @AllowOnline = 'Yes ', @ActiveId = '', @IndexedActiveId = '', @indexedStartTimeInfo = '9am', @amateurStartTimeInfo = '10am', @rsDescOpen = NULL, @rsDescIndexed = NULL, @tnDisabled = 0, @otherInfo = 'this si a test' Internet Information Services SQLPepsi 0 19 0 0 864 55 2005-05-06 13:35:44.987 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-05-06 : 17:45:21
|
| Did you add the exception event to your trace? If so, do you see an exception directly above this row that you posted?Tara |
|
|
|
flukebuzzsaw
Starting Member
13 Posts |
Posted - 2005-05-06 : 18:37:52
|
| AFter adding the exception, I get this: Exception Error: 515, Severity: 16, State: 2 Internet Information Services SQLPepsi 864 55 2005-05-06 15:36:56.830 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-05-06 : 18:38:52
|
| 515 is this error:Cannot insert the value NULL into column '%.*ls', table '%.*ls'; column does not allow nulls. %ls fails.So you are trying to insert a NULL into a column that does not allow NULLs. Due to this, the transaction is rolled back.Tara |
|
|
|
flukebuzzsaw
Starting Member
13 Posts |
Posted - 2005-05-06 : 19:21:53
|
| Tara,All my fields that don't except nulls are having data sent to them. A question for you that I have is this. When I copied data from one database to another, all the tables lost their primary key settings so I reset them. Do I need to start and stop the database for this. Because the only field I that might not be working correctly is the table ID field which may or may not be incrementing. |
|
|
|
flukebuzzsaw
Starting Member
13 Posts |
Posted - 2005-05-06 : 19:39:33
|
| Tara,I set the primary key field as an identity seed and for it to increment and now data gets added but when I click on the button which activates the sql statement to select the data to view, the data doesn't display. If I remove the newly created row, the data then displays again. |
|
|
|
flukebuzzsaw
Starting Member
13 Posts |
Posted - 2005-05-06 : 19:41:00
|
| Tara,Profiler is displaying no errors and here is the command it is displaying that worked before I made the primary key changes, which now doesn't work with the new data.select distinct tourneyId,includedInMoneyList from pepsi_tn_results where includedInMoneyList=0 |
|
|
|
flukebuzzsaw
Starting Member
13 Posts |
Posted - 2005-05-06 : 19:56:28
|
| now that I set these as identity seeds and to increment the sql statements do not recognize the tables as objectsInvalid object name 'tn_results'. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-05-07 : 20:28:36
|
| It sounds like you didn't bring the database over correctly. I'm going to go out on a limb here and assume you used the import/export wizard. I would redo this. Instead use BACKUP/RESTORE. It'll grab everything you need except the logins which are stored in the master database. Once the restore is complete, make sure to unorphan the users using sp_change_users_login.Tara |
|
|
|
|
data won't save