Forums (Obsolete)

Member

ruthh - 6/22/2012 5:29:16 AM

CMS folder permissions

Our hosting company have recently migrated the website to a different server and we're now having problems with forms with errors such as:

[DataConnection.ExecuteQuery]: Query: INSERT INTO power_wps ([FormInserted], [FormUpdated], [fname], [eadd] ) VALUES ( @FormInserted, @FormUpdated, @fname, @eadd); SELECT @@identity AS [power_wpsID] : caused exception: Invalid object name 'power_wps'

I believe this is a folder permissions issue? I seem to remember having to give certain folders IISuser write permissions but I can't remember which folders they were and obvioulsy there are lots. I'm talking about the CMSInlineControls, CMSFormControls etc.

Please can someone help as this is getting urgent. I've checked the manual http://devnet.kentico.com/docs/devguide/index.html?disk_permissions_problems.htm but that doesn't actually answer this question.

Many thanks.

Ruth

Kentico Support

kentico_radekm2 - 6/22/2012 6:16:04 AM

RE:CMS folder permissions

Hello.

I believe this is not related to permissions at all. It seems that a table called “power_wps” is missing in your new DB, so this query results in the error. As this is obviously name of your custom object, can you clarify what was it on original server? A document type, custom table, On-line form or so on?

How exactly was the deployment done? Using export/import functionality, restoring back-up of the DB or in any other way? Can you clarify it? Thank you.

Best Regards,
Radek Macalik


Member	ruthh - 6/22/2012 10:03:20 AM RE:CMS folder permissions Hi Radek It turns out that the four forms that don't work are all recent forms created in bizforms. All the original forms work ok. Do you have any further advice? Regards Ruth

Kentico Support

kentico_radekm - 6/28/2012 3:40:53 AM

RE:CMS folder permissions

Hello.

Did you check the current database to see, whether it contains these tables, e.g. “power_wps”? It would be very helpful to know what steps the hosting provider did, so we could deduce what might went wrong.

This issue should not appear if you migrate the site via standard export / import process or if you simply back-up / restore DB.

Can you also clarify what do you mean by “don't have access to Kentico to import/export”?

Also – where and when this error appears?

Thank you.

Best Regards,
Radek Macalik

Member

ruthh - 6/28/2012 3:47:33 AM

RE:CMS folder permissions

Hi Radek

I seemed that four custom tables were missing and these all applied to bizforms that had been created shortly before the hosting company had migrated the site. The quickest solution was for the client to recreate the forms and therefore the tables and this solved the problem.

The hosting company didn't have administrator logins for the site so they must have copied and moved all the files as they wouldn't have been able to use the standard export process.

Thank you for your help.


Member	ruthh - 6/22/2012 6:21:00 AM RE:CMS folder permissions I actually have no idea how they migrated the site. The hosting company did everything. I presume they copied the files and database across as they don't have access to Kentico to import/export and as they've taken the old server down I have no access to the original site. What would your advice be? Regards Ruth

Kentico Developer

kentico_ivanat - 7/1/2012 5:28:02 PM

RE:CMS folder permissions

Hi,

it is possible that they did not restore full database backup (some tables were missing) or they used some older database backup (which did not contain recently created tables).

In general, if you restore full database backup and project (without access to the Kentico site) this would not happen.

You said that your client recreated missing tables and it fixed the issue. Or do you have another issue on the site?

In case you need an administrator access to the site, you can ask your provider to create it directly in the database. There is CMS_User table. So in case they check option/column [UserIsGlobalAdministrator] they can make a global admin from the particular user.

Best regards,
Ivana Tomanickova