A place to discuss and receive support for the Web Auction application.
by Jim Bierbaum » Wed Dec 07, 2011 1:29 pm
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
-
- Posts: 9
- Joined: Mon Dec 05, 2011 2:13 pm
by Jim Bierbaum » Thu Dec 08, 2011 1:05 pm
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.
-
Jim Bierbaum
-
- Posts: 9
- Joined: Mon Dec 05, 2011 2:13 pm
by shannah » Mon Dec 12, 2011 3:21 pm
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
-
shannah
-
- Posts: 4457
- Joined: Wed Dec 31, 1969 5:00 pm
by Jim Bierbaum » Tue Dec 13, 2011 2:26 pm
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
-
- Posts: 9
- Joined: Mon Dec 05, 2011 2:13 pm
by Jim Bierbaum » Thu Dec 15, 2011 7:43 am
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.
-
Jim Bierbaum
-
- Posts: 9
- Joined: Mon Dec 05, 2011 2:13 pm
by shannah » Thu Dec 15, 2011 9:05 am
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
-
shannah
-
- Posts: 4457
- Joined: Wed Dec 31, 1969 5:00 pm
by Jim Bierbaum » Thu Dec 15, 2011 3:27 pm
Thanks a lot, I'll check it out.
-
Jim Bierbaum
-
- Posts: 9
- Joined: Mon Dec 05, 2011 2:13 pm
by Jim Bierbaum » Wed Dec 21, 2011 2:26 pm
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
-
Jim Bierbaum
-
- Posts: 9
- Joined: Mon Dec 05, 2011 2:13 pm
Return to Web Auction Discussion
Who is online
Users browsing this forum: No registered users and 1 guest
|