Dear:

I use the script for db_sqlsrv.sql for create the table.

I create a new proyect with the “guriddo_5_0_0_sources.zip”, i configured the jq-config.php of the “scheduler” folder, and don’t work.

I use SQL Server 2008 .

Hello,

I can not migrate to guriddo 5_1_0 from jqsuite 4_6_0

the scheduler not work, the same error:

the calendar remains in “loading….”

In firebug:

SQLSTATE[42000]: [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword ‘end’.

Fatal error: Uncaught exception ‘PDOException’ with message ‘SQLSTATE[IMSSP]: The statement must be executed before results can be retrieved.’ in C:\wamp\www\guriddo510\php\PHPSuito\DBdrivers\jqGridPdo.php on line <i>235</i>

( ! ) PDOException: SQLSTATE[IMSSP]: The statement must be executed before results can be retrieved. in C:\wamp\www\guriddo510\php\PHPSuito\DBdrivers\jqGridPdo.php on line <i>235</i>

Can you help me?

The SQL table:

CREATE TABLE [events](
[event_id] [int] IDENTITY(1,1) NOT NULL,
[user_id] [int] NOT NULL DEFAULT 0,
[start_event] [int] NOT NULL DEFAULT 0,
[end_event] [int] NOT NULL DEFAULT 0,
[title] [varchar](255) NOT NULL,
[description] [text] NOT NULL,
[location] [varchar](255) NOT NULL DEFAULT ”,
[categories] [varchar](255) NOT NULL DEFAULT ”,
[access] [varchar](255) NOT NULL DEFAULT ”,
[all_day] [tinyint] NOT NULL DEFAULT 0,
PRIMARY KEY CLUSTERED
(
[event_id] ASC
))

I changed my connection to MYSQL and it works , but not on SQL SERVER.

Is a new proyect folder.

Is urgent, thanks

• This reply was modified 9 years, 10 months ago by MarceloDiazO.
• This reply was modified 9 years, 10 months ago by MarceloDiazO.

Dear Will:

Why do you say “replaces all files” , I mentioned that it is a new project, I have guriddo_5_1_0_sources.zip release .

And I perform the following steps :

1. -Extract the file to a folder named webnot .
2. – Create the table “event” with db_sqlsrv.sql file on the SQL server.
3. – Create the table “event” from the file db_mysql.sql MySQLServer .
4. -Test connection to MySQL and all examples work , also the ” scheduler” .
5. -Test with the connection to SQL Server, run the example of ” jqGrid ” but not the ” scheduler” . , The aforementioned error message appears .

Please give me a solution.

• This reply was modified 9 years, 10 months ago by MarceloDiazO.

Yes ! , Now works properly , thank you very much .
Please include in the next release , it is very important grateful Will!.