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.

SebastianRamon

Page: 1
Topic (INVALID)[User Error] Couldn't run query: 2800 Views

(INVALID)[User Error] Couldn't run query:

28 June 2011 at 10:00pm Last edited: 28 June 2011 10:06pm

Hello,

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:

http://pastebin.com/QsvG3xU5

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:15pm

Hello 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:11am

Hiya 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:09am

Hi 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:50am

Whether 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:56pm

Hi 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