I am using version 1.9. I have been developing my site on my laptop and everything including registration and sending comments works fine. I deployed my site to godaddy by copying ALL my files via filezilla. I also exported the tables and views by management studio data export feature. Then I had to open every stored procedure in managtement studio, copy the create stored procedure text and run it on godaddy server. I did this for all stored procedures and functions that I could find in management studio in my database. But now, when I try to send a comment or register a new user on godaddy server, I get some errors which indicate I am missing some stored procedures. (I am not sure about this tho). What is the best way to get all the stored procedures and function from my local machine to godaddy?
The errors I am getting are:
Sending comments:
Cannot insert the value NULL into column 'LogID', table 'ik6s.dbo.Nop_Log'; column does not allow nulls. INSERT fails.
The statement has been terminated.
I am thinking an exception occured that does not exist in nop_log.
Registration:
Cannot insert the value NULL into column 'CustomerID', table 'ik6s.dbo.Nop_Customer'; column does not allow nulls. INSERT fails.
The statement has been terminated.
I am also having similar problems when I use admin panel to add categories.
Cannot insert the value NULL into column 'CategoryID', table 'ik6s.dbo.Nop_Category'; column does not allow nulls. INSERT fails.
The statement has been terminated.