SilverCart Forum
We moderate this Forum and we're here to help. Have you already run a forum search to check if your problem has already been solved?
You can help us helping you by providing detailed error messages, screenshots and logfile entries.
Page: 1 | ||
Topic (INVALID)[User Error] Couldn't run query: | 2884 Views |
(INVALID)[User Error] Couldn't run query:
28 June 2011 at 10:00pm Last edited: 28 June 2011 10:06pmHello,
I've tried to install SilverCart, but get the following:
[User Error] Couldn't run query: SELECT COUNT(*) FROM "SilvercartProductGroupPage_versions" LEFT JOIN "SilverCartPage_versions" ON "SilverCartPage_versions"."RecordID" = "SilvercartProductGroupPage_versions"."RecordID" AND "SilverCartPage_versions"."Version" = "SilvercartProductGroupPage_versions"."Version" WHERE "SilverCartPage_versions"."ID" IS NULL Table 'SS_silvercart.SilverCartPage_versions' doesn't exist
GET /dev/build?flush=all
Line 525 in /usr/home/gour/www/sc/sapphire/core/model/MySQLDatabase.php
Here is the complete output:
SilverStripe-2.4.5
[gour@atmarama gour] php-fpm --version
PHP 5.3.6 (fpm-fcgi) (built: Jun 12 2011 11:06:08)
Copyright (c) 1997-2009 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2011 Zend Technologies
[gour@atmarama gour] mysql --version
mysql Ver 14.14 Distrib 5.5.11, for FreeBSD9.0 (amd64) using 5.2
Cherokee-1.2.2 server running on my desktop machine (localhost).
Any hint?
Sincerely,
Gour
Edit:Ahhh... :-(
'SS_silvercart.SilverCartPage_versions' doesn't exist
Everything is fine...Excuse me for making noise. :-(
Re: (INVALID)[User Error] Couldn't run query:
28 June 2011 at 10:15pmHello gour,
your welcome. The best problems are those that are solved by itself ;)
Has your installation been successful?
Re: (INVALID)[User Error] Couldn't run query:
29 June 2011 at 8:11amHiya Roland,
> Has your installation been successful?
Yes, after I properly 'extended' classes. :-)
Now I see that SilverCart's installation is somehow intrusive to the rest of the site and wonder how one 'integrates' web site where the shop is not the major port of it, but just one (tiny) part.
In our case, we'll have 'shop' with maybe 10 'products' (services) and major port of the site should be dedicated to News, different articles, etc.
Another question is YAML licensing, but that's for another thread...
Re: (INVALID)[User Error] Couldn't run query:
29 June 2011 at 10:09amHi Goar,
not sure if I understand your question correctly.
Whether SC is a major or a minor part of a website makes no difference in the installation steps necessary.
We need to change the inheritance pattern in order to 'decorate' (or 'inject' if you will) the SC behaviour into the SS base classes at the right moment. There is no other solution for it with SS2.
Does this answer your question?
Cheers
Ramon
Re: (INVALID)[User Error] Couldn't run query:
29 June 2011 at 10:50amWhether SC is a major or a minor part of a website makes no difference in the installation steps necessary.
That is clear.
We need to change the inheritance pattern in order to 'decorate' (or 'inject' if you will) the SC behaviour into the SS base classes at the right moment. There is no other solution for it with SS2.
That is also reasonable.
Does this answer your question?
Well, I did install SC into 'default' SS install with sample content and and now when I access http://ss.local/ I'm redirected to the: http://ss.local/index.php/webshop/ - iow. SC has become 'home' of my old site and I wonder what would happen if I'd install SC in the fully developed site (news pages, blog section, galleries etc.) which was just missing shop-component?
Shortly, my question is about integrating SC into the already developed SS site or the correct workflow is to develop site with SC in mind from the scratch?
Re: (INVALID)[User Error] Couldn't run query:
29 June 2011 at 3:56pmHi Goar,
you can change the 'home' in the SiteTree, this is SilverStripe standard functionality.
We already extended an existing SilverStripe website with SilverCart, it was...ummmh... very easy... :-)
Check out http://hh-solartec.de/
They already had hundreds of blogposts highly ranked in google. The update did not affect this.
Cheers
Ramon