Elxis CMS Forum

Extensions => Components => Topic started by: bobsmithjr on December 23, 2009, 06:37:27

Title: IOS Reservations, installation error [SOLVED]
Post by: bobsmithjr on December 23, 2009, 06:37:27
Hi, I just purchased the IOS Reservations 3 component for Elxis CMS.

After installing Elxis and following all the steps in http://wiki.elxis.org/wiki/IOSR_Installation to install IOS Reservations, i get this error:



PHP error

URI: index2.php
Path: \administrator\components\com_installer\component\component.class.php
Line: 180
require_once(\nawinfs04\home\users\web\b2918\rh.xxxxxxx\xxxxxxx\administrator\components\com_reservations\/install.reservations.php) [function.require-once]: failed to open stream: No such file or directory



also, when i go into the control panel i get these errors:



mysql Error [1146] : EXECUTE
URI: index2.php?option=com_reservations
Message: Table 'elxis.elx_res_reservations' doesn't exist
SELECT COUNT(r.resid) FROM elx_res_reservations r LEFT JOIN elx_res_hotels h ON h.hid=r.hid

mysql Error [1146] : EXECUTE
URI: index2.php?option=com_reservations
Message: Table 'elxis.elx_res_reservations' doesn't exist
SELECT COUNT(r.resid) FROM elx_res_reservations r LEFT JOIN elx_res_hotels h ON h.hid=r.hid WHERE r.confirmed='0'

mysql Error [1146] : EXECUTE
URI: index2.php?option=com_reservations
Message: Table 'elxis.elx_res_reservations' doesn't exist
SELECT r.resid, r.resdate, r.ofirstname, r.olastname, r.rescode FROM elx_res_reservations r LEFT JOIN elx_res_hotels h ON h.hid=r.hid ORDER BY r.resdate DESC LIMIT 0,1



I'm using PHP version 5.2 and have mySQL database. so I'm not sure why I'm getting these errors...
I think the problem is that its not creating or populating the mySQL tables. But im not too sure, can anyone help?

Thanks in advance,
Alex
Title: Re: IOS Reservations, installation error
Post by: datahell on December 23, 2009, 13:58:51
The installation failed most probably due to files/folders permissions.

Clean previous install:
Delete folder: components/com_reservations/
Delete folder: administrator/components/com_reservations/

Make folder components/ write-able (permissions 777)
Make folder administrator/components/ write-able (permissions 777)

Install IOS Reservations.
Title: Re: IOS Reservations, installation error
Post by: bobsmithjr on December 23, 2009, 21:09:58
Those folders were already set as "777"

so, i uninstalled it and deleted those folders. then set the permissions again to "777".

then i reinstalled it and it still gives me this error:

PHP Error [Warning]
URI: index2.php
Path: \administrator\components\com_installer\component\component.class.php
Line: 180
require_once(\nawinfs04\home\users\web\b2918\rh.xxxxxxx\xxxxxxx\administrator\components\com_reservations\/install.reservations.php) [function.require-once]: failed to open stream: No such file or directory

 ??? ???
Title: Re: IOS Reservations, installation error
Post by: datahell on December 23, 2009, 21:14:05
You are on a windows server I see. I guess you have Plesk control panel and open_base_dir enabled.
Can you install anything else? Do you have XML and zlib support in your PHP? Are file uploads enabled? Is the php temporary directory properly set up in your php.ini? Try to install a module (any module).
If you can not install it send me with a personal message username/password to elxis administration and to your FTP to install it for you.
Title: Re: IOS Reservations, installation error
Post by: bobsmithjr on December 24, 2009, 00:53:44
i tried installing the modules. They work.
Only the main component doesn't install properly.

i'm gonna send you my information in a PM.

Thank you! :)
Title: Re: IOS Reservations, installation error
Post by: datahell on December 24, 2009, 09:01:17
IOS Reservations installed successfully. Case closed.
Title: Re: IOS Reservations, installation error [SOLVED]
Post by: bobsmithjr on December 24, 2009, 21:20:46
;D
Thanks datahell!

if you don't mind me asking, what specifically was the problem? because i tried everything.
Title: Re: IOS Reservations, installation error [SOLVED]
Post by: datahell on December 24, 2009, 21:42:58
The problem was your server, it could nt execute the IOSR installer script after unzipping the component. Some windows servers have several strange problems, I had no time to find out why your server could not execute the installer. If it was a UNIX based server I would have an answer, but not for windows. Windows are not built for servers but for desktop computers.

So what I did was to install manually IOS Reservations database via phpmyadmin. I also fixed permissions, cleaned-up your previous installations and temporary folder, changed your database password (your site could not connect to database) and bring the site back online.
Title: Re: IOS Reservations, installation error [SOLVED]
Post by: bobsmithjr on December 25, 2009, 21:40:32
oh, ic..

and i have 1 more question for you..  where is the config.php file located so i can change the password to my database?
because apparently 3 of my databases are sharing 1 password, so if i change one, the other one is inaccessible.

thanks datahell
Title: Re: IOS Reservations, installation error [SOLVED]
Post by: datahell on December 25, 2009, 22:07:03
You change the database password from your hosting control panel. After changing the password you have to update Elxis configuration file with the new password. This file is named configuration.php and is located in Elxis root folder.

Be careful as configuration.php is UTF-8 encoded. Edit it with a text editor such as pspad or notepad++
Title: Re: IOS Reservations, installation error [SOLVED]
Post by: bobsmithjr on December 25, 2009, 22:52:33
OH!! ok, i see it now.. because i was looking for it in the folder and it was 0 kb. i guess that it only updates after the installation. now i understand  :D