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.

General Questions

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

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

Copying from local to productie, 404 error?


Reply

30 Posts   4648 Views

Avatar
martimiz

26 June 2009 at 7:18pm Forum Moderator, 1095 Posts

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

26 June 2009 at 7:37pm Community Member, 182 Posts

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

26 June 2009 at 8:26pm Forum Moderator, 1095 Posts

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

26 June 2009 at 9:04pm (Last edited: 26 June 2009 9:06pm), Community Member, 182 Posts

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

26 June 2009 at 9:06pm Community Member, 182 Posts

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

Avatar
martimiz

26 June 2009 at 9:14pm (Last edited: 26 June 2009 9:16pm), Forum Moderator, 1095 Posts

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

26 June 2009 at 9:18pm (Last edited: 26 June 2009 9:37pm), Community Member, 182 Posts

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

26 June 2009 at 10:21pm Forum Moderator, 1095 Posts

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.