Installation Help

Migrating Site to new server, database and base url. Strict Standards Error

Permalink April 01, 2013 at 2:02 PM

I have migrated several sites before but this is the first one that I've had to move it to a new server, a new database and a new base URL. I have follow many of the online suggestions about turning errors off, updating the .htaccess and the php.ini. Nothing has helped.

Specifics:
I am moving the site from my hosting package to the clients hosting package, same company, same server configuration. Both are the same 1&1 Linux Package.

It is using Concrete5.5.1. I attempted to do a manual upgrade, thinking that would correct the issue, but I get a "Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1054: Unknown column 'logUserID' in 'field list']..."

Here is the URL:http://www.ksrx.co

Any help is GREATLY appreciated! Thank you in advance.

madeforspace replied on Apr 1, 2013 at 2:10 pm Permalink Reply

Have you seen this post?

http://www.concrete5.org/community/forums/installation/php-errors-w...

grosik replied on Apr 1, 2013 at 5:54 pm Permalink Reply

i was having somehow simmilar issue. try to update table names via phpmyadmin, it's my table update code im using when moving sites from localhost to server:

RENAME   TABLE   areapermissionassignments         TO   AreaPermissionAssignments            ;
RENAME   TABLE   areas         TO   Areas            ;
RENAME   TABLE   attributekeycategories         TO   AttributeKeyCategories            ;
RENAME   TABLE   attributekeys         TO   AttributeKeys            ;
RENAME   TABLE   attributesetkeys         TO   AttributeSetKeys            ;
RENAME   TABLE   attributesets         TO   AttributeSets            ;
RENAME   TABLE   attributetypecategories         TO   AttributeTypeCategories            ;
RENAME   TABLE   attributetypes         TO   AttributeTypes            ;
RENAME   TABLE   attributevalues         TO   AttributeValues            ;
RENAME   TABLE   blockrelations         TO   BlockRelations            ;
RENAME   TABLE   blocktypes         TO   BlockTypes            ;
RENAME   TABLE   blocks         TO   Blocks            ;
RENAME   TABLE   collectionattributevalues         TO   CollectionAttributeValues            ;
RENAME   TABLE   collectionsearchindexattributes         TO   CollectionSearchIndexAttributes            ;
RENAME   TABLE   collectionversionarealayouts         TO   CollectionVersionAreaLayouts            ;

Viewing 15 lines of 175 lines. View entire code block.

 
RENAME   TABLE   areapermissionassignments         TO   AreaPermissionAssignments            ;
RENAME   TABLE   areas         TO   Areas            ;
RENAME   TABLE   attributekeycategories         TO   AttributeKeyCategories            ;
RENAME   TABLE   attributekeys         TO   AttributeKeys            ;
RENAME   TABLE   attributesetkeys         TO   AttributeSetKeys            ;
RENAME   TABLE   attributesets         TO   AttributeSets            ;
RENAME   TABLE   attributetypecategories         TO   AttributeTypeCategories            ;
RENAME   TABLE   attributetypes         TO   AttributeTypes            ;
RENAME   TABLE   attributevalues         TO   AttributeValues            ;
RENAME   TABLE   blockrelations         TO   BlockRelations            ;
RENAME   TABLE   blocktypes         TO   BlockTypes            ;
RENAME   TABLE   blocks         TO   Blocks            ;
RENAME   TABLE   collectionattributevalues         TO   CollectionAttributeValues            ;
RENAME   TABLE   collectionsearchindexattributes         TO   CollectionSearchIndexAttributes            ;
RENAME   TABLE   collectionversionarealayouts         TO   CollectionVersionAreaLayouts            ;
RENAME   TABLE   collectionversionareastyles         TO   CollectionVersionAreaStyles            ;
RENAME   TABLE   collectionversionblockstyles         TO   CollectionVersionBlockStyles            ;
RENAME   TABLE   collectionversionblocks         TO   CollectionVersionBlocks            ;
RENAME   TABLE   collectionversionrelatededits         TO   CollectionVersionRelatedEdits            ;
RENAME   TABLE   collectionversions         TO   CollectionVersions            ;
RENAME   TABLE   collections         TO   Collections            ;
RENAME   TABLE   composercontentlayout         TO   ComposerContentLayout            ;
RENAME   TABLE   composerdrafts         TO   ComposerDrafts            ;
RENAME   TABLE   composertypes         TO   ComposerTypes            ;
RENAME   TABLE   config         TO   Config            ;
RENAME   TABLE   customstylepresets         TO   CustomStylePresets            ;
RENAME   TABLE   customstylerules         TO   CustomStyleRules            ;
RENAME   TABLE   dashboardhomepage         TO   DashboardHomepage            ;
RENAME   TABLE   downloadstatistics         TO   DownloadStatistics            ;
RENAME   TABLE   fileattributevalues         TO   FileAttributeValues            ;
RENAME   TABLE   filepermissionfiletypes         TO   FilePermissionFileTypes            ;
RENAME   TABLE   filepermissions         TO   FilePermissions            ;
RENAME   TABLE   filesearchindexattributes         TO   FileSearchIndexAttributes            ;
RENAME   TABLE   stacks         TO   Stacks            ;
RENAME   TABLE   systemantispamlibraries         TO   SystemAntispamLibraries            ;
RENAME   TABLE   systemcaptchalibraries         TO   SystemCaptchaLibraries            ;
RENAME   TABLE   usersearchindexattributes         TO   UserSearchIndexAttributes            ;
RENAME   TABLE   ataddress         TO   atAddress            ;
RENAME   TABLE   ataddresscustomcountries         TO   atAddressCustomCountries            ;
RENAME   TABLE   ataddresssettings         TO   atAddressSettings            ;
RENAME   TABLE   atboolean         TO   atBoolean            ;
RENAME   TABLE   atbooleansettings         TO   atBooleanSettings            ;
RENAME   TABLE   atdatetime         TO   atDateTime            ;
RENAME   TABLE   atdatetimesettings         TO   atDateTimeSettings            ;
RENAME   TABLE   atdefault         TO   atDefault            ;
RENAME   TABLE   atfile         TO   atFile            ;
RENAME   TABLE   atnumber         TO   atNumber            ;
RENAME   TABLE   atselectoptions         TO   atSelectOptions            ;
RENAME   TABLE   atselectoptionsselected         TO   atSelectOptionsSelected            ;
RENAME   TABLE   atselectsettings         TO   atSelectSettings            ;
RENAME   TABLE   attextareasettings         TO   atTextareaSettings            ;
RENAME   TABLE   btcontentfile         TO   btContentFile            ;
RENAME   TABLE   btcontentimage         TO   btContentImage            ;
RENAME   TABLE   btcontentlocal         TO   btContentLocal            ;
RENAME   TABLE   btcorescrapbookdisplay         TO   btCoreScrapbookDisplay            ;
RENAME   TABLE   btcorestackdisplay         TO   btCoreStackDisplay            ;
RENAME   TABLE   btdashboardnewsflowlatest         TO   btDashboardNewsflowLatest            ;
RENAME   TABLE   btdatenav         TO   btDateNav            ;
RENAME   TABLE   btexternalform         TO   btExternalForm            ;
RENAME   TABLE   btflashcontent         TO   btFlashContent            ;
RENAME   TABLE   btform         TO   btForm            ;
RENAME   TABLE   btformanswerset         TO   btFormAnswerSet            ;
RENAME   TABLE   btformanswers         TO   btFormAnswers            ;
RENAME   TABLE   btformquestions         TO   btFormQuestions            ;
RENAME   TABLE   btgooglemap         TO   btGoogleMap            ;
RENAME   TABLE   btguestbook         TO   btGuestBook            ;
RENAME   TABLE   btguestbookentries         TO   btGuestBookEntries            ;
RENAME   TABLE   btnavigation         TO   btNavigation            ;
RENAME   TABLE   btnextprevious         TO   btNextPrevious            ;
RENAME   TABLE   btpagelist         TO   btPageList            ;
RENAME   TABLE   btrssdisplay         TO   btRssDisplay            ;
RENAME   TABLE   btsearch         TO   btSearch            ;
RENAME   TABLE   btslideshow         TO   btSlideshow            ;
RENAME   TABLE   btslideshowimg         TO   btSlideshowImg            ;
RENAME   TABLE   btsurvey         TO   btSurvey            ;
RENAME   TABLE   btsurveyoptions         TO   btSurveyOptions            ;
RENAME   TABLE   btsurveyresults         TO   btSurveyResults            ;
RENAME   TABLE   bttags         TO   btTags            ;
RENAME   TABLE   btvideo         TO   btVideo            ;
RENAME   TABLE   btyoutube         TO   btYouTube            ;
RENAME TABLE areapermissionblocktypeaccesslist TO AreaPermissionBlockTypeAccessList;
RENAME TABLE areapermissionblocktypeaccesslistcustom TO AreaPermissionBlockTypeAccessListCustom;
RENAME TABLE basicworkflowpermissionassignments TO BasicWorkflowPermissionAssignments;
RENAME TABLE basicworkflowprogressdata TO BasicWorkflowProgressData;
RENAME TABLE blockpermissionassignments TO BlockPermissionAssignments;
RENAME TABLE blocktypepermissionblocktypeaccesslist TO BlockTypePermissionBlockTypeAccessList;
RENAME TABLE blocktypepermissionblocktypeaccesslistcustom TO BlockTypePermissionBlockTypeAccessListCustom;
RENAME TABLE btlistfilesfromset TO btListFilesFromSet;
RENAME TABLE btlogin TO  btLogin;
RENAME TABLE btndphpblockcontent TO btNdPhpBlockContent;
RENAME TABLE btpowerslide TO btPowerSlide;
RENAME TABLE btpowerslideimg TO btPowerSlideImg;
RENAME TABLE btswpbreadcrumbs TO btSwpBreadcrumbs;
RENAME TABLE filepermissionassignments TO FilePermissionAssignments;
RENAME TABLE files TO Files;
RENAME TABLE filesetfiles TO FileSetFiles;
RENAME TABLE filesetpermissionassignments TO FileSetPermissionAssignments;
RENAME TABLE filesetpermissionfiletypeaccesslist TO FileSetPermissionFileTypeAccessList;
RENAME TABLE filesetpermissionfiletypeaccesslistcustom TO FileSetPermissionFileTypeAccessListCustom;
RENAME TABLE filesets TO FileSets;
RENAME TABLE filesetsavedsearches TO FileSetSavedSearches;
RENAME TABLE filestoragelocations TO FileStorageLocations;
RENAME TABLE fileversionlog TO FileVersionLog;
RENAME TABLE fileversions TO FileVersions;
RENAME TABLE groups TO Groups;
RENAME TABLE groupsetgroups TO GroupSetGroups;
RENAME TABLE groupsets TO GroupSets;
RENAME TABLE jobs TO Jobs;
RENAME TABLE jobslog TO JobsLog;
RENAME TABLE layoutpresets TO LayoutPresets;
RENAME TABLE layouts TO Layouts;
RENAME TABLE logs TO Logs;
RENAME TABLE mailimporters TO MailImporters;
RENAME TABLE mailvalidationhashes TO MailValidationHashes;
RENAME TABLE packages TO Packages;
RENAME TABLE pagepaths TO PagePaths;
RENAME TABLE pagepermissionassignments TO PagePermissionAssignments;
RENAME TABLE pagepermissionpagetypeaccesslist TO PagePermissionPageTypeAccessList;
RENAME TABLE pagepermissionpagetypeaccesslistcustom TO PagePermissionPageTypeAccessListCustom;
RENAME TABLE pagepermissionpropertyaccesslist TO PagePermissionPropertyAccessList;
RENAME TABLE pagepermissionpropertyattributeaccesslistcustom TO PagePermissionPropertyAttributeAccessListCustom;
RENAME TABLE pagepermissionthemeaccesslist TO PagePermissionThemeAccessList;
RENAME TABLE pagepermissionthemeaccesslistcustom TO PagePermissionThemeAccessListCustom;
RENAME TABLE pages TO Pages;
RENAME TABLE pagesearchindex TO PageSearchIndex;
RENAME TABLE pagestatistics TO PageStatistics;
RENAME TABLE pagethemes TO PageThemes;
RENAME TABLE pagethemestyles TO PageThemeStyles;
RENAME TABLE pagetypeattributes TO PageTypeAttributes;
RENAME TABLE pagetypes TO PageTypes;
RENAME TABLE pageworkflowprogress TO PageWorkflowProgress;
RENAME TABLE permissionaccess TO PermissionAccess;
RENAME TABLE permissionaccessentities TO PermissionAccessEntities;
RENAME TABLE permissionaccessentitygroups TO PermissionAccessEntityGroups;
RENAME TABLE permissionaccessentitygroupsets TO PermissionAccessEntityGroupSets;
RENAME TABLE permissionaccessentitytypecategories TO PermissionAccessEntityTypeCategories;
RENAME TABLE permissionaccessentitytypes TO PermissionAccessEntityTypes;
RENAME TABLE permissionaccessentityusers TO PermissionAccessEntityUsers;
RENAME TABLE permissionaccesslist TO PermissionAccessList;
RENAME TABLE permissionaccessworkflows TO PermissionAccessWorkflows;
RENAME TABLE permissionassignments TO PermissionAssignments;
RENAME TABLE permissiondurationobjects TO PermissionDurationObjects;
RENAME TABLE permissionkeycategories TO PermissionKeyCategories;
RENAME TABLE permissionkeys TO PermissionKeys;
RENAME TABLE pilecontents TO PileContents;
RENAME TABLE piles TO Piles;
RENAME TABLE signuprequests TO SignupRequests;
RENAME TABLE systemnotifications TO SystemNotifications;
RENAME TABLE userattributekeys TO UserAttributeKeys;
RENAME TABLE userattributevalues TO UserAttributeValues;
RENAME TABLE userbannedips TO UserBannedIPs;
RENAME TABLE usergroups TO UserGroups;
RENAME TABLE useropenids TO UserOpenIDs;
RENAME TABLE userpermissionassigngroupaccesslist TO UserPermissionAssignGroupAccessList;
RENAME TABLE userpermissionassigngroupaccesslistcustom TO UserPermissionAssignGroupAccessListCustom;
RENAME TABLE userpermissioneditpropertyaccesslist TO UserPermissionEditPropertyAccessList;
RENAME TABLE userpermissioneditpropertyattributeaccesslistcustom TO UserPermissionEditPropertyAccessListCustom;
RENAME TABLE userpermissionusersearchaccesslist TO UserPermissionUserSearchAccessList;
RENAME TABLE userpermissionusersearchaccesslistcustom TO UserPermissionUserSearchAccessListCustom;
RENAME TABLE userpermissionviewattributeaccesslist TO UserPermissionViewAttributeAccessList;
RENAME TABLE userpermissionviewattributeaccesslistcustom TO UserPermissionViewAttributeAccessListCustom;
RENAME TABLE userprivatemessages TO UserPrivateMessages;
RENAME TABLE userprivatemessagesto TO UserPrivateMessagesTo;
RENAME TABLE users TO Users;
RENAME TABLE usersfriends TO UserFriends;
RENAME TABLE uservalidationhashes TO UserValidationHashes;
RENAME TABLE workflowprogress TO WorkflowProgress;
RENAME TABLE workflowprogresscategories TO WorkflowProgressCategories;
RENAME TABLE workflowprogresshistory TO WorkflowProgressHistory;
RENAME TABLE workflowrequestobjects TO WorkflowRequestObjects;
RENAME TABLE workflows TO Workflows;
RENAME TABLE workflowtypes TO WorkflowTypes;
RENAME TABLE btgallery TO btGallery;
RENAME TABLE btgalleryImg TO btGalleryImg;
RENAME TABLE collectionversionblocksoutputcache TO CollectionVersionBlocksOutputCache;

if an error occured (due to diffrent table names and so on), just remove code to the line, where error appeard and run the script again (without lines you have removed). then check all tables, if they were changed.

i hope this can help

Forums

Installation Help

Migrating Site to new server, database and base url. Strict Standards Error

Code

Post Reply

Delete Post

Mark Post as Spam

Destroy Spammer

Sign In?