Re: [Virtuoso-users] virtuoso-php5-t crashes on Vista with malformed SQL

[Mitko I. <im...@op...>]

Hi Sören,

I tried the case locally, but just getting :

Warning: PHP Startup: SQL error: [OpenLink][Virtuoso ODBC
Driver][Virtuoso Server]SQ074: Line 1: syntax error at '*' before
'FROM', SQL state 37000 in SQLExecDirect in
C:\dbs\var\lib\virtuoso\vsp\vos1.php on line 3
Warning: odbc_result_all(): supplied argument is not a valid ODBC result
resource in C:\dbs\var\lib\virtuoso\vsp\vos1.php on line 4

There are two things that can be tried:
- need to check if this is inside php lib as
  * make the c:\<vos-dir>\lib to take precedence to the your PHP install
path, i.e. the c:\<vos-dir>\lib to be at the front of the PATH.
     OR just temporarily rename the php5ts.dll in your PHP install to
something else .
     The idea is to use the php5ts.dll which is in the binary package,
i.e. one used to link against it.
  * run the virtuoso-php5-t and repeat the experiment, see if it crashes

- rename the php.ini from PHP install, so it can be seen if there is an
startup option causing one of virtuoso-php5-t, virtodbc.dll & php5ts.dll
to crash
  run the virtuoso-php5-t and repeat the experiment, see if it crashes
  if it doesn't crash lpease send me your php.ini so i can try to
reproduce locally and debug etc.

- if non of the above makes it to work, then please enable Drwtsn32 to
do mini-dump, the procedure is as follows :
  * run from command line "Drwtsn32 -i", should say installed
  * run Drwtsn32 again and configure to do mini-dump
  * repeat the experiment , when it crashes the drwtsn  should produce 
a user.dmp  (or whatever is  speicfied in it's config screen)
so if you get a mini dump, please send it to us  so we can  try to  see 
in which component is it.
 
Best Regards,
Mitko

Sören Auer wrote:
> On 10/3/07, Hugh Williams <hwi...@op...> wrote:
>   
>> 1. Confirm the Version of the Virtuoso ODBC Driver being used which can be
>> obtain from the Drivers Tab of the ODBC Administrator
>>     
>
> The drivers tab contains for Virtuoso:
>
> Name: Virtuoso (Open Source)
> Version: Not marked
> Company: Not marked
> File: VIRTODBC.DLL
> Date: 10/2/2007
>
> i.e. I downloaded and installed the package virtuoso-opensource-win32-5.0.2.zip
>
>   
>> 2. Provide and ODBC trace of the attempted connection such that we can see
>> where in the ODBC layer the failure is occurring possibly.
>>     
>
> I just tried many times to produce the log, but the log-file is simply
> not created :-( Must be a Vista bug.
>
>   
>> 3. Provide a copy of your virtuoso.log such that we can see if any errors
>> are reported here.
>>     
>
> Is attached.
>
> Sören
>   
> ------------------------------------------------------------------------
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Splunk Inc.
> Still grepping through log files to find problems?  Stop.
> Now Search log events and configuration files using AJAX and a browser.
> Download your FREE copy of Splunk now >> http://get.splunk.com/
> ------------------------------------------------------------------------
>
> _______________________________________________
> Virtuoso-users mailing list
> Vir...@li...
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users


-- 
Mitko Iliev
Developer Virtuoso Team
OpenLink Software
http://www.openlinksw.com/virtuoso
Cross Platform Web Services Middleware