Page 1 of 1

Big problem creating user accounts

PostPosted: Sat Oct 01, 2011 11:28 am
by briansd
Users can't create an account. Everything works fine in the web page except this. Everytime I try to create a new user I get this fatal error. If anyone knows how to solve the problem please reply. Thanks!!



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 /htdocs/potencialdigital/remate/dataface/actions/register.php:215 Stack trace: #0 /htdocs/potencialdigital/remate/dataface/actions/register.php(309): dataface_actions_register->createRegistrationTable() #1 [internal function]: dataface_actions_register->processRegistrationForm(Array) #2 /htdocs/potencialdigital/remate/dataface/lib/HTML/QuickForm.php(1626): call_user_func(Array, Array) #3 /htdocs/potencialdigital/remate/dataface/actions/register.php(131): HTML_QuickForm->process(Array, true) #4 /htdocs/potencialdigital/remate/dataface/Dataface/Application.php(1323): dataface_actions_register->handle(Array) #5 /www/qu in /htdocs/potencialdigital/remate/dataface/actions/register.php on line 215

Re: Big problem creating user accounts

PostPosted: Mon Oct 03, 2011 12:00 pm
by jonbfl
Since what you are getting is a SQL syntax error - 'I think' two things are possible -

1st Case - unbeknownst to you, some part of your structure is causing a fault in Xataface's logic - i.e. an unexpected value or type of value is being passed (or parsed)

2nd Case - The SQL parser that is built into XAMPP is failing to evaluate an expression correctly, resulting in a passed SQL query that MySQL errors out on.

These may sound the same, but I think there's a difference - 1st case - Structure/Schema issue, 2nd case - bad parsing of SQL argument embedded in Xataface (perhaps a lookup query) by the Xataface SQLParser.

I'm just a user here, so this is only speculation.

I'd suggest you post the Structure/Schema for your users table.

Good Luck
:)