Reinstall

Permalink
Unable to log in to site.
Will I loose my add-on's if I delete my site and re-install Concrete5?
Upgraded to 562.3 and things went wrong.

Download 562.3 to new data base and re-install from backup be okay

May fix my log in issues..

grannyiescrazy
View Replies:
Responsive replied on at Permalink Reply
Responsive
Hi did you manage to get this sorted , if not PM me for help
grannyiescrazy replied on at Permalink Reply
grannyiescrazy
Found a different server and reinstalled Concrete5.  Have a new log in now should work. Site is not live for a few more hours.

From: concrete5 Community <[email protected]>
To: [email protected]
Sent: Sunday, December 7, 2014 1:34 PM
Subject: Reinstall : Installation Help
grannyiescrazy replied on at Permalink Reply
grannyiescrazy
Major issues. Updated Concrete 5 and installed in a new data base on new server.
New data base will not accept install from old backup now.
Add On's are gone also.
Just added some.


Error
SQL query:

DROP TABLE IF EXISTS AreaPermissionAssignments;


MySQL said: Documentation

#1046 - No database selected



DROP TABLE IF EXISTS AreaPermissionAssignments;

CREATE TABLE IF NOT EXISTS `AreaPermissionAssignments` (
    `cID` int(10) unsigned NOT NULL DEFAULT '0',
    `arHandle` varchar(255) NOT NULL,
    `pkID` int(10) unsigned NOT NULL DEFAULT '0',
    `paID` int(10) unsigned NOT NULL DEFAULT '0',
    PRIMARY KEY (`cID`,`arHandle`,`pkID`,`paID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS AreaPermissionBlockTypeAccessList;

CREATE TABLE IF NOT EXISTS `AreaPermissionBlockTypeAccessList` (
    `paID` int(10) unsigned NOT NULL DEFAULT '0',
    `peID` int(10) unsigned NOT NULL DEFAULT '0',
    `permission` varchar(1) NOT NULL DEFAULT '1',
    PRIMARY KEY (`paID`,`peID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS AreaPermissionBlockTypeAccessListCustom;

CREATE TABLE IF NOT EXISTS `AreaPermissionBlockTypeAccessListCustom` (
    `paID` int(10) unsigned NOT NULL DEFAULT '0',
    `peID` int(10) unsigned NOT NULL DEFAULT '0',
    `btID` int(10) unsigned NOT NULL DEFAULT '0',
    PRIMARY KEY (`paID`,`peID`,`btID`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;



DROP TABLE IF EXISTS Areas;

CREATE TABLE IF NOT EXISTS `Areas` (
    `arID` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `cID` int(10) unsigned NOT NULL DEFAULT '0',
    `arHandle` varchar(255) NOT NULL,
    `arOverrideCollectionPermissions` tinyint(1) NOT NULL DEFAULT '0',
    `arInheritPermissionsFromAreaOnCID` int(10) unsigned NOT NULL DEFAULT '0',
    `arIsGlobal` int(1) unsigned NOT NULL DEFAULT '0',
    PRIMARY KEY (`arID`),
    KEY `arIsGlobal` (`arIsGlobal`),
    KEY `cID` (`cID`),
    KEY `arHandle` (`arHandle`)
) ENGINE=MyISAM AUTO_INCREMENT=547 DEFAULT CHARSET=utf8;