Jump to:

23450 Posts in 18899 Topics by 2877 members

General Questions

SilverStripe Forums » General Questions » Copying from local to productie, 404 error?

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

Page: 1 2 3 4
Go to End
Author Topic: 4535 Views
  • martimiz
    Avatar
    Forum Moderator
    1078 Posts

    Re: Copying from local to productie, 404 error? Link to this post

    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?

  • raamklaza
    Avatar
    Community Member
    182 Posts

    Re: Copying from local to productie, 404 error? Link to this post

    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

  • martimiz
    Avatar
    Forum Moderator
    1078 Posts

    Re: Copying from local to productie, 404 error? Link to this post

    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

  • raamklaza
    Avatar
    Community Member
    182 Posts

    Re: Copying from local to productie, 404 error? Link to this post

    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????

  • raamklaza
    Avatar
    Community Member
    182 Posts

    Re: Copying from local to productie, 404 error? Link to this post

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

  • martimiz
    Avatar
    Forum Moderator
    1078 Posts

    Re: Copying from local to productie, 404 error? Link to this post

    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 ]

  • raamklaza
    Avatar
    Community Member
    182 Posts

    Re: Copying from local to productie, 404 error? Link to this post

    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?

  • martimiz
    Avatar
    Forum Moderator
    1078 Posts

    Re: Copying from local to productie, 404 error? Link to this post

    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.

    4535 Views
Page: 1 2 3 4
Go to Top

Want to know more about the company that brought you SilverStripe? Then check out SilverStripe.com

Comments on this website? Please give feedback.