Guriddo » MarceloDiazO's Replies

MarceloDiazO

Guriddo

Forum Replies Created

Viewing 4 replies - 1 through 4 (of 4 total)

Author

Replies

June 24, 2016 at 8:29 pm in reply to: Scheduler and SQL Server #125353

MarceloDiazO

Participant

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

&lt;?php
require_once &quot;../php/PHPSuito/jqScheduler.php&quot;;
require_once &quot;../php/PHPSuito/DBdrivers/jqGridPdo.php&quot;;
require_once &quot;jq-config.php&quot;;

ini_set(&quot;display_errors&quot;,1);
//date_default_timezone_set(&#039;Europe/Sofia&#039;);
try {
	$conn = new PDO(DB_DSN,DB_USER,DB_PASSWORD);
	//$conn = sqlsrv_connect( $serverName, $connectionInfo);	   
} catch( Exception $e ) {
	die( &quot;Error connecting to  Server&quot; ); 
}
jqGridDB::query($conn, &#039;SET QUOTED_IDENTIFIER ON&#039;);
// Tell the db that we use utf-8
$conn-&gt;query(&quot;SET NAMES utf8&quot;);
$eventcal-&gt;table = &#039;events&#039;;
//$eventcal-&gt;table = &#039;TURNOS&#039;;
$eventcal = new jqScheduler($conn);
// set ansi quote
$eventcal-&gt;setQuote(&#039;&quot;&#039;);
$eventcal-&gt;setLocale(&#039;en_GB&#039;);
$eventcal-&gt;setUrl(&#039;eventcal.php&#039;);
//$eventcal-&gt;setPdfOptions(array(&quot;path_to_pdf_class&quot;=&gt;&quot;../php/PHPSuito/External/tcpdf/tcpdf.php&quot;));
$eventcal-&gt;setUser(1);
$eventcal-&gt;setUserNames(array(&#039;1&#039;=&gt;&quot;Calender User 1&quot;,&#039;2&#039;=&gt;&quot;Calendar user 2&quot;) );
$eventcal-&gt;setOption(array(&quot;weekends&quot;=&gt;true,&quot;hiddenDays&quot;=&gt;array(0) ));
$eventcal-&gt;render();
?&gt;

<?php

require_once "../php/PHPSuito/jqScheduler.php";

require_once "../php/PHPSuito/DBdrivers/jqGridPdo.php";

require_once "jq-config.php";

ini_set("display_errors",1);

//date_default_timezone_set('Europe/Sofia');

try {

$conn = new PDO(DB_DSN,DB_USER,DB_PASSWORD);

//$conn = sqlsrv_connect( $serverName, $connectionInfo);

} catch( Exception $e ) {

die( "Error connecting to Server" );

}

jqGridDB::query($conn, 'SET QUOTED_IDENTIFIER ON');

// Tell the db that we use utf-8

$conn->query("SET NAMES utf8");

$eventcal->table = 'events';

//$eventcal->table = 'TURNOS';

$eventcal = new jqScheduler($conn);

// set ansi quote

$eventcal->setQuote('"');

$eventcal->setLocale('en_GB');

$eventcal->setUrl('eventcal.php');

//$eventcal->setPdfOptions(array("path_to_pdf_class"=>"../php/PHPSuito/External/tcpdf/tcpdf.php"));

$eventcal->setUser(1);

$eventcal->setUserNames(array('1'=>"Calender User 1",'2'=>"Calendar user 2") );

$eventcal->setOption(array("weekends"=>true,"hiddenDays"=>array(0) ));

$eventcal->render();

June 24, 2016 at 3:43 am in reply to: Scheduler and SQL Server #125342

MarceloDiazO

Participant

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.

June 21, 2016 at 9:09 pm in reply to: Scheduler and SQL Server #125319

MarceloDiazO

Participant

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.

September 2, 2015 at 5:20 pm in reply to: Scheduler and SQL Server #124313

MarceloDiazO

Participant

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 .

Author

Replies

Viewing 4 replies - 1 through 4 (of 4 total)