Install problem

[Jim Bierbaum]

I am new to PHP and SQL, running WAMP on a local server (Apache 2.2.21, PHP 5.3.8, SQL 5.5.16), webauction 0.3.10 downloaded as a zip file, using the browser-based installation instructions.

Following the installation instructions, when I get to the step to do the SQL command: <?PHP include 'install/install.sql'?> when I put that in on the SQL tab in PHPmyadmin, I get the error "#1064 you have an error in your SQL syntax..."

I thought I followed all the steps, but I may have missed something. Any help figuring out where I'm going wrong would be much appreciated.

Thanks,
JB

[Jim Bierbaum]

I got some help to figure out what I was doing wrong, and think I've got the installation done, but now I'm getting an error message. After starting web auction and then going to "create user", when I fill in all the user information and submit, I get this error:

( ! ) Fatal error: Uncaught exception 'Exception' with message 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ' in C:\wamp\www\webauction-0.3.10\dataface\actions\register.php on line 215
( ! ) Exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(11) not null, registration_data longtext not null, primary key (registr' at line 3 in C:\wamp\www\webauction-0.3.10\dataface\actions\register.php on line 215
Call Stack
# Time Memory Function Location
1 0.0017 377680 {main}( ) ..\index.php:0
2 0.0518 2021560 Dataface_Application->display( ) ..\index.php:23
3 0.1342 5651928 Dataface_Application->handleRequest( ) ..\Application.php:1791
4 0.4603 9949440 dataface_actions_register->handle( ) ..\Application.php:1323
5 1.0329 13967728 HTML_QuickForm->process( ) ..\register.php:131
6 1.0329 13968968 call_user_func ( ) ..\QuickForm.php:1626
7 1.0329 13969016 dataface_actions_register->processRegistrationForm( ) ..\QuickForm.php:1626
8 1.0331 13969016 dataface_actions_register->createRegistrationTable( ) ..\register.php:309

Any advice would be most appreciated.

[shannah]

Looks like there may be some SQL in creating the registrations table that some versions of MySQL object to. I have fixed this in SVN.
Try replacing your dataface/actions/register.php file with the one at
http://weblite.ca/svn/dataface/core/bra ... gister.php

[Jim Bierbaum]

Thanks for the reply, I think that may have done the trick, but now I've got another problem, which I think is not Web Auction but my local server environment (and please forgive me if this is elementary, but I am new to this). I will be doing an online auction for a nonprofit in a few months, and right now I am trying to test on a local server using WAMP. WHen I try to register it hangs up at the e-mail confirmation step, saying something like "can't connect to host" and "e-mail not sent, try again later." Can you tell me how to get around this obstacle while I'm developing on a local server? Thanks again.

[Jim Bierbaum]

Any guidance would be most appreciated. Not asking to be spoonfed, but I am new to web development with Apache/mySQL/PHP and a local environment, and I'm not sure where to look for answers or help. If you can point me in the right direction, I may be able to figure it out myself.

Would using something like smtp4dev to set up a local SMTP server to simulate e-mail solve my problem and allow me to test with emails?

I should also mention that for security reasons the computer on which I'm doing development is not connected to the Web at all, so I have no e-mail functionality/connectivity.

[shannah]

Sometimes it can be tricky getting mail to work on the localhost. If you search on Google for "WAMP email won't work" or something like that, you'll find a number of informative posts.

Here is one blog post that offers some solutions:
http://www.joshstauffer.com/send-test-e ... ampserver/

-Steve

[Jim Bierbaum]

Thanks a lot, I'll check it out.

[Jim Bierbaum]

FYI, for anyone looking here who might have a similar problem, the software smpt4dev worked like a charm for providing a dummy e-mail server to receive system e-mails from web auction so that it can be tested on a local server with no e-mail connection. I registered a user and got bid and outbid notices

Thanks for your help!

JB