IOS Reservations, installation error [SOLVED]

[bobsmithjr]

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

[datahell]

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.

[bobsmithjr]

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

 

[datahell]

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.

[bobsmithjr]

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!

[datahell]

IOS Reservations installed successfully. Case closed.

[bobsmithjr]

Thanks datahell!

if you don't mind me asking, what specifically was the problem? because i tried everything.

[datahell]

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.

[bobsmithjr]

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

[datahell]

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++

[bobsmithjr]

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