blank screen

Asked by Gary Gustafson

I believe everything is setup properly and the database is created and populated with tables (empty).
I have the file in the root folder.
The login screen comes up when I access the program but when I click submit I get a blank page.
I am submitted with no data in the fields since there are no agents in the database.
Memory is set at 96MB so I don't think that is the issue and there is nothing in the error log.
The url on the blank screen is the same as the form /agent/login

2 questions:
- is there any documentation on this program
- what could be the issue with the blank screen
- how do I get some agent info into the database so I can login, is there some sample data?

So I don't know where to go from here. I hope you can offer a suggestion.

Thanks,
Gary

Question information

Language:
English Edit question
Status:
Answered
For:
openauctionlive Edit question
Assignee:
No assignee Edit question
Last query:
Last reply:
Revision history for this message
Michael Paric (mparic) said :
#1

Hi Gary;
Thanks for trying out the program; unfortunately no, there isn't currently any documentation as I've been pulled away on other projects (even though OpenAuctionLive is still used by a couple local organizations in my area; it works great in a thin-client environment). I'm hoping to get back to active development Q2 this year and build an installer.

Regarding your blank screen, possible causes are:
- your /openauctionlive/app/tmp directory is not readable/writable by your web browser
- /openauctionlive/app/config/database.php file is not configured properly (can't log in to database with user/password supplied)

To see for sure, double-check that your php.ini file is writing errors to a log file (http://www.cyberciti.biz/tips/php-howto-turn-on-error-log-file.html), restart Apache, run the program again and look at the end of the log to see why PHP is bonking. The answer is usually obvious once you get the error message, but let me know if it's still cryptic.

Passwords are SHA1 encrypted and you'll need to manually create the Admin user in the database. In MySQL create a new user in the openauctionlive database with the SQL "INSERT into agents (first_name, last_name, email, username, password, role) VALUES ('Admin','Admin','admin@localhost','admin','db28fb34f3cd76e6bfa1b53b132c6f4668077031','admin')". This will create an admin user with the username 'admin', password 'auction'. Once you have that user in the db you can log in and change the password, add new Agents, etc.

Good luck!
Michael

Revision history for this message
Gary Gustafson (garyg) said :
#2

Hi Michael,

Thanks for your help. I followed your guide here but still get the blank screen when submitting the login page.

/app/tmp is mod 777

I assume the database.php is configured properly because the program created the tables using SSH with cake
and I think it has to use the database.php file to do this. How else would I check this.

admin user created ok

I tested the log file with a test php file to generate errors. Writes fine but
php error log reports no errors on this event

I am stuck...

Regards,
Gary
--

----- Original message ----------------------------------------
From: "Michael Paric" <email address hidden>
To: <email address hidden>
Received: 1/2/2012 9:45:52 PM
Subject: Re: [Question #183574]: blank screen

Your question #183574 on openauctionlive changed:
https://answers.launchpad.net/openauctionlive/+question/183574

    Status: Open => Answered

Michael Paric proposed the following answer:
Hi Gary;
Thanks for trying out the program; unfortunately no, there isn't currently any
documentation as I've been pulled away on other projects (even though
OpenAuctionLive is still used by a couple local organizations in my area; it works
great in a thin-client environment). I'm hoping to get back to active development Q2
this year and build an installer.

Regarding your blank screen, possible causes are:
- your /openauctionlive/app/tmp directory is not readable/writable by your web
browser
- /openauctionlive/app/config/database.php file is not configured properly (can't log
in to database with user/password supplied)

To see for sure, double-check that your php.ini file is writing errors
to a log file (http://www.cyberciti.biz/tips/php-howto-turn-on-error-
log-file.html), restart Apache, run the program again and look at the
end of the log to see why PHP is bonking. The answer is usually obvious
once you get the error message, but let me know if it's still cryptic.

Passwords are SHA1 encrypted and you'll need to manually create the
Admin user in the database. In MySQL create a new user in the
openauctionlive database with the SQL "INSERT into agents (first_name,
last_name, email, username, password, role) VALUES
('Admin','Admin','admin@localhost','admin','db28fb34f3cd76e6bfa1b53b132c6f46680
77031','admin')".
This will create an admin user with the username 'admin', password
'auction'. Once you have that user in the db you can log in and change
the password, add new Agents, etc.

Good luck!
Michael

--
If this answers your question, please go to the following page to let us
know that it is solved:
https://answers.launchpad.net/openauctionlive/+question/183574/+confirm?answe
r_id=0

If you still need help, you can reply to this email or go to the
following page to enter your feedback:
https://answers.launchpad.net/openauctionlive/+question/183574

You received this question notification because you asked the question.

Revision history for this message
Michael Paric (mparic) said :
#3

Hmm.. is your PHP Error Report set to:

error_reporting = E_ALL | ~E_STRICT

because some errors are not reported using the stock settings (I've lost a lot of hair due to this one). If you're getting the login screen then you should be connected to the db (you'd get a missing database error right away). I thought I had included some default data, because there's a check for a valid event in the login function in the accounts_controller.php file. You can either add an event_type and then an event manually, or comment-out the checks for the valid Event to see if you can get farther than the blank screen. My apologies for making this tougher than it needs to be; my goal is to get a turn-key system by Q2. In the mean time, I will email you a sample sql file that contains enough default info that should get you going.

Can you help with this problem?

Provide an answer of your own, or ask Gary Gustafson for more information if necessary.

To post a message you must log in.