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..
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..
Hi did you manage to get this sorted , if not PM me for help
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 <discussions@concretecms.com>
To: grannyiescrazy@yahoo.com
Sent: Sunday, December 7, 2014 1:34 PM
Subject: Reinstall : Installation Help
From: concrete5 Community <discussions@concretecms.com>
To: grannyiescrazy@yahoo.com
Sent: Sunday, December 7, 2014 1:34 PM
Subject: Reinstall : Installation Help
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;
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;