Installation Help

Database: `redbackd_xxx`
--
CREATE DATABASE IF NOT EXISTS `redbackd_xxx` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
MySQL said: Documentation
#1044 - Access denied for user 'thegrump'@'localhost' to database 'redbackd_xxx'

 

ronyDdeveloper replied on Aug 29, 2013 at 6:40 am Permalink Reply

Well you have exportd the database from localhost. It has a user called "root" or something else. But in live server the username is something different. So try to open the SQL file which you have exported. Then delete the first few lines which is the definition to create database along with database users. You need to delete up to the first occurrence of the below line.
"CREATE TABLE <TABLE_NAME> ..... ".

Rony

chassa2556 replied on Aug 29, 2013 at 7:27 am Permalink Reply

Rony - that worked - thank you so much however I now have any error if you scroll to the bottom of the page

http://thegrumpybadger.co.uk/

mysqlt error: [1054: Unknown column 'isScheduled' in 'where clause'] in EXECUTE("SELECT jID FROM Jobs WHERE isScheduled = 1 ORDER BY jDateLastRun")

Any ideas on this as well??

chassa2556 replied on Aug 29, 2013 at 7:48 am Permalink Reply

Guys thanks for your help have resolved this by updating the install using this link

http://www.yourwebsite.com/index.php/tools/required/upgrade?source=...

Bingo message gone...

hansmonasso replied on Dec 11, 2013 at 4:36 am Permalink Reply

That worked for me too! Thanks a lot!

bobaudio replied on Feb 18, 2014 at 12:36 am Permalink Reply

Hi,
Can you tell me what you did? That link is no longer valid and I am not a back-end savvy person. I am trying to get the web host to resolve it but if they cannot I will be trying myself. I am with Powweb and had to have them fix something so I could get latest update installed and errors were there after update. Site is generic w no add ons or customization- just a slightly modified stock template. Thanks-
B

bobaudio replied on Feb 18, 2014 at 12:56 am Permalink Reply

Hi,
Can you tell me what you did? That link is no longer valid and I am not a back-end savvy person. I am trying to get the web host to resolve it but if they cannot I will be trying myself. I am with Powweb and had to have them fix something so I could get latest update installed and errors were there after update. Site is generic w no add ons or customization- just a slightly modified stock template. Thanks-
B

bobaudio replied on Feb 18, 2014 at 1:04 am Permalink Reply

Hi,
Can you tell me what you did? That link is no longer valid and I am not a back-end savvy person. I am trying to get the web host to resolve it but if they cannot I will be trying myself. I am with Powweb and had to have them fix something so I could get latest update installed and errors were there after update. Site is generic w no add ons or customization- just a slightly modified stock template. Thanks-
B

JohntheFish replied on Aug 29, 2013 at 6:51 am Permalink Reply

Most live server environments set the SQL permissions such that you cant do database level SQL, you can only do table level SQL.

You may need to use your host control panel to create the new database.

You can then use a SQL file to create all the tables and import the site in to the database.

bobaudio replied on Feb 18, 2014 at 11:34 pm Permalink Reply

FIXED my issue might help here:

JohnTheFish in another unrelated thread suggested simple direct database/C5 upgrade:

"http://yoursitehere.com/index.php/tools/required/upgrade"

This showed I could upgrade from earlier ver to 5.6.2.1 for some reason- ran it- errors gone!!

thread I found fix:
http://www.concrete5.org/community/forums/installation/table-jobset...