fbpx
0
Hi,
Freshly installed 2.0.0b3 pkg + pkg.ext on J3.9.24 and the rest reqs => as in the spec.
I've got "SQLSTATE[HY000]: General error: 1 near "(": syntax error" on the product list which seems a misdef or a typo conc sqlite (3.33) down there in the code... Please help
btw - impressive work, although only betas for potential clients?
Attachments (1)
Replies (9)
Indresh Maurya Accepted Answer Pending Moderation
Team
  1. Replied more than a month ago
  2. #Permalink
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.
woj Accepted Answer Pending Moderation
  1. Replied more than a month ago
  2. #Permalink
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
Indresh Maurya Accepted Answer Pending Moderation
Team
  1. Replied more than a month ago
  2. #Permalink
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.
woj Accepted Answer Pending Moderation
  1. Replied more than a month ago
  2. #Permalink
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
Indresh Maurya Accepted Answer Pending Moderation
Team
  1. Replied 4 weeks ago
  2. #Permalink
Hi,
Everything seems to be fine you should not get the issue.
Kindly rebuilt cache and then reindex.

Screenshot 2021-01-29 at 9.24.33 AM.png

if still facing issue reach me on live chat.

thanks.
Attachments (1)
woj Accepted Answer Pending Moderation
  1. Replied 4 weeks ago
  2. #Permalink
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.
Attachments (2)
Indresh Maurya Accepted Answer Pending Moderation
Team
  1. Replied 4 weeks ago
  2. #Permalink
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.
woj Accepted Answer Pending Moderation
  1. Replied 4 weeks ago
  2. #Permalink
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.
woj Accepted Answer Pending Moderation
  1. Replied 4 weeks ago
  2. #Permalink
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
  • Page :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.
Support is Offline
Support Hours
Monday To Saturday
From 09:00 To 21:00 IST
Sellacious Time 00:00:00

Login

?
?