Last post Dec 22, 2005 06:35 AM by Dr-Hack
Dec 19, 2005 04:49 AM|Dr-Hack|LINK
° I have been runnin a smooth site on my computer but had to shift my existin db and structure to a host but now i am gettin some strange errors which i need someone to give me a hint on which places to look out ..the error's come on different
places like if i try "Upgrade Log for version" i get this :Error: Cannot insert the value NULL into column 'IsPremium', table 'XXX.dbo.ModuleDefinitions'; column does not allow nulls. INSERT fails.
The statement has been terminated.
Log viewer doesnt get any error..
then there is the same kind of error in YAF module when i try to post it says:
Cannot insert the value NULL into column 'Flags', table 'XXX.dbo.yaf_Topic'; column does not allow nulls. INSERT fails. Cannot insert the value NULL into column 'TopicID', table 'XXX.dbo.yaf_Message'; column does not allow nulls. INSERT fails. The statement
has been terminated. The statement has been terminated.
have posted at yaf forums but thought both errors might have a common solution...
° Second Issue is that no one can get registred at my site after i moved the site (old members can get login etc) read on many places so did the "remove cache" , "clear cookie" tricks all in vain..but the strange thing is that my "Users"
module shows a blank area in front of the "latest" member and increase the count of todays registered users BUT clickin on the register link opens the same page again and again .. ooh yes but enterin a used username give out an error to put another username..
you can see all these errors in action on my site :(
everything was soo awesome on my computer but this host :(
Will be Glad for any Help .. guessin wat might help is also appreciated ..
Thank You :)
Dec 20, 2005 06:38 AM|Dr-Hack|LINK
I can provide any additional information which any one might need to assist me out a little..
or the best will be to give out some hints to where to look out or what can be the possibility's or what shd i do to see the error..
as it is my actualy site cant afford the loss of no userregistration and errors :(
thanks to all ...
Dec 20, 2005 03:05 PM|ecktwo|LINK
describe what DNN version you are dealing with and what your host is offering.
describe how you performed the "transfer".
Dec 22, 2005 06:35 AM|Dr-Hack|LINK
I am using Plesk 7 on my hosting and it comes with DNN 3.0 and i am using Dnn 2.1.2
I transfered my database using the DTS of MSSQL enterprise edition ..
first i selected the procedures using the "copy objects " selection ( i didnt not copied user and other stuff )
and then copied tables.. using the "copy tables and views option" ..also made a manual check that all the tables/views/procedures etc are same in number ... other then this almost everypart is of site is working ..
Thank You ecktwo for a reply it gives me some hope that i might get a solution