• Registered: 2009-03-16
  • Posts: 1

Topic: Strange error when installing for the first time...any help?

Hello,
I am working on installing miaCMS after really liking the demo and info on it. I checked the requirements, and have done everything I should have done for miaCMS to work properly, or atleast I think I have. I first uploaded the files to a sub-directory of my site for testing purposes, after I change configuration.sample.php to configuration.php. I have checked the file to make sure I changed everything that needed to be changed in this file. Then I created the MySQL databases in CPanel, just like I would usually do. But when I go to the subdirectory, I get a VERY strange error that I have no idea about...I've taken out all 'personal' info, so I can keep my domain private. All changes displayed in brackets {}.

Warning: Invalid argument supplied for foreach() in /home/{user}/public_html/cms/mia/includes/core.classes.php on line 2162
DB function failed with error number 1146
Table '{user}_miadb.mia_session' doesn't exist SQL=SELECT session_id FROM mia_session WHERE session_id=MD5('{i think this string is supposed to be private}')
SQL =

SELECT session_id FROM mia_session WHERE session_id=MD5('{i think this string is supposed to be private, but this is the same string as the first MD5 thing.}')

I hope this makes sense to someone because I'm at a complete loss on what to do. Any help is appreciated. Thanks in advance!

  • From: ph
  • Registered: 2008-05-02
  • Posts: 104

Re: Strange error when installing for the first time...any help?

It appears like you miacms installation is either incomplete or doesn't have any tables.

I suggest that you remove the configuration.php file and just run the installation via the web installer. If you remove the configuration.php, accessing your miacms installation should automatically take you to the installer. It should automatically populate the tables for you, and generate a configuration.php, if for some reason miacms cannot generate the file, at the end of the installation it will give you the 'text' which you can manually paste later to your configuration.php.

---------------------------------------------------------

however, if for some reason you want to continue with your "manual" installation. Just run the queries that will populate your database with data needed for miacms to run.

1.) open your /installation/sql/miacms.sql
2.) edit it and using a text editor, replace all instances of #_ with mia_
3.) open /installation/sql/sample_data.sql
4.) do step 2 on /installation/sql/sample_data.sql
5.) Go to your phpmyadmin, and select the miacms database you have created
6.) Click the 'SQL' link, and paste the results of 2.) and 4.)
7.) Run the query
8.) Lasty, run this query in the SQL box too in phpmyadmin, this should add the default admin user

INSERT INTO `mia_users` VALUES (62, 'Administrator', 'admin', '[email protected]', MD5('let_me_in'), 'Super Administrator', 0, 1, 25, NOW(), '0000-00-00 00:00:00', '', ''

The above query creates an admin user for you, password is let_me_in , don't forget to change it to something else right after you login in

Let us know how it goes

Last edited by Arpee Ong (2009-03-17 02:24:44)