Hi,
Please make sure your sqlite version is Sqlite 3.25.2+ .
Also when you are these make sure your system fulfils these requirements https://www.sellacious.com/documentation-v2#/learn/basics/system-requirements. (so that you do not face any issues in future)
One more thing beta3 version is optimised for joomla version 3 9 16 so use that in order to avoid any joomla compatibility issue.

Hope this helps.
Thanks.

Hi,
Thanks for your answer, but... as already stated:
Database Type mysql
Database Version 5.7.32-0ubuntu0.18.04.1
PHP Version 7.3.26-1+ubuntu18.04.1+deb.sury.org+1
Web Server Apache/2.4.29 (Ubuntu)
Joomla! Version Joomla! 3.9.24 Stable
sqlite3 --version: 3.33.0
php -v:
PHP 7.3.26-1+ubuntu18.04.1+deb.sury.org+1 (cli) (built: Jan 13 2021 08:00:44) ( NTS )
mysql: mysql Ver 14.14 Distrib 5.7.32

MysqlI Support enabled
Client API library version mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $

settings /etc/php/7.3/apache2/php.ini:
Safe Mode Off
Open basedir None
Display Errors Off
Short Open Tags Off
File Uploads On
Magic Quotes Off
Register Globals Off
Output Buffering On
Session Save Path /var/lib/php/sessions
Session Auto Start 0
XML Enabled Yes
Zlib Enabled Yes
Native ZIP Enabled Yes
Disabled Functions pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_get_handler,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,pcntl_async_signals,

Cache rebuilding, auto-fix and re-index work well. The error shows up on product list only (as in the attachment).

Any ideas?
Thanks

Hi,
Product list page comes from cache which is sqlite db, which cos of some reason not being built.
Can you ask your server provider that php executable cli is implemented and kindly check with joomla 3 9 16.
also send me latest cache log which is find in /tmp folder https://www.sellacious.com/community-support/5192-products-section-crashes-after-update-from-2-0-beta1-to-2-0-beta3#reply-5530

Thanks.

Hi,
cli as of php -v:
PHP 7.3.26-1+ubuntu18.04.1+deb.sury.org+1 (cli)
so there is cli installed

also:
MysqlI Support enabled
Client API library version mysqlnd 5.0.12-dev - 20150407 - $Id: 7cc7cc96e675f6d72e5cf0f267f48e167c2abb23 $

and the log is:
Sellacious Cache Cli
============================
Cache build starting...
Initializing cache rebuild…
Running products cache rebuild…
Flush: 1 at 1611786442.9965 sec
Products cache rebuild finished in 0.52758002281189 seconds.
Running discovery and cleanup of media files from filesystem…
Discovery and cleanup of media files from filesystem finished in 0.025063037872314 seconds.
Product output cache deleted.

Cache finished.
EOF

And we are speaking of sqlite3 not sqlite, right?

regarding joomla: at the stage we can't go under joomla 3.9.23

Hi,
Everything seems to be fine you should not get the issue.
Kindly rebuilt cache and then reindex.



if still facing issue reach me on live chat.

thanks.

Thanks for reply.
I re-cached and re-indexed it many times, all went well but the error remains. And as previously stated:
'Cache rebuilding, auto-fix and re-index work well.'

The error shows only on main product list, either in sellacious dashboard or a page with product list.

I checked it with other sqlite3 versions in range 3.25.2 - 3.34, also with PHP 7.2 and 7.3, it really seems like a wrong sqlite3/mysql sql statement, unwanted char (eg. white space)... And it concerns rereading product list from the cache I believe.

Hi,

I have shown this issue to dev team and this was the response.

For SQLite version 3.7.17, below error is shown on product lists -



SQLSTATE[HY000]: General error: 1 near "(": syntax error



This is because of libraries/sellacious/objects/Sellacious/Cache/Storage/Sqlite/SqliteCacheStorageRead.php:183



$query->clear('select')->select('SUM(1) OVER ()');



this was fixed in SQLite version 3.25.2

Our testing team also faced same issue but it was resolved after updating to sqlite version 3.25.2+


Thanks.

Hi,

Exactly!
Commenting out this line helps with the error. Now I must check what's going on with the sqlite<>php.
I'll back as soon I solve it.

OK... so the problem is PDO sqlite driver version (pdo_sqlite.so), it's not a trivial issue.

PDO drivers are not part of sqlite. Seems like upgrading/recompiling/reinstalling sqlite to 3.25.2+ won't solve the problem (although 3.25.2+ it's still required for properly working cache subroutines).

PDO drivers come with PHP (php7.x-sqlite). Php7.2-sqlite has pdo_sqlite driver version 3.22. As php-sqlite 7.3, 7.4 and even 8.0.
Thus above upgrading Sqlite to 3.25.2+ and/or PHP/php-sqlite to 8.0 won't solve the problem.

Do you have any further suggestions? (other then recompiling PHP maybe)
(btw it would be great to have the required pdo_sqlite version info in requirements)

Thanks for your help

Hi Woj,

I am also having this issue, did you get a working solution in the end, if so, please could you kindly explain to me how to go about fixing it?

Cheers
Sam

Hi,
upgrading your sqlite version to Sqlite 3.25.2+ will fix the problem . also make sure your system fulfils these requirements https://www.sellacious.com/documentation-v2#/learn/basics/system-requirements.

once above is done pls re-index from sellacious backend.

thanks.

Hi, in your info 3.8 is given which is less than 3.25 in sqlite versions. Kindly upgrade.

Thanks.

Hi Indresh,

Could you point me to where I would do that please? As I cannot find where, and there is nothing online about how to do so.
I am with CloudAccess and the only option I have is for updating PhP Versions, so I assume this is updated within joomla?
Where abouts please?

Cheers
Sam

Hi,
Kindly contact your server provider and ask to upgrade it.

thanks