Howdy guys,
I have WebAuction installed on a centos box,
PHP 5.3.8, mysql Ver 14.14 Distrib 5.5.15, for Linux (i686) using readline 5.1, apache.
Everything installed fine, and i have added some auctions as admin. I can manually add users while logged in as admin..
When i log out and try to register a new user, i get the following error (i followed the other thread which allows the debugging to go to screen)
----------
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 '(11) not null, registration_data longtext not null, primary key (registr' at line 3' in /var/www/html/webauction-0.3.10/dataface/actions/register.php:215 Stack trace: #0 /var/www/html/webauction-0.3.10/dataface/actions/register.php(309): dataface_actions_register->createRegistrationTable() #1 [internal function]: dataface_actions_register->processRegistrationForm(Array) #2 /var/www/html/webauction-0.3.10/dataface/lib/HTML/QuickForm.php(1626): call_user_func(Array, Array) #3 /var/www/html/webauction-0.3.10/dataface/actions/register.php(131): HTML_QuickForm->process(Array, true) #4 /var/www/html/webauction-0.3.10/dataface/Dataface/Application.php(1323): dataface_actions_register->handle(Array) #5 /var/www/html/webauction-0.3.10/dataface/Dataface/Application.php(1791): Dataface_Application->handleRequest(false) #6 /var/www/html in /var/www/html/webauction-0.3.10/dataface/actions/register.php on line 215
-----------
I have modified the register.php to the app line too..
conf.ini
[_auth]
;auth_type=ldap
;url="https://my.sfu.ca/cgi-bin/WebObjects/cas.woa/wa"
users_table = users
username_column = username
password_column = "password"
allow_register=1
Any ideas?