Elxis CMS Forum

Support => Elxis 4.x/5.x DEV => Topic started by: xmanhattan on September 26, 2012, 17:14:08

Title: install not working
Post by: xmanhattan on September 26, 2012, 17:14:08
Hello guys,

I just downloaded the latest version and tried to install but I am seeing the following msg from the nautilus error log:
Quote
[2012-09-26 14:01:59]    ERROR in file C:\wamp\www\nautilus\includes\libraries\elxis\database\statement.class.php line 41
Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'nautilus.elx_components' doesn't exist' in C:\wamp\www\nautilus\includes\libraries\elxis\database\statement.class.php:41
Stack trace:
#0 C:\wamp\www\nautilus\includes\libraries\elxis\database\statement.class.php(41): PDOStatement->execute(NULL)
#1 C:\wamp\www\nautilus\includes\libraries\elxis\uri.class.php(374): elxisPDOStatement->execute()
#2 C:\wamp\www\nautilus\includes\libraries\elxis\uri.class.php(71): elxisUri->loadRoutes()
#3 C:\wamp\www\nautilus\includes\loader.php(101): elxisUri->__construct()
#4 C:\wamp\www\nautilus\includes\loader.php(208): elxisLoader::loadInit('libraries:elxis...', 'eURI', 'elxisUri')
#5 C:\wamp\www\nautilus\index.php(18): require('C:\wamp\www\nau...')
#6 {main}
  thrown


Title: Re: install not working
Post by: webgift on September 26, 2012, 17:22:02
Hello Peter,
As it seems you use PHP 5.2.x which PDO library to access the database is disabled by default. Make me a favor.
Go to your php.ini file and find out these 2 lines:
extension=php_pdo.dll
extension=php_pdo_mysql.dll


Are these 2 lines commented with ; character at the front? If yes then remove the ; character and restart the Apache server.
Hope this will help you.
Title: Re: install not working
Post by: xmanhattan on September 26, 2012, 17:35:57
Hello webgift,

I have changed the settings in wamp as follows and did a restart but still no good same problem:
Code: [Select]
extension=php_pdo_firebird.dll
;extension=php_pdo_mssql.dll
extension=php_pdo_mysql.dll
;extension=php_pdo_oci.dll
;extension=php_pdo_odbc.dll
;extension=php_pdo_pgsql.dll
extension=php_pdo_sqlite.dll

Title: Re: install not working
Post by: webgift on September 26, 2012, 17:41:35
Hello!!
1. Have you do the same with the line below?:
extension=php_pdo.dll
2. Have you restart the apache server server?
Title: Re: install not working
Post by: xmanhattan on September 26, 2012, 17:53:32
I did not find that line in the settings or in the php ext directory. 
I am using php 5.3.13

Title: Re: install not working
Post by: datahell on September 26, 2012, 19:50:33
When elxis can't connect to db generates a fatal error.
Did you tried to install Elxis or you did something weird by yourself?
From the error message you posted looks like you try to use Elxis without installing it first...

Elxis install procedure
1. Download Elxis from elxis.org
2. Unzip it in your site (don't touch any file!)
3. Create an empty database
4. Visit the site with your browser (eg http://localhost )
5. The web installer will automatically appear, follow the installer steps to install elxis.


Tips
1. On database settings page click on "check connection" to make sure your settings are correct.
2. Do the same as above for the FTP settings in case you want to enable FTP.
3. After install ends if elxis is not able to create the configuration.php file create it manually with the data it provides you with. If there are no data (due to some error) use the sample_configuration.php file and edit it manually.
4. Elxis requires PDO. PDO is by default enabled in newer PHP versions. If not, edit your php.ini to enable PDO and restart your web server.
Title: Re: install not working
Post by: Amigamerlin on September 26, 2012, 20:52:07
When elxis can't connect to db generates a fatal error.
Did you tried to install Elxis or you did something weird by yourself?
From the error message you posted looks like you try to use Elxis without installing it first...

Elxis install procedure
1. Download Elxis from elxis.org
2. Unzip it in your site (don't touch any file!)
3. Create an empty database
4. Visit the site with your browser (eg http://localhost )
5. The web installer will automatically appear, follow the installer steps to install elxis.


Tips
1. On database settings page click on "check connection" to make sure your settings are correct.
2. Do the same as above for the FTP settings in case you want to enable FTP.
3. After install ends if elxis is not able to create the configuration.php file create it manually with the data it provides you with. If there are no data (due to some error) use the sample_configuration.php file and edit it manually.
4. Elxis requires PDO. PDO is by default enabled in newer PHP versions. If not, edit your php.ini to enable PDO and restart your web server.

Sorry datahell just a aquestion.
Have the elxis_4.0_nautilus_beta_rev1297 the web installer in it?
I ask this because I never was able to see the web installer. I was curious about your install instruction in this post and because of it I just download it again and uncompressed in a directory (http://localhost/elxis4) but when I call the url : http://localhost/elxis4 I'll redirect to http://localhost and no webinstaller come out.
Is this normal ?

Let me know.

PS: Sorry for the off topic.

PPS: Since no web installer I manually installed it for my test.
Title: Re: install not working
Post by: @ndreas on September 26, 2012, 21:20:50
You have to install elxis at the root folder, not subfolder
Title: Re: install not working
Post by: Amigamerlin on September 26, 2012, 22:01:16
You have to install elxis at the root folder, not subfolder

Sorry but for me have no sense ; I don't understand ... If it can work in a subfolder (I'm currently using it in a subfolder without problem) why the installer shouldn't work?

Datahell is just a beta limitation or what? please can you provide a definitve answers about?

Thank you in advance.
Title: Re: install not working
Post by: datahell on September 26, 2012, 22:46:41
Elxis 4.0 does have a web installer. It is just not so obvious like 2009.3 and you should not delete it like you did on 2009.3.
The installer is here: includes/install/

Your problem is due to a re-direction elxis installer performs as it tries to force redirect you to the web site root.
I guess the redirection is not perfect for sub-folders... as it thinks that the folder is a category or something like that. I will check it and fix this if need it.

To stop redirection (just for your local site) open file includes/install/install.class.php
and put above line 591 ( if ($reload == true) { ) this:

Code: [Select]
$this->url = 'http://localhost/elxis4';
$reload = false;
Title: Re: install not working
Post by: nikos on September 26, 2012, 23:06:14
Facing the same as Amigamerlin i just did the above and web installation starts. But on step 3 after setting database data (name, username, password) and clicking on submit to proceed to step 4, it returns to step 1.

Earlier today trying to find a solution on this i changed line 570

if (file_exists(ELXIS_PATH.'/'.$newpath.'/includes/version.php')) {

with this

if (file_exists(ELXIS_PATH.'/includes/version.php')) {

and the installation started but on step 3 after setting database data (name, username, password) and clicking on submit to proceed to step 4, it returns to step 1
Title: Re: install not working
Post by: datahell on September 26, 2012, 23:21:21
I have get bored saying years now, don't install Elxis inside a folder...
I know that it should work there and if the installer has a bug I will fix it but please don't destroy elxis by putting it inside sub-folders.
Especially when there are other sites above it with htaccess overlaps, it becomes a mess...
Elxis is a CMS, it wants to be the master of the web site, not a sub-script.

@nikos: make sure during the installation process the value of the URL text field (elxis asks for validation the site's url I think on step 3) is the correct one.
If you get redirected again to the first step then you either need to debug elxis installer and fix it (...) or move elxis in the root folder, do the installation and then move it back to the folder you want (edit the configuration after the move to change the site's url).
Title: Re: install not working
Post by: nikos on September 26, 2012, 23:28:33
On root works without any problem and i am thinking to have a different setup with wamp which i have already installed in the same pc together with xampp only for nautilus installations.
Title: Re: install not working
Post by: datahell on September 26, 2012, 23:52:02
OK, I will check and fix it tomorrow.
Title: Re: install not working
Post by: nikos on September 26, 2012, 23:53:00
Thank you   :)
Title: Re: install not working
Post by: Amigamerlin on September 27, 2012, 08:13:46
I have get bored saying years now, don't install Elxis inside a folder...
I know that it should work there and if the installer has a bug I will fix it but please don't destroy elxis by putting it inside sub-folders.
Especially when there are other sites above it with htaccess overlaps, it becomes a mess...
Elxis is a CMS, it wants to be the master of the web site, not a sub-script.

Yes Datahell, I remember you each time you have said this  ;D and I was one of them that installed elxis in a subfolder (in my case was the release 2006). but sometimes you have no choice due to specific customer restrictions  :'( .
Anyway, for my personal point of view, we need to have the freedom to choice and is long time that I don't install anymore elxis in real environment subfolder, this just after your suggestion about I should admit  ;).
For my organizzation, on local machine e I MUST INSTALL it on a subfolder.

Thank you for your time and patience.
Title: Re: install not working
Post by: xmanhattan on September 27, 2012, 08:54:35
From what I am reading it looks like the problem is because I am installing it locally in a folder.

As I did not see any screen except a blank one, I assumed that I should edit the config.php file manually.  This is all that I did but it still did not work.

I have always loaded elxis and other programs into separate directories under wamp.  I have 3 elxis 2009.x working at the moment that way for demo purposes to show different extension usage.

I have contacted wamp to find out about the missing dll file.

Title: Re: install not working
Post by: datahell on September 27, 2012, 09:08:07
Don't worry all these issues will be fixed.
This is why the beta versions exist, to check the application in real enviroments and do fixes where needed.
I will do the checks later today and notify you.
Title: Re: install not working
Post by: speck on September 27, 2012, 09:48:36
I have 3 elxis 2009.x working at the moment that way for demo purposes to show different extension usage.

I have contacted wamp to find out about the missing dll file.

Under Wamp, the elxis install works right.
Delete all content u find in the c:/wamp/www or better make a copy of the folder, and place all content of Elxis package in the "www" wamp folder. Open your broswer and type localhost in your browser and elxis4 works right. Rememebr to create a database with phpadmin u find under wamp.

I'm using this "wampserver2.2e-php5.3.13-httpd2.2.22-mysql5.5.24-32b" package and at difference of Xammp (where i had a lot of problem of PHP and much more) i had no problems to install Elxis 4 and use it.
My OS Windows Xp service pack 3.  ;D

Note: Before to use wamp, stop the IIS service and your Mysql.
For security, if u had installed PHP in your windows, rename the file PHP.ini u find in the c:/windows folder.
Title: Re: install not working
Post by: xmanhattan on September 27, 2012, 09:51:21
Thanks Speck, I will wait for the next beta.
Title: Re: install not working
Post by: datahell on September 27, 2012, 21:27:35
Elxis installer fixed for sub-folders and FTP check on rev1302
https://forum.elxis.org/index.php?topic=7214.msg46719;topicseen#msg46719 (https://forum.elxis.org/index.php?topic=7214.msg46719;topicseen#msg46719)
Title: Re: install not working
Post by: nikos on September 27, 2012, 22:34:07
Bravo Datahell

Everything works perfect with rev1302

Thank you once again for your time and effort