Sqlite 2.x in Sqlite 3.x world on Sitebuilder 4

[etoh1973]

I'm using Fedora 6 and Plesk 8.2
Version : 2.6.20-1.2962.fc6

When I attempt to publish using FTP; error message is that it can not publish because SQLite 2.x is not installed or found. However, SQlite 3. and pdo_sqlite extensions are found on my server. -- Surprisingly, Sitebuilder 4.0 only supports SQlite 2.x -- and I can not for the life of my find SQlite 2.x source code to recompile.
OK : extension sqlite in state on found ----> what is found?
OK : supported SQLite version 2.x found----------------------> its found? but......................

XCopy gives an error message that it does not have permissions to write, but I can not find documentation to premit XCopy to write to directory for /var/www/vhosts/xxxxxx.com/httpdocs

The other option, I do not have installed on my server using the VIP id.
Any suggestions would be awesome to get this resolved.
check.php -- gives the following results:
OK : supported version of PHP found (5.1.X or newer - 5.2.1)
OK : extension sitebuilder3 in state on found
OK : extension pdo in state on found
OK : extension pdo_mysql in state on found
OK : extension sqlite in state on found ----> what is found?
OK : extension dom in state on found
OK : extension libxml in state on found
OK : extension xml in state on found
OK : extension xsl in state on found
OK : extension spl in state on found
OK : extension pcre in state on found
OK : extension session in state on found
OK : extension simplexml in state on found
OK : extension ftp in state on found
OK : extension openssl in state on found
OK : extension mbstring in state on found
OK : extension soap in state on found
OK : extension gd in state on found
OK : extension ctype in state on found
OK : extension zlib in state on found
OK : extension iconv in state on found
OK : extension posix in state on found
OK : extension curl in state on found
OK : extension mysql in state on found
OK : setting magic_quotes_gpc in state off found
OK : setting magic_quotes_runtime in state off found
OK : setting open_basedir in state off found
OK : setting safe_mode in state off found
OK : setting zend.ze1_compatibility_mode in state off found
OK : setting mbstring.internal_encoding in state UTF-8 found
OK : supported SQLite version 2.x found----------------------> its found? but......................
OK : SQLite UTF-8 encoding found
OK : GD library PNG support found
OK : GD library GIF support found
OK : GD library JPG support found
OK : GD library WBMP support found
OK : supported GD library version 2.0.1 (or newer) found

 

[etoh1973]

?

Anyone experience the same issue I'm having with publish from previous thread? Any sight to this issue would be most helpfull.
Thanks,

 

[Dmitry Frantsev]

Sitebuilder requires SQLite 2.x installed on publishing server with UTF-8 encoding support. Unfortunately, SQLite 3.x does not supported by Sitebuilder. The thing is that SQlite required for Sitebuilder itself and for publishing host also. As I can see from the output which you posted SQLite support included for Sitebuilder as Sitebuilder itself goes wtih compiled PHP 5.2.1 where SQLite extensions already included. But SQLite also required to be installed on the publishing host where sites will be published to. I can suggest you to check this article for more details: http://kb.swsoft.com/en/1812
Moreover there were a lot of posts on this forum related to SQLite support. Try to check them.

As for Xcopy publishing method and permissions to /var/www/vhosts/xxxxxx.com/httpdocs folder everything is correct here. As I understand this is Plesk server and folder /var/www/vhosts/xxxxxx.com/httpdocs is owned by FTP user. Xcopy method uses xcopy function to copy files from one location to another. As all this made through WEB service apache user should have enought permissions to write into destination folder. This method not secure one and it is suggested to use in only locally on your server without Internet access. In this situation it is better to use FTP publishing method. Try to use it and let me know about the results, but before make sure that SQLite is enabled for client's PHP.

 

[etoh1973]

check.php

I've check the check.php which I'm using on the site that has been configured a sitebuilder server. But, when I copy that check.php to the domain name that I want to publish to it comes up as a blank page.
However, PHP does response and I'm able to pull php pages that were published.


PHP 5.2.3 (cli) (built: Aug 27 2007 09:24:59)
Copyright (c) 1997-2007 The PHP Group
Zend Engine v2.2.0, Copyright (c) 1998-2007 Zend Technologies
with the ionCube PHP Loader v3.1.32, Copyright (c) 2002-2007, by ionCube Ltd., and with Zend Extension Manager v1.2.2, Copyright (c) 2003-2007, by Zend Technol
ogieswith Zend Optimizer v3.3.0, Copyright (c) 1998-2007, by Zend Technologies

error mesage:
PHP Warning: main(init.php): failed to open stream: Operation not permitted in
/var/www/vhosts/kypctech.com/httpdocs/check.php on line 12
PHP Fatal error: main(): Failed opening required 'init.php' (include_path='.:')
in /var/www/vhosts/kypctech.com/httpdocs/check.php on line 12

Is there a configuration issue on mine end?

Thanks,