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?
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.
- Previous 10 entries
- 1
- 2
- Page 33(current)
- 4
- Next 10 entries
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
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 :-)
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????
P.s bug in the forum, you can't delete files ;)
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 :-)]
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?
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.
- Previous 10 entries
- 1
- 2
- Page 33(current)
- 4
- Next 10 entries