SQL Syntax Error

Hi WA,

Just created a few pages using Siteassist Pro v1.0.9 and then used Dataassist 2.0.8. All looked like it worked when using the wizard however when accessing the pages I received the following error

"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 '2, Suburb, Postcode, Agency_Admin_Contact, Agency_Admin_Email, Agency_Admin_Tel,' at line 1"

Do you have any idea if this a key field error or other? I understand that its a recent version of MySQL - PS4.5 instals without a problem for example.

Thanks.

It looks to me like you have a column name in your table that has a space in it, perhaps the column is named "Address 2".


Spaces should be avoided when naming database objects like tables or columns.

Thanks Jason - that was it!

I now have another error after inserting a record.

"The requested URL /share/MD0_DATA/Web/mason/admin/manageusers/searchusers/userdetail.php was not found on this server."

it appears to be grabbing additional folder details "/share/MD0_DATA/Web/" if I edit the URL to remove this on the browser the page loads correctly

The page code looks correct " $WA_redirectURL = "searchusers/userdetail.php";"

Any clues on this one?

Cheers

there is a fix for this issue in the known issues section of the Data Assist 2 download center page.

Thanks Jason - I'll get onto it.