Skip to main content ↑ ↓
Topic: SQL Server PHPrad syntax errors? (Read 564 times) previous topic - next topic

SQL Server PHPrad syntax errors?

So I have spent some time trying to figure out what's going on.
I did a SQL trace on the authentication form. I captured the below
Alter table statement. I then looked at the table and noticed that the
column was not entered, no change was made to the table. I copied the
query and tried to run it. It was immediately flagged with syntax errors.
Please see below. Can someone look into this?

MSSQL Server

This is from PHPRAD
ALTER TABLE `Users` ADD `email_status` VARCHAR(255) NULL;

This is correct.
ALTER TABLE Users ADD email_status VARCHAR(255) NULL;

Re: SQL Server PHPrad syntax errors?

Reply #1 –
Also, note that under General Settings-> "System default setting" -> Default
database setting. The database dropdown select box does not have mssql server
as a selection, and MYSQL is the default database selection and by default the
"Apply to all pages on property changes" is selected. Deselecting the "Apply to all
pages on property changes" does not hold. whenever PHPrad is started this
option is preselected.

Re: SQL Server PHPrad syntax errors?

Reply #2 –
@dra‍ the General or Global settings are the default setting you want phprad to use when presented with the creation page for a new project.

Re: SQL Server PHPrad syntax errors?

Reply #3 –
@willvin. Yes I get that. Thing is, MS SQL server is not in the dropdown as an option to choose as the database type.
I was wondering if this might be the cause of the syntax issue for generating the tables in my mssql database.
Also If I untick the "Apply to all Pages on Property Change", then save the changes, then open the project again, the
"Apply to all Pages on Property Change" check box is ticked. Again note that the Default database is MYSQL and there
is no option to change to mssql.