Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

We've moved the forum!

Please use forum.silverstripe.org for any new questions (announcement).
The forum archive will stick around, but will be read only.

You can also use our Slack channel or StackOverflow to ask for help.
Check out our community overview for more options to contribute.

General Questions /

General questions about getting started with SilverStripe that don't fit in any of the categories above.

Moderators: martimiz, Sean, Ed, biapar, Willr, Ingo, swaiba

Copying from local to productie, 404 error?


Go to End


30 Posts   8208 Views

Avatar
martimiz

Forum Moderator, 1391 Posts

26 June 2009 at 7:18pm

OK, right, you need to log in before you can /dev/build/ because otherwise all you visiters could as well... Did you have a problem logging in?

Avatar
raamklaza

Community Member, 182 Posts

26 June 2009 at 7:37pm

Euhm yes that's the whole problem ;)

The website shows this because it's in "live" mode:
Website Error
There has been an error

The website server has not been able to respond to your request.

There is an email send to me that's says:
Error: Couldn't run query: SELECT `SiteTree`.*, `Page`.*, `GhostPage`.*, `BlogEntry`.*, `BlogHolder`.*, `Calendar`.*, `CalendarEvent`.*, `FlickrGallery`.*, `Forum`.*, `ForumHolder`.*, `ErrorPage`.*, `RedirectorPage`.*, `VirtualPage`.*, `MetaBlog`.*, `UserDefinedForm`.*, `YoutubeGallery`.*, `SiteTree`.ID, if(`SiteTree`.ClassName,`SiteTree`.ClassName,'SiteTree') AS RecordClassName FROM `SiteTree` LEFT JOIN `Page` ON `Page`.ID = `SiteTree`.ID LEFT JOIN `GhostPage` ON `GhostPage`.ID = `SiteTree`.ID LEFT JOIN `BlogEntry` ON `BlogEntry`.ID = `SiteTree`.ID LEFT JOIN `BlogHolder` ON `BlogHolder`.ID = `SiteTree`.ID LEFT JOIN `Calendar` ON `Calendar`.ID = `SiteTree`.ID LEFT JOIN `CalendarEvent` ON `CalendarEvent`.ID = `SiteTree`.ID LEFT JOIN `FlickrGallery` ON `FlickrGallery`.ID = `SiteTree`.ID LEFT JOIN `Forum` ON `Forum`.ID = `SiteTree`.ID LEFT JOIN `ForumHolder` ON `ForumHolder`.ID = `SiteTree`.ID LEFT JOIN `ErrorPage` ON `ErrorPage`.ID = `SiteTree`.ID LEFT JOIN `RedirectorPage` ON `RedirectorPage`.ID = `SiteTree`.ID LEFT JOIN `VirtualPage` ON `VirtualPage`.ID = `SiteTree`.ID LEFT JOIN `MetaBlog` ON `MetaBlog`.ID = `SiteTree`.ID LEFT JOIN `UserDefinedForm` ON `UserDefinedForm`.ID = `SiteTree`.ID LEFT JOIN `YoutubeGallery` ON `YoutubeGallery`.ID = `SiteTree`.ID WHERE (HomepageForDomain REGEXP '(, ^) *roufaida\.nl *(,|$)') ORDER BY Sort LIMIT 1 | Table 'w0576642_ss.SiteTree' doesn't exist
At line 400 in /home/w0576642/domains/roufaida.nl/public_html/sapphire/core/model/MySQLDatabase.php

Avatar
martimiz

Forum Moderator, 1391 Posts

26 June 2009 at 8:26pm

auch...

The only way I can reproduce exactly this error is when I execute your query on the wrong database. So either there's something wrong with some (database)cache I know nothing about, or you're for some reason addressing the wrong database... I can see no other options, be interested if you find out though :-)

Avatar
raamklaza

Community Member, 182 Posts

26 June 2009 at 9:04pm

Edited: 26/06/2009 9:06pm

I checked and i checked.

Database is completly the same, user is correct with all permissions, database is correct :(

I added two screenshots with my ss db. Locally and on production. They are the same right????

Avatar
raamklaza

Community Member, 182 Posts

26 June 2009 at 9:06pm

P.s bug in the forum, you can't delete files ;)

Avatar
martimiz

Forum Moderator, 1391 Posts

26 June 2009 at 9:14pm

Edited: 26/06/2009 9:16pm

OK, guess I see the problem now. Maybe you were testing on a windows box and now you moved to linux? Anyway: The database tablenames are for some reason all in lowercase, Silverstripe Expects a SiteTree table (as the error says) You table is called sitetree.

Thought you'd checked that, as Sam mentioned it before in this topic. MySQL Windows might accept it (I vaguely recall), however the Linux version doesn't. You'd have to rename the tables in the original way for the setup to work.

[EDIT I meant lowercase, not underscore :-)]

Avatar
raamklaza

Community Member, 182 Posts

26 June 2009 at 9:18pm

Edited: 26/06/2009 9:37pm

if you look at the screenshots so you can see both are lowercase so where does silverstripe get SiteTree (with uppercase) from?

Where can i change that?

Do i have to change my database manually?

Avatar
martimiz

Forum Moderator, 1391 Posts

26 June 2009 at 10:21pm

Sure they're both lowercase as one is a copy of the other. But they shouldn't be. SiteTree (uppercase is the correct name and you can't change the queries within Silverstripe. You just have to provide a database with the right tablenames, I'm afraid.