Thread

Hi There,

I have been given all files folders and databases from the UK administator to create an Australian variant.

All files have been uploaded to a test site and the website functions correctly.

I have purchased a licence but have encountered a few problems that I was hoping to resolve.

The original UK site was built using version v1.6.6 of Expression Engine and I cannot seem to access the control panle it will not take my authentication

The MySQL database and the Config.php file have been updated and all links appear to be working but now I need access to the ExpressionEngine Control Panel.

Several questions:
1   Should I update Expression Engine to v2.4.0
2   Where do I enter my ExpressionEngine licence number or Username and Password. The ones I use for the website don’t work in the attached screen grab.
3   Is the ExpressionEngine login preventing me from accessing control panel?

Your help would be appreciated.

Can you confirm that I have posted into the right forum.

It appears my post has slipped off the radar. Is my request too basic / too hard / or does not contain enough information?

Hi Creatology

If you can’t access the control panel using the login provided have you checked that the user/pass is correct? If you have the correct email account for that username you can always use the Forgot password function on the login screen.

For EE1.6 you can enter the licence number under Admin ›  System Preferences ›  General Configuration in the control panel.

1. It’s well worth upgrading to the newest version (currently EE2.4) as it contains many new features, official support for the 1.x series will be stopping soon.
2. For EE2 you enter the licence number on the install/upgrade screen
3. Yes, if your login is wrong you won’t be able to access the CP

The site currently resides in the UK and a second copy exists on my test server for adaption for the Australian market.

I have spend the entire day trying to get an outcome….The site works 100% on the test server other than the control panel.

It was built using EE v1.6 in the UK and so I don’t want a clean install here I just want to try and get access to the control panel to make some alts and upgrade to v2.4.

I don’t know the UK site EE login details, and I have purchased a licence yesterday to try and gain access to this Australian copy of the website.

Is there a way I can set the username, password and email details to gain access to the control panel?

If it’s an exact copy of the UK site (including database) then the login will be the same on both versions. If you’re comfortable using mysql you could change the main admin account’s email address in the database then use the Forgot password to reset the password.

How do I determine the username? Or will that be available in MySQL?

Yes you’ll find usernames in the database,

The SQL database I have looked into doesn’t appear to have entries that I can see for admin accounts email, user and password.

I take it this info is not stored in any of the PHP files but the main SQL file…can you elaborate on what I should by looking for and whether this SQL database that was backed up might have been strippped of the admin details?

Accounts are listed in the exp_members table in the database.

Hello Creatology and Rob,

I am sorry to hear you are running into this snag Creatology.

It sounds like you are on the right path. So I will not disrupt that. You will be able to find the user in the exp_members table as Rob has mentioned.

I am curious. What behavior did you observe when your credentials were not accepted? For example, does it just take the information and then return you to the same page with the username and password fields now empty? Or does it take you elsewhere? Did you happen to notice if the url in the url bar changed in anyway? If it does, would you mind describing that here?

I will do my best to help you with this and I am looking forward to your response.

Cheers!

Hi Shane,

I modified the SQL database to forward an existing Super Administator member’s password reset to my email and was able to get access that way.

I now can access the CP but there is no formatting in place, which I am trying to solve.

The login window for the CP also lacked formatting all away along this process.

At the start - It only recognised users that already existed in the SQL database and would report back a password error. If I tried my EE username and password it reported back user not in database, the same for the email.

My next challenge will be upgrading to version 2.4….but the formatting is my issue at the moment…ideas would be welcome.

Hello Creatology,

I am glad one hurdle has been cleared.

The formatting, background, CSS and all that great stuff comes from the Themes folder. You might try uploading that folder again just in case the upload was not great, or check the directory/file permissions.

If that does not work, please let me know and we can go from there.

Cheers,

I have progressed further to an upgraded to version 2.4

All seemed to be sucessful and I have removed the installer folder as required.

However I am now reciving an error when I try to acces bothe site and the CP as follows:

“Your config file does not appear to be formatted correctly.”

The config file follows….is there a glaring error that I am missing?

I have not altered the EE version that could be 1 error??

<?php

if ( ! defined(‘EXT’)){
exit('Invalid file request');
}

$conf[‘app_version’] = “166”;
$conf[‘license_number’] = “1111-1111-1111-1111”;
$conf[‘debug’] = “1”;
$conf[‘install_lock’] = “1”;
$conf[‘db_hostname’] = “n3-db_hostname.ISP.com.au”;
$conf[‘db_username’] = “username”;
$conf[‘db_password’] = “password”;
$conf[‘db_name’] = “db_name_db”;
$conf[‘db_type’] = “mysql”;
$conf[‘db_prefix’] = “exp”;
$conf[‘db_conntype’] = “0”;
$conf[‘system_folder’] = “seaband-admin”;
$conf[‘cp_url’] = “http://test.mydomain.com.au/seaband-admin/index.php”;
$conf[‘doc_url’] = “http://expressionengine.com/docs/”;
$conf[‘cookie_prefix’] = “”;
$conf[‘is_system_on’] = “y”;
$conf[‘allow_extensions’] = “y”;
$conf[‘multiple_sites_enabled’] = “n”;
$conf[‘admin_session_type’] = “s”
?>

Got past the “Your config file does not appear to be formatted correctly” by adding the following into the config.php file:
$config[‘uri_protocol’]  = “QUERY_STRING”;

Now a new problem….formerley vers 1.6 didn’t have a folder called code igniter and I’m having issues with a database that was working fine in v1.6

I now get on both site and CP the following:
An Error Was Encountered
You have specified an invalid database connection group

This has stumped me…can I add an entry to PHP file to get around this? Any ideas welcome.

Hello Creatology,

I am sorry about all these snags you are hitting.

After the update your config.php file should list the version as $config[‘app_version’] = ‘240’;

If the version is different then the update did not complete successfully.

The above config file that you show is not the correct file, that looks like the old 1.X config file. Did you upload the old config file after updating?

Let me know what you find. It may be that you will need to roll back and use your backup and run the update again, or possibly just upload the correct files and edit them accordingly.

Please let me know if I can clarify any of these points or if you need anything else.

Cheers,