fbpx
0
  Tuesday, 26 January 2021
  14 Replies
  1.3K Visits
  Subscribe
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?
9 months ago
·
#5535
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.
8 months ago
·
#5538
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
8 months ago
·
#5541
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.
8 months ago
·
#5542
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
8 months ago
·
#5544
Hi,
Everything seems to be fine you should not get the issue.
Kindly rebuilt cache and then reindex.

https://www.sellacious.com/community-support?controller=attachment&task=download&tmpl=component&id=992

if still facing issue reach me on live chat.

thanks.
8 months ago
·
#5545
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.
8 months ago
·
#5546
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.
8 months ago
·
#5549
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.
8 months ago
·
#5550
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
4 months ago
·
#5928
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
4 months ago
·
#5929
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.
3 months ago
·
#5939
https://www.sellacious.com/community-support?controller=attachment&task=download&tmpl=component&id=1028

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

Thanks.
3 months ago
·
#5976
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
3 months ago
·
#5977
Hi,
Kindly contact your server provider and ask to upgrade it.

thanks
  • Page :
  • 1
There are no replies made for this post yet.
Be one of the first 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

?
?
  • +91 9410060107
  • Email contact@sellacious.com