Developing (v7+)

blank page after login page

Permalink May 28, 2015 at 10:43 PM

Hi,

I upload online a website.
I can connect to it but i have those 2 problems :

1- i can see the images i upload in the file manager (logo, slider images...)
If i check the address of the images it seams that they keep the offline local address but not the online one.

2- When i try to connect to dashboard with this address :http://www.sparkdesignhotel.com/temp
i can enter the login page but after entering the username and password i have a blank page with this address :http://www.sparkdesignhotel.com/temp/index.php/login/do_login/...

Any ideas of what happend ??

Thanks in advance

Chris

chrismodlao replied on May 28, 2015 at 11:18 pm Permalink Reply

So i have some progress.

I did drop all the tables in my database and upload a fresh backup from my local development server.
Then i change the Case of all the tables names with this SQL script for concrete 5.6.3 :

ALTER TABLE areapermissionblocktypeaccesslist RENAME AreaPermissionBlockTypeAccessList;
ALTER TABLE areapermissionblocktypeaccesslistcustom RENAME AreaPermissionBlockTypeAccessListCustom;
ALTER TABLE areas RENAME Areas;
ALTER TABLE ataddress RENAME atAddress;
ALTER TABLE ataddresscustomcountries RENAME atAddressCustomCountries;
ALTER TABLE ataddresssettings RENAME atAddressSettings;
ALTER TABLE atadvpageselector RENAME atAdvPageSelector;
ALTER TABLE atadvpageselectorsettings RENAME atAdvPageSelectorSettings;
ALTER TABLE atboolean RENAME atBoolean;
ALTER TABLE atbooleansettings RENAME atBooleanSettings;
ALTER TABLE atdatetime RENAME atDateTime;
ALTER TABLE atdatetimesettings RENAME atDateTimeSettings;
ALTER TABLE atdefault RENAME atDefault;
ALTER TABLE atfile RENAME atFile;
ALTER TABLE atmultipageselectorsettings RENAME atMultiPageSelectorSettings;

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

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

And manually i change the few table name that was still lowcase.

So actually i can login to the website and to the dashboard.

Now i can go to my File Manager and i can see images in it.
The point is that still in the website they are wrong :
- bad address
- bad link if there is some link on it.

Also i'm just unable to enter edit mode.

Any ideas ??

Chris

chrismodlao replied on May 28, 2015 at 11:30 pm Permalink Reply

So actually everything seams to work.

What i did is to reload some images and concrete5 find the link to all of them.

Why ??

Forums

Developing (v7+)

blank page after login page

Code

Post Reply

Delete Post

Mark Post as Spam

Destroy Spammer

Sign In?